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

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.1.7
    • 1.1.8
    • None
    • None
    • 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

            massimo.siani Massimo Siani (Inactive)
            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.