Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(704)

Issues Search
    My Issues | Starred     Open | Closed | All

Side by Side Diff: third_party/sqlite/test/boundary4.test

Issue 3108030: Move bundled copy of sqlite one level deeper to better separate it... (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/
Patch Set: Created 10 years, 4 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch | Annotate | Revision Log
« no previous file with comments | « third_party/sqlite/test/boundary4.tcl ('k') | third_party/sqlite/test/busy.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
(Empty)
1 # 2008 December 11
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library.
12 #
13 # This file is automatically generated from a separate TCL script.
14 # This file seeks to exercise integer boundary values.
15 #
16 # $Id: boundary4.test,v 1.2 2009/01/02 15:45:48 shane Exp $
17
18 set testdir [file dirname $argv0]
19 source $testdir/tester.tcl
20
21 # Many of the boundary tests depend on a working 64-bit implementation.
22 if {![working_64bit_int]} { finish_test; return }
23
24 do_test boundary4-1.1 {
25 db eval {
26 CREATE TABLE t1(a,x);
27 INSERT INTO t1(oid,a,x) VALUES(549755813887,1,'0000007fffffffff');
28 INSERT INTO t1(oid,a,x) VALUES(-8388608,2,'ffffffffff800000');
29 INSERT INTO t1(oid,a,x) VALUES(0,3,'0000000000000000');
30 INSERT INTO t1(oid,a,x) VALUES(-129,4,'ffffffffffffff7f');
31 INSERT INTO t1(oid,a,x) VALUES(8388608,5,'0000000000800000');
32 INSERT INTO t1(oid,a,x) VALUES(65535,6,'000000000000ffff');
33 INSERT INTO t1(oid,a,x) VALUES(8388607,7,'00000000007fffff');
34 INSERT INTO t1(oid,a,x) VALUES(1099511627776,8,'0000010000000000');
35 INSERT INTO t1(oid,a,x) VALUES(16777215,9,'0000000000ffffff');
36 INSERT INTO t1(oid,a,x) VALUES(32767,10,'0000000000007fff');
37 INSERT INTO t1(oid,a,x) VALUES(4294967296,11,'0000000100000000');
38 INSERT INTO t1(oid,a,x) VALUES(-549755813888,12,'ffffff8000000000');
39 INSERT INTO t1(oid,a,x) VALUES(-140737488355328,13,'ffff800000000000');
40 INSERT INTO t1(oid,a,x) VALUES(256,14,'0000000000000100');
41 INSERT INTO t1(oid,a,x) VALUES(16777216,15,'0000000001000000');
42 INSERT INTO t1(oid,a,x) VALUES(72057594037927936,16,'0100000000000000');
43 INSERT INTO t1(oid,a,x) VALUES(-1,17,'ffffffffffffffff');
44 INSERT INTO t1(oid,a,x) VALUES(9223372036854775807,18,'7fffffffffffffff');
45 INSERT INTO t1(oid,a,x) VALUES(281474976710655,19,'0000ffffffffffff');
46 INSERT INTO t1(oid,a,x) VALUES(1099511627775,20,'000000ffffffffff');
47 INSERT INTO t1(oid,a,x) VALUES(-8388609,21,'ffffffffff7fffff');
48 INSERT INTO t1(oid,a,x) VALUES(32768,22,'0000000000008000');
49 INSERT INTO t1(oid,a,x) VALUES(36028797018963968,23,'0080000000000000');
50 INSERT INTO t1(oid,a,x) VALUES(-32769,24,'ffffffffffff7fff');
51 INSERT INTO t1(oid,a,x) VALUES(127,25,'000000000000007f');
52 INSERT INTO t1(oid,a,x) VALUES(-9223372036854775808,26,'8000000000000000');
53 INSERT INTO t1(oid,a,x) VALUES(72057594037927935,27,'00ffffffffffffff');
54 INSERT INTO t1(oid,a,x) VALUES(-549755813889,28,'ffffff7fffffffff');
55 INSERT INTO t1(oid,a,x) VALUES(255,29,'00000000000000ff');
56 INSERT INTO t1(oid,a,x) VALUES(-36028797018963969,30,'ff7fffffffffffff');
57 INSERT INTO t1(oid,a,x) VALUES(-2147483648,31,'ffffffff80000000');
58 INSERT INTO t1(oid,a,x) VALUES(281474976710656,32,'0001000000000000');
59 INSERT INTO t1(oid,a,x) VALUES(65536,33,'0000000000010000');
60 INSERT INTO t1(oid,a,x) VALUES(140737488355328,34,'0000800000000000');
61 INSERT INTO t1(oid,a,x) VALUES(549755813888,35,'0000008000000000');
62 INSERT INTO t1(oid,a,x) VALUES(2147483648,36,'0000000080000000');
63 INSERT INTO t1(oid,a,x) VALUES(4294967295,37,'00000000ffffffff');
64 INSERT INTO t1(oid,a,x) VALUES(140737488355327,38,'00007fffffffffff');
65 INSERT INTO t1(oid,a,x) VALUES(-2147483649,39,'ffffffff7fffffff');
66 INSERT INTO t1(oid,a,x) VALUES(36028797018963967,40,'007fffffffffffff');
67 INSERT INTO t1(oid,a,x) VALUES(128,41,'0000000000000080');
68 INSERT INTO t1(oid,a,x) VALUES(-32768,42,'ffffffffffff8000');
69 INSERT INTO t1(oid,a,x) VALUES(-36028797018963968,43,'ff80000000000000');
70 INSERT INTO t1(oid,a,x) VALUES(-140737488355329,44,'ffff7fffffffffff');
71 INSERT INTO t1(oid,a,x) VALUES(-128,45,'ffffffffffffff80');
72 INSERT INTO t1(oid,a,x) VALUES(2147483647,46,'000000007fffffff');
73 CREATE INDEX t1i1 ON t1(a);
74 CREATE INDEX t1i2 ON t1(x);
75 }
76 } {}
77 do_test boundary4-1.2 {
78 db eval {
79 SELECT count(*) FROM t1
80 }
81 } {46}
82 do_test boundary4-1.3 {
83 db eval {
84 SELECT rowid, a, x FROM t1 ORDER BY +rowid
85 }
86 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
87 do_test boundary4-1.4 {
88 db eval {
89 SELECT rowid, a, x FROM t1 ORDER BY rowid
90 }
91 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
92 do_test boundary4-1.5 {
93 db eval {
94 SELECT rowid, a, x FROM t1 ORDER BY +rowid DESC
95 }
96 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
97 do_test boundary4-1.6 {
98 db eval {
99 SELECT rowid, a, x FROM t1 ORDER BY rowid DESC
100 }
101 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
102 do_test boundary4-1.7 {
103 db eval {
104 SELECT rowid, a, x FROM t1 ORDER BY +a
105 }
106 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
107 do_test boundary4-1.8 {
108 db eval {
109 SELECT rowid, a, x FROM t1 ORDER BY a
110 }
111 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
112 do_test boundary4-1.9 {
113 db eval {
114 SELECT rowid, a, x FROM t1 ORDER BY +a DESC
115 }
116 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
117 do_test boundary4-1.10 {
118 db eval {
119 SELECT rowid, a, x FROM t1 ORDER BY a DESC
120 }
121 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
122 do_test boundary4-1.11 {
123 db eval {
124 SELECT rowid, a, x FROM t1 ORDER BY +x
125 }
126 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
127 do_test boundary4-1.12 {
128 db eval {
129 SELECT rowid, a, x FROM t1 ORDER BY x
130 }
131 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
132 do_test boundary4-1.13 {
133 db eval {
134 SELECT rowid, a, x FROM t1 ORDER BY +x DESC
135 }
136 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
137 do_test boundary4-1.14 {
138 db eval {
139 SELECT rowid, a, x FROM t1 ORDER BY x DESC
140 }
141 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
142 do_test boundary4-2.1 {
143 db eval {
144 UPDATE t1 SET rowid=a, a=rowid
145 }
146 } {}
147 do_test boundary4-2.3 {
148 db eval {
149 SELECT a, rowid, x FROM t1 ORDER BY +a
150 }
151 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
152 do_test boundary4-2.4 {
153 db eval {
154 SELECT a, rowid, x FROM t1 ORDER BY a
155 }
156 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
157 do_test boundary4-2.5 {
158 db eval {
159 SELECT a, rowid, x FROM t1 ORDER BY +a DESC
160 }
161 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
162 do_test boundary4-2.6 {
163 db eval {
164 SELECT a, rowid, x FROM t1 ORDER BY a DESC
165 }
166 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
167 do_test boundary4-2.7 {
168 db eval {
169 SELECT a, rowid, x FROM t1 ORDER BY +rowid
170 }
171 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
172 do_test boundary4-2.8 {
173 db eval {
174 SELECT a, rowid, x FROM t1 ORDER BY rowid
175 }
176 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
177 do_test boundary4-2.9 {
178 db eval {
179 SELECT a, rowid, x FROM t1 ORDER BY +rowid DESC
180 }
181 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
182 do_test boundary4-2.10 {
183 db eval {
184 SELECT a, rowid, x FROM t1 ORDER BY rowid DESC
185 }
186 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
187 do_test boundary4-2.11 {
188 db eval {
189 SELECT a, rowid, x FROM t1 ORDER BY +x
190 }
191 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
192 do_test boundary4-2.12 {
193 db eval {
194 SELECT a, rowid, x FROM t1 ORDER BY x
195 }
196 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
197 do_test boundary4-2.13 {
198 db eval {
199 SELECT a, rowid, x FROM t1 ORDER BY +x DESC
200 }
201 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
202 do_test boundary4-2.14 {
203 db eval {
204 SELECT a, rowid, x FROM t1 ORDER BY x DESC
205 }
206 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
207 do_test boundary4-3.1 {
208 db eval {
209 UPDATE t1 SET rowid=a, a=rowid
210 }
211 } {}
212 do_test boundary4-3.2 {
213 db eval {
214 ALTER TABLE t1 ADD COLUMN z; UPDATE t1 SET z=zeroblob(600)
215 }
216 } {}
217 do_test boundary4-3.3 {
218 db eval {
219 SELECT rowid, a, x FROM t1 ORDER BY +rowid
220 }
221 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
222 do_test boundary4-3.4 {
223 db eval {
224 SELECT rowid, a, x FROM t1 ORDER BY rowid
225 }
226 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
227 do_test boundary4-3.5 {
228 db eval {
229 SELECT rowid, a, x FROM t1 ORDER BY +rowid DESC
230 }
231 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
232 do_test boundary4-3.6 {
233 db eval {
234 SELECT rowid, a, x FROM t1 ORDER BY rowid DESC
235 }
236 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
237 do_test boundary4-3.7 {
238 db eval {
239 SELECT rowid, a, x FROM t1 ORDER BY +a
240 }
241 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
242 do_test boundary4-3.8 {
243 db eval {
244 SELECT rowid, a, x FROM t1 ORDER BY a
245 }
246 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
247 do_test boundary4-3.9 {
248 db eval {
249 SELECT rowid, a, x FROM t1 ORDER BY +a DESC
250 }
251 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
252 do_test boundary4-3.10 {
253 db eval {
254 SELECT rowid, a, x FROM t1 ORDER BY a DESC
255 }
256 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
257 do_test boundary4-3.11 {
258 db eval {
259 SELECT rowid, a, x FROM t1 ORDER BY +x
260 }
261 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
262 do_test boundary4-3.12 {
263 db eval {
264 SELECT rowid, a, x FROM t1 ORDER BY x
265 }
266 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
267 do_test boundary4-3.13 {
268 db eval {
269 SELECT rowid, a, x FROM t1 ORDER BY +x DESC
270 }
271 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
272 do_test boundary4-3.14 {
273 db eval {
274 SELECT rowid, a, x FROM t1 ORDER BY x DESC
275 }
276 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
277 do_test boundary4-4.1 {
278 db eval {
279 UPDATE t1 SET rowid=a, a=rowid, x=z, z=x
280 }
281 } {}
282 do_test boundary4-4.3 {
283 db eval {
284 SELECT a, rowid, z FROM t1 ORDER BY +a
285 }
286 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
287 do_test boundary4-4.4 {
288 db eval {
289 SELECT a, rowid, z FROM t1 ORDER BY a
290 }
291 } {-9223372036854775808 26 8000000000000000 -36028797018963969 30 ff7fffffffffff ff -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff - 140737488355328 13 ffff800000000000 -549755813889 28 ffffff7fffffffff -549755813 888 12 ffffff8000000000 -2147483649 39 ffffffff7fffffff -2147483648 31 ffffffff8 0000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 fffff fffffff7fff -32768 42 ffffffffffff8000 -129 4 ffffffffffffff7f -128 45 fffffffff fffff80 -1 17 ffffffffffffffff 0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 00000000000000ff 256 14 0000000000000100 32767 10 000 0000000007fff 32768 22 0000000000008000 65535 6 000000000000ffff 65536 33 000000 0000010000 8388607 7 00000000007fffff 8388608 5 0000000000800000 16777215 9 0000 000000ffffff 16777216 15 0000000001000000 2147483647 46 000000007fffffff 2147483 648 36 0000000080000000 4294967295 37 00000000ffffffff 4294967296 11 00000001000 00000 549755813887 1 0000007fffffffff 549755813888 35 0000008000000000 109951162 7775 20 000000ffffffffff 1099511627776 8 0000010000000000 140737488355327 38 000 07fffffffffff 140737488355328 34 0000800000000000 281474976710655 19 0000fffffff fffff 281474976710656 32 0001000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000000000000 72057594037927935 27 00ffffffffffffff 7205 7594037927936 16 0100000000000000 9223372036854775807 18 7fffffffffffffff}
292 do_test boundary4-4.5 {
293 db eval {
294 SELECT a, rowid, z FROM t1 ORDER BY +a DESC
295 }
296 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
297 do_test boundary4-4.6 {
298 db eval {
299 SELECT a, rowid, z FROM t1 ORDER BY a DESC
300 }
301 } {9223372036854775807 18 7fffffffffffffff 72057594037927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 36028797018963968 23 0080000000000000 360 28797018963967 40 007fffffffffffff 281474976710656 32 0001000000000000 281474976 710655 19 0000ffffffffffff 140737488355328 34 0000800000000000 140737488355327 3 8 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000fffff fffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 429496729 6 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000 000 2147483647 46 000000007fffffff 16777216 15 0000000001000000 16777215 9 00000 00000ffffff 8388608 5 0000000000800000 8388607 7 00000000007fffff 65536 33 00000 00000010000 65535 6 000000000000ffff 32768 22 0000000000008000 32767 10 00000000 00007fff 256 14 0000000000000100 255 29 00000000000000ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000 -1 17 ffffffffffffffff -128 45 fff fffffffffff80 -129 4 ffffffffffffff7f -32768 42 ffffffffffff8000 -32769 24 fffff fffffff7fff -8388608 2 ffffffffff800000 -8388609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 ffffffff7fffffff -549755813888 12 ffffff8000 000000 -549755813889 28 ffffff7fffffffff -140737488355328 13 ffff800000000000 -1 40737488355329 44 ffff7fffffffffff -36028797018963968 43 ff80000000000000 -36028 797018963969 30 ff7fffffffffffff -9223372036854775808 26 8000000000000000}
302 do_test boundary4-4.7 {
303 db eval {
304 SELECT a, rowid, z FROM t1 ORDER BY +rowid
305 }
306 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
307 do_test boundary4-4.8 {
308 db eval {
309 SELECT a, rowid, z FROM t1 ORDER BY rowid
310 }
311 } {549755813887 1 0000007fffffffff -8388608 2 ffffffffff800000 0 3 0000000000000 000 -129 4 ffffffffffffff7f 8388608 5 0000000000800000 65535 6 000000000000ffff 8388607 7 00000000007fffff 1099511627776 8 0000010000000000 16777215 9 000000000 0ffffff 32767 10 0000000000007fff 4294967296 11 0000000100000000 -549755813888 1 2 ffffff8000000000 -140737488355328 13 ffff800000000000 256 14 0000000000000100 16777216 15 0000000001000000 72057594037927936 16 0100000000000000 -1 17 fffffff fffffffff 9223372036854775807 18 7fffffffffffffff 281474976710655 19 0000fffffff fffff 1099511627775 20 000000ffffffffff -8388609 21 ffffffffff7fffff 32768 22 00 00000000008000 36028797018963968 23 0080000000000000 -32769 24 ffffffffffff7fff 127 25 000000000000007f -9223372036854775808 26 8000000000000000 720575940379279 35 27 00ffffffffffffff -549755813889 28 ffffff7fffffffff 255 29 00000000000000ff -36028797018963969 30 ff7fffffffffffff -2147483648 31 ffffffff80000000 28147497 6710656 32 0001000000000000 65536 33 0000000000010000 140737488355328 34 0000800 000000000 549755813888 35 0000008000000000 2147483648 36 0000000080000000 429496 7295 37 00000000ffffffff 140737488355327 38 00007fffffffffff -2147483649 39 ffff ffff7fffffff 36028797018963967 40 007fffffffffffff 128 41 0000000000000080 -3276 8 42 ffffffffffff8000 -36028797018963968 43 ff80000000000000 -140737488355329 44 ffff7fffffffffff -128 45 ffffffffffffff80 2147483647 46 000000007fffffff}
312 do_test boundary4-4.9 {
313 db eval {
314 SELECT a, rowid, z FROM t1 ORDER BY +rowid DESC
315 }
316 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
317 do_test boundary4-4.10 {
318 db eval {
319 SELECT a, rowid, z FROM t1 ORDER BY rowid DESC
320 }
321 } {2147483647 46 000000007fffffff -128 45 ffffffffffffff80 -140737488355329 44 f fff7fffffffffff -36028797018963968 43 ff80000000000000 -32768 42 ffffffffffff800 0 128 41 0000000000000080 36028797018963967 40 007fffffffffffff -2147483649 39 f fffffff7fffffff 140737488355327 38 00007fffffffffff 4294967295 37 00000000ffffff ff 2147483648 36 0000000080000000 549755813888 35 0000008000000000 1407374883553 28 34 0000800000000000 65536 33 0000000000010000 281474976710656 32 000100000000 0000 -2147483648 31 ffffffff80000000 -36028797018963969 30 ff7fffffffffffff 255 29 00000000000000ff -549755813889 28 ffffff7fffffffff 72057594037927935 27 00fff fffffffffff -9223372036854775808 26 8000000000000000 127 25 000000000000007f -32 769 24 ffffffffffff7fff 36028797018963968 23 0080000000000000 32768 22 000000000 0008000 -8388609 21 ffffffffff7fffff 1099511627775 20 000000ffffffffff 281474976 710655 19 0000ffffffffffff 9223372036854775807 18 7fffffffffffffff -1 17 fffffff fffffffff 72057594037927936 16 0100000000000000 16777216 15 0000000001000000 256 14 0000000000000100 -140737488355328 13 ffff800000000000 -549755813888 12 fffff f8000000000 4294967296 11 0000000100000000 32767 10 0000000000007fff 16777215 9 0000000000ffffff 1099511627776 8 0000010000000000 8388607 7 00000000007fffff 655 35 6 000000000000ffff 8388608 5 0000000000800000 -129 4 ffffffffffffff7f 0 3 000 0000000000000 -8388608 2 ffffffffff800000 549755813887 1 0000007fffffffff}
322 do_test boundary4-4.11 {
323 db eval {
324 SELECT a, rowid, z FROM t1 ORDER BY +z
325 }
326 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
327 do_test boundary4-4.12 {
328 db eval {
329 SELECT a, rowid, z FROM t1 ORDER BY z
330 }
331 } {0 3 0000000000000000 127 25 000000000000007f 128 41 0000000000000080 255 29 0 0000000000000ff 256 14 0000000000000100 32767 10 0000000000007fff 32768 22 00000 00000008000 65535 6 000000000000ffff 65536 33 0000000000010000 8388607 7 0000000 0007fffff 8388608 5 0000000000800000 16777215 9 0000000000ffffff 16777216 15 000 0000001000000 2147483647 46 000000007fffffff 2147483648 36 0000000080000000 4294 967295 37 00000000ffffffff 4294967296 11 0000000100000000 549755813887 1 0000007 fffffffff 549755813888 35 0000008000000000 1099511627775 20 000000ffffffffff 109 9511627776 8 0000010000000000 140737488355327 38 00007fffffffffff 14073748835532 8 34 0000800000000000 281474976710655 19 0000ffffffffffff 281474976710656 32 000 1000000000000 36028797018963967 40 007fffffffffffff 36028797018963968 23 0080000 000000000 72057594037927935 27 00ffffffffffffff 72057594037927936 16 01000000000 00000 9223372036854775807 18 7fffffffffffffff -9223372036854775808 26 8000000000 000000 -36028797018963969 30 ff7fffffffffffff -36028797018963968 43 ff8000000000 0000 -140737488355329 44 ffff7fffffffffff -140737488355328 13 ffff800000000000 - 549755813889 28 ffffff7fffffffff -549755813888 12 ffffff8000000000 -2147483649 3 9 ffffffff7fffffff -2147483648 31 ffffffff80000000 -8388609 21 ffffffffff7fffff -8388608 2 ffffffffff800000 -32769 24 ffffffffffff7fff -32768 42 ffffffffffff800 0 -129 4 ffffffffffffff7f -128 45 ffffffffffffff80 -1 17 ffffffffffffffff}
332 do_test boundary4-4.13 {
333 db eval {
334 SELECT a, rowid, z FROM t1 ORDER BY +z DESC
335 }
336 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
337 do_test boundary4-4.14 {
338 db eval {
339 SELECT a, rowid, z FROM t1 ORDER BY z DESC
340 }
341 } {-1 17 ffffffffffffffff -128 45 ffffffffffffff80 -129 4 ffffffffffffff7f -3276 8 42 ffffffffffff8000 -32769 24 ffffffffffff7fff -8388608 2 ffffffffff800000 -83 88609 21 ffffffffff7fffff -2147483648 31 ffffffff80000000 -2147483649 39 fffffff f7fffffff -549755813888 12 ffffff8000000000 -549755813889 28 ffffff7fffffffff -1 40737488355328 13 ffff800000000000 -140737488355329 44 ffff7fffffffffff -3602879 7018963968 43 ff80000000000000 -36028797018963969 30 ff7fffffffffffff -922337203 6854775808 26 8000000000000000 9223372036854775807 18 7fffffffffffffff 720575940 37927936 16 0100000000000000 72057594037927935 27 00ffffffffffffff 3602879701896 3968 23 0080000000000000 36028797018963967 40 007fffffffffffff 281474976710656 3 2 0001000000000000 281474976710655 19 0000ffffffffffff 140737488355328 34 000080 0000000000 140737488355327 38 00007fffffffffff 1099511627776 8 0000010000000000 1099511627775 20 000000ffffffffff 549755813888 35 0000008000000000 549755813887 1 0000007fffffffff 4294967296 11 0000000100000000 4294967295 37 00000000ffffffff 2147483648 36 0000000080000000 2147483647 46 000000007fffffff 16777216 15 00000 00001000000 16777215 9 0000000000ffffff 8388608 5 0000000000800000 8388607 7 000 00000007fffff 65536 33 0000000000010000 65535 6 000000000000ffff 32768 22 000000 0000008000 32767 10 0000000000007fff 256 14 0000000000000100 255 29 000000000000 00ff 128 41 0000000000000080 127 25 000000000000007f 0 3 0000000000000000}
342 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/test/boundary4.tcl ('k') | third_party/sqlite/test/busy.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698