Lines Matching refs:h1

1185   CREATE TABLE h1(a, b);
1186   INSERT INTO h1 VALUES(1, 'one');
1187   INSERT INTO h1 VALUES(1, 'I');
1188   INSERT INTO h1 VALUES(1, 'i');
1189   INSERT INTO h1 VALUES(4, 'four');
1190   INSERT INTO h1 VALUES(4, 'IV');
1191   INSERT INTO h1 VALUES(4, 'iv');
1219   1   "SELECT ALL a FROM h1"      {1 1 1 4 4 4}
1220   2   "SELECT DISTINCT a FROM h1" {1 4}
1238   3.2 "SELECT ALL x FROM h1, h2 ON (x=b)" {One one Four four}
1241   3.2 "SELECT x FROM h1, h2 ON (x=b)" {One one Four four}
1244   4.2 "SELECT DISTINCT x FROM h1, h2 ON (x=b)" {One Four}
1258   1  "SELECT DISTINCT b FROM h1"                  {one I i four IV iv}
1259   2  "SELECT DISTINCT b COLLATE nocase FROM h1"   {one I four IV}