receive not all rows on text field select

tmolomby / pyodbc

Automatically exported from code.google.com/p/pyodbc

MIT No Attribution

0 stars 0 forks source link

receive not all rows on text field select #279

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. connect on 4D Database over System DSN
2. simple cursor.execute on text field (on date field i get all rows)
3. for row in cursor:

What is the expected output? What do you see instead?
88000 Rows

i get only
1000 Rows

What version of the product are you using? On what operating system?
win7, python 2.6.5, pyodbc-2.1.11-py2.6-win32, 4D ODBC v12.3

Please provide any additional information below.
with php odbc i get all data, is not a driver issues

Original issue reported on code.google.com by p.dirck...@googlemail.com on 26 Jul 2012 at 4:13

GoogleCodeExporter commented 9 years ago

same with pyodbc 3.0.6

Original comment by p.dirck...@googlemail.com on 26 Jul 2012 at 4:32

GoogleCodeExporter commented 9 years ago

Can you provide an ODBC trace for the text case?

I installed a trial copy of 4D on OS/X but was not successful -- one is 32-bit 
and the other 64-bit.

Original comment by mkleehammer on 26 Sep 2012 at 9:53

Changed state: Investigating

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 27 Sep 2012 at 8:19

Added labels: Rare-DB

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 29 Sep 2012 at 3:09

Added labels: Driver-4D
Removed labels: Rare-DB

GoogleCodeExporter commented 9 years ago

Sounds like the same problem I just reported as issue 296.  If it is, then what 
happens is that row 1001 contains a text longer than 19KiB (and apparently the 
first 1000 are smaller than that), which causes a NULL return that is 
misinterpreted as "no more data".

Original comment by and...@jmunch.dk on 1 Nov 2012 at 8:52