OLD | NEW |
1 # 2008 December 11 | 1 # 2008 December 11 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 323 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
334 db eval { | 334 db eval { |
335 SELECT a, rowid, z FROM t1 ORDER BY +z DESC | 335 SELECT a, rowid, z FROM t1 ORDER BY +z DESC |
336 } | 336 } |
337 } {-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 } {-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} |
338 do_test boundary4-4.14 { | 338 do_test boundary4-4.14 { |
339 db eval { | 339 db eval { |
340 SELECT a, rowid, z FROM t1 ORDER BY z DESC | 340 SELECT a, rowid, z FROM t1 ORDER BY z DESC |
341 } | 341 } |
342 } {-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 } {-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} |
343 finish_test | 343 finish_test |
OLD | NEW |