Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Additional integer overflow boundary case tests. (CVS 1159) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
532170d4b8fc7a4e596a817257e9e1f8 |
User & Date: | drh 2004-01-06 01:52:34.000 |
Context
2004-01-06
| ||
02:23 | Version 2.8.9 (CVS 1160) (check-in: d8ae6bddeb user: drh tags: trunk) | |
01:52 | Additional integer overflow boundary case tests. (CVS 1159) (check-in: 532170d4b8 user: drh tags: trunk) | |
01:27 | Increase the version number and update the change log prior to the next release. (CVS 1158) (check-in: b99b68d026 user: drh tags: trunk) | |
Changes
Changes to test/misc3.test.
︙ | ︙ | |||
9 10 11 12 13 14 15 | # #*********************************************************************** # This file implements regression tests for SQLite library. # # This file implements tests for miscellanous features that were # left out of other test files. # | | | 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | # #*********************************************************************** # This file implements regression tests for SQLite library. # # This file implements tests for miscellanous features that were # left out of other test files. # # $Id: misc3.test,v 1.4 2004/01/06 01:52:34 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Ticket #529. Make sure an ABORT does not damage the in-memory cache # that will be used by subsequent statements in the same transaction. # |
︙ | ︙ | |||
118 119 120 121 122 123 124 | } ok do_test misc3-3.4 { execsql { INSERT INTO t2 VALUES(-2147483649); PRAGMA integrity_check; } } ok | > > > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 | } ok do_test misc3-3.4 { execsql { INSERT INTO t2 VALUES(-2147483649); PRAGMA integrity_check; } } ok do_test misc3-3.5 { execsql { INSERT INTO t2 VALUES(+2147483649); PRAGMA integrity_check; } } ok do_test misc3-3.6 { execsql { INSERT INTO t2 VALUES(+2147483647); INSERT INTO t2 VALUES(-2147483648); INSERT INTO t2 VALUES(-2147483647); INSERT INTO t2 VALUES(2147483646); SELECT * FROM t2 ORDER BY a; } } {-2147483649 -2147483648 -2147483647 2147483646 2147483647 2147483648 2147483649} do_test misc3-3.7 { execsql { SELECT * FROM t2 WHERE a>=-2147483648 ORDER BY a; } } {-2147483648 -2147483647 2147483646 2147483647 2147483648 2147483649} do_test misc3-3.8 { execsql { SELECT * FROM t2 WHERE a>-2147483648 ORDER BY a; } } {-2147483647 2147483646 2147483647 2147483648 2147483649} do_test misc3-3.9 { execsql { SELECT * FROM t2 WHERE a>-2147483649 ORDER BY a; } } {-2147483648 -2147483647 2147483646 2147483647 2147483648 2147483649} do_test misc3-3.10 { execsql { SELECT * FROM t2 WHERE a>=0 AND a<2147483649 ORDER BY a DESC; } } {2147483648 2147483647 2147483646} do_test misc3-3.11 { execsql { SELECT * FROM t2 WHERE a>=0 AND a<=2147483648 ORDER BY a DESC; } } {2147483648 2147483647 2147483646} do_test misc3-3.12 { execsql { SELECT * FROM t2 WHERE a>=0 AND a<2147483648 ORDER BY a DESC; } } {2147483647 2147483646} do_test misc3-3.13 { execsql { SELECT * FROM t2 WHERE a>=0 AND a<=2147483647 ORDER BY a DESC; } } {2147483647 2147483646} do_test misc3-3.14 { execsql { SELECT * FROM t2 WHERE a>=0 AND a<2147483647 ORDER BY a DESC; } } {2147483646} finish_test |