agesys-dev team mailing list archive

[Jonathan Bastnagel <jonthebagel@xxxxxxxxx>]

Public bug reported:

Calling a stored procedure shows a positive row count but won't let me
fetch results.

Client running Ubuntu 12.04 LTS, Python 2.7.3, OurSQL 0.9.2, and libmysqlclient-dev 5.5
Server is an Amazon RDS MySQL instance running MySQL 5.5.12

Python Code: 
import oursql

conn = oursql.connect(host='www.example.com', user='foo', passwd='bar', port=3306)
curs = conn.cursor()

curs.execute("CALL db.foo(?, ?, ?)", (1, 2, 3))
print("Row count: " + str(curs.rowcount))
print(curs.nextset())
res = curs.fetchone()
print(res)
curs.close()

Output:
Row count: 189
Traceback (most recent call last):
  File "test.py", line 8, in <module>
    print(curs.nextset())
  File "cursor.pyx", line 169, in oursql.Cursor.nextset (oursqlx/oursql.c:16436)
  File "cursor.pyx", line 161, in oursql.Cursor._check_statements (oursqlx/oursql.c:16392)
oursql.ProgrammingError: (None, 'no results available', None)

** Affects: oursql
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
https://bugs.launchpad.net/bugs/1004991

Title:
  Calling a stored procedure says rows returned but won't let me fetch
  results.

Status in oursql:
  New

Bug description:
  Calling a stored procedure shows a positive row count but won't let me
  fetch results.

  Client running Ubuntu 12.04 LTS, Python 2.7.3, OurSQL 0.9.2, and libmysqlclient-dev 5.5
  Server is an Amazon RDS MySQL instance running MySQL 5.5.12

  Python Code: 
  import oursql

  conn = oursql.connect(host='www.example.com', user='foo', passwd='bar', port=3306)
  curs = conn.cursor()

  curs.execute("CALL db.foo(?, ?, ?)", (1, 2, 3))
  print("Row count: " + str(curs.rowcount))
  print(curs.nextset())
  res = curs.fetchone()
  print(res)
  curs.close()

  Output:
  Row count: 189
  Traceback (most recent call last):
    File "test.py", line 8, in <module>
      print(curs.nextset())
    File "cursor.pyx", line 169, in oursql.Cursor.nextset (oursqlx/oursql.c:16436)
    File "cursor.pyx", line 161, in oursql.Cursor._check_statements (oursqlx/oursql.c:16392)
  oursql.ProgrammingError: (None, 'no results available', None)

To manage notifications about this bug go to:
https://bugs.launchpad.net/oursql/+bug/1004991/+subscriptions