Lines Matching refs:r2
24 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
137 test_expr expr-2.1 {r1=1.23, r2=2.34} {r1+r2} 3.57
138 test_expr expr-2.2 {r1=1.23, r2=2.34} {r1-r2} -1.11
139 test_expr expr-2.3 {r1=1.23, r2=2.34} {r1*r2} 2.8782
140 test_expr expr-2.4 {r1=1.23, r2=2.34} {r1/r2} 0.525641025641026
141 test_expr expr-2.5 {r1=1.23, r2=2.34} {r2/r1} 1.90243902439024
142 test_expr expr-2.6 {r1=1.23, r2=2.34} {r2<r1} 0
143 test_expr expr-2.7 {r1=1.23, r2=2.34} {r2<=r1} 0
144 test_expr expr-2.8 {r1=1.23, r2=2.34} {r2>r1} 1
145 test_expr expr-2.9 {r1=1.23, r2=2.34} {r2>=r1} 1
146 test_expr expr-2.10 {r1=1.23, r2=2.34} {r2!=r1} 1
147 test_expr expr-2.11 {r1=1.23, r2=2.34} {r2=r1} 0
148 test_expr expr-2.12 {r1=1.23, r2=2.34} {r2<>r1} 1
149 test_expr expr-2.13 {r1=1.23, r2=2.34} {r2==r1} 0
150 test_expr expr-2.14 {r1=2.34, r2=2.34} {r2<r1} 0
151 test_expr expr-2.15 {r1=2.34, r2=2.34} {r2<=r1} 1
152 test_expr expr-2.16 {r1=2.34, r2=2.34} {r2>r1} 0
153 test_expr expr-2.17 {r1=2.34, r2=2.34} {r2>=r1} 1
154 test_expr expr-2.18 {r1=2.34, r2=2.34} {r2!=r1} 0
155 test_expr expr-2.19 {r1=2.34, r2=2.34} {r2=r1} 1
156 test_expr expr-2.20 {r1=2.34, r2=2.34} {r2<>r1} 0
157 test_expr expr-2.21 {r1=2.34, r2=2.34} {r2==r1} 1
158 test_expr expr-2.22 {r1=1.23, r2=2.34} {min(r1,r2,r1+r2,r1-r2)} {-1.11}
159 test_expr expr-2.23 {r1=1.23, r2=2.34} {max(r1,r2,r1+r2,r1-r2)} {3.57}
160 test_expr expr-2.24 {r1=25.0, r2=11.0} {r1%r2} 3
161 test_expr expr-2.25 {r1=1.23, r2=NULL} {coalesce(r1+r2,99.0)} 99.0
220 test_expr expr-4.10 {r1='0.0', r2='abc'} {r1>r2} 0
221 test_expr expr-4.11 {r1='abc', r2='Abc'} {r1<r2} 0
222 test_expr expr-4.12 {r1='abc', r2='Abc'} {r1>r2} 1
223 test_expr expr-4.13 {r1='abc', r2='Bbc'} {r1<r2} 0
224 test_expr expr-4.14 {r1='abc', r2='Bbc'} {r1>r2} 1
225 test_expr expr-4.15 {r1='0', r2='0.0'} {r1==r2} 1
226 test_expr expr-4.16 {r1='0.000', r2='0.0'} {r1==r2} 1
227 test_expr expr-4.17 {r1=' 0.000', r2=' 0.0'} {r1==r2} 0
228 test_expr expr-4.18 {r1='0.0', r2='abc'} {r1<r2} 1
229 test_expr expr-4.19 {r1='0.0', r2='abc'} {r1==r2} 0
230 test_expr expr-4.20 {r1='0.0', r2='abc'} {r1>r2} 0