Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-102

MySQL-Incompatible result from ResultSet.getString() for BIT(1)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.1.7
    • Fix Version/s: 1.1.8
    • Component/s: None
    • 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.)

        Attachments

          Activity

            People

            Assignee:
            massimo.siani Massimo Siani (Inactive)
            Reporter:
            toolforger Joachim Durchholz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.