Lines Matching refs:i2
22 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
26 execsql {CREATE TABLE test1(i1 int, i2 int, t1 text, t2 text)}
41 test_expr expr-1.1 {i1=10, i2=20} {i1+i2} 30
42 test_expr expr-1.2 {i1=10, i2=20} {i1-i2} -10
43 test_expr expr-1.3 {i1=10, i2=20} {i1*i2} 200
44 test_expr expr-1.4 {i1=10, i2=20} {i1/i2} 0
45 test_expr expr-1.5 {i1=10, i2=20} {i2/i1} 2
46 test_expr expr-1.6 {i1=10, i2=20} {i2<i1} 0
47 test_expr expr-1.7 {i1=10, i2=20} {i2<=i1} 0
48 test_expr expr-1.8 {i1=10, i2=20} {i2>i1} 1
49 test_expr expr-1.9 {i1=10, i2=20} {i2>=i1} 1
50 test_expr expr-1.10 {i1=10, i2=20} {i2!=i1} 1
51 test_expr expr-1.11 {i1=10, i2=20} {i2=i1} 0
52 test_expr expr-1.12 {i1=10, i2=20} {i2<>i1} 1
53 test_expr expr-1.13 {i1=10, i2=20} {i2==i1} 0
54 test_expr expr-1.14 {i1=20, i2=20} {i2<i1} 0
55 test_expr expr-1.15 {i1=20, i2=20} {i2<=i1} 1
56 test_expr expr-1.16 {i1=20, i2=20} {i2>i1} 0
57 test_expr expr-1.17 {i1=20, i2=20} {i2>=i1} 1
58 test_expr expr-1.18 {i1=20, i2=20} {i2!=i1} 0
59 test_expr expr-1.19 {i1=20, i2=20} {i2=i1} 1
60 test_expr expr-1.20 {i1=20, i2=20} {i2<>i1} 0
61 test_expr expr-1.21 {i1=20, i2=20} {i2==i1} 1
63 test_expr expr-1.22 {i1=1, i2=2, r1=3.0} {i1+i2*r1} {7.0}
64 test_expr expr-1.23 {i1=1, i2=2, r1=3.0} {(i1+i2)*r1} {9.0}
66 test_expr expr-1.24 {i1=1, i2=2} {min(i1,i2,i1+i2,i1-i2)} {-1}
67 test_expr expr-1.25 {i1=1, i2=2} {max(i1,i2,i1+i2,i1-i2)} {3}
68 test_expr expr-1.26 {i1=1, i2=2} {max(i1,i2,i1+i2,i1-i2)} {3}
69 test_expr expr-1.27 {i1=1, i2=2} {i1==1 AND i2=2} {1}
70 test_expr expr-1.28 {i1=1, i2=2} {i1=2 AND i2=1} {0}
71 test_expr expr-1.29 {i1=1, i2=2} {i1=1 AND i2=1} {0}
72 test_expr expr-1.30 {i1=1, i2=2} {i1=2 AND i2=2} {0}
73 test_expr expr-1.31 {i1=1, i2=2} {i1==1 OR i2=2} {1}
74 test_expr expr-1.32 {i1=1, i2=2} {i1=2 OR i2=1} {0}
75 test_expr expr-1.33 {i1=1, i2=2} {i1=1 OR i2=1} {1}
76 test_expr expr-1.34 {i1=1, i2=2} {i1=2 OR i2=2} {1}
77 test_expr expr-1.35 {i1=1, i2=2} {i1-i2=-1} {1}
78 test_expr expr-1.36 {i1=1, i2=0} {not i1} {0}
79 test_expr expr-1.37 {i1=1, i2=0} {not i2} {1}
82 test_expr expr-1.40 {i1=1, i2=2} {+(i2+i1)} {3}
83 test_expr expr-1.41 {i1=1, i2=2} {-(i2+i1)} {-3}
84 test_expr expr-1.42 {i1=1, i2=2} {i1|i2} {3}
85 test_expr expr-1.42b {i1=1, i2=2} {4|2} {6}
86 test_expr expr-1.43 {i1=1, i2=2} {i1&i2} {0}
87 test_expr expr-1.43b {i1=1, i2=2} {4&5} {4}
90 test_expr expr-1.45a {i1=1, i2=3} {i1<<i2} {8}
91 test_expr expr-1.45b {i1=1, i2=-3} {i1>>i2} {8}
92 test_expr expr-1.45c {i1=1, i2=0} {i1<<i2} {1}
93 test_expr expr-1.45d {i1=1, i2=62} {i1<<i2} {4611686018427387904}
94 test_expr expr-1.45e {i1=1, i2=63} {i1<<i2} {-9223372036854775808}
95 test_expr expr-1.45f {i1=1, i2=64} {i1<<i2} {0}
96 test_expr expr-1.45g {i1=32, i2=-9223372036854775808} {i1>>i2} {0}
97 test_expr expr-1.46a {i1=32, i2=3} {i1>>i2} {4}
98 test_expr expr-1.46b {i1=32, i2=6} {i1>>i2} {0}
99 test_expr expr-1.46c {i1=-32, i2=3} {i1>>i2} {-4}
100 test_expr expr-1.46d {i1=-32, i2=100} {i1>>i2} {-1}
101 test_expr expr-1.46e {i1=32, i2=-3} {i1>>i2} {256}
102 test_expr expr-1.47 {i1=9999999999, i2=8888888888} {i1<i2} 0
103 test_expr expr-1.48 {i1=9999999999, i2=8888888888} {i1=i2} 0
104 test_expr expr-1.49 {i1=9999999999, i2=8888888888} {i1>i2} 1
105 test_expr expr-1.50 {i1=99999999999, i2=99999999998} {i1<i2} 0
106 test_expr expr-1.51 {i1=99999999999, i2=99999999998} {i1=i2} 0
107 test_expr expr-1.52 {i1=99999999999, i2=99999999998} {i1>i2} 1
108 test_expr expr-1.53 {i1=099999999999, i2=99999999999} {i1<i2} 0
109 test_expr expr-1.54 {i1=099999999999, i2=99999999999} {i1=i2} 1
110 test_expr expr-1.55 {i1=099999999999, i2=99999999999} {i1>i2} 0
111 test_expr expr-1.56 {i1=25, i2=11} {i1%i2} 3
112 test_expr expr-1.58 {i1=NULL, i2=1} {coalesce(i1+i2,99)} 99
113 test_expr expr-1.59 {i1=1, i2=NULL} {coalesce(i1+i2,99)} 99
114 test_expr expr-1.60 {i1=NULL, i2=NULL} {coalesce(i1+i2,99)} 99
115 test_expr expr-1.61 {i1=NULL, i2=1} {coalesce(i1-i2,99)} 99
116 test_expr expr-1.62 {i1=1, i2=NULL} {coalesce(i1-i2,99)} 99
117 test_expr expr-1.63 {i1=NULL, i2=NULL} {coalesce(i1-i2,99)} 99
118 test_expr expr-1.64 {i1=NULL, i2=1} {coalesce(i1*i2,99)} 99
119 test_expr expr-1.65 {i1=1, i2=NULL} {coalesce(i1*i2,99)} 99
120 test_expr expr-1.66 {i1=NULL, i2=NULL} {coalesce(i1*i2,99)} 99
121 test_expr expr-1.67 {i1=NULL, i2=1} {coalesce(i1/i2,99)} 99
122 test_expr expr-1.68 {i1=1, i2=NULL} {coalesce(i1/i2,99)} 99
123 test_expr expr-1.69 {i1=NULL, i2=NULL} {coalesce(i1/i2,99)} 99
124 test_expr expr-1.70 {i1=NULL, i2=1} {coalesce(i1<i2,99)} 99
125 test_expr expr-1.71 {i1=1, i2=NULL} {coalesce(i1>i2,99)} 99
126 test_expr expr-1.72 {i1=NULL, i2=NULL} {coalesce(i1<=i2,99)} 99
127 test_expr expr-1.73 {i1=NULL, i2=1} {coalesce(i1>=i2,99)} 99
128 test_expr expr-1.74 {i1=1, i2=NULL} {coalesce(i1!=i2,99)} 99
129 test_expr expr-1.75 {i1=NULL, i2=NULL} {coalesce(i1==i2,99)} 99
130 test_expr expr-1.76 {i1=NULL, i2=NULL} {coalesce(not i1,99)} 99
131 test_expr expr-1.77 {i1=NULL, i2=NULL} {coalesce(-i1,99)} 99
132 test_expr expr-1.78 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL AND i2=5,99)} 99
133 test_expr expr-1.79 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL OR i2=5,99)} 1
134 test_expr expr-1.80 {i1=NULL, i2=NULL} {coalesce(i1=5 AND i2 IS NULL,99)} 99
135 test_expr expr-1.81 {i1=NULL, i2=NULL} {coalesce(i1=5 OR i2 IS NULL,99)} 1
136 test_expr expr-1.82 {i1=NULL, i2=3} {coalesce(min(i1,i2,1),99)} 99
137 test_expr expr-1.83 {i1=NULL, i2=3} {coalesce(max(i1,i2,1),99)} 99
138 test_expr expr-1.84 {i1=3, i2=NULL} {coalesce(min(i1,i2,1),99)} 99
139 test_expr expr-1.85 {i1=3, i2=NULL} {coalesce(max(i1,i2,1),99)} 99
140 test_expr expr-1.86 {i1=3, i2=8} {5 between i1 and i2} 1
141 test_expr expr-1.87 {i1=3, i2=8} {5 not between i1 and i2} 0
142 test_expr expr-1.88 {i1=3, i2=8} {55 between i1 and i2} 0
143 test_expr expr-1.89 {i1=3, i2=8} {55 not between i1 and i2} 1
144 test_expr expr-1.90 {i1=3, i2=NULL} {5 between i1 and i2} {{}}
145 test_expr expr-1.91 {i1=3, i2=NULL} {5 not between i1 and i2} {{}}
146 test_expr expr-1.92 {i1=3, i2=NULL} {2 between i1 and i2} 0
147 test_expr expr-1.93 {i1=3, i2=NULL} {2 not between i1 and i2} 1
148 test_expr expr-1.94 {i1=NULL, i2=8} {2 between i1 and i2} {{}}
149 test_expr expr-1.95 {i1=NULL, i2=8} {2 not between i1 and i2} {{}}
150 test_expr expr-1.94 {i1=NULL, i2=8} {55 between i1 and i2} 0
151 test_expr expr-1.95 {i1=NULL, i2=8} {55 not between i1 and i2} 1
152 test_expr expr-1.96 {i1=NULL, i2=3} {coalesce(i1<<i2,99)} 99
153 test_expr expr-1.97 {i1=32, i2=NULL} {coalesce(i1>>i2,99)} 99
154 test_expr expr-1.98 {i1=NULL, i2=NULL} {coalesce(i1|i2,99)} 99
155 test_expr expr-1.99 {i1=32, i2=NULL} {coalesce(i1&i2,99)} 99
156 test_expr expr-1.100 {i1=1, i2=''} {i1=i2} 0
157 test_expr expr-1.101 {i1=0, i2=''} {i1=i2} 0
162 test_expr expr-1.102 {i1=40, i2=1} {i2<<i1} 1099511627776
183 test_expr expr-1.111 {i1=NULL, i2=8} {i1 IS i2} 0
184 test_expr expr-1.111b {i1=NULL, i2=8} {i1 IS NOT DISTINCT FROM i2} 0
185 test_expr expr-1.112 {i1=NULL, i2=NULL} {i1 IS i2} 1
186 test_expr expr-1.112b {i1=NULL, i2=NULL} {i1 IS NOT DISTINCT FROM i2} 1
187 test_expr expr-1.113 {i1=6, i2=NULL} {i1 IS i2} 0
188 test_expr expr-1.113b {i1=6, i2=NULL} {i1 IS NOT DISTINCT FROM i2} 0
189 test_expr expr-1.114 {i1=6, i2=6} {i1 IS i2} 1
190 test_expr expr-1.114b {i1=6, i2=6} {i1 IS NOT DISTINCT FROM i2} 1
191 test_expr expr-1.115 {i1=NULL, i2=8} \
192 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
193 test_expr expr-1.115b {i1=NULL, i2=8} \
194 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
195 test_expr expr-1.116 {i1=NULL, i2=NULL} \
196 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
197 test_expr expr-1.116b {i1=NULL, i2=NULL} \
198 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
199 test_expr expr-1.117 {i1=6, i2=NULL} \
200 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
201 test_expr expr-1.117b {i1=6, i2=NULL} \
202 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
203 test_expr expr-1.118 {i1=8, i2=8} \
204 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
205 test_expr expr-1.118b {i1=8, i2=8} \
206 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
207 test_expr expr-1.119 {i1=NULL, i2=8} {i1 IS NOT i2} 1
208 test_expr expr-1.119b {i1=NULL, i2=8} {i1 IS DISTINCT FROM i2} 1
209 test_expr expr-1.120 {i1=NULL, i2=NULL} {i1 IS NOT i2} 0
210 test_expr expr-1.120b {i1=NULL, i2=NULL} {i1 IS DISTINCT FROM i2} 0
211 test_expr expr-1.121 {i1=6, i2=NULL} {i1 IS NOT i2} 1
212 test_expr expr-1.121b {i1=6, i2=NULL} {i1 IS DISTINCT FROM i2} 1
213 test_expr expr-1.122 {i1=6, i2=6} {i1 IS NOT i2} 0
214 test_expr expr-1.122b {i1=6, i2=6} {i1 IS DISTINCT FROM i2} 0
215 test_expr expr-1.123 {i1=NULL, i2=8} \
216 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
217 test_expr expr-1.123b {i1=NULL, i2=8} \
218 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
219 test_expr expr-1.124 {i1=NULL, i2=NULL} \
220 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
221 test_expr expr-1.124b {i1=NULL, i2=NULL} \
222 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
223 test_expr expr-1.125 {i1=6, i2=NULL} \
224 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
225 test_expr expr-1.125b {i1=6, i2=NULL} \
226 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
227 test_expr expr-1.126 {i1=8, i2=8} \
228 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
229 test_expr expr-1.126b {i1=8, i2=8} \
230 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
238 {i1=9223372036854775806, i2=1} {i1+i2} 9223372036854775807
240 {i1=9223372036854775806, i2=2} {i1+i2} 9.22337203685478e+18
242 {i1=9223372036854775806, i2=100000} {i1+i2} 9.22337203685488e+18
244 {i1=9223372036854775807, i2=0} {i1+i2} 9223372036854775807
246 {i1=9223372036854775807, i2=1} {i1+i2} 9.22337203685478e+18
248 {i2=9223372036854775806, i1=1} {i1+i2} 9223372036854775807
250 {i2=9223372036854775806, i1=2} {i1+i2} 9.22337203685478e+18
252 {i2=9223372036854775806, i1=100000} {i1+i2} 9.22337203685488e+18
254 {i2=9223372036854775807, i1=0} {i1+i2} 9223372036854775807
256 {i2=9223372036854775807, i1=1} {i1+i2} 9.22337203685478e+18
258 {i1=-9223372036854775807, i2=-1} {i1+i2} -9223372036854775808
260 {i1=-9223372036854775807, i2=-2} {i1+i2} -9.22337203685478e+18
262 {i1=-9223372036854775807, i2=-100000} {i1+i2} -9.22337203685488e+18
264 {i1=-9223372036854775808, i2=0} {i1+i2} -9223372036854775808
266 {i1=-9223372036854775808, i2=-1} {i1+i2} -9.22337203685478e+18
268 {i2=-9223372036854775807, i1=-1} {i1+i2} -9223372036854775808
270 {i2=-9223372036854775807, i1=-2} {i1+i2} -9.22337203685478e+18
272 {i2=-9223372036854775807, i1=-100000} {i1+i2} -9.22337203685488e+18
274 {i2=-9223372036854775808, i1=0} {i1+i2} -9223372036854775808
276 {i2=-9223372036854775808, i1=-1} {i1+i2} -9.22337203685478e+18
278 {i1=9223372036854775806, i2=-1} {i1-i2} 9223372036854775807
280 {i1=9223372036854775806, i2=-2} {i1-i2} 9.22337203685478e+18
282 {i1=9223372036854775806, i2=-100000} {i1-i2} 9.22337203685488e+18
284 {i1=9223372036854775807, i2=0} {i1-i2} 9223372036854775807
286 {i1=9223372036854775807, i2=-1} {i1-i2} 9.22337203685478e+18
288 {i2=-9223372036854775806, i1=1} {i1-i2} 9223372036854775807
290 {i2=-9223372036854775806, i1=2} {i1-i2} 9.22337203685478e+18
292 {i2=-9223372036854775806, i1=100000} {i1-i2} 9.22337203685488e+18
294 {i2=-9223372036854775807, i1=0} {i1-i2} 9223372036854775807
296 {i2=-9223372036854775807, i1=1} {i1-i2} 9.22337203685478e+18
298 {i1=-9223372036854775807, i2=1} {i1-i2} -9223372036854775808
300 {i1=-9223372036854775807, i2=2} {i1-i2} -9.22337203685478e+18
302 {i1=-9223372036854775807, i2=100000} {i1-i2} -9.22337203685488e+18
304 {i1=-9223372036854775808, i2=0} {i1-i2} -9223372036854775808
306 {i1=-9223372036854775808, i2=1} {i1-i2} -9.22337203685478e+18
308 {i2=9223372036854775807, i1=-1} {i1-i2} -9223372036854775808
310 {i2=9223372036854775807, i1=-2} {i1-i2} -9.22337203685478e+18
312 {i2=9223372036854775807, i1=-100000} {i1-i2} -9.22337203685488e+18
314 {i2=9223372036854775807, i1=0} {i1-i2} -9223372036854775807
316 {i2=9223372036854775807, i1=-1} {i1-i2} -9223372036854775808
319 {i1=4294967296, i2=2147483648} {i1*i2} 9.22337203685478e+18
321 {i1=4294967296, i2=2147483647} {i1*i2} 9223372032559808512
323 {i1=-4294967296, i2=2147483648} {i1*i2} -9223372036854775808
325 {i1=-4294967296, i2=2147483647} {i1*i2} -9223372032559808512
327 {i1=4294967296, i2=-2147483648} {i1*i2} -9223372036854775808
329 {i1=4294967296, i2=-2147483647} {i1*i2} -9223372032559808512
331 {i1=-4294967296, i2=-2147483648} {i1*i2} 9.22337203685478e+18
333 {i1=-4294967296, i2=-2147483647} {i1*i2} 9223372032559808512
336 {i1=3037000500, i2=3037000500} {i1*i2} 9.22337203700025e+18
338 {i1=3037000500, i2=-3037000500} {i1*i2} -9.22337203700025e+18
340 {i1=-3037000500, i2=3037000500} {i1*i2} -9.22337203700025e+18
342 {i1=-3037000500, i2=-3037000500} {i1*i2} 9.22337203700025e+18
345 {i1=3037000500, i2=3037000499} {i1*i2} 9223372033963249500
347 {i1=3037000500, i2=-3037000499} {i1*i2} -9223372033963249500
349 {i1=-3037000500, i2=3037000499} {i1*i2} -9223372033963249500
351 {i1=-3037000500, i2=-3037000499} {i1*i2} 9223372033963249500
354 {i1=3037000499, i2=3037000500} {i1*i2} 9223372033963249500
356 {i1=3037000499, i2=-3037000500} {i1*i2} -9223372033963249500
358 {i1=-3037000499, i2=3037000500} {i1*i2} -9223372033963249500
360 {i1=-3037000499, i2=-3037000500} {i1*i2} 9223372033963249500
706 test_expr expr-case.1 {i1=1, i2=2} \
707 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne
708 test_expr expr-case.2 {i1=2, i2=2} \
709 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} eq
710 test_expr expr-case.3 {i1=NULL, i2=2} \
711 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne
712 test_expr expr-case.4 {i1=2, i2=NULL} \
713 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne