mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
2606c91afd
* Sort test result so the test case would pass * Server message has been changes * Added schema name in query for rows in test case only. Also use lower case schema name * Changed database to lower case * Run test case in its own database to avoid table already exists error Co-authored-by: root <root@rocky8.localdomain>
20 lines
1.4 KiB
Plaintext
20 lines
1.4 KiB
Plaintext
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol4766;
|
|
--enable_warnings
|
|
CREATE DATABASE mcol4766;
|
|
USE mcol4766;
|
|
CREATE TABLE t(x integer) ENGINE=COLUMNSTORE;
|
|
INSERT INTO t(x) VALUES (1), (2);
|
|
SELECT c.table_schema, c.table_name, c.column_name, e.min_value, e.max_value FROM information_schema.columnstore_extents e, information_schema.columnstore_columns c WHERE c.table_schema='mcol4766' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
|
|
START TRANSACTION;
|
|
INSERT INTO t(x) VALUES (-1), (100);
|
|
ROLLBACK;
|
|
SELECT c.table_schema, c.table_name, c.column_name, e.min_value, e.max_value FROM information_schema.columnstore_extents e, information_schema.columnstore_columns c WHERE c.table_schema='mcol4766' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
|
|
START TRANSACTION;
|
|
UPDATE t SET x = 100 WHERE x = 2;
|
|
SELECT c.table_schema, c.table_name, c.column_name, e.min_value, e.max_value FROM information_schema.columnstore_extents e, information_schema.columnstore_columns c WHERE c.table_schema='mcol4766' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
|
|
ROLLBACK;
|
|
SELECT c.table_schema, c.table_name, c.column_name, e.min_value, e.max_value FROM information_schema.columnstore_extents e, information_schema.columnstore_columns c WHERE c.table_schema='mcol4766' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
|
|
SELECT * FROM t;
|
|
DROP DATABASE mcol4766;
|