Bug #35615 | Unable to insert values to a bit column if it is bound with SQL_C_CHAR | ||
---|---|---|---|
Submitted: | 27 Mar 2008 15:42 | Modified: | 10 Dec 2008 15:04 |
Reporter: | John Water | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | 5.1.3-20080320 | OS: | Windows (XP) |
Assigned to: | CPU Architecture: | Any | |
Tags: | bit, ODBC, SQL_C_CHAR |
[27 Mar 2008 15:42]
John Water
[28 Mar 2008 9:04]
Tonci Grgin
Test case
Attachment: Bug35615.cpp (text/x-c++), 4.45 KiB.
[28 Mar 2008 9:06]
Tonci Grgin
Hi John and thanks for your report. You are right, only default conversions seems to be supported as per http://msdn2.microsoft.com/en-us/library/ms716298(VS.85).aspx.
[28 Mar 2008 9:08]
Tonci Grgin
Hm, my mistake. Even though it might not be that obvious, this report is duplicate of Bug#30349 and Lawrin is working on fix right now.
[29 Mar 2008 20:09]
Lawrenty Novitsky
BTW John, your test case works for me w/ 5.1.23 server, but doesn't with 5.0.* (if you try "insert into test values(5,'1')" you will see it doesn't work w/ 5.0.*) It's weird that 5.1.22 produces same error for you. So, it may be also 5.0 server bug, but we will fix driver anyway.
[10 Dec 2008 15:04]
John Water
Hi, This bug still shows up with the 5.1 GA server and 5.1.5 ODBC driver. Please try to run my repro against the 5.1 GA server and the 5.1.5 ODBC driver. The server will complain with the following error: [MySQL][ODBC 5.1 Driver][mysqld-5.1.30-community]Data too long for column 'c1' at row 1 Thanks, John