SQLite
Check-in [0ae142178d]
Not logged in
Overview
SHA1 Hash:0ae142178d5ff874a4df58d699adad3a41e3d8d2
Date: 2012-12-19 16:32:33
User: drh
Comment:A couple more test cases.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to test/tkt-a7b7803e.test

61 db eval { 61 db eval { 62 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b 62 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b 63 FROM t1 M, t1 N 63 FROM t1 M, t1 N 64 WHERE x AND y 64 WHERE x AND y 65 ORDER BY M.a, N.a 65 ORDER BY M.a, N.a 66 } 66 } 67 } {1 fuzzy 1 first} 67 } {1 fuzzy 1 first} > 68 do_test tkt-a7b7803e.7 { > 69 db eval { > 70 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b > 71 FROM t1 M JOIN t1 N ON x AND y > 72 ORDER BY M.a, N.a 68 | 73 } > 74 } {1 fuzzy 1 first} > 75 do_test tkt-a7b7803e.8 { > 76 db eval { > 77 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b > 78 FROM t1 M JOIN t1 N ON x > 79 ORDER BY M.a, N.a > 80 } > 81 } {1 fuzzy 1 first 1 fuzzy 0 fuzzy} > 82 > 83 69 finish_test 84 finish_test