[ODBC-216] SQLColAttribute and SQL_DESC_FIXED_PREC_SCALE returns wrong value for BigInt Created: 2019-01-31 Updated: 2019-03-14 Resolved: 2019-02-28 |
|
| Status: | Closed |
| Project: | MariaDB Connector/ODBC |
| Component/s: | General |
| Affects Version/s: | 3.0.8 |
| Fix Version/s: | 2.0.19, 3.0.9 |
| Type: | Bug | Priority: | Major |
| Reporter: | Johan Telenius | Assignee: | Lawrin Novitsky |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 10, 64-bit |
||
| Description |
|
I have a simple test database, two columns, one is a varchar, the other one is a BigInt with Numeric_precision = 19 and Numeric_scale = 0. When I in my application use the command SQLColAttribute with the field descriptor SQL_DESC_FIXED_PREC_SCALE, it returns SQL_TRUE. But according to documentation, I think it should return SQL_FALSE. Link to documentation: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolattribute-function?view=sql-server-2017 I have tried MariaDB driver 3.0.7 and 3.1.0 Release Candiate with the same result. The same database setup on SQL Server and MySQL, and the same application gives the result SQL_FALSE. |
| Comments |
| Comment by Lawrin Novitsky [ 2019-01-31 ] |
|
Thank you for your report! "SQL_TRUE if the column has a fixed precision and nonzero scale that are data source-specific. But yeah, we will fix this. |
| Comment by Lawrin Novitsky [ 2019-02-28 ] |
|
Connector returned wrong value for SQL_DESC_FIXED_PREC_SCALE. In the |