Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Test for NULL/empty value handling of DATETIME columns, ticket [8554170e09]. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
e81a7d474cf3274387cd7379cddf5814 |
User & Date: | mistachkin 2011-09-30 21:01:41.320 |
References
2011-09-30
| ||
21:02 | • Ticket [8554170e09] Executing INSERT statement with empty string for timestamp field results in unreadable data status still Open with 1 other change artifact: 80005f339a user: mistachkin | |
Context
2011-10-02
| ||
07:26 | Update Eagle in externals to the official beta 18 release. check-in: a2cff58449 user: mistachkin tags: trunk | |
2011-09-30
| ||
21:01 | Test for NULL/empty value handling of DATETIME columns, ticket [8554170e09]. check-in: e81a7d474c user: mistachkin tags: trunk | |
2011-09-29
| ||
06:20 | Missed one instance of common.eagle being loaded manually. check-in: e206579218 user: mistachkin tags: trunk | |
Changes
Added Tests/tkt-8554170e09.eagle.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 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 | ############################################################################### # # tkt-8554170e09.eagle -- # # Written by Joe Mistachkin. # Released to the public domain, use at your own risk! # ############################################################################### package require Eagle package require EagleLibrary package require EagleTest runTestPrologue ############################################################################### package require System.Data.SQLite.Test runSQLiteTestPrologue ############################################################################### runTest {test tkt-8554170e09-1.1 {default DATETIME value, NULL} -setup { setupDb [set fileName tkt-8554170e09-1.1.db] } -body { sql execute $db "CREATE TABLE t1(x INTEGER, y DATETIME);" sql execute $db "INSERT INTO t1 (x, y) VALUES(1, NULL);" set result [sql execute -execute reader -format list $db \ "SELECT x, y FROM t1 ORDER BY x;"] } -cleanup { cleanupDb $fileName unset -nocomplain result db fileName } -constraints {eagle monoBug28 command.sql compile.DATA System.Data.SQLite} \ -result {1}} ############################################################################### runTest {test tkt-8554170e09-1.2 {default DATETIME value, empty} -setup { setupDb [set fileName tkt-8554170e09-1.2.db] } -body { sql execute $db "CREATE TABLE t1(x INTEGER, y DATETIME);" sql execute $db "INSERT INTO t1 (x, y) VALUES(1, '');" set result [sql execute -execute reader -format list $db \ "SELECT x, y FROM t1 ORDER BY x;"] } -cleanup { cleanupDb $fileName unset -nocomplain result db fileName } -constraints {eagle monoBug28 command.sql compile.DATA System.Data.SQLite} \ -returnCodes 1 -match glob -result {*.SQLiteConvert.ToDateTime(*}} ############################################################################### runSQLiteTestEpilogue runTestEpilogue |