Return empty value with big text column
Bug #661334 reported by
_JulienH
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Connector/Python |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Hi Geert,
In my database i have a table who have a text column with a big text value, for example 78000 characters.
When i do a select query with this table and this column, the result is empty.
ps: sorry for my english
Julien
Changed in myconnpy: | |
status: | Incomplete → Invalid |
To post a comment you must log in.
Hello Julien,
Do you have a test case which shows the problem? What version of MySQL Connector/Python?
>>> cnx = mysql.connector .connect( database= 'test') aaaaaaaaaaaaaaa aaaaaaaaaaaaaaa aaaaaaaaaaaaaaa aaaaaaaaaaaaaaa aaaaaaaaaaaaaaa aaaaaaaaaa
>>> cur = cnx.cursor()
>>> cur.execute("SELECT REPEAT('a',78000)")
-1
>>> row = cur.fetchone()
>>> len(row[0])
78000
>>> print row[0][0:100]
aaaaaaaaaaaaaaa
And with a table wich c1 LONGTEXT:
>>> cur.execute("SELECT c1 FROM t1")
-1
>>> len(row[0])
78000