Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Enable previously failing tests in e_expr.test that pass following [3e5975aa3b]. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3d59c54a39c4c3149bf01063a91c3db3 |
User & Date: | dan 2010-07-19 05:27:18.000 |
Context
2010-07-19
| ||
11:16 | Re-introduce the prefix-search optimization of [feef1b15d6], which was lost in a reorganization of FTS3 code. (check-in: d692434b49 user: dan tags: trunk) | |
05:27 | Enable previously failing tests in e_expr.test that pass following [3e5975aa3b]. (check-in: 3d59c54a39 user: dan tags: trunk) | |
02:30 | Fix a parser bug that was causing the relative precedence of LIKE and < operators to be incorrect. (check-in: 3e5975aa3b user: drh tags: trunk) | |
Changes
Changes to test/e_expr.test.
︙ | ︙ | |||
74 75 76 77 78 79 80 | # << >> & | < <= > >= = == != <> IS IS # NOT IN LIKE GLOB MATCH REGEXP AND OR # # EVIDENCE-OF: R-38759-38789 Operators IS and IS NOT have the same # precedence as =. # | < < < < < < < | 74 75 76 77 78 79 80 81 82 83 84 85 86 87 | # << >> & | < <= > >= = == != <> IS IS # NOT IN LIKE GLOB MATCH REGEXP AND OR # # EVIDENCE-OF: R-38759-38789 Operators IS and IS NOT have the same # precedence as =. # unset -nocomplain untested foreach op1 $oplist { foreach op2 $oplist { set untested($op1,$op2) 1 foreach {tn A B C} { 1 22 45 66 2 0 0 0 |
︙ | ︙ | |||
122 123 124 125 126 127 128 | set sql2 "SELECT ($A $op1 $B) $op2 $C" set sql3 "SELECT $A $op1 ($B $op2 $C)" set a2 [db one $sql2] set a3 [db one $sql3] do_execsql_test $testname $sql1 [list [ | | < | 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 | set sql2 "SELECT ($A $op1 $B) $op2 $C" set sql3 "SELECT $A $op1 ($B $op2 $C)" set a2 [db one $sql2] set a3 [db one $sql3] do_execsql_test $testname $sql1 [list [ if {$opprec($op2) < $opprec($op1)} {set a3} {set a2} ]] if {$a2 != $a3} { unset -nocomplain untested($op1,$op2) } } } } foreach op {* AND OR + || & |} { unset untested($op,$op) } unset untested(+,-) ;# Since (a+b)-c == a+(b-c) |
︙ | ︙ | |||
165 166 167 168 169 170 171 | do_execsql_test e_expr-1.2.5 { SELECT 0 < 2 == 1, (0 < 2) == 1, 0 < (2 == 1) } {1 1 0} do_execsql_test e_expr-1.6 { SELECT 0 == 0 < 2, (0 == 0) < 2, 0 == (0 < 2) } {0 1 0} | < < | 157 158 159 160 161 162 163 164 165 166 167 168 169 170 | do_execsql_test e_expr-1.2.5 { SELECT 0 < 2 == 1, (0 < 2) == 1, 0 < (2 == 1) } {1 1 0} do_execsql_test e_expr-1.6 { SELECT 0 == 0 < 2, (0 == 0) < 2, 0 == (0 < 2) } {0 1 0} #------------------------------------------------------------------------- # Check that the four unary prefix operators mentioned in the # documentation exist. # # EVIDENCE-OF: R-13958-53419 Supported unary prefix operators are these: # - + ~ NOT # |
︙ | ︙ |