env_java
repro2.class
repro2.java
repro2.log
[CONJ-352] Wrong precision is returned for NUMERIC columns - 2 greater than it should be. Created: 2016-09-20 Updated: 2016-09-21 Resolved: 2016-09-21 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | Other |
| Affects Version/s: | 1.5.2 |
| Fix Version/s: | 1.5.3 |
| Type: | Bug | Priority: | Major |
| Reporter: | Yekaterina | Assignee: | Diego Dupin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
env_java
repro2.class
repro2.java
repro2.log
|
| Description |
|
Wrong precision is returned for NUMERIC columns. The returned precision is 2 greater than it should be (see the attached java repro) execute CREATE TABLE TESTNUM (N9X2 NUMERIC(9,2), N20X4 NUMERIC (20,4)) execute SELECT N9X2, N20X4 FROM TESTNUM get resultset metadata N9X2 precision is 11 N20X4 precision is 22 |
| Comments |
| Comment by Diego Dupin [ 2016-09-21 ] |
|
confirmed. The problem concern DECIMAL type. Signed will have +2 precision, unsigned +1. |
| Comment by Diego Dupin [ 2016-09-21 ] |
|
fixed in https://github.com/MariaDB/mariadb-connector-j/commit/26ed0fd511fdfafa0233e074f04fdd4ed81518e8 |