mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
33 lines
1.4 KiB
Plaintext
33 lines
1.4 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3258.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists var_between;
|
|
--enable_warnings
|
|
|
|
create table var_between (c1 varchar(10), c2 char(7)) engine=columnstore;
|
|
insert into var_between values ('099', '099');
|
|
insert into var_between values ('9', '9');
|
|
insert into var_between values ('1', '1');
|
|
select 'q1', var_between.* from var_between where substr(c1,1,1) between '0' and '9';
|
|
select 'q2', var_between.* from var_between where substr(c1,1,1) not between '0' and '9';
|
|
select 'q3', var_between.* from var_between where substr(c2,1,1) between '0' and '9';
|
|
select 'q4', var_between.* from var_between where substr(c2,1,1) not between '0' and '9';
|
|
select 'q5', count(*) from orders where substr(o_comment, 1, 1) between 'a' and 'f';
|
|
select 'q6', count(*) from orders where substr(o_orderpriority, 1, 1) between '2' and '3';
|
|
select 'q7', count(*) from orders where substr(o_orderpriority, 1, 1) not between '2' and '3';
|
|
select 'q8', count(*) from orders where substr(o_totalprice, 2, 3) between '200' and '300';
|
|
select 'q9', count(*) from orders where substr(o_totalprice, 2, 3) not between '200' and '300';
|
|
#
|
|
--disable_warnings
|
|
drop table var_between;
|
|
--enable_warnings
|
|
#
|