| 2012-05-26 21:12:02 |
Jonathan Bastnagel |
bug |
|
|
added bug |
| 2012-05-26 22:14:54 |
Jonathan Bastnagel |
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) |
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
Create Table:
delimiter $$
CREATE TABLE `test` (
`idtest` int(11) NOT NULL AUTO_INCREMENT,
`data` int(11) DEFAULT NULL,
PRIMARY KEY (`idtest`),
UNIQUE KEY `idtest_UNIQUE` (`idtest`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1$$
Populate this table. I have 189 entries all with random numbers for `data`.
Create Procedure:
delimiter $$
CREATE DEFINER=`db`@`%` PROCEDURE `foo`(
IN a INT
,IN b INT
,IN c INT
)
BEGIN
SELECT SQL_CACHE
`data`
FROM `db`.`test`
ORDER BY a ASC;
END$$
Python Code (test.py):
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) |
|
| 2012-05-26 22:34:22 |
jeremyb |
bug |
|
|
added subscriber jeremyb |
| 2012-05-26 23:28:19 |
Jonathan Bastnagel |
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
Create Table:
delimiter $$
CREATE TABLE `test` (
`idtest` int(11) NOT NULL AUTO_INCREMENT,
`data` int(11) DEFAULT NULL,
PRIMARY KEY (`idtest`),
UNIQUE KEY `idtest_UNIQUE` (`idtest`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1$$
Populate this table. I have 189 entries all with random numbers for `data`.
Create Procedure:
delimiter $$
CREATE DEFINER=`db`@`%` PROCEDURE `foo`(
IN a INT
,IN b INT
,IN c INT
)
BEGIN
SELECT SQL_CACHE
`data`
FROM `db`.`test`
ORDER BY a ASC;
END$$
Python Code (test.py):
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) |
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.3, and libmysqlclient-dev 5.5
Server is an Amazon RDS MySQL instance running MySQL 5.5.12
Create Table:
delimiter $$
CREATE TABLE `test` (
`idtest` int(11) NOT NULL AUTO_INCREMENT,
`data` int(11) DEFAULT NULL,
PRIMARY KEY (`idtest`),
UNIQUE KEY `idtest_UNIQUE` (`idtest`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1$$
Populate this table. I have 189 entries all with random numbers for `data`.
Create Procedure:
delimiter $$
CREATE DEFINER=`db`@`%` PROCEDURE `foo`(
IN a INT
,IN b INT
,IN c INT
)
BEGIN
SELECT SQL_CACHE
`data`
FROM `db`.`test`
ORDER BY a ASC;
END$$
Python Code (test.py):
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) |
|
| 2012-06-01 13:25:55 |
Jonathan Bastnagel |
oursql: status |
New |
Confirmed |
|
| 2012-06-05 11:56:37 |
Stephen Thorne |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=42490 |
|
| 2012-06-05 11:56:37 |
Stephen Thorne |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=19008 |
|
| 2012-06-05 11:56:37 |
Stephen Thorne |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=11918 |
|
