1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-05 15:41:14 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7132_regression_bug3952.result
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;