System.Data.SQLite

Check-in [8748c7e73a]
Login

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
Timelines: family | ancestors | descendants | both | netStandard21
Files: files | file ages | folders
SHA1: 8748c7e73a6e912b64ff248fce0dbeb937edc74e
User & Date: mistachkin 2019-10-09 03:38:46.413
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
Unified Diff 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
  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







|
|
>







121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
  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
146
147
148
149
150
151
152
153

154

155

156
157
158
159
160
161
162
163
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







|
>
|
>
|
>
|







147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
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
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
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







|
|
|







177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
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
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
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);"







|







990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
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);"