1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sqlite3api/TEST/TclScript/where5.test Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,288 @@
1.4 +# 2007 June 8
1.5 +#
1.6 +# The author disclaims copyright to this source code. In place of
1.7 +# a legal notice, here is a blessing:
1.8 +#
1.9 +# May you do good and not evil.
1.10 +# May you find forgiveness for yourself and forgive others.
1.11 +# May you share freely, never taking more than you give.
1.12 +#
1.13 +#***********************************************************************
1.14 +# This file implements regression tests for SQLite library. The
1.15 +# focus of this file is testing NULL comparisons in the WHERE clause.
1.16 +# See ticket #2404.
1.17 +#
1.18 +# $Id: where5.test,v 1.2 2007/06/08 08:43:10 drh Exp $
1.19 +
1.20 +set testdir [file dirname $argv0]
1.21 +source $testdir/tester.tcl
1.22 +
1.23 +# Build some test data
1.24 +#
1.25 +do_test where5-1.0 {
1.26 + execsql {
1.27 + CREATE TABLE t1(x TEXT);
1.28 + CREATE TABLE t2(x INTEGER);
1.29 + CREATE TABLE t3(x INTEGER PRIMARY KEY);
1.30 + INSERT INTO t1 VALUES(-1);
1.31 + INSERT INTO t1 VALUES(0);
1.32 + INSERT INTO t1 VALUES(1);
1.33 + INSERT INTO t2 SELECT * FROM t1;
1.34 + INSERT INTO t3 SELECT * FROM t2;
1.35 + }
1.36 + execsql {
1.37 + SELECT * FROM t1 WHERE x<0
1.38 + }
1.39 +} {-1}
1.40 +do_test where5-1.1 {
1.41 + execsql {
1.42 + SELECT * FROM t1 WHERE x<=0
1.43 + }
1.44 +} {-1 0}
1.45 +do_test where5-1.2 {
1.46 + execsql {
1.47 + SELECT * FROM t1 WHERE x=0
1.48 + }
1.49 +} {0}
1.50 +do_test where5-1.3 {
1.51 + execsql {
1.52 + SELECT * FROM t1 WHERE x>=0
1.53 + }
1.54 +} {0 1}
1.55 +do_test where5-1.4 {
1.56 + execsql {
1.57 + SELECT * FROM t1 WHERE x>0
1.58 + }
1.59 +} {1}
1.60 +do_test where5-1.5 {
1.61 + execsql {
1.62 + SELECT * FROM t1 WHERE x<>0
1.63 + }
1.64 +} {-1 1}
1.65 +do_test where5-1.6 {
1.66 + execsql {
1.67 + SELECT * FROM t1 WHERE x<NULL
1.68 + }
1.69 +} {}
1.70 +do_test where5-1.7 {
1.71 + execsql {
1.72 + SELECT * FROM t1 WHERE x<=NULL
1.73 + }
1.74 +} {}
1.75 +do_test where5-1.8 {
1.76 + execsql {
1.77 + SELECT * FROM t1 WHERE x=NULL
1.78 + }
1.79 +} {}
1.80 +do_test where5-1.9 {
1.81 + execsql {
1.82 + SELECT * FROM t1 WHERE x>=NULL
1.83 + }
1.84 +} {}
1.85 +do_test where5-1.10 {
1.86 + execsql {
1.87 + SELECT * FROM t1 WHERE x>NULL
1.88 + }
1.89 +} {}
1.90 +do_test where5-1.11 {
1.91 + execsql {
1.92 + SELECT * FROM t1 WHERE x!=NULL
1.93 + }
1.94 +} {}
1.95 +do_test where5-1.12 {
1.96 + execsql {
1.97 + SELECT * FROM t1 WHERE x IS NULL
1.98 + }
1.99 +} {}
1.100 +do_test where5-1.13 {
1.101 + execsql {
1.102 + SELECT * FROM t1 WHERE x IS NOT NULL
1.103 + }
1.104 +} {-1 0 1}
1.105 +
1.106 +
1.107 +do_test where5-2.0 {
1.108 + execsql {
1.109 + SELECT * FROM t2 WHERE x<0
1.110 + }
1.111 +} {-1}
1.112 +do_test where5-2.1 {
1.113 + execsql {
1.114 + SELECT * FROM t2 WHERE x<=0
1.115 + }
1.116 +} {-1 0}
1.117 +do_test where5-2.2 {
1.118 + execsql {
1.119 + SELECT * FROM t2 WHERE x=0
1.120 + }
1.121 +} {0}
1.122 +do_test where5-2.3 {
1.123 + execsql {
1.124 + SELECT * FROM t2 WHERE x>=0
1.125 + }
1.126 +} {0 1}
1.127 +do_test where5-2.4 {
1.128 + execsql {
1.129 + SELECT * FROM t2 WHERE x>0
1.130 + }
1.131 +} {1}
1.132 +do_test where5-2.5 {
1.133 + execsql {
1.134 + SELECT * FROM t2 WHERE x<>0
1.135 + }
1.136 +} {-1 1}
1.137 +do_test where5-2.6 {
1.138 + execsql {
1.139 + SELECT * FROM t2 WHERE x<NULL
1.140 + }
1.141 +} {}
1.142 +do_test where5-2.7 {
1.143 + execsql {
1.144 + SELECT * FROM t2 WHERE x<=NULL
1.145 + }
1.146 +} {}
1.147 +do_test where5-2.8 {
1.148 + execsql {
1.149 + SELECT * FROM t2 WHERE x=NULL
1.150 + }
1.151 +} {}
1.152 +do_test where5-2.9 {
1.153 + execsql {
1.154 + SELECT * FROM t2 WHERE x>=NULL
1.155 + }
1.156 +} {}
1.157 +do_test where5-2.10 {
1.158 + execsql {
1.159 + SELECT * FROM t2 WHERE x>NULL
1.160 + }
1.161 +} {}
1.162 +do_test where5-2.11 {
1.163 + execsql {
1.164 + SELECT * FROM t2 WHERE x!=NULL
1.165 + }
1.166 +} {}
1.167 +do_test where5-2.12 {
1.168 + execsql {
1.169 + SELECT * FROM t2 WHERE x IS NULL
1.170 + }
1.171 +} {}
1.172 +do_test where5-2.13 {
1.173 + execsql {
1.174 + SELECT * FROM t2 WHERE x IS NOT NULL
1.175 + }
1.176 +} {-1 0 1}
1.177 +
1.178 +
1.179 +do_test where5-3.0 {
1.180 + execsql {
1.181 + SELECT * FROM t3 WHERE x<0
1.182 + }
1.183 +} {-1}
1.184 +do_test where5-3.1 {
1.185 + execsql {
1.186 + SELECT * FROM t3 WHERE x<=0
1.187 + }
1.188 +} {-1 0}
1.189 +do_test where5-3.2 {
1.190 + execsql {
1.191 + SELECT * FROM t3 WHERE x=0
1.192 + }
1.193 +} {0}
1.194 +do_test where5-3.3 {
1.195 + execsql {
1.196 + SELECT * FROM t3 WHERE x>=0
1.197 + }
1.198 +} {0 1}
1.199 +do_test where5-3.4 {
1.200 + execsql {
1.201 + SELECT * FROM t3 WHERE x>0
1.202 + }
1.203 +} {1}
1.204 +do_test where5-3.5 {
1.205 + execsql {
1.206 + SELECT * FROM t3 WHERE x<>0
1.207 + }
1.208 +} {-1 1}
1.209 +do_test where5-3.6 {
1.210 + execsql {
1.211 + SELECT * FROM t3 WHERE x<NULL
1.212 + }
1.213 +} {}
1.214 +do_test where5-3.7 {
1.215 + execsql {
1.216 + SELECT * FROM t3 WHERE x<=NULL
1.217 + }
1.218 +} {}
1.219 +do_test where5-3.8 {
1.220 + execsql {
1.221 + SELECT * FROM t3 WHERE x=NULL
1.222 + }
1.223 +} {}
1.224 +do_test where5-3.9 {
1.225 + execsql {
1.226 + SELECT * FROM t3 WHERE x>=NULL
1.227 + }
1.228 +} {}
1.229 +do_test where5-3.10 {
1.230 + execsql {
1.231 + SELECT * FROM t3 WHERE x>NULL
1.232 + }
1.233 +} {}
1.234 +do_test where5-3.11 {
1.235 + execsql {
1.236 + SELECT * FROM t3 WHERE x!=NULL
1.237 + }
1.238 +} {}
1.239 +do_test where5-3.12 {
1.240 + execsql {
1.241 + SELECT * FROM t3 WHERE x IS NULL
1.242 + }
1.243 +} {}
1.244 +do_test where5-3.13 {
1.245 + execsql {
1.246 + SELECT * FROM t3 WHERE x IS NOT NULL
1.247 + }
1.248 +} {-1 0 1}
1.249 +
1.250 +do_test where5-4.0 {
1.251 + execsql {
1.252 + SELECT x<NULL FROM t3
1.253 + }
1.254 +} {{} {} {}}
1.255 +do_test where5-4.1 {
1.256 + execsql {
1.257 + SELECT x<=NULL FROM t3
1.258 + }
1.259 +} {{} {} {}}
1.260 +do_test where5-4.2 {
1.261 + execsql {
1.262 + SELECT x==NULL FROM t3
1.263 + }
1.264 +} {{} {} {}}
1.265 +do_test where5-4.3 {
1.266 + execsql {
1.267 + SELECT x>NULL FROM t3
1.268 + }
1.269 +} {{} {} {}}
1.270 +do_test where5-4.4 {
1.271 + execsql {
1.272 + SELECT x>=NULL FROM t3
1.273 + }
1.274 +} {{} {} {}}
1.275 +do_test where5-4.5 {
1.276 + execsql {
1.277 + SELECT x!=NULL FROM t3
1.278 + }
1.279 +} {{} {} {}}
1.280 +do_test where5-4.6 {
1.281 + execsql {
1.282 + SELECT x IS NULL FROM t3
1.283 + }
1.284 +} {0 0 0}
1.285 +do_test where5-4.7 {
1.286 + execsql {
1.287 + SELECT x IS NOT NULL FROM t3
1.288 + }
1.289 +} {1 1 1}
1.290 +
1.291 +finish_test