System.Data.SQLite

Check-in [d110972bc5]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Adjust expected results for tests 'tkt-3e783eecbe-1.1', 'tkt-3e783eecbe-1.2', and 'tkt-69cf6e5dc8-1.1' to account for floating point differences between runtimes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | netStandard21
Files: files | file ages | folders
SHA1: d110972bc5914803a29fe7e24627156da402b4b7
User & Date: mistachkin 2019-10-09 01:31:31.838
Context
2019-10-09
02:10
Simplify the changes to test 'data-1.3'. check-in: 60e9befd31 user: mistachkin tags: netStandard21
01:31
Adjust expected results for tests 'tkt-3e783eecbe-1.1', 'tkt-3e783eecbe-1.2', and 'tkt-69cf6e5dc8-1.1' to account for floating point differences between runtimes. check-in: d110972bc5 user: mistachkin tags: netStandard21
01:07
Add missing calls to 'info previouspid true' to the test suite. check-in: c7c7f4032f user: mistachkin tags: netStandard21
Changes
Unified Diff Ignore Whitespace Patch
Changes to Tests/tkt-3e783eecbe.eagle.
︙︙
53
54
55
56
57
58
59
60
61
62

63
64
65
66
67
68
69

        $code $result]
  }

  set results
} -cleanup {
  unset -nocomplain code result results dateTimeValue dateTimeValues \
      maxDateTime minDateTime
} -constraints {eagle command.object System.Data.SQLite} -result {{{0001-01-01\
00:00:00} 0 1721425.5} {{0099-12-31 00:00:00Z} 0 1757583.5} {{0100-01-01\
00:00:00Z} 0 1757584.5} {{9999-12-31 23:59:59.9999999} 0 5373484.49999999}}}


###############################################################################

runTest {test tkt-3e783eecbe-1.2 {From Julian Day w/o OLE Automation} -setup {
  set minDoubleValue [object invoke -create -alias Double MinValue]
  set maxDoubleValue [object invoke -create -alias Double MaxValue]









|
|
|
>








53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

        $code $result]
  }

  set results
} -cleanup {
  unset -nocomplain code result results dateTimeValue dateTimeValues \
      maxDateTime minDateTime
} -constraints {eagle command.object System.Data.SQLite} -match regexp \
-result {^\{\{0001-01-01 00:00:00\} 0 1721425\.5\} \{\{0099-12-31 00:00:00Z\}\
0 1757583\.5\} \{\{0100-01-01 00:00:00Z\} 0 1757584\.5\} \{\{9999-12-31\
23:59:59\.9999999\} 0 (?:5373484\.49999999|5373484\.499999989)\}$}}

###############################################################################

runTest {test tkt-3e783eecbe-1.2 {From Julian Day w/o OLE Automation} -setup {
  set minDoubleValue [object invoke -create -alias Double MinValue]
  set maxDoubleValue [object invoke -create -alias Double MaxValue]
︙︙
94
95
96
97
98
99
100
101
102
103

104
105

106
107
108
109
110
111
112
113
114
115

    lappend results [list [$doubleValue ToString] $code $result]
  }

  set results
} -cleanup {
  unset -nocomplain code result results dateTimeValue doubleValue \
      doubleValues maxDoubleValue minDoubleValue
} -constraints {eagle command.object System.Data.SQLite} -result \
{{-1.79769313486232E+308 1 System.ArgumentException} {-1 1\
System.ArgumentException} {0 1 System.ArgumentException} {1 1\

System.ArgumentException} {1721425.5 0 {0001-01-01 00:00:00Z}} {1757583.5 0\
{0099-12-31 00:00:00Z}} {2451910.5 0 {2001-01-01 00:00:00Z}} {2456962 0\

{2014-10-31 12:00:00Z}} {5373484.49999998 0 {9999-12-31 23:59:59.998Z}}\
{5373484.49999999 0 {9999-12-31 23:59:59.999Z}} {1.79769313486232E+308 1\
System.ArgumentException}}}

###############################################################################

runTest {test tkt-3e783eecbe-1.3 {Julian Day storage} -setup {
  set doubleValues [list \
      -1.0 0.0 1.0 1721425.5 1757583.5 2451910.5 2456962.0 \
      5373484.49999998 5373484.49999999]








|
|
|
>
|
|
>
|
|
|








95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

    lappend results [list [$doubleValue ToString] $code $result]
  }

  set results
} -cleanup {
  unset -nocomplain code result results dateTimeValue doubleValue \
      doubleValues maxDoubleValue minDoubleValue
} -constraints {eagle command.object System.Data.SQLite} -match regexp \
-result {^\{-1\.79769313486232E\+308|-1\.7976931348623157E\+308 1\
System\.ArgumentException\} \{-1 1 System\.ArgumentException\} \{0 1\
System\.ArgumentException\} \{1 1 System\.ArgumentException\} \{1721425\.5 0\
\{0001-01-01 00:00:00Z\}\} \{1757583\.5 0 \{0099-12-31 00:00:00Z\}\}\
\{2451910\.5 0 \{2001-01-01 00:00:00Z\}\} \{2456962 0 \{2014-10-31\
12:00:00Z\}\} \{5373484\.49999998 0 \{9999-12-31 23:59:59\.998Z\}\}\
\{5373484\.49999999 0 \{9999-12-31 23:59:59.999Z\}\}\
\{1\.79769313486232E\+308|1\.7976931348623157E\+308 1\
System\.ArgumentException\}$}}

###############################################################################

runTest {test tkt-3e783eecbe-1.3 {Julian Day storage} -setup {
  set doubleValues [list \
      -1.0 0.0 1.0 1721425.5 1757583.5 2451910.5 2456962.0 \
      5373484.49999998 5373484.49999999]
︙︙
Changes to Tests/tkt-69cf6e5dc8.eagle.
︙︙
47
48
49
50
51
52
53
54
55
56
57
58
59
60

} -cleanup {
  unset -nocomplain dataReader

  cleanupDb $fileName

  unset -nocomplain dateTime result db fileName
} -constraints {eagle command.object monoBug28 monoBug42 command.sql\
compile.DATA SQLite System.Data.SQLite} -result {2457712.53197917 {2016-11-20\
00:46:03Z}}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue








|
|






47
48
49
50
51
52
53
54
55
56
57
58
59
60

} -cleanup {
  unset -nocomplain dataReader

  cleanupDb $fileName

  unset -nocomplain dateTime result db fileName
} -constraints {eagle command.object monoBug28 monoBug42 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result \
{^(?:2457712\.53197917|2457712\.5319791664) \{2016-11-20 00:46:03Z\}$}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue