Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add another test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
00e7e8913961adfa16217a8a87b51258 |
| User & Date: | mistachkin 2014-02-05 21:05:28 |
Context
|
2014-02-06
| ||
| 19:45 | Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e]. check-in: 62a5b57a69 user: mistachkin tags: trunk | |
|
2014-02-05
| ||
| 21:05 | Add another test. check-in: 00e7e89139 user: mistachkin tags: trunk | |
| 21:00 | Add more tests. check-in: dc9d065888 user: mistachkin tags: trunk | |
Changes
Changes to Tests/basic.eagle.
2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 |
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{0 1 {{2014-02-01 12:34:56} 20140201123456} 0 0 1 1 2 2 0 {MYDATE {MYDATE\
DateTime True}} {{2014-02-01 12:34:56} {2014-02-01 12:34:56}}}}
###############################################################################
runTest {test data-1.61 {using TYPES with SELECT} -setup {
setupDb [set fileName data-1.61.db]
} -body {
set values [list NULL 1 'one' 1.0 X'01']
sql execute $db "CREATE TABLE t1(x, y);"
foreach x $values {
foreach y $values {
sql execute $db [appendArgs \
|
| > > > > > > > > > > > > > > > > > > > > > > > > > > > |
2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 |
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{0 1 {{2014-02-01 12:34:56} 20140201123456} 0 0 1 1 2 2 0 {MYDATE {MYDATE\
DateTime True}} {{2014-02-01 12:34:56} {2014-02-01 12:34:56}}}}
###############################################################################
runTest {test data-1.61 {SELECT without TYPES} -setup {
setupDb [set fileName data-1.61.db]
} -body {
set values [list NULL 1 'one' 1.0 X'01']
sql execute $db "CREATE TABLE t1(x, y);"
foreach x $values {
foreach y $values {
sql execute $db [appendArgs \
"INSERT INTO t1 (x, y) VALUES(" $x ", " $y ");"]
}
}
sql execute -execute reader -format list -allownull true $db \
"SELECT rowId, x, y FROM t1 ORDER BY rowId;"
} -cleanup {
cleanupDb $fileName
unset -nocomplain y x values db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{1 {} {} 2 {} 1 3 {} one 4 {} 1 5 {} 1 6 1 {} 7 1 1 8 1 one 9 1 1 10 1 1 11 one\
{} 12 one 1 13 one one 14 one 1 15 one 1 16 1 {} 17 1 1 18 1 one 19 1 1 20 1 1\
21 1 {} 22 1 1 23 1 one 24 1 1 25 1 1}}
###############################################################################
runTest {test data-1.62 {SELECT with TYPES} -setup {
setupDb [set fileName data-1.62.db]
} -body {
set values [list NULL 1 'one' 1.0 X'01']
sql execute $db "CREATE TABLE t1(x, y);"
foreach x $values {
foreach y $values {
sql execute $db [appendArgs \
|