--disable_query_log
set @@session.explicit_defaults_for_timestamp=off;
--enable_query_log
# owner: bin.lb
# owner group: SQL2
# tags: dml
# description:
#
--disable_warnings
drop table if exists tt1;
--enable_warnings

create table tt1(c1 int primary key, c2 int);
insert into tt1 values(1,4);
insert into tt1 values(2,3);

select c1, c2 as c1 from tt1;

--error 1052
select c1, c2 as c1 from tt1 order by c1;

select c2 as c1 from tt1 order by c1;

select c2 as c1 from tt1 where c1<4;

select c1 as cc, c2 as c1 from tt1 where c1<4;

select c1 as cc, c2 as c1 from tt1 order by c1;

select c1, c2 as c1 from tt1 where c1<4;

select c2 as cc from tt1  order by c1;

select c2 as c1 from tt1 order by c1;

select c1 as c1, c2 as c1 from tt1 where c1<4;
#show columns from t1 like 'c1';
show columns from tt1;
#show columns from t1 like '%c%';