Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
23.02.2
-
None
-
None
-
2024-2
Description
Same query produces different results when one table is ENGINE=COLUMNSTORE. You must enable cross-engine queries to do this.
$ mariadb < CS0715568_dump.sql
|
$ mariadb -v -v -v < CS0715568_query.sql | grep 'rows in set'
|
42 rows in set (0.001 sec)
|
$ mariadb -Ae "alter table zzz_999.colstore_zzzzzz_zzz_999999 engine=COLUMNSTORE;"
|
$ mariadb -v -v -v < CS0715568_query.sql | grep 'rows in set'
|
25 rows in set (0.033 sec)
|
$
|
Tested on 23.02.2. I will attach the scripts used to show this.