Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.10
    • 10.0.13
    • None
    • None

    Description

      Found while merging type_bit test. type_bit patch attached.

      CREATE TABLE t1(f1 bit(2) NOT NULL default b'10',f2 bit(14) NOT NULL default b'11110000111100');
      INSERT INTO t1 (f1) VALUES (DEFAULT);
      INSERT INTO t1 VALUES (b'',b''),('','');
      SELECT HEX(f1), HEX(f2) FROM t1;
      HEX(f1)	HEX(f2)
      2	3C3C
      2	3C8F <!-------- should be 0 0?
      0	0
      DROP TABLE t1;

      Attachments

        Issue Links

          Activity

            svoj Sergey Vojtovich created issue -
            svoj Sergey Vojtovich made changes -
            Field Original Value New Value
            igor Igor Babaev (Inactive) made changes -
            Assignee Igor Babaev [ igor ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.12 [ 15201 ]
            Fix Version/s 10.0.11 [ 15200 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 38605 ] MariaDB v2 [ 43592 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.13 [ 16000 ]
            Fix Version/s 10.0.12 [ 15201 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.13 [ 16300 ]
            Fix Version/s 10.0 [ 16000 ]
            igor Igor Babaev (Inactive) added a comment - - edited

            Here' s what we have for MyISAM (the correct result):

            MariaDB [test]> CREATE TABLE t1(f1 bit(2)) ENGINE=MYISAM;
            Query OK, 0 rows affected (0.01 sec)
             
            MariaDB [test]> INSERT INTO t1 VALUES (b'');
            Query OK, 1 row affected (0.00 sec)
             
            MariaDB [test]> SELECT HEX(f1) from t1;
            +---------+
            | HEX(f1) |
            +---------+
            | 0       |
            +---------+
            1 row in set (0.00 sec)
             
            MariaDB [test]> SELECT bin(f1) from t1;
            +---------+
            | bin(f1) |
            +---------+
            | 0       |
            +---------+
            1 row in set (0.00 sec)

            And here's what we have for INNODB (an incorrect result):

            MariaDB [test]> CREATE TABLE t2(f1 bit(2)) ENGINE=INNODB;
            Query OK, 0 rows affected (0.06 sec)
             
            MariaDB [test]> INSERT INTO t2 VALUES (b'');
            Query OK, 1 row affected (0.01 sec)
             
            MariaDB [test]> SELECT HEX(f1) from t2;
            +---------+
            | HEX(f1) |
            +---------+
            | 8F      |
            +---------+
            1 row in set (0.00 sec)
             
            MariaDB [test]> SELECT bin(f1) from t2;
            +----------+
            | bin(f1)  |
            +----------+
            | 10001111 |
            +----------+
            1 row in set (0.00 sec)

            mysql-5.6 returns the correct result in both cases.

            igor Igor Babaev (Inactive) added a comment - - edited Here' s what we have for MyISAM (the correct result): MariaDB [test]> CREATE TABLE t1(f1 bit(2)) ENGINE=MYISAM; Query OK, 0 rows affected (0.01 sec)   MariaDB [test]> INSERT INTO t1 VALUES (b''); Query OK, 1 row affected (0.00 sec)   MariaDB [test]> SELECT HEX(f1) from t1; +---------+ | HEX(f1) | +---------+ | 0 | +---------+ 1 row in set (0.00 sec)   MariaDB [test]> SELECT bin(f1) from t1; +---------+ | bin(f1) | +---------+ | 0 | +---------+ 1 row in set (0.00 sec) And here's what we have for INNODB (an incorrect result): MariaDB [test]> CREATE TABLE t2(f1 bit(2)) ENGINE=INNODB; Query OK, 0 rows affected (0.06 sec)   MariaDB [test]> INSERT INTO t2 VALUES (b''); Query OK, 1 row affected (0.01 sec)   MariaDB [test]> SELECT HEX(f1) from t2; +---------+ | HEX(f1) | +---------+ | 8F | +---------+ 1 row in set (0.00 sec)   MariaDB [test]> SELECT bin(f1) from t2; +----------+ | bin(f1) | +----------+ | 10001111 | +----------+ 1 row in set (0.00 sec) mysql-5.6 returns the correct result in both cases.
            svoj Sergey Vojtovich made changes -
            Assignee Igor Babaev [ igor ] Alexander Barkov [ bar ]
            serg Sergei Golubchik made changes -
            Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 43592 ] MariaDB v3 [ 64888 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64888 ] MariaDB v4 [ 147764 ]

            People

              serg Sergei Golubchik
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.