Overview
| SHA1 Hash: | 0ae142178d5ff874a4df58d699adad3a41e3d8d2 |
|---|---|
| Date: | 2012-12-19 16:32:33 |
| User: | drh |
| Comment: | A couple more test cases. |
Tags And Properties
- branch=tkt-a7b7803e inherited from [3d0e00c731]
- closed added by [ce1c4feae8] on 2012-12-19 16:58:14
- sym-tkt-a7b7803e inherited from [3d0e00c731]
Changes
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