[MDEV-10950] CONNECT engine table_type=JDBC non-VARCHAR column types do not return NULL correctly Created: 2016-10-03 Updated: 2016-10-14 Resolved: 2016-10-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Connect |
| Affects Version/s: | 10.1.18 |
| Fix Version/s: | 10.0.28, 10.1.19 |
| Type: | Bug | Priority: | Major |
| Reporter: | Robert Dyas | Assignee: | Olivier Bertrand |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
centOS 7 |
||
| Description |
|
Non-VARCHAR column types on remote servers that have null values show up with ZERO values rather than null. For example, in the query results below from a CONNECT table of type JDBC, the second row should contain all NULL values. However, only the first column of type VARCHAR actually returns null, the rest incorrectly return zero values.
|
| Comments |
| Comment by Robert Dyas [ 2016-10-13 ] |
|
Does this problem with NULL coming back as 0 look like it could be corrected for the next release? The behavior is completely consistent across the two (very different) JDBC drivers I have tried (Simba's Salesforce driver and the MySQL JDBC driver). Thank you. |