Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6029

columnstore/basic.func_bit fails with server 11.8

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.10.7
    • Tests
    • None

    Description

      --- /usr/share/mariadb/mariadb-test/plugin/columnstore/columnstore/basic/r/func_bit.result	2025-05-30 22:58:22.000000000 +0200
      +++ /usr/share/mariadb/mariadb-test/plugin/columnstore/columnstore/basic/r/func_bit.reject	2025-05-31 01:09:09.704942046 +0200
      @@ -101,9 +101,6 @@
       INSERT INTO t1 VALUES (63),(64),(65);
       SELECT a, 1<<a,1>>a FROM t1;
       a	1<<a	1>>a
      -63	9223372036854775808	0
      -64	0	0
      -65	0	0
       DROP TABLE t1;
       #
       # MCOL-4666 Empty set when using BIT OR and BIT AND functions in WHERE
      
      

      Manual check:

       
      MariaDB [(none)]> SET @@default_storage_engine=COALESCE("COLUMNSTORE", 'ColumnStore');
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> USE func_bit;
      Database changed
      MariaDB [func_bit]> CREATE TABLE t1 (a INT NOT NULL);
      Query OK, 0 rows affected (0.221 sec)
       
      MariaDB [func_bit]> INSERT INTO t1 VALUES (63),(64),(65);
      Query OK, 3 rows affected (0.017 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      MariaDB [func_bit]> SELECT a, 1<<a,1>>a FROM t1;
      +---+------+------+
      | a | 1<<a | 1>>a |
      +---+------+------+
      +---+------+------+
      0 rows in set (0.158 sec)
       
      MariaDB [func_bit]> SELECT a FROM t1;
      +---+
      | a |
      +---+
      +---+
      0 rows in set (0.004 sec)
       
      MariaDB [func_bit]> SELECT * FROM t1;
      +---+
      | a |
      +---+
      +---+
      0 rows in set (0.004 sec)
      

      Attachments

        Issue Links

          Activity

            People

              alexey.antipovsky Aleksei Antipovskii
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.