Lines Matching refs:o

105   CREATE TABLE t2(i INTEGER, n NUMERIC, t TEXT, o XBLOBY);
109   CREATE INDEX t2i4 ON t2(o);
137 test_boolset types2-2.10 {o = 30} {9 10}
138 test_boolset types2-2.11 {o = 30.0} {9 10}
139 test_boolset types2-2.12 {o = '30'} 11
140 test_boolset types2-2.13 {o = '30.0'} 12
157 test_boolset types2-3.1 {o < 20} {1 2}
158 test_boolset types2-3.2 {o < 20.0} {1 2}
159 test_boolset types2-3.3 {o < '20'} {1 2 3 4 5 6 9 10}
160 test_boolset types2-3.3 {o < '20.0'} {1 2 3 4 5 6 7 9 10}
269   test_boolset types2-6.1 {o IN ('10', 30)} {3 9 10}
270   test_boolset types2-6.2 {o IN (20.0, 30.0)} {5 6 9 10}
285   CREATE TABLE t3(i INTEGER, n NUMERIC, t TEXT, o BLOB);
298   test_bool types2-7.5 {i1='2.0'} {i1 IN (SELECT o FROM t3)} 1
304   test_bool types2-7.10 {n1='2.0'} {n1 IN (SELECT o FROM t3)} 1
310   test_bool types2-7.10 {t1='2.0'} {t1 IN (SELECT o FROM t3)} 0
312   test_bool types2-7.12 {t1='1.0'} {t1 IN (SELECT o FROM t3)} 1
314   test_bool types2-7.13 {o1=2} {o1 IN (SELECT o FROM t3)} 1
315   test_bool types2-7.14 {o1='2'} {o1 IN (SELECT o FROM t3)} 0
316   test_bool types2-7.15 {o1='2'} {o1 IN (SELECT o||'' FROM t3)} 1
322   CREATE TABLE t4(i INTEGER, n NUMERIC, t VARCHAR(20), o LARGE BLOB);
329   test_boolset types2-8.4 {o IN (SELECT i FROM t4)} {1 2 3 4}
333   test_boolset types2-8.8 {o IN (SELECT t FROM t4)} {7}
334   test_boolset types2-8.9 {i IN (SELECT o FROM t4)} {9 10 11 12}
335   test_boolset types2-8.6 {n IN (SELECT o FROM t4)} {9 10 11 12}
336   test_boolset types2-8.7 {t IN (SELECT o FROM t4)} {}
337   test_boolset types2-8.8 {o IN (SELECT o FROM t4)} {9 10}