[CONJ-437] Missing leading zeros when fetching String values from numeric columns with zerofill Created: 2017-03-01 Updated: 2017-03-03 Resolved: 2017-03-03 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | Other |
| Affects Version/s: | 1.3.7, 1.4.6, 1.5.8 |
| Fix Version/s: | 1.5.9 |
| Type: | Bug | Priority: | Major |
| Reporter: | Francisco Javier Garcia Urtiaga | Assignee: | Diego Dupin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
If we use the getString() method to get the value from a ResultSet for a integer column with the zerofill option the value we obtain doesn't have the expected leading zeros. Statement st = connection.createStatement(); PreparedStatement pst1 = connection.prepareStatement("select value from tmpTest"); rs1.close(); st.close(); Using the 1.1.8 or 1.2.3 versions of the connector this returns the expected result: In any version after 1.3.0 the behavior changes: |