Issue 279: receive not all rows on text field select
Status:  Investigating
Owner: ----
Reported by p.dirck...@googlemail.com, Jul 26, 2012
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

Jul 26, 2012
#1 p.dirck...@googlemail.com
same with pyodbc 3.0.6
Sep 26, 2012
Project Member #2 mkleehammer
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.

Status: Investigating
Sep 27, 2012
Project Member #3 mkleehammer
(No comment was entered for this change.)
Labels: Rare-DB
Sep 29, 2012
Project Member #4 mkleehammer
(No comment was entered for this change.)
Labels: -Rare-DB Driver-4D
Nov 1, 2012
#5 and...@jmunch.dk
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".