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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e81a7d474cf3274387cd7379cddf5814 |
| User & Date: | mistachkin 2011-09-30 21:01:41 |
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 |