Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add some more IN operator tests. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
fb32e374b75b160e7b535e732ced6c34 |
| User & Date: | mistachkin 2014-06-26 22:17:21.764 |
Context
|
2014-06-30
| ||
| 11:14 | Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. (check-in: 6f86d89b88 user: drh tags: trunk) | |
|
2014-06-28
| ||
| 14:25 | Merge fixes from trunk with this branch. (check-in: 6af219d1b8 user: dan tags: stat4-skipscan) | |
|
2014-06-26
| ||
| 22:17 | Add some more IN operator tests. (check-in: fb32e374b7 user: mistachkin tags: trunk) | |
| 21:28 | Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. (check-in: 92f7ad43db user: mistachkin tags: trunk) | |
Changes
Changes to test/tkt-9a8b09f8e6.test.
| ︙ | ︙ | |||
41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
do_test 1.4 {
execsql {
CREATE TABLE t4(x REAL);
INSERT INTO t4 VALUES(1.11);
}
} {}
do_test 2.1 {
execsql {
SELECT x FROM t1 WHERE x IN (1);
}
} {1}
| > > > > > > > > > > | 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
do_test 1.4 {
execsql {
CREATE TABLE t4(x REAL);
INSERT INTO t4 VALUES(1.11);
}
} {}
do_test 1.5 {
execsql {
CREATE TABLE t5(x, y);
INSERT INTO t5 VALUES('1', 'one');
INSERT INTO t5 VALUES(1, 'two');
INSERT INTO t5 VALUES('1.0', 'three');
INSERT INTO t5 VALUES(1.0, 'four');
}
} {}
do_test 2.1 {
execsql {
SELECT x FROM t1 WHERE x IN (1);
}
} {1}
|
| ︙ | ︙ | |||
257 258 259 260 261 262 263 264 265 |
} {1.11}
do_test 5.12 {
execsql {
SELECT x FROM t4 WHERE '1.11' IN (x);
}
} {}
finish_test
| > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 |
} {1.11}
do_test 5.12 {
execsql {
SELECT x FROM t4 WHERE '1.11' IN (x);
}
} {}
do_test 6.1 {
execsql {
SELECT x, y FROM t5 WHERE x IN (1);
}
} {1 two 1.0 four}
do_test 6.2 {
execsql {
SELECT x, y FROM t5 WHERE x IN (1.0);
}
} {1 two 1.0 four}
do_test 6.3 {
execsql {
SELECT x, y FROM t5 WHERE x IN ('1');
}
} {1 one}
do_test 6.4 {
execsql {
SELECT x, y FROM t5 WHERE x IN ('1.0');
}
} {1.0 three}
do_test 6.5 {
execsql {
SELECT x, y FROM t5 WHERE 1 IN (x);
}
} {1 two 1.0 four}
do_test 6.6 {
execsql {
SELECT x, y FROM t5 WHERE 1.0 IN (x);
}
} {1 two 1.0 four}
do_test 6.7 {
execsql {
SELECT x, y FROM t5 WHERE '1' IN (x);
}
} {1 one}
do_test 6.8 {
execsql {
SELECT x, y FROM t5 WHERE '1.0' IN (x);
}
} {1.0 three}
finish_test
|