"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/709493.result" (6 May 2012, 468 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 create table t1 (pk int primary key, col_int int, col_int_unique int unique key);
    2 insert into t1 values (1,NULL,2), (2,0,0);
    3 create table t2 (pk int primary key, col_int int, col_int_unique int unique key);
    4 insert into t2 values (1,0,1), (2,0,2);
    5 select * from t1 left join t2
    6 on t1.col_int_unique = t2.col_int_unique and t1.col_int = t2.col_int 
    7 where t1.pk=1;
    8 pk	col_int	col_int_unique	pk	col_int	col_int_unique
    9 1	NULL	2	NULL	NULL	NULL
   10 drop table t1;
   11 drop table t2;