Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Comment out some tests in select1.test that depend on "PRAGMA full_column_names" and "PRAGMA short_column_names". |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | primary-keys |
| Files: | files | file ages | folders |
| SHA1: |
946fe6504a509539837a4814f0ffc4a7 |
| User & Date: | dan 2012-04-17 18:49:06 |
Context
|
2012-04-18
| ||
| 18:27 | Add file kvlsm.c, a KVStore wrapper around lsm. check-in: 174119bec7 user: dan tags: primary-keys | |
|
2012-04-17
| ||
| 18:49 | Comment out some tests in select1.test that depend on "PRAGMA full_column_names" and "PRAGMA short_column_names". check-in: 946fe6504a user: dan tags: primary-keys | |
| 18:47 | Fix a couple of issues with ORDER BY. check-in: 34138a088b user: dan tags: primary-keys | |
Changes
Changes to test/select1.test.
406
407
408
409
410
411
412
413
414
415
416
417
418
419
...
606
607
608
609
610
611
612
613
614
615
616
617
618
619
|
} {0 33}
execsql {CREATE TABLE test2(t1 text, t2 text)}
execsql {INSERT INTO test2 VALUES('abc','xyz')}
# Check for column naming
#
do_test select1-6.1 {
set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
lappend v $msg
} {0 {f1 11 f1 33}}
do_test select1-6.1.1 {
db eval {PRAGMA full_column_names=on}
set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
................................................................................
} {test1.f1 11 test2.t1 abc}
db eval {
PRAGMA short_column_names=ON;
PRAGMA full_column_names=OFF;
}
ifcapable compound {
do_test select1-6.10 {
set v [catch {execsql2 {
SELECT f1 FROM test1 UNION SELECT f2 FROM test1
ORDER BY f2;
}} msg]
|
>
>
|
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
...
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
|
} {0 33}
execsql {CREATE TABLE test2(t1 text, t2 text)}
execsql {INSERT INTO test2 VALUES('abc','xyz')}
# Check for column naming
#
if 0 {
do_test select1-6.1 {
set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
lappend v $msg
} {0 {f1 11 f1 33}}
do_test select1-6.1.1 {
db eval {PRAGMA full_column_names=on}
set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
................................................................................
} {test1.f1 11 test2.t1 abc}
db eval {
PRAGMA short_column_names=ON;
PRAGMA full_column_names=OFF;
}
} ;# if 0 ...
ifcapable compound {
do_test select1-6.10 {
set v [catch {execsql2 {
SELECT f1 FROM test1 UNION SELECT f2 FROM test1
ORDER BY f2;
}} msg]
|