You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
2f4108be00
* Need to add order by clause since different test run would return rows in different order * Avoid warning regarding undeterministic functions when binlog is enabled * Added missing drop database statement * Added reference result files * Added order by clause to more queries
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;
|