Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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
- blocks
-
MCOL-6003 Check columnstore against 11.8
-
- In Progress
-
- is blocked by
-
MDEV-37484 Sql_cmd_dml::execute_inner Sql_cmd_update::execute_inner do not call Select handler for the engine involved
-
- In Progress
-