Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Work in progress on the test for ticket [53633bbe39]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | tkt-53633bbe39 |
| Files: | files | file ages | folders |
| SHA1: |
56a4359338799deb7af7068b8b43cc76 |
| User & Date: | mistachkin 2016-03-21 21:35:09 |
Context
|
2016-04-01
| ||
| 00:23 | Add tests for ticket [53633bbe39]. check-in: 8b5a097e13 user: mistachkin tags: trunk | |
|
2016-03-21
| ||
| 21:35 | Work in progress on the test for ticket [53633bbe39]. Closed-Leaf check-in: 56a4359338 user: mistachkin tags: tkt-53633bbe39 | |
| 16:18 | Add preliminary test for ticket [53633bbe39]. check-in: a5653a0674 user: mistachkin tags: tkt-53633bbe39 | |
Changes
Changes to Tests/tkt-53633bbe39.eagle.
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
CREATE TABLE t1(x);
INSERT INTO t1 (x) VALUES(NULL);
INSERT INTO t1 (x) VALUES(1);
INSERT INTO t1 (x) VALUES(2.0);
INSERT INTO t1 (x) VALUES(3.14159);
}
sql execute -execute reader -format list -allownull true $db \
"SELECT x FROM t1 ORDER BY x;"
} -cleanup {
cleanupDb $fileName
restoreSQLiteConvertEnvironment
restoreSQLiteConnectionEnvironment
unset -nocomplain db fileName savedEnv
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{{} 1 2.0 3.14159}}
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|
| | > > > > > > > > > > > > > | | < |
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 |
CREATE TABLE t1(x);
INSERT INTO t1 (x) VALUES(NULL);
INSERT INTO t1 (x) VALUES(1);
INSERT INTO t1 (x) VALUES(2.0);
INSERT INTO t1 (x) VALUES(3.14159);
}
set dataReader [sql execute -execute reader -format datareader \
-alias $db "SELECT x FROM t1 ORDER BY x;"]
set results [list]
while {[$dataReader Read]} {
set result [list]
lappend result [catch {$dataReader GetString 0} result] $result
lappend result [catch {$dataReader GetValue 0} result] $result
lappend results $result
}
set results
} -cleanup {
cleanupDb $fileName
restoreSQLiteConvertEnvironment
restoreSQLiteConnectionEnvironment
unset -nocomplain result results db fileName savedEnv
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result {}}
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|