[CONJ-102] MySQL-Incompatible result from ResultSet.getString() for BIT(1) Created: 2014-06-15  Updated: 2014-11-26  Resolved: 2014-11-26

Status: Closed
Project: MariaDB Connector/J
Component/s: None
Affects Version/s: 1.1.7
Fix Version/s: 1.1.8

Type: Bug Priority: Blocker
Reporter: Joachim Durchholz Assignee: Massimo Siani (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux


 Description   

ResultSet.getString() returns "true" or "false" for BIT(1).
The Mysql connector returns "0" or "1" for the same situation.

I'm trying to move a steaming pile of code from MySQL to MariaDB, and the prior dev assumed that BIT(1) would come out as "0" or "1" in getString.

I classify this as a bug because MariaDB claims MySQL compatibility at the driver level (among others), and as a blocker because I can't reasonably switch to MariaDB due to this bug.
Free free to reclassify.

(Suggestion: Add unit tests for checking compatibility.)
Generated at Thu Feb 08 03:13:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.