Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
23.02.19
-
None
Description
— /usr/share/mysql/mysql-test/plugin/columnstore/columnstore/basic/r/mcs254_hex_function.result 2026-04-24 18:07:37.000000000 +0200
+++ /usr/share/mysql/mysql-test/plugin/columnstore/columnstore/basic/r/mcs254_hex_function.reject 2026-04-24 21:46:20.444043795 +0200
@@ -18,7 +18,7 @@
|
A
|
SELECT HEX(-1) FROM t1 LIMIT 1;
|
HEX(-1)
|
-FFFFFFFFFFFFFFFF
|
+FFFF
|
SELECT HEX('a') FROM t1 LIMIT 1;
|
HEX('a')
|
61
|
|
|
mysqltest: Result length mismatch
|
Manual check shows different behavious with Columnstore and InnoDB:
MariaDB [(none)]> CREATE DATABASE mcs254_db;
|
Query OK, 1 row affected (0.000 sec)
|
|
|
MariaDB [(none)]> USE mcs254_db;
|
Database changed
|
MariaDB [mcs254_db]> CREATE TABLE t1
|
-> (
|
-> t1_INT INT,
|
-> t1_DECIMAL DECIMAL(12,5),
|
-> t1_TEXT TEXT,
|
-> t1_DATE DATE,
|
-> t1_TIME TIME
|
-> )ENGINE=Columnstore;
|
Query OK, 0 rows affected (0.260 sec)
|
|
|
MariaDB [mcs254_db]> CREATE TABLE t1
|
-> (
|
-> t1_INT INT,
|
-> t1_DECIMAL DECIMAL(12,5),
|
-> t1_TEXT TEXT,
|
-> t1_DATE DATE,
|
-> t1_TIME TIME
|
-> )ENGINE=Innodb;
|
ERROR 1050 (42S01): Table 't1' already exists
|
MariaDB [mcs254_db]> CREATE TABLE t2 ( t1_INT INT, t1_DECIMAL DECIMAL(12,5), t1_TEXT TEXT, t1_DATE DATE, t1_TIME TIME )ENGINE=Innodb;
|
Query OK, 0 rows affected (0.005 sec)
|
|
|
MariaDB [mcs254_db]> SELECT HEX(-1) FROM t1 LIMIT 1;
|
Empty set (0.365 sec)
|
|
|
MariaDB [mcs254_db]> SELECT HEX(-1) FROM t1 LIMIT 2;
|
Empty set (0.005 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t1 VALUES(103, 1234.5699, 'pqrstuvwxyz', '1997-12-12', '22:12:02');
|
Query OK, 1 row affected (0.150 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t1 VALUES(-7299, 111.99, 'abcdefghijklm', '2001-1-1', '23:59:59');
|
Query OK, 1 row affected (0.104 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
|
Query OK, 1 row affected (0.102 sec)
|
|
|
MariaDB [mcs254_db]> SELECT HEX(-1) FROM t1 LIMIT 1;
|
+---------+
|
| HEX(-1) |
|
+---------+
|
| FFFF |
|
+---------+
|
1 row in set (0.050 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t2 VALUES(103, 1234.5699, 'pqrstuvwxyz', '1997-12-12', '22:12:02');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t2 VALUES(-7299, 111.99, 'abcdefghijklm', '2001-1-1', '23:59:59');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs254_db]> INSERT INTO t2 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs254_db]> SELECT HEX(-1) FROM t2 LIMIT 1;
|
+------------------+
|
| HEX(-1) |
|
+------------------+
|
| FFFFFFFFFFFFFFFF |
|
+------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [mcs254_db]>
|
|
Attachments
Issue Links
- blocks
-
-
- In Progress
-