Bug #24426 | Invalid JDBC column types: VARCHAR instead of DOUBLE | ||
---|---|---|---|
Submitted: | 19 Nov 2006 8:11 | Modified: | 20 Nov 2006 19:21 |
Reporter: | Razvan Surdulescu | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / J | Severity: | S3 (Non-critical) |
Version: | 3.1.10 | OS: | Linux (Linux RedHat) |
Assigned to: | CPU Architecture: | Any |
[19 Nov 2006 8:11]
Razvan Surdulescu
[20 Nov 2006 9:30]
Tonci Grgin
Hi Razvan and thanks for your problem report. You are using rather old version of c/J. Can you please upgrade and inform me of result.
[20 Nov 2006 10:38]
Tonci Grgin
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Explanation: MySQL server 5.0.27BK JDK 1.5.0.07 connector/J 3.1 latest SVN create table test(a int, b double); insert into test values(1, 2); mysql> SELECT a / a AS IntOverInt, b / a AS DoubleOverInt, b / b AS DoubleOverDo uble FROM test; Field 1: `IntOverInt` Catalog: `def` Database: `` Table: `` Org_table: `` Type: NEWDECIMAL Collation: binary (63) Length: 16 Max_length: 6 Decimals: 4 Flags: BINARY Field 2: `DoubleOverInt` Catalog: `def` Database: `` Table: `` Org_table: `` Type: DOUBLE Collation: binary (63) Length: 23 Max_length: 1 Decimals: 31 Flags: BINARY NUM Field 3: `DoubleOverDouble` Catalog: `def` Database: `` Table: `` Org_table: `` Type: DOUBLE Collation: binary (63) Length: 23 Max_length: 1 Decimals: 31 Flags: BINARY NUM +------------+---------------+------------------+ | IntOverInt | DoubleOverInt | DoubleOverDouble | +------------+---------------+------------------+ | 1.0000 | 2 | 1 | +------------+---------------+------------------+ Test case result is correct: IntOverInt => 3 DoubleOverInt => 8 DoubleOverDouble => 8
[20 Nov 2006 10:39]
Tonci Grgin
Test case
Attachment: TestBug24426.java (text/x-java), 1.75 KiB.
[20 Nov 2006 17:53]
Razvan Surdulescu
That's great to know that it's been fixed (I assume latest SVN means latest source trunk). When is the next binary release of Connector/J 3.1.x expected to come out with this bug fix?
[20 Nov 2006 19:04]
Tonci Grgin
Razvan, just try last GA. I think it was fixed some time ago.
[20 Nov 2006 19:21]
Razvan Surdulescu
You're right, I just upgraded to the latest Connector/J and it's working now. Thanks!