1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-23 07:05:36 +03:00
2022-12-09 02:24:40 +00:00

10 lines
269 B
Plaintext

USE tpch1;
drop table if exists bug3952;
create table bug3952 (id int, name varchar(25));
insert into bug3952 values (1,'aaa'),(2,'bbb');
select * from bug3952 n1, (select * from bug3952)n2 where n1.id=n2.id;
id name id name
1 aaa 1 aaa
2 bbb 2 bbb
drop table bug3952;