Bug #41261 odbc truncate negative integer

• Submitted: 5 Dec 2008 14:03
• Modified: 5 Dec 2008 16:25
• Reporter: Susanne Ebrecht
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 3.51.22, 5.1.4
• OS: Linux (Linux (32bit), Windows (32bit), Mac OS)
• CPU Architecture: Any

[5 Dec 2008 14:03] Susanne Ebrecht

Description:
I found this on German community mailing list:

create table test (num0 int);
insert into test values  (1234567890);
insert into test values (-1234567890);
insert into test values  (-123456789);
select * from test;

Result:
1234567890
-123456789 (why is it truncated?)
-123456789

How to repeat:
see above

Suggested fix:
...

[5 Dec 2008 16:25] Tonci Grgin

Hi Susanne.

There is no firm logic in this claim. My guess is that they messed up something with their application.

Test was run against latest releases of both 3.51 and 5.1 connectors using Microsoft default odbc client (odbcte(w)32.exe):

Server version: 5.0.68-pb10-log MySQL Pushbuild Edition, build 10

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table bug41261 (Id INT);
Query OK, 0 rows affected (0.08 sec)

insert into bug41261 values  (1234567890);
insert into bug41261 values (-1234567890);
insert into bug41261 values  (-123456789);
select * from bug41261;
+-------------+
| Id          |
+-------------+
|  1234567890 |
| -1234567890 |
|  -123456789 |
+-------------+
3 rows in set (0.00 sec)

ODBCTE32.exe, MyODBC 3.51:
select * from bug41261
Get Data All:
"bug41261.Id"
1234567890
-1234567890
-123456789
3 rows fetched from 1 column.

ODBCTE32.exe, MyODBC 5.1:
Successfully connected to DSN '51on5068'.
select * from bug41261
SQLExecDirect:	In:	hstmt = 0x00961FD8, szSqlStr = "", cbSqlStr = -3	Return:	SQL_SUCCESS=0

Get Data All:
"Id"
1234567890
-1234567890
-123456789
3 rows fetched from 1 column.