USE tpch1;
drop database if exists test023_cs3;
drop database if exists test023_cs2;
create database test023_cs3;
create database test023_cs2;
use test023_cs2;
drop table if exists `test023_cs3`.`cs3`;
create table `test023_cs3`.`cs3`(i int, t text) engine=columnstore;
insert into `test023_cs3`.`cs3` values (1,'Lorem ipsum dolor sit amet, consectetur adipiscing elit,'),(7,'sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.'),(8,'Ut enim ad minim veniam,'),(9,'quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.'),(10,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore e');
select * from `test023_cs3`.`cs3`;
i	t
1	Lorem ipsum dolor sit amet, consectetur adipiscing elit,
7	sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
8	Ut enim ad minim veniam,
9	quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
10	Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore e
show create table `test023_cs3`.`cs3`;
Table	Create Table
cs3	CREATE TABLE `cs3` (
  `i` int(11) DEFAULT NULL,
  `t` text DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
delete from `test023_cs3`.`cs3` where i = 1;
update `test023_cs3`.`cs3` set i = 5 where i = 10;
select * from `test023_cs3`.`cs3`;
i	t
7	sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
8	Ut enim ad minim veniam,
9	quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
5	Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore e
alter table `test023_cs3`.`cs3` add column (nt text);
show create table `test023_cs3`.`cs3`;
Table	Create Table
cs3	CREATE TABLE `cs3` (
  `i` int(11) DEFAULT NULL,
  `t` text DEFAULT NULL,
  `nt` text DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
drop table `test023_cs3`.`cs3`;
show create table `test023_cs3`.`cs3`;
ERROR 42S02: Table 'test023_cs3.cs3' doesn't exist
use tpch1;
drop database if exists test023_cs3;
drop database if exists test023_cs2;