Bug #9817 DECIMAL / NUMERIC columns ignored
Submitted: 11 Apr 2005 14:09 Modified: 25 Oct 2005 15:46
Reporter: Tal Kormas Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51.11 OS:Windows (Windows)
Assigned to: Peter Harvey CPU Architecture:Any

[11 Apr 2005 14:09] Tal Kormas
Description:
When having a table with DECIMAL or NUMERIC columns, the ODBC driver seems to be removing those columns from the resultset.

How to repeat:
I am using Delphi 7.1 with ODBC.

create table test(test decimal(10,1), test2 numeric(10,1),test3 char(10));
insert into test values(123,123,'123');

On the client do use TQuery or TTABLE to get * from test.

The test and test2 columns are not in the results.
[12 Apr 2005 4:20] MySQL Verification Team
MyODBC and C++ Builder 4.0 Database Explorer

Attachment: decimal.PNG (image/png, text), 30.16 KiB.

[12 Apr 2005 4:23] MySQL Verification Team
I tested this issue with a Borland product C++ Builder 4.0 with
the Database Explorer (I attached a picture) without any problem.
Then I assume that is something wrong with your environment.
[12 Apr 2005 12:52] Tal Kormas
Could you explain which environment variables need to be set? I've tried to turn on and off all the flags on that connection and I'm getting the same results. I've opened Borland C++ 6.0 and the Database Explorer doesn't show the decimal fields for me. More ever, any table that contains decimal/numeric/float/double getting me an error message (Could not find object).
[12 Apr 2005 14:00] Tal Kormas
I haven't mantioned it before, but my server is 5.0.3-beta on Linux box.
[12 Apr 2005 14:25] MySQL Verification Team
I tested against a server BK 5.0.5 running on Linux Slackware and
I was able to repeat the behavior reported.

So the issue is limited to 5.0.XX servers.

Thank you for the bug report.
[19 Jul 2005 14:41] Tal Kormas
Peter,

Do you have any idea what version this fix is schedule to?

Thanks,

Tal
[25 Oct 2005 15:26] Peter Harvey
Please try c/odbc v3.51.12 as there are a number of fixs related to numeric types in this version. Please report success/failure.
[25 Oct 2005 15:46] Tal Kormas
This was fixed!

Thanks Peter!
[25 Oct 2005 15:46] Tal Kormas
Done