database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-30 19:23:07 +03:00
Code Activity
Files
cmapi-grammar-fixes
mariadb-columnstore-engine/mysql-test/columnstore/basic/r/mcol2044-keep-actual-ranges-during-dml.result
Sergey Zefirov 69eec2cc0f MCOL-2044 Test sources made more resilient
2021-07-09 18:21:08 +03:00

704 lines
39 KiB
Plaintext
Raw Permalink Blame History

create database if not exists test_ranges;
use test_ranges;
drop table if exists t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x bigint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x decimal(38)) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x integer) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x smallint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
NULL NULL
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x tinyint) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x bigint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x integer unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x smallint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
delete from t where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
delete from t where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=66;
insert into t(x) values (77), (22);
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
0 -1
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=77 where x=66;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
77 44
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=33 where x=44;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 33
drop table t;
create table t(x tinyint unsigned) engine=columnstore;
insert into t(x) values (44),(55),(66);
update t set x=65 where x=55;
select e.max_value, e.min_value from information_schema.columnstore_extents e, information_schema.columnstore_columns c where c.table_schema='test_ranges' and c.table_name='t' and c.column_name='x' and c.object_id=e.object_id;
max_value min_value
66 44
drop database test_ranges;
View Git Blame Copy Permalink