System.Data.SQLite
Check-in [8748c7e73a]
Not logged in

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

Overview
Comment:Adjust expected results for test 'tkt-c010fa6584-1.1' to account for floating point differences between runtimes.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | netStandard21
Files: files | file ages | folders
SHA1: 8748c7e73a6e912b64ff248fce0dbeb937edc74e
User & Date: mistachkin 2019-10-09 03:38:46
Context
2019-10-09
20:04
Fix typo in the 'testef6' project file for .NET Standard. check-in: e1d87429dc user: mistachkin tags: netStandard21
03:38
Adjust expected results for test 'tkt-c010fa6584-1.1' to account for floating point differences between runtimes. check-in: 8748c7e73a user: mistachkin tags: netStandard21
03:09
Update test 'data-1.2' to make it consistent with test 'data-1.3'. check-in: b1f8b8d63a user: mistachkin tags: netStandard21
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to Tests/tkt-c010fa6584.eagle.

121
122
123
124
125
126
127
128
129

130
131
132
133
134
135
136
...
146
147
148
149
150
151
152
153

154

155

156
157
158
159
160
161
162
163
...
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
...
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
  set results
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain match result code offset count results value name index \
      values db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{a01 0 False -9223372036854775809 0 -9.22337203685478E+18

a01 1 True -9223372036854775808 0 -9223372036854775808
a01 2 True -2147483649 0 -2147483649
a01 3 True -2147483648 0 -2147483648
a01 4 True -32769 0 -32769
a01 5 True -32768 0 -32768
a01 6 True -129 0 -129
a01 7 True -128 0 -128
................................................................................
a01 17 True 65535 0 65535
a01 18 True 65536 0 65536
a01 19 True 2147483647 0 2147483647
a01 20 True 2147483648 0 2147483648
a01 21 True 4294967295 0 4294967295
a01 22 True 4294967296 0 4294967296
a01 23 True 9223372036854775807 0 9223372036854775807
a01 24 False 9223372036854775808 0 9.22337203685478E+18

a01 25 False 18446744073709551615 0 1.84467440737096E+19

a01 26 False 18446744073709551616 0 1.84467440737096E+19

a02 0 False -9223372036854775809 0 -9.22337203685478e+18
a02 1 True -9223372036854775808 0 -9223372036854775808
a02 2 True -2147483649 0 -2147483649
a02 3 True -2147483648 0 -2147483648
a02 4 True -32769 0 -32769
a02 5 True -32768 0 -32768
a02 6 True -129 0 -129
a02 7 True -128 0 -128
................................................................................
a02 17 True 65535 0 65535
a02 18 True 65536 0 65536
a02 19 True 2147483647 0 2147483647
a02 20 True 2147483648 0 2147483648
a02 21 True 4294967295 0 4294967295
a02 22 True 4294967296 0 4294967296
a02 23 True 9223372036854775807 0 9223372036854775807
a02 24 False 9223372036854775808 0 9.22337203685478e+18
a02 25 False 18446744073709551615 0 1.84467440737096e+19
a02 26 False 18446744073709551616 0 1.84467440737096e+19
a03 0 False -9223372036854775809 0 -9223372036854775808
a03 1 True -9223372036854775808 0 -9223372036854775808
a03 2 True -2147483649 0 -2147483649
a03 3 True -2147483648 0 -2147483648
a03 4 True -32769 0 -32769
a03 5 True -32768 0 -32768
a03 6 True -129 0 -129
................................................................................
a32 20 True 2147483648 0 2147483648
a32 21 True 4294967295 0 4294967295
a32 22 True 4294967296 0 4294967296
a32 23 True 9223372036854775807 0 9223372036854775807
a32 24 False 9223372036854775808 0 9223372036854775807
a32 25 False 18446744073709551615 0 9223372036854775807
a32 26 False 18446744073709551616 0 9223372036854775807
}}

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

runTest {test tkt-c010fa6584-1.2 {UInt32 parameter} -setup {
  setupDb [set fileName tkt-c010fa6584-1.2.db]
} -body {
  sql execute $db "CREATE TABLE t1(x UINT32);"







|
|
>







 







|
>
|
>
|
>
|







 







|
|
|







 







|







121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
...
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
...
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
...
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
  set results
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain match result code offset count results value name index \
      values db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
regexp -result {^a01 0 False -9223372036854775809 0\
(?:-9\.22337203685478E\+18|-9\.223372036854776E\+18)
a01 1 True -9223372036854775808 0 -9223372036854775808
a01 2 True -2147483649 0 -2147483649
a01 3 True -2147483648 0 -2147483648
a01 4 True -32769 0 -32769
a01 5 True -32768 0 -32768
a01 6 True -129 0 -129
a01 7 True -128 0 -128
................................................................................
a01 17 True 65535 0 65535
a01 18 True 65536 0 65536
a01 19 True 2147483647 0 2147483647
a01 20 True 2147483648 0 2147483648
a01 21 True 4294967295 0 4294967295
a01 22 True 4294967296 0 4294967296
a01 23 True 9223372036854775807 0 9223372036854775807
a01 24 False 9223372036854775808 0\
(?:9\.22337203685478E\+18|9\.223372036854776E\+18)
a01 25 False 18446744073709551615 0\
(?:1\.84467440737096E\+19|1\.8446744073709552E\+19)
a01 26 False 18446744073709551616 0\
(?:1\.84467440737096E\+19|1\.8446744073709552E\+19)
a02 0 False -9223372036854775809 0 -9\.22337203685478e\+18
a02 1 True -9223372036854775808 0 -9223372036854775808
a02 2 True -2147483649 0 -2147483649
a02 3 True -2147483648 0 -2147483648
a02 4 True -32769 0 -32769
a02 5 True -32768 0 -32768
a02 6 True -129 0 -129
a02 7 True -128 0 -128
................................................................................
a02 17 True 65535 0 65535
a02 18 True 65536 0 65536
a02 19 True 2147483647 0 2147483647
a02 20 True 2147483648 0 2147483648
a02 21 True 4294967295 0 4294967295
a02 22 True 4294967296 0 4294967296
a02 23 True 9223372036854775807 0 9223372036854775807
a02 24 False 9223372036854775808 0 9\.22337203685478e\+18
a02 25 False 18446744073709551615 0 1\.84467440737096e\+19
a02 26 False 18446744073709551616 0 1\.84467440737096e\+19
a03 0 False -9223372036854775809 0 -9223372036854775808
a03 1 True -9223372036854775808 0 -9223372036854775808
a03 2 True -2147483649 0 -2147483649
a03 3 True -2147483648 0 -2147483648
a03 4 True -32769 0 -32769
a03 5 True -32768 0 -32768
a03 6 True -129 0 -129
................................................................................
a32 20 True 2147483648 0 2147483648
a32 21 True 4294967295 0 4294967295
a32 22 True 4294967296 0 4294967296
a32 23 True 9223372036854775807 0 9223372036854775807
a32 24 False 9223372036854775808 0 9223372036854775807
a32 25 False 18446744073709551615 0 9223372036854775807
a32 26 False 18446744073709551616 0 9223372036854775807
$}}

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

runTest {test tkt-c010fa6584-1.2 {UInt32 parameter} -setup {
  setupDb [set fileName tkt-c010fa6584-1.2.db]
} -body {
  sql execute $db "CREATE TABLE t1(x UINT32);"