Lines Matching refs:h2

1193   CREATE TABLE h2(x COLLATE nocase);
1194   INSERT INTO h2 VALUES('One');
1195   INSERT INTO h2 VALUES('Two');
1196   INSERT INTO h2 VALUES('Three');
1197   INSERT INTO h2 VALUES('Four');
1198   INSERT INTO h2 VALUES('one');
1199   INSERT INTO h2 VALUES('two');
1200   INSERT INTO h2 VALUES('three');
1201   INSERT INTO h2 VALUES('four');
1237   3.1 "SELECT ALL x FROM h2" {One Two Three Four one two three four}
1238   3.2 "SELECT ALL x FROM h1, h2 ON (x=b)" {One one Four four}
1240   3.1 "SELECT x FROM h2" {One Two Three Four one two three four}
1241   3.2 "SELECT x FROM h1, h2 ON (x=b)" {One one Four four}
1243   4.1 "SELECT DISTINCT x FROM h2" {One Two Three Four}
1244   4.2 "SELECT DISTINCT x FROM h1, h2 ON (x=b)" {One Four}
1260   3  "SELECT DISTINCT x FROM h2"                  {One Two Three Four}
1261   4  "SELECT DISTINCT x COLLATE binary FROM h2"   {