-- original: expr.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT t1='a7Xc', t2='A7_C' ;SELECT t1='abcde', t2='a%e' ;SELECT t1='abcde', t2='A%E' ;SELECT t1='abcde', t2='a7%e' ;SELECT t1='abcde', t2='A7%E' ;SELECT t1='a7cde', t2='a7%e' ;SELECT t1='a7cde', t2='A7%E' ;SELECT t1='a7cde', t2='a77%e' ;SELECT t1='a7cde', t2='A77%E' ;SELECT t1='abc7', t2='a%77' ;SELECT t1='abc7', t2='A%77' ;SELECT t1='abc_', t2='a%7_' ;SELECT t1='abc_', t2='A%7_' ;SELECT t1='abc7', t2='a%7_' ;SELECT t1='abc7', t2='A%7_' ;SELECT t1='abc', t2='a_c' ;SELECT t1='abc', t2='A_C' ;SELECT t1='a_c', t2='au1234_c' ;SELECT t1='a_c', t2='Au1234_C' ;SELECT t1='abc', t2='au1234_c' ;SELECT t1='abc', t2='Au1234_C' ;SELECT t1='au1234Xc', t2='au1234_c' ;SELECT t1='au1234Xc', t2='Au1234_C' ;SELECT t1='abcde', t2='a%e' ;SELECT t1='abcde', t2='A%E' ;SELECT t1='abcde', t2='au1234%e' ;SELECT t1='abcde', t2='Au1234%E' ;SELECT t1='au1234cde', t2='au1234%e' ;SELECT t1='au1234cde', t2='Au1234%E' ;SELECT t1='au1234cde', t2='au1234u1234%e' ;SELECT t1='au1234cde', t2='Au1234u1234%E' ;SELECT t1='abcu1234', t2='a%u1234u1234' ;SELECT t1='abcu1234', t2='A%u1234u1234' ;SELECT t1='abc_', t2='a%u1234_' ;SELECT t1='abc_', t2='A%u1234_' ;SELECT t1='abcu1234', t2='a%u1234_' ;SELECT t1='abcu1234', t2='A%u1234_' ;SELECT t1='abc', t2='xyz' ;SELECT t1='abc', t2='ABC' ;SELECT t1='abc', t2='A?C' ;SELECT t1='abc', t2='a?c' ;SELECT t1='abc', t2='abc?' ;SELECT t1='abc', t2='A*C' ;SELECT t1='abc', t2='a*c' ;SELECT t1='abxyzzyc', t2='a*c' ;SELECT t1='abxyzzy', t2='a*c' ;SELECT t1='abxyzzycx', t2='a*c' ;SELECT t1='abc', t2='xyz' ;SELECT t1='abc', t2='abc' ;SELECT t1='abc', t2='a[bx]c' ;SELECT t1='abc', t2='a[cx]c' ;SELECT t1='abc', t2='a[a-d]c' ;SELECT t1='abc', t2='a[^a-d]c' ;SELECT t1='abc', t2='a[A-Dc]c' ;SELECT t1='abc', t2='a[^A-Dc]c' ;SELECT t1='abc', t2='a[]b]c' ;SELECT t1='abc', t2='a[^]b]c' ;SELECT t1='abcdefg', t2='a*[de]g' ;SELECT t1='abcdefg', t2='a*[df]g' ;SELECT t1='abcdefg', t2='a*[d-h]g' ;SELECT t1='abcdefg', t2='a*[b-e]g' ;SELECT t1='abcdefg', t2='a*[^de]g' ;SELECT t1='abcdefg', t2='a*[^def]g' ;SELECT t1='abcdefg', t2='a*?g' ;SELECT t1='ac', t2='a*c' ;SELECT t1='ac', t2='a*?c' ;SELECT t1='a*c', t2='a[*]c' ;SELECT t1='a?c', t2='a[?]c' ;SELECT t1='a[c', t2='a[[]c' ;SELECT t1='au0080c', t2='a?c' ;SELECT t1='au07ffc', t2='a?c' ;SELECT t1='au0800c', t2='a?c' ;SELECT t1='auffffc', t2='a?c' ;SELECT t1='au1234', t2='a?' ;SELECT t1='au1234', t2='a??' ;SELECT t1='axu1234', t2='a?u1234' ;SELECT t1='axu1234', t2='a*u1234' ;SELECT t1='axu1234yu1234', t2='a*u1234' ;SELECT t1='au1234b', t2='a[xu1234y]b' ;SELECT t1='au1234b', t2='a[u1233-u1235]b' ;SELECT t1='au1234b', t2='a[u1234-u124f]b' ;SELECT t1='au1234b', t2='a[u1235-u124f]b' ;SELECT t1='au1234b', t2='a[a-u1235]b' ;SELECT t1='au1234b', t2='a[a-u1234]b' ;SELECT t1='au1234b', t2='a[a-u1233]b' ;SELECT t1='ABC', t2='xyz' ;SELECT t1='ABC', t2='abc' ;SELECT t1='ABC', t2='a?c' ;SELECT t1='ABC', t2='A?C' ;SELECT t1='ABC', t2='abc?' ;SELECT t1='ABC', t2='a*c' ;SELECT t1='ABC', t2='A*C' ;SELECT t1='ABxyzzyC', t2='A*C' ;SELECT t1='ABxyzzy', t2='A*C' ;SELECT t1='ABxyzzyCx', t2='A*C' ;SELECT t1='ABC', t2='xyz' ;SELECT t1='ABC', t2='ABC' ;SELECT t1='ABC', t2='A[Bx]C' ;SELECT t1='ABC', t2='A[Cx]C' ;SELECT t1='ABC', t2='A[A-D]C';