Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
2023-8, 2023-10
Description
To replicate this issue, download the file CS162.tar.gz (360MB) from Support shared google drive, subdirectory CS0586162. You will need at least10G free space to make this happen. Follow these steps:
root@logs:~/CS0586162/run$ tar xvfz /tmp/CS162.tar.gz
|
root@logs:~/CS0586162/run$ ls -l ./*
|
-rw-r--r-- 1 root root 2898 Jul 22 03:52 ./cs_162.sql
|
-rw-r--r-- 1 root root 908 Jul 22 03:17 ./cs_queries.sql
|
-rw-r--r-- 1 root root 3581066458 Jul 22 01:56 ./inno_162.sql
|
-rw-r--r-- 1 root root 910 Jul 22 03:17 ./inno_queries.sql
|
root@logs:~/CS0586162/run$ mariadb < inno_162.sql # will create schema "inno" with innodb tables
|
root@logs:~/CS0586162/run$ mariadb < cs_162.sql # will create schema "cs" with columnstore tables, and load from "inno" schema using cpimport
|
Now, using the provided scripts, you can compare the results of the same queries on "inno" tables with queries on "cs" tables. You will see that the final query returns 111 rows on "inno" tables and 10 rows on "cs" tables, even though the data is identical.
root@logs:~/CS0586162/run$ mariadb -v -Ae "source inno_queries.sql"
|
+----------+
|
| count(*) |
|
+----------+
|
| 111 |
|
+----------+
|
root@logs:~/CS0586162/run$ mariadb -v -Ae "source cs_queries.sql"
|
+----------+
|
| count(*) |
|
+----------+
|
| 10 |
|
+----------+
|