} {ab bA bB ba bb}do_test collate2-2.14 {  execsql {    SELECT b FROM collate2t1 WHERE NOT b <= 'aa' ORDER BY 1, oid;  }} {ab aB Ab AB ba bA Ba BA bb bB Bb BB}do_test collate2-2.15 {  execsql {    SELECT c FROM collate2t1 WHERE NOT c <= 'aa' ORDER BY 1;  }} {ba Ab Bb ab bb}do_test collate2-2.16 {  execsql {    SELECT a FROM collate2t1 WHERE a NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;  }} {AA AB aA aB aa ab bA bB ba bb}do_test collate2-2.17 {  execsql {    SELECT b FROM collate2t1 WHERE b NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1, oid;  }} {}do_test collate2-2.18 {  execsql {    SELECT c FROM collate2t1 WHERE c NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;  }} {AA BA aA bA AB BB aB bB ab bb}do_test collate2-2.19 {  execsql {    SELECT a FROM collate2t1 WHERE NOT CASE a WHEN 'aa' THEN 1 ELSE 0 END;  }} {{} ab ba bb aA aB bA bB Aa Ab Ba Bb AA AB BA BB}do_test collate2-2.20 {  execsql {    SELECT b FROM collate2t1 WHERE NOT CASE b WHEN 'aa' THEN 1 ELSE 0 END;  }} {{} ab ba bb aB bA bB Ab Ba Bb AB BA BB}do_test collate2-2.21 {  execsql {    SELECT c FROM collate2t1 WHERE NOT CASE c WHEN 'aa' THEN 1 ELSE 0 END;  }} {{} ab ba bb aA aB bA bB Aa Ab Ba Bb AA AB BA BB}ifcapable subquery {  do_test collate2-2.22 {    execsql {      SELECT a FROM collate2t1 WHERE NOT a IN ('aa', 'bb');    }  } {ab ba aA aB bA bB Aa Ab Ba Bb AA AB BA BB}  do_test collate2-2.23 {    execsql {      SELECT b FROM collate2t1 WHERE NOT b IN ('aa', 'bb');    }  } {ab ba aB bA Ab Ba AB BA}  do_test collate2-2.24 {    execsql {      SELECT c FROM collate2t1 WHERE NOT c IN ('aa', 'bb');    }  } {ab ba aA aB bA bB Aa Ab Ba Bb AA AB BA BB}  do_test collate2-2.25 {    execsql {      SELECT a FROM collate2t1         WHERE NOT a IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));    }  } {ab ba aA aB bA bB Aa Ab Ba Bb AA AB BA BB}  do_test collate2-2.26 {    execsql {      SELECT b FROM collate2t1         WHERE NOT b IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));    }  } {ab ba aB bA Ab Ba AB BA}  do_test collate2-2.27 {    execsql {      SELECT c FROM collate2t1         WHERE NOT c IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'));    }  } {ab ba aA aB bA bB Aa Ab Ba Bb AA AB BA BB}}do_test collate2-3.1 {  execsql {    SELECT a > 'aa' FROM collate2t1;  }} {{} 0 1 1 1 0 0 1 1 0 0 0 0 0 0 0 0}do_test collate2-3.2 {  execsql {    SELECT b > 'aa' FROM collate2t1;  }} {{} 0 1 1 1 0 1 1 1 0 1 1 1 0 1 1 1}do_test collate2-3.3 {  execsql {    SELECT c > 'aa' FROM collate2t1;  }} {{} 0 1 1 1 0 0 0 0 0 1 0 1 0 0 0 0}do_test collate2-3.4 {  execsql {    SELECT a < 'aa' FROM collate2t1;  }} {{} 0 0 0 0 1 1 0 0 1 1 1 1 1 1 1 1}do_test collate2-3.5 {  execsql {    SELECT b < 'aa' FROM collate2t1;  }} {{} 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0}do_test collate2-3.6 {  execsql {    SELECT c < 'aa' FROM collate2t1;  }} {{} 0 0 0 0 1 1 1 1 1 0 1 0 1 1 1 1}do_test collate2-3.7 {  execsql {    SELECT a = 'aa' FROM collate2t1;  }} {{} 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0}do_test collate2-3.8 {  execsql {    SELECT b = 'aa' FROM collate2t1;  }} {{} 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0}do_test collate2-3.9 {  execsql {    SELECT c = 'aa' FROM collate2t1;  }} {{} 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0}do_test collate2-3.10 {  execsql {    SELECT a <= 'aa' FROM collate2t1;  }} {{} 1 0 0 0 1 1 0 0 1 1 1 1 1 1 1 1}do_test collate2-3.11 {  execsql {    SELECT b <= 'aa' FROM collate2t1;  }} {{} 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0}do_test collate2-3.12 {  execsql {    SELECT c <= 'aa' FROM collate2t1;  }} {{} 1 0 0 0 1 1 1 1 1 0 1 0 1 1 1 1}do_test collate2-3.13 {  execsql {    SELECT a >= 'aa' FROM collate2t1;  }} {{} 1 1 1 1 0 0 1 1 0 0 0 0 0 0 0 0}do_test collate2-3.14 {  execsql {    SELECT b >= 'aa' FROM collate2t1;  }} {{} 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1}do_test collate2-3.15 {  execsql {    SELECT c >= 'aa' FROM collate2t1;  }} {{} 1 1 1 1 0 0 0 0 0 1 0 1 0 0 0 0}do_test collate2-3.16 {  execsql {    SELECT a BETWEEN 'Aa' AND 'Bb' FROM collate2t1;  }} {{} 0 0 0 0 0 0 0 0 1 1 1 1 0 0 1 1}do_test collate2-3.17 {  execsql {    SELECT b BETWEEN 'Aa' AND 'Bb' FROM collate2t1;  }} {{} 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1}do_test collate2-3.18 {  execsql {    SELECT c BETWEEN 'Aa' AND 'Bb' FROM collate2t1;  }} {{} 1 0 1 0 0 0 0 0 1 1 1 1 0 0 0 0}do_test collate2-3.19 {  execsql {    SELECT CASE a WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;  }} {0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0}do_test collate2-3.20 {  execsql {    SELECT CASE b WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;  }} {0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0}do_test collate2-3.21 {  execsql {    SELECT CASE c WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;  }} {0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0}ifcapable subquery {  do_test collate2-3.22 {    execsql {      SELECT a IN ('aa', 'bb') FROM collate2t1;    }  } {{} 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0}  do_test collate2-3.23 {    execsql {      SELECT b IN ('aa', 'bb') FROM collate2t1;    }  } {{} 1 0 0 1 1 0 0 1 1 0 0 1 1 0 0 1}  do_test collate2-3.24 {    execsql {      SELECT c IN ('aa', 'bb') FROM collate2t1;    }  } {{} 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0}  do_test collate2-3.25 {    execsql {      SELECT a IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))         FROM collate2t1;    }  } {{} 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0}  do_test collate2-3.26 {    execsql {      SELECT b IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))         FROM collate2t1;    }  } {{} 1 0 0 1 1 0 0 1 1 0 0 1 1 0 0 1}  do_test collate2-3.27 {    execsql {      SELECT c IN (SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb'))         FROM collate2t1;    }  } {{} 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0}}do_test collate2-4.0 {  execsql {    CREATE TABLE collate2t2(b COLLATE binary);    CREATE TABLE collate2t3(b text);    INSERT INTO collate2t2 VALUES('aa');    INSERT INTO collate2t3 VALUES('aa');  }} {}# Test that when both sides of a binary comparison operator have# default collation types, the collate type for the leftmost term# is used.do_test collate2-4.1 {  execsql {    SELECT collate2t1.a FROM collate2t1, collate2t2       WHERE collate2t1.b = collate2t2.b;  }} {aa aA Aa AA}do_test collate2-4.2 {  execsql {    SELECT collate2t1.a FROM collate2t1, collate2t2       WHERE collate2t2.b = collate2t1.b;  }} {aa}# Test that when one side has a default collation type and the other# does not, the collation type is used.do_test collate2-4.3 {  execsql {    SELECT collate2t1.a FROM collate2t1, collate2t3       WHERE collate2t1.b = collate2t3.b||'';  }} {aa aA Aa AA}do_test collate2-4.4 {  execsql {    SELECT collate2t1.a FROM collate2t1, collate2t3       WHERE collate2t3.b||'' = collate2t1.b;  }} {aa aA Aa AA}do_test collate2-4.5 {  execsql {    DROP TABLE collate2t3;  }} {}## Test that the default collation types are used when the JOIN syntax# is used in place of a WHERE clause.## SQLite transforms the JOIN syntax into a WHERE clause internally, so# the focus of these tests is to ensure that the table on the left-hand-side# of the join determines the collation type used. #do_test collate2-5.0 {  execsql {    SELECT collate2t1.b FROM collate2t1 JOIN collate2t2 USING (b);  }} {aa aA Aa AA}do_test collate2-5.1 {  execsql {    SELECT collate2t1.b FROM collate2t2 JOIN collate2t1 USING (b);  }} {aa}do_test collate2-5.2 {  execsql {    SELECT collate2t1.b FROM collate2t1 NATURAL JOIN collate2t2;  }} {aa aA Aa AA}do_test collate2-5.3 {  execsql {    SELECT collate2t1.b FROM collate2t2 NATURAL JOIN collate2t1;  }} {aa}do_test collate2-5.4 {  execsql {    SELECT collate2t2.b FROM collate2t1 LEFT OUTER JOIN collate2t2 USING (b) order by collate2t1.oid;  }} {{} aa {} {} {} aa {} {} {} aa {} {} {} aa {} {} {}}do_test collate2-5.5 {  execsql {    SELECT collate2t1.b, collate2t2.b FROM collate2t2 LEFT OUTER JOIN collate2t1 USING (b);  }} {aa aa}finish_test