USE tpch1;
drop table if exists bug3657;
CREATE TABLE `bug3657` ( `name` varchar(11) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`id` int(11) DEFAULT NULL ) engine=columnstore;
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,11);
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,10);
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,9);
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,8);
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,7);
insert into bug3657 (name,birthdate,age,id)values("kayla",'2001-01-01',9,6);
select 'q1', birthdate, age, id from bug3657;
q1	birthdate	age	id
q1	2001-01-01	9	11
q1	2001-01-01	9	10
q1	2001-01-01	9	9
q1	2001-01-01	9	8
q1	2001-01-01	9	7
q1	2001-01-01	9	6
alter table bug3657 ADD COLUMN col8 int comment 'autoincrement';
select 'q2', birthdate, age, id, col8 from bug3657;
q2	birthdate	age	id	col8
q2	2001-01-01	9	11	1
q2	2001-01-01	9	10	2
q2	2001-01-01	9	9	3
q2	2001-01-01	9	8	4
q2	2001-01-01	9	7	5
q2	2001-01-01	9	6	6
select 'q3', birthdate, age, id, col8 from bug3657 where col8=2;
q3	birthdate	age	id	col8
q3	2001-01-01	9	10	2
select 'q4', birthdate, age, id, col8 from bug3657 where col8=1;
q4	birthdate	age	id	col8
q4	2001-01-01	9	11	1
select 'q5', birthdate, age, id, col8 from bug3657 where col8=6;
q5	birthdate	age	id	col8
q5	2001-01-01	9	6	6
select calflushcache();
calflushcache()
0
select 'q6', birthdate, age, id, col8 from bug3657 where col8=2;
q6	birthdate	age	id	col8
q6	2001-01-01	9	10	2
drop table if exists bug3657;