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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
3d59c54a39c4c3149bf01063a91c3db3 |
| User & Date: | dan 2010-07-19 05:27:18 |
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: d692434b user: dan tags: trunk | |
| 05:27 | Enable previously failing tests in e_expr.test that pass following [3e5975aa3b]. check-in: 3d59c54a 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: 3e5975aa user: drh tags: trunk | |
Changes
Changes to test/e_expr.test.
74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 ... 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 ... 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 |
# << >> & | < <= > >= = == != <> 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 =. # # TODO: These tests are currently omitted because one or two cases # related to LIKE/GLOB/MATCH/REGEXP fail. After this case is fixed, # reinstate these tests. # if 0 { 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 ................................................................................ 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 [ expr {$opprec($op2) < $opprec($op1) ? $a3 : $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) ................................................................................ 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 # |
< < < < < < < | < < < |
74 75 76 77 78 79 80 81 82 83 84 85 86 87 ... 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 ... 157 158 159 160 161 162 163 164 165 166 167 168 169 170 |
# << >> & | < <= > >= = == != <> 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
................................................................................
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)
................................................................................
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
#
|