"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/709493.test" (6 May 2012, 398 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 
    6 select * from t1 left join t2
    7   on t1.col_int_unique = t2.col_int_unique and t1.col_int = t2.col_int 
    8   where t1.pk=1;
    9 
   10 drop table t1;
   11 drop table t2;