
Connexion:kxsrvmulti2_mysql5
User:kxenodbc
Password:kxenodbc
Function 'SQLAllocHandle env' return '0'
Function 'SQLSetEnvAttr' return '0'
Function 'SQLAllocHandle connection' return '0'
Function 'SQLConnect' return '0'
Function 'SQLAllocHandle statement' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'We prepare our test table

Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'
Function 'SQLExecDirect ODBC_ExecuteSimpleSQL' return '0'Table ALAIN contains now 16384 rows

Function 'SQLColumns' return '0'
Function 'SQLBindCol # 4 COLUMN_NAME' return '0'
Function 'SQLBindCol # 6 NATIVE_TYPE' return '0'
Function 'SQLBindCol # 5 NATIVE_TYPE_CODE' return '0'
Function 'SQLBindCol # 6 COLSIZE' return '0'
Function 'SQLBindCol # 9 DECIMAL_DIGITS' return '0'

Here is the MySQL description of table ALAIN
Field 0
Native Column Name id
Native Type: integer
Native Type Code 4
Col Size 10
Decimal digits 0

Field 1
Native Column Name fvalue
Native Type: float
Native Type Code 7
Col Size 7
Decimal digits 0

Function 'SELECT * FROM ALAIN' return '0'
id	fvalue	
Function 'SQLBindCol For Read' return '0'
Function 'SQLBindCol For Read' return '0'
id	fvalue	
0:
100:
200:
300:
400:
500:
600:
700:
800:
900:
1000:
1100:
1200:
1300:
1400:
1500:
1600:
1700:
1800:
1900:
2000:
2100:
2200:
2300:
2400:
2500:
2600:
2700:
2800:
2900:
3000:
3100:
3200:
3300:
3400:
3500:
3600:
3700:
3800:
3900:
4000:
4100:
4200:
4300:
4400:
4500:
4600:
4700:
4800:
4900:
5000:
5100:
5200:
5300:
5400:
5500:
5600:
5700:
5800:
5900:
6000:
6100:
6200:
6300:
6400:
6500:
6600:
6700:
6800:
6900:
7000:
7100:
7200:
7300:
7400:
7500:
7600:
7700:
7800:
7900:
8000:
12:00:04:We are sleeping a while at row 8000 just to simulate a very complex computation between two fetches

12:00:34:OK we restart to fetch

8100:
8200:
8300:
8400:
8500:
8600:
8700:
8800:
8900:
9000:
9100:
9200:
9300:
9400:
9500:
9600:
9700:
9800:
9900:
10000:
10100:
10200:
10300:
10400:
10500:
10600:
10700:
10800:
10900:
11000:
11100:
11200:
11300:
11400:
11500:
11600:
11700:
11800:
11900:
12000:
12100:
12200:
12300:
12400:
12500:
12600:
12700:
12800:
12900:
13000:
13100:
13200:
13300:
13400:
13500:
13600:
13700:
13800:
13900:

 We have retrieved all data (13971 rows )in table ALAIN
Function 'After last fetch' return '100'
[]:

Function 'End of retrieve data' return '100'
[]:
If you see that less than 16384 rows has been retrieved, you have reproduced the issue !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

