-- original: like2.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT x FROM t3 WHERE y LIKE 'abcA%' ;SELECT x FROM t1 WHERE y LIKE 'B%' ;SELECT x FROM t2 WHERE y LIKE 'B%' ;SELECT x FROM t3 WHERE y LIKE 'abcB%' ;SELECT x FROM t1 WHERE y LIKE 'C%' ;SELECT x FROM t2 WHERE y LIKE 'C%' ;SELECT x FROM t3 WHERE y LIKE 'abcC%' ;SELECT x FROM t1 WHERE y LIKE 'D%' ;SELECT x FROM t2 WHERE y LIKE 'D%' ;SELECT x FROM t3 WHERE y LIKE 'abcD%' ;SELECT x FROM t1 WHERE y LIKE 'E%' ;SELECT x FROM t2 WHERE y LIKE 'E%' ;SELECT x FROM t3 WHERE y LIKE 'abcE%' ;SELECT x FROM t1 WHERE y LIKE 'F%' ;SELECT x FROM t2 WHERE y LIKE 'F%' ;SELECT x FROM t3 WHERE y LIKE 'abcF%' ;SELECT x FROM t1 WHERE y LIKE 'G%' ;SELECT x FROM t2 WHERE y LIKE 'G%' ;SELECT x FROM t3 WHERE y LIKE 'abcG%' ;SELECT x FROM t1 WHERE y LIKE 'H%' ;SELECT x FROM t2 WHERE y LIKE 'H%' ;SELECT x FROM t3 WHERE y LIKE 'abcH%' ;SELECT x FROM t1 WHERE y LIKE 'I%' ;SELECT x FROM t2 WHERE y LIKE 'I%' ;SELECT x FROM t3 WHERE y LIKE 'abcI%' ;SELECT x FROM t1 WHERE y LIKE 'J%' ;SELECT x FROM t2 WHERE y LIKE 'J%' ;SELECT x FROM t3 WHERE y LIKE 'abcJ%' ;SELECT x FROM t1 WHERE y LIKE 'K%' ;SELECT x FROM t2 WHERE y LIKE 'K%' ;SELECT x FROM t3 WHERE y LIKE 'abcK%' ;SELECT x FROM t1 WHERE y LIKE 'L%' ;SELECT x FROM t2 WHERE y LIKE 'L%' ;SELECT x FROM t3 WHERE y LIKE 'abcL%' ;SELECT x FROM t1 WHERE y LIKE 'M%' ;SELECT x FROM t2 WHERE y LIKE 'M%' ;SELECT x FROM t3 WHERE y LIKE 'abcM%' ;SELECT x FROM t1 WHERE y LIKE 'N%' ;SELECT x FROM t2 WHERE y LIKE 'N%' ;SELECT x FROM t3 WHERE y LIKE 'abcN%' ;SELECT x FROM t1 WHERE y LIKE 'O%' ;SELECT x FROM t2 WHERE y LIKE 'O%' ;SELECT x FROM t3 WHERE y LIKE 'abcO%' ;SELECT x FROM t1 WHERE y LIKE 'P%' ;SELECT x FROM t2 WHERE y LIKE 'P%' ;SELECT x FROM t3 WHERE y LIKE 'abcP%' ;SELECT x FROM t1 WHERE y LIKE 'Q%' ;SELECT x FROM t2 WHERE y LIKE 'Q%' ;SELECT x FROM t3 WHERE y LIKE 'abcQ%' ;SELECT x FROM t1 WHERE y LIKE 'R%' ;SELECT x FROM t2 WHERE y LIKE 'R%' ;SELECT x FROM t3 WHERE y LIKE 'abcR%' ;SELECT x FROM t1 WHERE y LIKE 'S%' ;SELECT x FROM t2 WHERE y LIKE 'S%' ;SELECT x FROM t3 WHERE y LIKE 'abcS%' ;SELECT x FROM t1 WHERE y LIKE 'T%' ;SELECT x FROM t2 WHERE y LIKE 'T%' ;SELECT x FROM t3 WHERE y LIKE 'abcT%' ;SELECT x FROM t1 WHERE y LIKE 'U%' ;SELECT x FROM t2 WHERE y LIKE 'U%' ;SELECT x FROM t3 WHERE y LIKE 'abcU%' ;SELECT x FROM t1 WHERE y LIKE 'V%' ;SELECT x FROM t2 WHERE y LIKE 'V%' ;SELECT x FROM t3 WHERE y LIKE 'abcV%' ;SELECT x FROM t1 WHERE y LIKE 'W%' ;SELECT x FROM t2 WHERE y LIKE 'W%' ;SELECT x FROM t3 WHERE y LIKE 'abcW%' ;SELECT x FROM t1 WHERE y LIKE 'X%' ;SELECT x FROM t2 WHERE y LIKE 'X%' ;SELECT x FROM t3 WHERE y LIKE 'abcX%' ;SELECT x FROM t1 WHERE y LIKE 'Y%' ;SELECT x FROM t2 WHERE y LIKE 'Y%' ;SELECT x FROM t3 WHERE y LIKE 'abcY%' ;SELECT x FROM t1 WHERE y LIKE 'Z%' ;SELECT x FROM t2 WHERE y LIKE 'Z%' ;SELECT x FROM t3 WHERE y LIKE 'abcZ%' ;SELECT x FROM t1 WHERE y LIKE '[%' ;SELECT x FROM t2 WHERE y LIKE '[%' ;SELECT x FROM t3 WHERE y LIKE 'abc[%' ;SELECT x FROM t1 WHERE y LIKE '\%' ;SELECT x FROM t2 WHERE y LIKE '\%' ;SELECT x FROM t3 WHERE y LIKE 'abc\%' ;SELECT x FROM t1 WHERE y LIKE ']%' ;SELECT x FROM t2 WHERE y LIKE ']%' ;SELECT x FROM t3 WHERE y LIKE 'abc]%' ;SELECT x FROM t1 WHERE y LIKE '^%' ;SELECT x FROM t2 WHERE y LIKE '^%' ;SELECT x FROM t3 WHERE y LIKE 'abc^%' ;SELECT x FROM t1 WHERE y LIKE '`%' ;SELECT x FROM t2 WHERE y LIKE '`%' ;SELECT x FROM t3 WHERE y LIKE 'abc`%' ;SELECT x FROM t1 WHERE y LIKE 'a%' ;SELECT x FROM t2 WHERE y LIKE 'a%' ;SELECT x FROM t3 WHERE y LIKE 'abca%' ;SELECT x FROM t1 WHERE y LIKE 'b%' ;SELECT x FROM t2 WHERE y LIKE 'b%' ;SELECT x FROM t3 WHERE y LIKE 'abcb%' ;SELECT x FROM t1 WHERE y LIKE 'c%' ;SELECT x FROM t2 WHERE y LIKE 'c%' ;SELECT x FROM t3 WHERE y LIKE 'abcc%';