1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7112_regression_bug3708.result
2022-12-09 02:24:40 +00:00

13 lines
1004 B
Plaintext

USE tpch1;
drop table if exists looooooooooooooooooooooooooooooooooooooooong_tb_name;
create table looooooooooooooooooooooooooooooooooooooooong_tb_name (looooooooooooooooooooooooooooooooooooooooong_col_name int)engine=columnstore;
insert into looooooooooooooooooooooooooooooooooooooooong_tb_name values (10);
select looooooooooooooooooooooooooooooooooooooooong_col_name from looooooooooooooooooooooooooooooooooooooooong_tb_name
order by isnull(looooooooooooooooooooooooooooooooooooooooong_col_name);
looooooooooooooooooooooooooooooooooooooooong_col_name
10
select concat('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', looooooooooooooooooooooooooooooooooooooooong_col_name) from looooooooooooooooooooooooooooooooooooooooong_tb_name;
concat('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', looooooooooooooooooooooooooooooooooooooooong_col_name)
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa10
drop table looooooooooooooooooooooooooooooooooooooooong_tb_name;