Lines Matching refs:r2
22 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
365 test_expr expr-2.1 {r1=1.23, r2=2.34} {r1+r2} 3.57
366 test_expr expr-2.2 {r1=1.23, r2=2.34} {r1-r2} -1.11
367 test_expr expr-2.3 {r1=1.23, r2=2.34} {r1*r2} 2.8782
371 test_expr expr-2.4 {r1=1.23, r2=2.34} {r1/r2} 0.525641025641026
372 test_expr expr-2.5 {r1=1.23, r2=2.34} {r2/r1} 1.90243902439024
373 test_expr expr-2.6 {r1=1.23, r2=2.34} {r2<r1} 0
374 test_expr expr-2.7 {r1=1.23, r2=2.34} {r2<=r1} 0
375 test_expr expr-2.8 {r1=1.23, r2=2.34} {r2>r1} 1
376 test_expr expr-2.9 {r1=1.23, r2=2.34} {r2>=r1} 1
377 test_expr expr-2.10 {r1=1.23, r2=2.34} {r2!=r1} 1
378 test_expr expr-2.11 {r1=1.23, r2=2.34} {r2=r1} 0
379 test_expr expr-2.12 {r1=1.23, r2=2.34} {r2<>r1} 1
380 test_expr expr-2.13 {r1=1.23, r2=2.34} {r2==r1} 0
381 test_expr expr-2.14 {r1=2.34, r2=2.34} {r2<r1} 0
382 test_expr expr-2.15 {r1=2.34, r2=2.34} {r2<=r1} 1
383 test_expr expr-2.16 {r1=2.34, r2=2.34} {r2>r1} 0
384 test_expr expr-2.17 {r1=2.34, r2=2.34} {r2>=r1} 1
385 test_expr expr-2.18 {r1=2.34, r2=2.34} {r2!=r1} 0
386 test_expr expr-2.19 {r1=2.34, r2=2.34} {r2=r1} 1
387 test_expr expr-2.20 {r1=2.34, r2=2.34} {r2<>r1} 0
388 test_expr expr-2.21 {r1=2.34, r2=2.34} {r2==r1} 1
389 test_expr expr-2.22 {r1=1.23, r2=2.34} {min(r1,r2,r1+r2,r1-r2)} {-1.11}
390 test_expr expr-2.23 {r1=1.23, r2=2.34} {max(r1,r2,r1+r2,r1-r2)} {3.57}
391 test_expr expr-2.24 {r1=25.0, r2=11.0} {r1%r2} 3.0
392 test_expr expr-2.25 {r1=1.23, r2=NULL} {coalesce(r1+r2,99.0)} 99.0
393 test_expr expr-2.26 {r1=1e300, r2=1e300} {coalesce((r1*r2)*0.0,99.0)} 99.0
394 test_expr expr-2.26b {r1=1e300, r2=-1e300} {coalesce((r1*r2)*0.0,99.0)} 99.0
395 test_expr expr-2.27 {r1=1.1, r2=0.0} {r1/r2} {{}}
396 test_expr expr-2.28 {r1=1.1, r2=0.0} {r1%r2} {{}}
457 test_expr expr-4.10 {r1='0.0', r2='abc'} {r1>r2} 0
458 test_expr expr-4.11 {r1='abc', r2='Abc'} {r1<r2} 0
459 test_expr expr-4.12 {r1='abc', r2='Abc'} {r1>r2} 1
460 test_expr expr-4.13 {r1='abc', r2='Bbc'} {r1<r2} 0
461 test_expr expr-4.14 {r1='abc', r2='Bbc'} {r1>r2} 1
462 test_expr expr-4.15 {r1='0', r2='0.0'} {r1==r2} 1
463 test_expr expr-4.16 {r1='0.000', r2='0.0'} {r1==r2} 1
464 test_expr expr-4.17 {r1=' 0.000', r2=' 0.0'} {r1==r2} 1
465 test_expr expr-4.18 {r1='0.0', r2='abc'} {r1<r2} 1
466 test_expr expr-4.19 {r1='0.0', r2='abc'} {r1==r2} 0
467 test_expr expr-4.20 {r1='0.0', r2='abc'} {r1>r2} 0