boundary3.test - OpenGrok cross reference for /sqlite-3.40.0/test/boundary3.test

Lines Matching refs:a
4 # a legal notice, here is a blessing:
13 # This file is automatically generated from a separate TCL script.
21 # Many of the boundary tests depend on a working 64-bit implementation.
26     CREATE TABLE t1(a,x);
27     INSERT INTO t1(oid,a,x) VALUES(-8388609,1,'ffffffffff7fffff');
28     INSERT INTO t1(oid,a,x) VALUES(-36028797018963969,2,'ff7fffffffffffff');
29     INSERT INTO t1(oid,a,x) VALUES(9223372036854775807,3,'7fffffffffffffff');
30     INSERT INTO t1(oid,a,x) VALUES(127,4,'000000000000007f');
31     INSERT INTO t1(oid,a,x) VALUES(3,5,'0000000000000003');
32     INSERT INTO t1(oid,a,x) VALUES(16777216,6,'0000000001000000');
33     INSERT INTO t1(oid,a,x) VALUES(4398046511103,7,'000003ffffffffff');
34     INSERT INTO t1(oid,a,x) VALUES(16383,8,'0000000000003fff');
35     INSERT INTO t1(oid,a,x) VALUES(16777215,9,'0000000000ffffff');
36     INSERT INTO t1(oid,a,x) VALUES(281474976710655,10,'0000ffffffffffff');
37     INSERT INTO t1(oid,a,x) VALUES(-2147483648,11,'ffffffff80000000');
38     INSERT INTO t1(oid,a,x) VALUES(268435455,12,'000000000fffffff');
39     INSERT INTO t1(oid,a,x) VALUES(562949953421311,13,'0001ffffffffffff');
40     INSERT INTO t1(oid,a,x) VALUES(4294967295,14,'00000000ffffffff');
41     INSERT INTO t1(oid,a,x) VALUES(2097151,15,'00000000001fffff');
42     INSERT INTO t1(oid,a,x) VALUES(16384,16,'0000000000004000');
43     INSERT INTO t1(oid,a,x) VALUES(72057594037927935,17,'00ffffffffffffff');
44     INSERT INTO t1(oid,a,x) VALUES(8388607,18,'00000000007fffff');
45     INSERT INTO t1(oid,a,x) VALUES(1099511627776,19,'0000010000000000');
46     INSERT INTO t1(oid,a,x) VALUES(2147483647,20,'000000007fffffff');
47     INSERT INTO t1(oid,a,x) VALUES(-140737488355329,21,'ffff7fffffffffff');
48     INSERT INTO t1(oid,a,x) VALUES(34359738368,22,'0000000800000000');
49     INSERT INTO t1(oid,a,x) VALUES(32767,23,'0000000000007fff');
50     INSERT INTO t1(oid,a,x) VALUES(8388608,24,'0000000000800000');
51     INSERT INTO t1(oid,a,x) VALUES(140737488355327,25,'00007fffffffffff');
52     INSERT INTO t1(oid,a,x) VALUES(281474976710656,26,'0001000000000000');
53     INSERT INTO t1(oid,a,x) VALUES(36028797018963967,27,'007fffffffffffff');
54     INSERT INTO t1(oid,a,x) VALUES(72057594037927936,28,'0100000000000000');
55     INSERT INTO t1(oid,a,x) VALUES(-32769,29,'ffffffffffff7fff');
56     INSERT INTO t1(oid,a,x) VALUES(255,30,'00000000000000ff');
57     INSERT INTO t1(oid,a,x) VALUES(4,31,'0000000000000004');
58     INSERT INTO t1(oid,a,x) VALUES(-32768,32,'ffffffffffff8000');
59     INSERT INTO t1(oid,a,x) VALUES(-2,33,'fffffffffffffffe');
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(4294967296,36,'0000000100000000');
63     INSERT INTO t1(oid,a,x) VALUES(-8388608,37,'ffffffffff800000');
64     INSERT INTO t1(oid,a,x) VALUES(-1,38,'ffffffffffffffff');
65     INSERT INTO t1(oid,a,x) VALUES(34359738367,39,'00000007ffffffff');
66     INSERT INTO t1(oid,a,x) VALUES(268435456,40,'0000000010000000');
67     INSERT INTO t1(oid,a,x) VALUES(2,41,'0000000000000002');
68     INSERT INTO t1(oid,a,x) VALUES(2097152,42,'0000000000200000');
69     INSERT INTO t1(oid,a,x) VALUES(562949953421312,43,'0002000000000000');
70     INSERT INTO t1(oid,a,x) VALUES(-140737488355328,44,'ffff800000000000');
71     INSERT INTO t1(oid,a,x) VALUES(36028797018963968,45,'0080000000000000');
72     INSERT INTO t1(oid,a,x) VALUES(549755813887,46,'0000007fffffffff');
73     INSERT INTO t1(oid,a,x) VALUES(-2147483649,47,'ffffffff7fffffff');
74     INSERT INTO t1(oid,a,x) VALUES(65535,48,'000000000000ffff');
75     INSERT INTO t1(oid,a,x) VALUES(128,49,'0000000000000080');
76     INSERT INTO t1(oid,a,x) VALUES(32768,50,'0000000000008000');
77     INSERT INTO t1(oid,a,x) VALUES(2147483648,51,'0000000080000000');
78     INSERT INTO t1(oid,a,x) VALUES(-3,52,'fffffffffffffffd');
79     INSERT INTO t1(oid,a,x) VALUES(-128,53,'ffffffffffffff80');
80     INSERT INTO t1(oid,a,x) VALUES(-129,54,'ffffffffffffff7f');
81     INSERT INTO t1(oid,a,x) VALUES(-9223372036854775808,55,'8000000000000000');
82     INSERT INTO t1(oid,a,x) VALUES(4398046511104,56,'0000040000000000');
83     INSERT INTO t1(oid,a,x) VALUES(1099511627775,57,'000000ffffffffff');
84     INSERT INTO t1(oid,a,x) VALUES(-549755813889,58,'ffffff7fffffffff');
85     INSERT INTO t1(oid,a,x) VALUES(0,59,'0000000000000000');
86     INSERT INTO t1(oid,a,x) VALUES(1,60,'0000000000000001');
87     INSERT INTO t1(oid,a,x) VALUES(256,61,'0000000000000100');
88     INSERT INTO t1(oid,a,x) VALUES(65536,62,'0000000000010000');
89     INSERT INTO t1(oid,a,x) VALUES(-549755813888,63,'ffffff8000000000');
90     INSERT INTO t1(oid,a,x) VALUES(-36028797018963968,64,'ff80000000000000');
91     CREATE INDEX t1i1 ON t1(a);
102     CREATE TABLE t2(r,a);
103     INSERT INTO t2 SELECT rowid, a FROM t1;
105     CREATE INDEX t2i2 ON t2(a);
113     SELECT t1.* FROM t1, t2 WHERE t1.rowid=72057594037927935 AND t2.a=t1.a
118     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00ffffffffffffff'
123     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=17
128     SELECT t2.a FROM t1 JOIN t2 USING(a)
129      WHERE t1.rowid > 72057594037927935 ORDER BY t2.a
134     SELECT t2.a FROM t2 NATURAL JOIN t1
135      WHERE t1.rowid > 72057594037927935 ORDER BY t1.a DESC
140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
141      WHERE t2.a=17
147     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
148      WHERE t2.a=17
154     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
155      WHERE t2.a=17
161     SELECT t2.a FROM t1 JOIN t2 USING(a)
162      WHERE t1.rowid >= 72057594037927935 ORDER BY t2.a
167     SELECT t2.a FROM t2 NATURAL JOIN t1
168      WHERE t1.rowid >= 72057594037927935 ORDER BY t1.a DESC
173     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
174      WHERE t2.a=17
180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
181      WHERE t2.a=17
187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
188      WHERE t2.a=17
194     SELECT t2.a FROM t1 JOIN t2 USING(a)
195      WHERE t1.rowid < 72057594037927935 ORDER BY t2.a
200     SELECT t2.a FROM t2 NATURAL JOIN t1
201      WHERE t1.rowid < 72057594037927935 ORDER BY t1.a DESC
206     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
207      WHERE t2.a=17
213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
214      WHERE t2.a=17
220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
221      WHERE t2.a=17
227     SELECT t2.a FROM t1 JOIN t2 USING(a)
228      WHERE t1.rowid <= 72057594037927935 ORDER BY t2.a
233     SELECT t2.a FROM t2 NATURAL JOIN t1
234      WHERE t1.rowid <= 72057594037927935 ORDER BY t1.a DESC
239     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
240      WHERE t2.a=17
246     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
247      WHERE t2.a=17
253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
254      WHERE t2.a=17
260     SELECT t1.* FROM t1, t2 WHERE t1.rowid=16384 AND t2.a=t1.a
265     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000004000'
270     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=16
275     SELECT t2.a FROM t1 JOIN t2 USING(a)
276      WHERE t1.rowid > 16384 ORDER BY t2.a
281     SELECT t2.a FROM t2 NATURAL JOIN t1
282      WHERE t1.rowid > 16384 ORDER BY t1.a DESC
287     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
288      WHERE t2.a=16
294     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
295      WHERE t2.a=16
301     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
302      WHERE t2.a=16
308     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
309      WHERE t2.a=16
315     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
316      WHERE t2.a=16
322     SELECT t2.a FROM t1 JOIN t2 USING(a)
323      WHERE t1.rowid >= 16384 ORDER BY t2.a
328     SELECT t2.a FROM t2 NATURAL JOIN t1
329      WHERE t1.rowid >= 16384 ORDER BY t1.a DESC
334     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
335      WHERE t2.a=16
341     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
342      WHERE t2.a=16
348     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
349      WHERE t2.a=16
355     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
356      WHERE t2.a=16
362     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
363      WHERE t2.a=16
369     SELECT t2.a FROM t1 JOIN t2 USING(a)
370      WHERE t1.rowid < 16384 ORDER BY t2.a
375     SELECT t2.a FROM t2 NATURAL JOIN t1
376      WHERE t1.rowid < 16384 ORDER BY t1.a DESC
381     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
382      WHERE t2.a=16
388     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
389      WHERE t2.a=16
395     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
396      WHERE t2.a=16
402     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
403      WHERE t2.a=16
409     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
410      WHERE t2.a=16
416     SELECT t2.a FROM t1 JOIN t2 USING(a)
417      WHERE t1.rowid <= 16384 ORDER BY t2.a
422     SELECT t2.a FROM t2 NATURAL JOIN t1
423      WHERE t1.rowid <= 16384 ORDER BY t1.a DESC
428     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
429      WHERE t2.a=16
435     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
436      WHERE t2.a=16
442     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
443      WHERE t2.a=16
449     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
450      WHERE t2.a=16
456     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
457      WHERE t2.a=16
463     SELECT t1.* FROM t1, t2 WHERE t1.rowid=4294967296 AND t2.a=t1.a
468     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000100000000'
473     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=36
478     SELECT t2.a FROM t1 JOIN t2 USING(a)
479      WHERE t1.rowid > 4294967296 ORDER BY t2.a
484     SELECT t2.a FROM t2 NATURAL JOIN t1
485      WHERE t1.rowid > 4294967296 ORDER BY t1.a DESC
490     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
491      WHERE t2.a=36
497     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
498      WHERE t2.a=36
504     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
505      WHERE t2.a=36
511     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
512      WHERE t2.a=36
518     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
519      WHERE t2.a=36
525     SELECT t2.a FROM t1 JOIN t2 USING(a)
526      WHERE t1.rowid >= 4294967296 ORDER BY t2.a
531     SELECT t2.a FROM t2 NATURAL JOIN t1
532      WHERE t1.rowid >= 4294967296 ORDER BY t1.a DESC
537     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
538      WHERE t2.a=36
544     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
545      WHERE t2.a=36
551     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
552      WHERE t2.a=36
558     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
559      WHERE t2.a=36
565     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
566      WHERE t2.a=36
572     SELECT t2.a FROM t1 JOIN t2 USING(a)
573      WHERE t1.rowid < 4294967296 ORDER BY t2.a
578     SELECT t2.a FROM t2 NATURAL JOIN t1
579      WHERE t1.rowid < 4294967296 ORDER BY t1.a DESC
584     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
585      WHERE t2.a=36
591     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
592      WHERE t2.a=36
598     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
599      WHERE t2.a=36
605     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
606      WHERE t2.a=36
612     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
613      WHERE t2.a=36
619     SELECT t2.a FROM t1 JOIN t2 USING(a)
620      WHERE t1.rowid <= 4294967296 ORDER BY t2.a
625     SELECT t2.a FROM t2 NATURAL JOIN t1
626      WHERE t1.rowid <= 4294967296 ORDER BY t1.a DESC
631     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
632      WHERE t2.a=36
638     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
639      WHERE t2.a=36
645     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
646      WHERE t2.a=36
652     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
653      WHERE t2.a=36
659     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
660      WHERE t2.a=36
666     SELECT t1.* FROM t1, t2 WHERE t1.rowid=16777216 AND t2.a=t1.a
671     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000001000000'
676     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=6
681     SELECT t2.a FROM t1 JOIN t2 USING(a)
682      WHERE t1.rowid > 16777216 ORDER BY t2.a
687     SELECT t2.a FROM t2 NATURAL JOIN t1
688      WHERE t1.rowid > 16777216 ORDER BY t1.a DESC
693     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
694      WHERE t2.a=6
700     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
701      WHERE t2.a=6
707     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
708      WHERE t2.a=6
714     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
715      WHERE t2.a=6
721     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
722      WHERE t2.a=6
728     SELECT t2.a FROM t1 JOIN t2 USING(a)
729      WHERE t1.rowid >= 16777216 ORDER BY t2.a
734     SELECT t2.a FROM t2 NATURAL JOIN t1
735      WHERE t1.rowid >= 16777216 ORDER BY t1.a DESC
740     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
741      WHERE t2.a=6
747     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
748      WHERE t2.a=6
754     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
755      WHERE t2.a=6
761     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
762      WHERE t2.a=6
768     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
769      WHERE t2.a=6
775     SELECT t2.a FROM t1 JOIN t2 USING(a)
776      WHERE t1.rowid < 16777216 ORDER BY t2.a
781     SELECT t2.a FROM t2 NATURAL JOIN t1
782      WHERE t1.rowid < 16777216 ORDER BY t1.a DESC
787     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
788      WHERE t2.a=6
794     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
795      WHERE t2.a=6
801     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
802      WHERE t2.a=6
808     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
809      WHERE t2.a=6
815     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
816      WHERE t2.a=6
822     SELECT t2.a FROM t1 JOIN t2 USING(a)
823      WHERE t1.rowid <= 16777216 ORDER BY t2.a
828     SELECT t2.a FROM t2 NATURAL JOIN t1
829      WHERE t1.rowid <= 16777216 ORDER BY t1.a DESC
834     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
835      WHERE t2.a=6
841     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
842      WHERE t2.a=6
848     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
849      WHERE t2.a=6
855     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
856      WHERE t2.a=6
862     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
863      WHERE t2.a=6
869     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-32769 AND t2.a=t1.a
874     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffff7fff'
879     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=29
884     SELECT t2.a FROM t1 JOIN t2 USING(a)
885      WHERE t1.rowid > -32769 ORDER BY t2.a
890     SELECT t2.a FROM t2 NATURAL JOIN t1
891      WHERE t1.rowid > -32769 ORDER BY t1.a DESC
896     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
897      WHERE t2.a=29
903     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
904      WHERE t2.a=29
910     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
911      WHERE t2.a=29
917     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
918      WHERE t2.a=29
924     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
925      WHERE t2.a=29
931     SELECT t2.a FROM t1 JOIN t2 USING(a)
932      WHERE t1.rowid >= -32769 ORDER BY t2.a
937     SELECT t2.a FROM t2 NATURAL JOIN t1
938      WHERE t1.rowid >= -32769 ORDER BY t1.a DESC
943     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
944      WHERE t2.a=29
950     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
951      WHERE t2.a=29
957     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
958      WHERE t2.a=29
964     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
965      WHERE t2.a=29
971     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
972      WHERE t2.a=29
978     SELECT t2.a FROM t1 JOIN t2 USING(a)
979      WHERE t1.rowid < -32769 ORDER BY t2.a
984     SELECT t2.a FROM t2 NATURAL JOIN t1
985      WHERE t1.rowid < -32769 ORDER BY t1.a DESC
990     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
991      WHERE t2.a=29
997     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
998      WHERE t2.a=29
1004     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1005      WHERE t2.a=29
1011     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1012      WHERE t2.a=29
1018     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1019      WHERE t2.a=29
1025     SELECT t2.a FROM t1 JOIN t2 USING(a)
1026      WHERE t1.rowid <= -32769 ORDER BY t2.a
1031     SELECT t2.a FROM t2 NATURAL JOIN t1
1032      WHERE t1.rowid <= -32769 ORDER BY t1.a DESC
1037     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1038      WHERE t2.a=29
1044     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1045      WHERE t2.a=29
1051     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1052      WHERE t2.a=29
1058     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1059      WHERE t2.a=29
1065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1066      WHERE t2.a=29
1072     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-140737488355329 AND t2.a=t1.a
1077     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffff7fffffffffff'
1082     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=21
1087     SELECT t2.a FROM t1 JOIN t2 USING(a)
1088      WHERE t1.rowid > -140737488355329 ORDER BY t2.a
1093     SELECT t2.a FROM t2 NATURAL JOIN t1
1094      WHERE t1.rowid > -140737488355329 ORDER BY t1.a DESC
1099     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1100      WHERE t2.a=21
1106     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1107      WHERE t2.a=21
1113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1114      WHERE t2.a=21
1120     SELECT t2.a FROM t1 JOIN t2 USING(a)
1121      WHERE t1.rowid >= -140737488355329 ORDER BY t2.a
1126     SELECT t2.a FROM t2 NATURAL JOIN t1
1127      WHERE t1.rowid >= -140737488355329 ORDER BY t1.a DESC
1132     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1133      WHERE t2.a=21
1139     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1140      WHERE t2.a=21
1146     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1147      WHERE t2.a=21
1153     SELECT t2.a FROM t1 JOIN t2 USING(a)
1154      WHERE t1.rowid < -140737488355329 ORDER BY t2.a
1159     SELECT t2.a FROM t2 NATURAL JOIN t1
1160      WHERE t1.rowid < -140737488355329 ORDER BY t1.a DESC
1165     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1166      WHERE t2.a=21
1172     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1173      WHERE t2.a=21
1179     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1180      WHERE t2.a=21
1186     SELECT t2.a FROM t1 JOIN t2 USING(a)
1187      WHERE t1.rowid <= -140737488355329 ORDER BY t2.a
1192     SELECT t2.a FROM t2 NATURAL JOIN t1
1193      WHERE t1.rowid <= -140737488355329 ORDER BY t1.a DESC
1198     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1199      WHERE t2.a=21
1205     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1206      WHERE t2.a=21
1212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1213      WHERE t2.a=21
1219     SELECT t1.* FROM t1, t2 WHERE t1.rowid=2 AND t2.a=t1.a
1224     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000002'
1229     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=41
1234     SELECT t2.a FROM t1 JOIN t2 USING(a)
1235      WHERE t1.rowid > 2 ORDER BY t2.a
1240     SELECT t2.a FROM t2 NATURAL JOIN t1
1241      WHERE t1.rowid > 2 ORDER BY t1.a DESC
1246     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1247      WHERE t2.a=41
1253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1254      WHERE t2.a=41
1260     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1261      WHERE t2.a=41
1267     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1268      WHERE t2.a=41
1274     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1275      WHERE t2.a=41
1281     SELECT t2.a FROM t1 JOIN t2 USING(a)
1282      WHERE t1.rowid >= 2 ORDER BY t2.a
1287     SELECT t2.a FROM t2 NATURAL JOIN t1
1288      WHERE t1.rowid >= 2 ORDER BY t1.a DESC
1293     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1294      WHERE t2.a=41
1300     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1301      WHERE t2.a=41
1307     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1308      WHERE t2.a=41
1314     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1315      WHERE t2.a=41
1321     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1322      WHERE t2.a=41
1328     SELECT t2.a FROM t1 JOIN t2 USING(a)
1329      WHERE t1.rowid < 2 ORDER BY t2.a
1334     SELECT t2.a FROM t2 NATURAL JOIN t1
1335      WHERE t1.rowid < 2 ORDER BY t1.a DESC
1340     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1341      WHERE t2.a=41
1347     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1348      WHERE t2.a=41
1354     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1355      WHERE t2.a=41
1361     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1362      WHERE t2.a=41
1368     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1369      WHERE t2.a=41
1375     SELECT t2.a FROM t1 JOIN t2 USING(a)
1376      WHERE t1.rowid <= 2 ORDER BY t2.a
1381     SELECT t2.a FROM t2 NATURAL JOIN t1
1382      WHERE t1.rowid <= 2 ORDER BY t1.a DESC
1387     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1388      WHERE t2.a=41
1394     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1395      WHERE t2.a=41
1401     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1402      WHERE t2.a=41
1408     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1409      WHERE t2.a=41
1415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1416      WHERE t2.a=41
1422     SELECT t1.* FROM t1, t2 WHERE t1.rowid=4 AND t2.a=t1.a
1427     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000004'
1432     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=31
1437     SELECT t2.a FROM t1 JOIN t2 USING(a)
1438      WHERE t1.rowid > 4 ORDER BY t2.a
1443     SELECT t2.a FROM t2 NATURAL JOIN t1
1444      WHERE t1.rowid > 4 ORDER BY t1.a DESC
1449     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1450      WHERE t2.a=31
1456     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1457      WHERE t2.a=31
1463     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1464      WHERE t2.a=31
1470     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1471      WHERE t2.a=31
1477     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1478      WHERE t2.a=31
1484     SELECT t2.a FROM t1 JOIN t2 USING(a)
1485      WHERE t1.rowid >= 4 ORDER BY t2.a
1490     SELECT t2.a FROM t2 NATURAL JOIN t1
1491      WHERE t1.rowid >= 4 ORDER BY t1.a DESC
1496     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1497      WHERE t2.a=31
1503     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1504      WHERE t2.a=31
1510     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1511      WHERE t2.a=31
1517     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1518      WHERE t2.a=31
1524     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1525      WHERE t2.a=31
1531     SELECT t2.a FROM t1 JOIN t2 USING(a)
1532      WHERE t1.rowid < 4 ORDER BY t2.a
1537     SELECT t2.a FROM t2 NATURAL JOIN t1
1538      WHERE t1.rowid < 4 ORDER BY t1.a DESC
1543     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1544      WHERE t2.a=31
1550     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1551      WHERE t2.a=31
1557     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1558      WHERE t2.a=31
1564     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1565      WHERE t2.a=31
1571     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1572      WHERE t2.a=31
1578     SELECT t2.a FROM t1 JOIN t2 USING(a)
1579      WHERE t1.rowid <= 4 ORDER BY t2.a
1584     SELECT t2.a FROM t2 NATURAL JOIN t1
1585      WHERE t1.rowid <= 4 ORDER BY t1.a DESC
1590     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1591      WHERE t2.a=31
1597     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1598      WHERE t2.a=31
1604     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1605      WHERE t2.a=31
1611     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1612      WHERE t2.a=31
1618     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1619      WHERE t2.a=31
1625     SELECT t1.* FROM t1, t2 WHERE t1.rowid=562949953421311 AND t2.a=t1.a
1630     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0001ffffffffffff'
1635     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=13
1640     SELECT t2.a FROM t1 JOIN t2 USING(a)
1641      WHERE t1.rowid > 562949953421311 ORDER BY t2.a
1646     SELECT t2.a FROM t2 NATURAL JOIN t1
1647      WHERE t1.rowid > 562949953421311 ORDER BY t1.a DESC
1652     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1653      WHERE t2.a=13
1659     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1660      WHERE t2.a=13
1666     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1667      WHERE t2.a=13
1673     SELECT t2.a FROM t1 JOIN t2 USING(a)
1674      WHERE t1.rowid >= 562949953421311 ORDER BY t2.a
1679     SELECT t2.a FROM t2 NATURAL JOIN t1
1680      WHERE t1.rowid >= 562949953421311 ORDER BY t1.a DESC
1685     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1686      WHERE t2.a=13
1692     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1693      WHERE t2.a=13
1699     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1700      WHERE t2.a=13
1706     SELECT t2.a FROM t1 JOIN t2 USING(a)
1707      WHERE t1.rowid < 562949953421311 ORDER BY t2.a
1712     SELECT t2.a FROM t2 NATURAL JOIN t1
1713      WHERE t1.rowid < 562949953421311 ORDER BY t1.a DESC
1718     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1719      WHERE t2.a=13
1725     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1726      WHERE t2.a=13
1732     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1733      WHERE t2.a=13
1739     SELECT t2.a FROM t1 JOIN t2 USING(a)
1740      WHERE t1.rowid <= 562949953421311 ORDER BY t2.a
1745     SELECT t2.a FROM t2 NATURAL JOIN t1
1746      WHERE t1.rowid <= 562949953421311 ORDER BY t1.a DESC
1751     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1752      WHERE t2.a=13
1758     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1759      WHERE t2.a=13
1765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1766      WHERE t2.a=13
1772     SELECT t1.* FROM t1, t2 WHERE t1.rowid=256 AND t2.a=t1.a
1777     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000100'
1782     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=61
1787     SELECT t2.a FROM t1 JOIN t2 USING(a)
1788      WHERE t1.rowid > 256 ORDER BY t2.a
1793     SELECT t2.a FROM t2 NATURAL JOIN t1
1794      WHERE t1.rowid > 256 ORDER BY t1.a DESC
1799     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1800      WHERE t2.a=61
1806     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1807      WHERE t2.a=61
1813     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1814      WHERE t2.a=61
1820     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1821      WHERE t2.a=61
1827     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1828      WHERE t2.a=61
1834     SELECT t2.a FROM t1 JOIN t2 USING(a)
1835      WHERE t1.rowid >= 256 ORDER BY t2.a
1840     SELECT t2.a FROM t2 NATURAL JOIN t1
1841      WHERE t1.rowid >= 256 ORDER BY t1.a DESC
1846     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1847      WHERE t2.a=61
1853     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1854      WHERE t2.a=61
1860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1861      WHERE t2.a=61
1867     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1868      WHERE t2.a=61
1874     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1875      WHERE t2.a=61
1881     SELECT t2.a FROM t1 JOIN t2 USING(a)
1882      WHERE t1.rowid < 256 ORDER BY t2.a
1887     SELECT t2.a FROM t2 NATURAL JOIN t1
1888      WHERE t1.rowid < 256 ORDER BY t1.a DESC
1893     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1894      WHERE t2.a=61
1900     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1901      WHERE t2.a=61
1907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1908      WHERE t2.a=61
1914     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1915      WHERE t2.a=61
1921     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1922      WHERE t2.a=61
1928     SELECT t2.a FROM t1 JOIN t2 USING(a)
1929      WHERE t1.rowid <= 256 ORDER BY t2.a
1934     SELECT t2.a FROM t2 NATURAL JOIN t1
1935      WHERE t1.rowid <= 256 ORDER BY t1.a DESC
1940     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1941      WHERE t2.a=61
1947     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1948      WHERE t2.a=61
1954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1955      WHERE t2.a=61
1961     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1962      WHERE t2.a=61
1968     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1969      WHERE t2.a=61
1975     SELECT t1.* FROM t1, t2 WHERE t1.rowid=34359738368 AND t2.a=t1.a
1980     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000800000000'
1985     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=22
1990     SELECT t2.a FROM t1 JOIN t2 USING(a)
1991      WHERE t1.rowid > 34359738368 ORDER BY t2.a
1996     SELECT t2.a FROM t2 NATURAL JOIN t1
1997      WHERE t1.rowid > 34359738368 ORDER BY t1.a DESC
2002     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2003      WHERE t2.a=22
2009     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2010      WHERE t2.a=22
2016     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2017      WHERE t2.a=22
2023     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2024      WHERE t2.a=22
2030     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2031      WHERE t2.a=22
2037     SELECT t2.a FROM t1 JOIN t2 USING(a)
2038      WHERE t1.rowid >= 34359738368 ORDER BY t2.a
2043     SELECT t2.a FROM t2 NATURAL JOIN t1
2044      WHERE t1.rowid >= 34359738368 ORDER BY t1.a DESC
2049     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2050      WHERE t2.a=22
2056     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2057      WHERE t2.a=22
2063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2064      WHERE t2.a=22
2070     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2071      WHERE t2.a=22
2077     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2078      WHERE t2.a=22
2084     SELECT t2.a FROM t1 JOIN t2 USING(a)
2085      WHERE t1.rowid < 34359738368 ORDER BY t2.a
2090     SELECT t2.a FROM t2 NATURAL JOIN t1
2091      WHERE t1.rowid < 34359738368 ORDER BY t1.a DESC
2096     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2097      WHERE t2.a=22
2103     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2104      WHERE t2.a=22
2110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2111      WHERE t2.a=22
2117     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2118      WHERE t2.a=22
2124     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2125      WHERE t2.a=22
2131     SELECT t2.a FROM t1 JOIN t2 USING(a)
2132      WHERE t1.rowid <= 34359738368 ORDER BY t2.a
2137     SELECT t2.a FROM t2 NATURAL JOIN t1
2138      WHERE t1.rowid <= 34359738368 ORDER BY t1.a DESC
2143     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2144      WHERE t2.a=22
2150     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2151      WHERE t2.a=22
2157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2158      WHERE t2.a=22
2164     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2165      WHERE t2.a=22
2171     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2172      WHERE t2.a=22
2178     SELECT t1.* FROM t1, t2 WHERE t1.rowid=65536 AND t2.a=t1.a
2183     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000010000'
2188     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=62
2193     SELECT t2.a FROM t1 JOIN t2 USING(a)
2194      WHERE t1.rowid > 65536 ORDER BY t2.a
2199     SELECT t2.a FROM t2 NATURAL JOIN t1
2200      WHERE t1.rowid > 65536 ORDER BY t1.a DESC
2205     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2206      WHERE t2.a=62
2212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2213      WHERE t2.a=62
2219     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2220      WHERE t2.a=62
2226     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2227      WHERE t2.a=62
2233     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2234      WHERE t2.a=62
2240     SELECT t2.a FROM t1 JOIN t2 USING(a)
2241      WHERE t1.rowid >= 65536 ORDER BY t2.a
2246     SELECT t2.a FROM t2 NATURAL JOIN t1
2247      WHERE t1.rowid >= 65536 ORDER BY t1.a DESC
2252     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2253      WHERE t2.a=62
2259     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2260      WHERE t2.a=62
2266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2267      WHERE t2.a=62
2273     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2274      WHERE t2.a=62
2280     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2281      WHERE t2.a=62
2287     SELECT t2.a FROM t1 JOIN t2 USING(a)
2288      WHERE t1.rowid < 65536 ORDER BY t2.a
2293     SELECT t2.a FROM t2 NATURAL JOIN t1
2294      WHERE t1.rowid < 65536 ORDER BY t1.a DESC
2299     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2300      WHERE t2.a=62
2306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2307      WHERE t2.a=62
2313     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2314      WHERE t2.a=62
2320     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2321      WHERE t2.a=62
2327     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2328      WHERE t2.a=62
2334     SELECT t2.a FROM t1 JOIN t2 USING(a)
2335      WHERE t1.rowid <= 65536 ORDER BY t2.a
2340     SELECT t2.a FROM t2 NATURAL JOIN t1
2341      WHERE t1.rowid <= 65536 ORDER BY t1.a DESC
2346     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2347      WHERE t2.a=62
2353     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2354      WHERE t2.a=62
2360     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2361      WHERE t2.a=62
2367     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2368      WHERE t2.a=62
2374     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2375      WHERE t2.a=62
2381     SELECT t1.* FROM t1, t2 WHERE t1.rowid=268435456 AND t2.a=t1.a
2386     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000010000000'
2391     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=40
2396     SELECT t2.a FROM t1 JOIN t2 USING(a)
2397      WHERE t1.rowid > 268435456 ORDER BY t2.a
2402     SELECT t2.a FROM t2 NATURAL JOIN t1
2403      WHERE t1.rowid > 268435456 ORDER BY t1.a DESC
2408     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2409      WHERE t2.a=40
2415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2416      WHERE t2.a=40
2422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2423      WHERE t2.a=40
2429     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2430      WHERE t2.a=40
2436     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2437      WHERE t2.a=40
2443     SELECT t2.a FROM t1 JOIN t2 USING(a)
2444      WHERE t1.rowid >= 268435456 ORDER BY t2.a
2449     SELECT t2.a FROM t2 NATURAL JOIN t1
2450      WHERE t1.rowid >= 268435456 ORDER BY t1.a DESC
2455     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2456      WHERE t2.a=40
2462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2463      WHERE t2.a=40
2469     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2470      WHERE t2.a=40
2476     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2477      WHERE t2.a=40
2483     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2484      WHERE t2.a=40
2490     SELECT t2.a FROM t1 JOIN t2 USING(a)
2491      WHERE t1.rowid < 268435456 ORDER BY t2.a
2496     SELECT t2.a FROM t2 NATURAL JOIN t1
2497      WHERE t1.rowid < 268435456 ORDER BY t1.a DESC
2502     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2503      WHERE t2.a=40
2509     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2510      WHERE t2.a=40
2516     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2517      WHERE t2.a=40
2523     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2524      WHERE t2.a=40
2530     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2531      WHERE t2.a=40
2537     SELECT t2.a FROM t1 JOIN t2 USING(a)
2538      WHERE t1.rowid <= 268435456 ORDER BY t2.a
2543     SELECT t2.a FROM t2 NATURAL JOIN t1
2544      WHERE t1.rowid <= 268435456 ORDER BY t1.a DESC
2549     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2550      WHERE t2.a=40
2556     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2557      WHERE t2.a=40
2563     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2564      WHERE t2.a=40
2570     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2571      WHERE t2.a=40
2577     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2578      WHERE t2.a=40
2584     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-140737488355328 AND t2.a=t1.a
2589     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffff800000000000'
2594     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=44
2599     SELECT t2.a FROM t1 JOIN t2 USING(a)
2600      WHERE t1.rowid > -140737488355328 ORDER BY t2.a
2605     SELECT t2.a FROM t2 NATURAL JOIN t1
2606      WHERE t1.rowid > -140737488355328 ORDER BY t1.a DESC
2611     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2612      WHERE t2.a=44
2618     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2619      WHERE t2.a=44
2625     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2626      WHERE t2.a=44
2632     SELECT t2.a FROM t1 JOIN t2 USING(a)
2633      WHERE t1.rowid >= -140737488355328 ORDER BY t2.a
2638     SELECT t2.a FROM t2 NATURAL JOIN t1
2639      WHERE t1.rowid >= -140737488355328 ORDER BY t1.a DESC
2644     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2645      WHERE t2.a=44
2651     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2652      WHERE t2.a=44
2658     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2659      WHERE t2.a=44
2665     SELECT t2.a FROM t1 JOIN t2 USING(a)
2666      WHERE t1.rowid < -140737488355328 ORDER BY t2.a
2671     SELECT t2.a FROM t2 NATURAL JOIN t1
2672      WHERE t1.rowid < -140737488355328 ORDER BY t1.a DESC
2677     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2678      WHERE t2.a=44
2684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2685      WHERE t2.a=44
2691     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2692      WHERE t2.a=44
2698     SELECT t2.a FROM t1 JOIN t2 USING(a)
2699      WHERE t1.rowid <= -140737488355328 ORDER BY t2.a
2704     SELECT t2.a FROM t2 NATURAL JOIN t1
2705      WHERE t1.rowid <= -140737488355328 ORDER BY t1.a DESC
2710     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2711      WHERE t2.a=44
2717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2718      WHERE t2.a=44
2724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2725      WHERE t2.a=44
2731     SELECT t1.* FROM t1, t2 WHERE t1.rowid=1099511627776 AND t2.a=t1.a
2736     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000010000000000'
2741     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=19
2746     SELECT t2.a FROM t1 JOIN t2 USING(a)
2747      WHERE t1.rowid > 1099511627776 ORDER BY t2.a
2752     SELECT t2.a FROM t2 NATURAL JOIN t1
2753      WHERE t1.rowid > 1099511627776 ORDER BY t1.a DESC
2758     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2759      WHERE t2.a=19
2765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2766      WHERE t2.a=19
2772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2773      WHERE t2.a=19
2779     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2780      WHERE t2.a=19
2786     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2787      WHERE t2.a=19
2793     SELECT t2.a FROM t1 JOIN t2 USING(a)
2794      WHERE t1.rowid >= 1099511627776 ORDER BY t2.a
2799     SELECT t2.a FROM t2 NATURAL JOIN t1
2800      WHERE t1.rowid >= 1099511627776 ORDER BY t1.a DESC
2805     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2806      WHERE t2.a=19
2812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2813      WHERE t2.a=19
2819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2820      WHERE t2.a=19
2826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2827      WHERE t2.a=19
2833     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2834      WHERE t2.a=19
2840     SELECT t2.a FROM t1 JOIN t2 USING(a)
2841      WHERE t1.rowid < 1099511627776 ORDER BY t2.a
2846     SELECT t2.a FROM t2 NATURAL JOIN t1
2847      WHERE t1.rowid < 1099511627776 ORDER BY t1.a DESC
2852     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2853      WHERE t2.a=19
2859     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2860      WHERE t2.a=19
2866     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2867      WHERE t2.a=19
2873     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2874      WHERE t2.a=19
2880     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2881      WHERE t2.a=19
2887     SELECT t2.a FROM t1 JOIN t2 USING(a)
2888      WHERE t1.rowid <= 1099511627776 ORDER BY t2.a
2893     SELECT t2.a FROM t2 NATURAL JOIN t1
2894      WHERE t1.rowid <= 1099511627776 ORDER BY t1.a DESC
2899     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2900      WHERE t2.a=19
2906     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2907      WHERE t2.a=19
2913     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2914      WHERE t2.a=19
2920     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2921      WHERE t2.a=19
2927     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2928      WHERE t2.a=19
2934     SELECT t2.a FROM t1 JOIN t2 USING(a)
2935      WHERE t1.rowid > 9223372036854775807 ORDER BY t2.a
2940     SELECT t2.a FROM t2 NATURAL JOIN t1
2941      WHERE t1.rowid > 9223372036854775807 ORDER BY t1.a DESC
2946     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2947      WHERE t2.a=3
2953     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2954      WHERE t2.a=3
2960     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2961      WHERE t2.a=3
2967     SELECT t2.a FROM t1 JOIN t2 USING(a)
2968      WHERE t1.rowid >= 9223372036854775807 ORDER BY t2.a
2973     SELECT t2.a FROM t2 NATURAL JOIN t1
2974      WHERE t1.rowid >= 9223372036854775807 ORDER BY t1.a DESC
2979     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2980      WHERE t2.a=3
2986     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2987      WHERE t2.a=3
2993     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2994      WHERE t2.a=3
3000     SELECT t2.a FROM t1 JOIN t2 USING(a)
3001      WHERE t1.rowid < 9223372036854775807 ORDER BY t2.a
3006     SELECT t2.a FROM t2 NATURAL JOIN t1
3007      WHERE t1.rowid < 9223372036854775807 ORDER BY t1.a DESC
3012     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3013      WHERE t2.a=3
3019     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3020      WHERE t2.a=3
3026     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3027      WHERE t2.a=3
3033     SELECT t2.a FROM t1 JOIN t2 USING(a)
3034      WHERE t1.rowid <= 9223372036854775807 ORDER BY t2.a
3039     SELECT t2.a FROM t2 NATURAL JOIN t1
3040      WHERE t1.rowid <= 9223372036854775807 ORDER BY t1.a DESC
3045     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3046      WHERE t2.a=3
3052     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3053      WHERE t2.a=3
3059     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3060      WHERE t2.a=3
3066     SELECT t1.* FROM t1, t2 WHERE t1.rowid=32768 AND t2.a=t1.a
3071     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000008000'
3076     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=50
3081     SELECT t2.a FROM t1 JOIN t2 USING(a)
3082      WHERE t1.rowid > 32768 ORDER BY t2.a
3087     SELECT t2.a FROM t2 NATURAL JOIN t1
3088      WHERE t1.rowid > 32768 ORDER BY t1.a DESC
3093     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3094      WHERE t2.a=50
3100     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3101      WHERE t2.a=50
3107     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3108      WHERE t2.a=50
3114     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3115      WHERE t2.a=50
3121     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3122      WHERE t2.a=50
3128     SELECT t2.a FROM t1 JOIN t2 USING(a)
3129      WHERE t1.rowid >= 32768 ORDER BY t2.a
3134     SELECT t2.a FROM t2 NATURAL JOIN t1
3135      WHERE t1.rowid >= 32768 ORDER BY t1.a DESC
3140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3141      WHERE t2.a=50
3147     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3148      WHERE t2.a=50
3154     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3155      WHERE t2.a=50
3161     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3162      WHERE t2.a=50
3168     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3169      WHERE t2.a=50
3175     SELECT t2.a FROM t1 JOIN t2 USING(a)
3176      WHERE t1.rowid < 32768 ORDER BY t2.a
3181     SELECT t2.a FROM t2 NATURAL JOIN t1
3182      WHERE t1.rowid < 32768 ORDER BY t1.a DESC
3187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3188      WHERE t2.a=50
3194     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3195      WHERE t2.a=50
3201     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3202      WHERE t2.a=50
3208     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3209      WHERE t2.a=50
3215     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3216      WHERE t2.a=50
3222     SELECT t2.a FROM t1 JOIN t2 USING(a)
3223      WHERE t1.rowid <= 32768 ORDER BY t2.a
3228     SELECT t2.a FROM t2 NATURAL JOIN t1
3229      WHERE t1.rowid <= 32768 ORDER BY t1.a DESC
3234     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3235      WHERE t2.a=50
3241     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3242      WHERE t2.a=50
3248     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3249      WHERE t2.a=50
3255     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3256      WHERE t2.a=50
3262     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3263      WHERE t2.a=50
3269     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-36028797018963968 AND t2.a=t1.a
3274     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ff80000000000000'
3279     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=64
3284     SELECT t2.a FROM t1 JOIN t2 USING(a)
3285      WHERE t1.rowid > -36028797018963968 ORDER BY t2.a
3290     SELECT t2.a FROM t2 NATURAL JOIN t1
3291      WHERE t1.rowid > -36028797018963968 ORDER BY t1.a DESC
3296     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3297      WHERE t2.a=64
3303     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3304      WHERE t2.a=64
3310     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3311      WHERE t2.a=64
3317     SELECT t2.a FROM t1 JOIN t2 USING(a)
3318      WHERE t1.rowid >= -36028797018963968 ORDER BY t2.a
3323     SELECT t2.a FROM t2 NATURAL JOIN t1
3324      WHERE t1.rowid >= -36028797018963968 ORDER BY t1.a DESC
3329     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3330      WHERE t2.a=64
3336     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3337      WHERE t2.a=64
3343     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3344      WHERE t2.a=64
3350     SELECT t2.a FROM t1 JOIN t2 USING(a)
3351      WHERE t1.rowid < -36028797018963968 ORDER BY t2.a
3356     SELECT t2.a FROM t2 NATURAL JOIN t1
3357      WHERE t1.rowid < -36028797018963968 ORDER BY t1.a DESC
3362     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3363      WHERE t2.a=64
3369     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3370      WHERE t2.a=64
3376     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3377      WHERE t2.a=64
3383     SELECT t2.a FROM t1 JOIN t2 USING(a)
3384      WHERE t1.rowid <= -36028797018963968 ORDER BY t2.a
3389     SELECT t2.a FROM t2 NATURAL JOIN t1
3390      WHERE t1.rowid <= -36028797018963968 ORDER BY t1.a DESC
3395     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3396      WHERE t2.a=64
3402     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3403      WHERE t2.a=64
3409     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3410      WHERE t2.a=64
3416     SELECT t1.* FROM t1, t2 WHERE t1.rowid=65535 AND t2.a=t1.a
3421     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000000000000ffff'
3426     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=48
3431     SELECT t2.a FROM t1 JOIN t2 USING(a)
3432      WHERE t1.rowid > 65535 ORDER BY t2.a
3437     SELECT t2.a FROM t2 NATURAL JOIN t1
3438      WHERE t1.rowid > 65535 ORDER BY t1.a DESC
3443     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3444      WHERE t2.a=48
3450     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3451      WHERE t2.a=48
3457     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3458      WHERE t2.a=48
3464     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3465      WHERE t2.a=48
3471     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3472      WHERE t2.a=48
3478     SELECT t2.a FROM t1 JOIN t2 USING(a)
3479      WHERE t1.rowid >= 65535 ORDER BY t2.a
3484     SELECT t2.a FROM t2 NATURAL JOIN t1
3485      WHERE t1.rowid >= 65535 ORDER BY t1.a DESC
3490     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3491      WHERE t2.a=48
3497     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3498      WHERE t2.a=48
3504     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3505      WHERE t2.a=48
3511     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3512      WHERE t2.a=48
3518     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3519      WHERE t2.a=48
3525     SELECT t2.a FROM t1 JOIN t2 USING(a)
3526      WHERE t1.rowid < 65535 ORDER BY t2.a
3531     SELECT t2.a FROM t2 NATURAL JOIN t1
3532      WHERE t1.rowid < 65535 ORDER BY t1.a DESC
3537     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3538      WHERE t2.a=48
3544     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3545      WHERE t2.a=48
3551     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3552      WHERE t2.a=48
3558     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3559      WHERE t2.a=48
3565     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3566      WHERE t2.a=48
3572     SELECT t2.a FROM t1 JOIN t2 USING(a)
3573      WHERE t1.rowid <= 65535 ORDER BY t2.a
3578     SELECT t2.a FROM t2 NATURAL JOIN t1
3579      WHERE t1.rowid <= 65535 ORDER BY t1.a DESC
3584     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3585      WHERE t2.a=48
3591     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3592      WHERE t2.a=48
3598     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3599      WHERE t2.a=48
3605     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3606      WHERE t2.a=48
3612     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3613      WHERE t2.a=48
3619     SELECT t1.* FROM t1, t2 WHERE t1.rowid=4294967295 AND t2.a=t1.a
3624     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00000000ffffffff'
3629     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=14
3634     SELECT t2.a FROM t1 JOIN t2 USING(a)
3635      WHERE t1.rowid > 4294967295 ORDER BY t2.a
3640     SELECT t2.a FROM t2 NATURAL JOIN t1
3641      WHERE t1.rowid > 4294967295 ORDER BY t1.a DESC
3646     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3647      WHERE t2.a=14
3653     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3654      WHERE t2.a=14
3660     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3661      WHERE t2.a=14
3667     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3668      WHERE t2.a=14
3674     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3675      WHERE t2.a=14
3681     SELECT t2.a FROM t1 JOIN t2 USING(a)
3682      WHERE t1.rowid >= 4294967295 ORDER BY t2.a
3687     SELECT t2.a FROM t2 NATURAL JOIN t1
3688      WHERE t1.rowid >= 4294967295 ORDER BY t1.a DESC
3693     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3694      WHERE t2.a=14
3700     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3701      WHERE t2.a=14
3707     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3708      WHERE t2.a=14
3714     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3715      WHERE t2.a=14
3721     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3722      WHERE t2.a=14
3728     SELECT t2.a FROM t1 JOIN t2 USING(a)
3729      WHERE t1.rowid < 4294967295 ORDER BY t2.a
3734     SELECT t2.a FROM t2 NATURAL JOIN t1
3735      WHERE t1.rowid < 4294967295 ORDER BY t1.a DESC
3740     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3741      WHERE t2.a=14
3747     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3748      WHERE t2.a=14
3754     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3755      WHERE t2.a=14
3761     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3762      WHERE t2.a=14
3768     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3769      WHERE t2.a=14
3775     SELECT t2.a FROM t1 JOIN t2 USING(a)
3776      WHERE t1.rowid <= 4294967295 ORDER BY t2.a
3781     SELECT t2.a FROM t2 NATURAL JOIN t1
3782      WHERE t1.rowid <= 4294967295 ORDER BY t1.a DESC
3787     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3788      WHERE t2.a=14
3794     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3795      WHERE t2.a=14
3801     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3802      WHERE t2.a=14
3808     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3809      WHERE t2.a=14
3815     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3816      WHERE t2.a=14
3822     SELECT t1.* FROM t1, t2 WHERE t1.rowid=1099511627775 AND t2.a=t1.a
3827     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000000ffffffffff'
3832     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=57
3837     SELECT t2.a FROM t1 JOIN t2 USING(a)
3838      WHERE t1.rowid > 1099511627775 ORDER BY t2.a
3843     SELECT t2.a FROM t2 NATURAL JOIN t1
3844      WHERE t1.rowid > 1099511627775 ORDER BY t1.a DESC
3849     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3850      WHERE t2.a=57
3856     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3857      WHERE t2.a=57
3863     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3864      WHERE t2.a=57
3870     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3871      WHERE t2.a=57
3877     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3878      WHERE t2.a=57
3884     SELECT t2.a FROM t1 JOIN t2 USING(a)
3885      WHERE t1.rowid >= 1099511627775 ORDER BY t2.a
3890     SELECT t2.a FROM t2 NATURAL JOIN t1
3891      WHERE t1.rowid >= 1099511627775 ORDER BY t1.a DESC
3896     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3897      WHERE t2.a=57
3903     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3904      WHERE t2.a=57
3910     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3911      WHERE t2.a=57
3917     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3918      WHERE t2.a=57
3924     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3925      WHERE t2.a=57
3931     SELECT t2.a FROM t1 JOIN t2 USING(a)
3932      WHERE t1.rowid < 1099511627775 ORDER BY t2.a
3937     SELECT t2.a FROM t2 NATURAL JOIN t1
3938      WHERE t1.rowid < 1099511627775 ORDER BY t1.a DESC
3943     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3944      WHERE t2.a=57
3950     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3951      WHERE t2.a=57
3957     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3958      WHERE t2.a=57
3964     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3965      WHERE t2.a=57
3971     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3972      WHERE t2.a=57
3978     SELECT t2.a FROM t1 JOIN t2 USING(a)
3979      WHERE t1.rowid <= 1099511627775 ORDER BY t2.a
3984     SELECT t2.a FROM t2 NATURAL JOIN t1
3985      WHERE t1.rowid <= 1099511627775 ORDER BY t1.a DESC
3990     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3991      WHERE t2.a=57
3997     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3998      WHERE t2.a=57
4004     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4005      WHERE t2.a=57
4011     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4012      WHERE t2.a=57
4018     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4019      WHERE t2.a=57
4025     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-8388608 AND t2.a=t1.a
4030     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffff800000'
4035     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=37
4040     SELECT t2.a FROM t1 JOIN t2 USING(a)
4041      WHERE t1.rowid > -8388608 ORDER BY t2.a
4046     SELECT t2.a FROM t2 NATURAL JOIN t1
4047      WHERE t1.rowid > -8388608 ORDER BY t1.a DESC
4052     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4053      WHERE t2.a=37
4059     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4060      WHERE t2.a=37
4066     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4067      WHERE t2.a=37
4073     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4074      WHERE t2.a=37
4080     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4081      WHERE t2.a=37
4087     SELECT t2.a FROM t1 JOIN t2 USING(a)
4088      WHERE t1.rowid >= -8388608 ORDER BY t2.a
4093     SELECT t2.a FROM t2 NATURAL JOIN t1
4094      WHERE t1.rowid >= -8388608 ORDER BY t1.a DESC
4099     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4100      WHERE t2.a=37
4106     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4107      WHERE t2.a=37
4113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4114      WHERE t2.a=37
4120     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4121      WHERE t2.a=37
4127     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4128      WHERE t2.a=37
4134     SELECT t2.a FROM t1 JOIN t2 USING(a)
4135      WHERE t1.rowid < -8388608 ORDER BY t2.a
4140     SELECT t2.a FROM t2 NATURAL JOIN t1
4141      WHERE t1.rowid < -8388608 ORDER BY t1.a DESC
4146     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4147      WHERE t2.a=37
4153     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4154      WHERE t2.a=37
4160     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4161      WHERE t2.a=37
4167     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4168      WHERE t2.a=37
4174     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4175      WHERE t2.a=37
4181     SELECT t2.a FROM t1 JOIN t2 USING(a)
4182      WHERE t1.rowid <= -8388608 ORDER BY t2.a
4187     SELECT t2.a FROM t2 NATURAL JOIN t1
4188      WHERE t1.rowid <= -8388608 ORDER BY t1.a DESC
4193     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4194      WHERE t2.a=37
4200     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4201      WHERE t2.a=37
4207     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4208      WHERE t2.a=37
4214     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4215      WHERE t2.a=37
4221     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4222      WHERE t2.a=37
4228     SELECT t1.* FROM t1, t2 WHERE t1.rowid=549755813888 AND t2.a=t1.a
4233     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000008000000000'
4238     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=35
4243     SELECT t2.a FROM t1 JOIN t2 USING(a)
4244      WHERE t1.rowid > 549755813888 ORDER BY t2.a
4249     SELECT t2.a FROM t2 NATURAL JOIN t1
4250      WHERE t1.rowid > 549755813888 ORDER BY t1.a DESC
4255     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4256      WHERE t2.a=35
4262     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4263      WHERE t2.a=35
4269     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4270      WHERE t2.a=35
4276     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4277      WHERE t2.a=35
4283     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4284      WHERE t2.a=35
4290     SELECT t2.a FROM t1 JOIN t2 USING(a)
4291      WHERE t1.rowid >= 549755813888 ORDER BY t2.a
4296     SELECT t2.a FROM t2 NATURAL JOIN t1
4297      WHERE t1.rowid >= 549755813888 ORDER BY t1.a DESC
4302     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4303      WHERE t2.a=35
4309     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4310      WHERE t2.a=35
4316     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4317      WHERE t2.a=35
4323     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4324      WHERE t2.a=35
4330     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4331      WHERE t2.a=35
4337     SELECT t2.a FROM t1 JOIN t2 USING(a)
4338      WHERE t1.rowid < 549755813888 ORDER BY t2.a
4343     SELECT t2.a FROM t2 NATURAL JOIN t1
4344      WHERE t1.rowid < 549755813888 ORDER BY t1.a DESC
4349     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4350      WHERE t2.a=35
4356     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4357      WHERE t2.a=35
4363     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4364      WHERE t2.a=35
4370     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4371      WHERE t2.a=35
4377     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4378      WHERE t2.a=35
4384     SELECT t2.a FROM t1 JOIN t2 USING(a)
4385      WHERE t1.rowid <= 549755813888 ORDER BY t2.a
4390     SELECT t2.a FROM t2 NATURAL JOIN t1
4391      WHERE t1.rowid <= 549755813888 ORDER BY t1.a DESC
4396     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4397      WHERE t2.a=35
4403     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4404      WHERE t2.a=35
4410     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4411      WHERE t2.a=35
4417     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4418      WHERE t2.a=35
4424     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4425      WHERE t2.a=35
4431     SELECT t1.* FROM t1, t2 WHERE t1.rowid=8388607 AND t2.a=t1.a
4436     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00000000007fffff'
4441     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=18
4446     SELECT t2.a FROM t1 JOIN t2 USING(a)
4447      WHERE t1.rowid > 8388607 ORDER BY t2.a
4452     SELECT t2.a FROM t2 NATURAL JOIN t1
4453      WHERE t1.rowid > 8388607 ORDER BY t1.a DESC
4458     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4459      WHERE t2.a=18
4465     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4466      WHERE t2.a=18
4472     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4473      WHERE t2.a=18
4479     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4480      WHERE t2.a=18
4486     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4487      WHERE t2.a=18
4493     SELECT t2.a FROM t1 JOIN t2 USING(a)
4494      WHERE t1.rowid >= 8388607 ORDER BY t2.a
4499     SELECT t2.a FROM t2 NATURAL JOIN t1
4500      WHERE t1.rowid >= 8388607 ORDER BY t1.a DESC
4505     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4506      WHERE t2.a=18
4512     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4513      WHERE t2.a=18
4519     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4520      WHERE t2.a=18
4526     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4527      WHERE t2.a=18
4533     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4534      WHERE t2.a=18
4540     SELECT t2.a FROM t1 JOIN t2 USING(a)
4541      WHERE t1.rowid < 8388607 ORDER BY t2.a
4546     SELECT t2.a FROM t2 NATURAL JOIN t1
4547      WHERE t1.rowid < 8388607 ORDER BY t1.a DESC
4552     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4553      WHERE t2.a=18
4559     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4560      WHERE t2.a=18
4566     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4567      WHERE t2.a=18
4573     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4574      WHERE t2.a=18
4580     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4581      WHERE t2.a=18
4587     SELECT t2.a FROM t1 JOIN t2 USING(a)
4588      WHERE t1.rowid <= 8388607 ORDER BY t2.a
4593     SELECT t2.a FROM t2 NATURAL JOIN t1
4594      WHERE t1.rowid <= 8388607 ORDER BY t1.a DESC
4599     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4600      WHERE t2.a=18
4606     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4607      WHERE t2.a=18
4613     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4614      WHERE t2.a=18
4620     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4621      WHERE t2.a=18
4627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4628      WHERE t2.a=18
4634     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-3 AND t2.a=t1.a
4639     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='fffffffffffffffd'
4644     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=52
4649     SELECT t2.a FROM t1 JOIN t2 USING(a)
4650      WHERE t1.rowid > -3 ORDER BY t2.a
4655     SELECT t2.a FROM t2 NATURAL JOIN t1
4656      WHERE t1.rowid > -3 ORDER BY t1.a DESC
4661     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4662      WHERE t2.a=52
4668     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4669      WHERE t2.a=52
4675     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4676      WHERE t2.a=52
4682     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4683      WHERE t2.a=52
4689     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4690      WHERE t2.a=52
4696     SELECT t2.a FROM t1 JOIN t2 USING(a)
4697      WHERE t1.rowid >= -3 ORDER BY t2.a
4702     SELECT t2.a FROM t2 NATURAL JOIN t1
4703      WHERE t1.rowid >= -3 ORDER BY t1.a DESC
4708     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4709      WHERE t2.a=52
4715     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4716      WHERE t2.a=52
4722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4723      WHERE t2.a=52
4729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4730      WHERE t2.a=52
4736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4737      WHERE t2.a=52
4743     SELECT t2.a FROM t1 JOIN t2 USING(a)
4744      WHERE t1.rowid < -3 ORDER BY t2.a
4749     SELECT t2.a FROM t2 NATURAL JOIN t1
4750      WHERE t1.rowid < -3 ORDER BY t1.a DESC
4755     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4756      WHERE t2.a=52
4762     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4763      WHERE t2.a=52
4769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4770      WHERE t2.a=52
4776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4777      WHERE t2.a=52
4783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4784      WHERE t2.a=52
4790     SELECT t2.a FROM t1 JOIN t2 USING(a)
4791      WHERE t1.rowid <= -3 ORDER BY t2.a
4796     SELECT t2.a FROM t2 NATURAL JOIN t1
4797      WHERE t1.rowid <= -3 ORDER BY t1.a DESC
4802     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4803      WHERE t2.a=52
4809     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4810      WHERE t2.a=52
4816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4817      WHERE t2.a=52
4823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4824      WHERE t2.a=52
4830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4831      WHERE t2.a=52
4837     SELECT t1.* FROM t1, t2 WHERE t1.rowid=0 AND t2.a=t1.a
4842     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000000'
4847     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=59
4852     SELECT t2.a FROM t1 JOIN t2 USING(a)
4853      WHERE t1.rowid > 0 ORDER BY t2.a
4858     SELECT t2.a FROM t2 NATURAL JOIN t1
4859      WHERE t1.rowid > 0 ORDER BY t1.a DESC
4864     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4865      WHERE t2.a=59
4871     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4872      WHERE t2.a=59
4878     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4879      WHERE t2.a=59
4885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4886      WHERE t2.a=59
4892     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4893      WHERE t2.a=59
4899     SELECT t2.a FROM t1 JOIN t2 USING(a)
4900      WHERE t1.rowid >= 0 ORDER BY t2.a
4905     SELECT t2.a FROM t2 NATURAL JOIN t1
4906      WHERE t1.rowid >= 0 ORDER BY t1.a DESC
4911     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4912      WHERE t2.a=59
4918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4919      WHERE t2.a=59
4925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4926      WHERE t2.a=59
4932     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4933      WHERE t2.a=59
4939     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4940      WHERE t2.a=59
4946     SELECT t2.a FROM t1 JOIN t2 USING(a)
4947      WHERE t1.rowid < 0 ORDER BY t2.a
4952     SELECT t2.a FROM t2 NATURAL JOIN t1
4953      WHERE t1.rowid < 0 ORDER BY t1.a DESC
4958     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4959      WHERE t2.a=59
4965     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4966      WHERE t2.a=59
4972     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4973      WHERE t2.a=59
4979     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4980      WHERE t2.a=59
4986     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4987      WHERE t2.a=59
4993     SELECT t2.a FROM t1 JOIN t2 USING(a)
4994      WHERE t1.rowid <= 0 ORDER BY t2.a
4999     SELECT t2.a FROM t2 NATURAL JOIN t1
5000      WHERE t1.rowid <= 0 ORDER BY t1.a DESC
5005     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5006      WHERE t2.a=59
5012     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5013      WHERE t2.a=59
5019     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5020      WHERE t2.a=59
5026     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5027      WHERE t2.a=59
5033     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5034      WHERE t2.a=59
5040     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-1 AND t2.a=t1.a
5045     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffffffff'
5050     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=38
5055     SELECT t2.a FROM t1 JOIN t2 USING(a)
5056      WHERE t1.rowid > -1 ORDER BY t2.a
5061     SELECT t2.a FROM t2 NATURAL JOIN t1
5062      WHERE t1.rowid > -1 ORDER BY t1.a DESC
5067     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5068      WHERE t2.a=38
5074     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5075      WHERE t2.a=38
5081     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5082      WHERE t2.a=38
5088     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5089      WHERE t2.a=38
5095     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5096      WHERE t2.a=38
5102     SELECT t2.a FROM t1 JOIN t2 USING(a)
5103      WHERE t1.rowid >= -1 ORDER BY t2.a
5108     SELECT t2.a FROM t2 NATURAL JOIN t1
5109      WHERE t1.rowid >= -1 ORDER BY t1.a DESC
5114     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5115      WHERE t2.a=38
5121     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5122      WHERE t2.a=38
5128     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5129      WHERE t2.a=38
5135     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5136      WHERE t2.a=38
5142     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5143      WHERE t2.a=38
5149     SELECT t2.a FROM t1 JOIN t2 USING(a)
5150      WHERE t1.rowid < -1 ORDER BY t2.a
5155     SELECT t2.a FROM t2 NATURAL JOIN t1
5156      WHERE t1.rowid < -1 ORDER BY t1.a DESC
5161     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5162      WHERE t2.a=38
5168     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5169      WHERE t2.a=38
5175     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5176      WHERE t2.a=38
5182     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5183      WHERE t2.a=38
5189     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5190      WHERE t2.a=38
5196     SELECT t2.a FROM t1 JOIN t2 USING(a)
5197      WHERE t1.rowid <= -1 ORDER BY t2.a
5202     SELECT t2.a FROM t2 NATURAL JOIN t1
5203      WHERE t1.rowid <= -1 ORDER BY t1.a DESC
5208     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5209      WHERE t2.a=38
5215     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5216      WHERE t2.a=38
5222     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5223      WHERE t2.a=38
5229     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5230      WHERE t2.a=38
5236     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5237      WHERE t2.a=38
5243     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-2 AND t2.a=t1.a
5248     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='fffffffffffffffe'
5253     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=33
5258     SELECT t2.a FROM t1 JOIN t2 USING(a)
5259      WHERE t1.rowid > -2 ORDER BY t2.a
5264     SELECT t2.a FROM t2 NATURAL JOIN t1
5265      WHERE t1.rowid > -2 ORDER BY t1.a DESC
5270     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5271      WHERE t2.a=33
5277     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5278      WHERE t2.a=33
5284     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5285      WHERE t2.a=33
5291     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5292      WHERE t2.a=33
5298     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5299      WHERE t2.a=33
5305     SELECT t2.a FROM t1 JOIN t2 USING(a)
5306      WHERE t1.rowid >= -2 ORDER BY t2.a
5311     SELECT t2.a FROM t2 NATURAL JOIN t1
5312      WHERE t1.rowid >= -2 ORDER BY t1.a DESC
5317     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5318      WHERE t2.a=33
5324     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5325      WHERE t2.a=33
5331     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5332      WHERE t2.a=33
5338     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5339      WHERE t2.a=33
5345     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5346      WHERE t2.a=33
5352     SELECT t2.a FROM t1 JOIN t2 USING(a)
5353      WHERE t1.rowid < -2 ORDER BY t2.a
5358     SELECT t2.a FROM t2 NATURAL JOIN t1
5359      WHERE t1.rowid < -2 ORDER BY t1.a DESC
5364     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5365      WHERE t2.a=33
5371     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5372      WHERE t2.a=33
5378     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5379      WHERE t2.a=33
5385     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5386      WHERE t2.a=33
5392     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5393      WHERE t2.a=33
5399     SELECT t2.a FROM t1 JOIN t2 USING(a)
5400      WHERE t1.rowid <= -2 ORDER BY t2.a
5405     SELECT t2.a FROM t2 NATURAL JOIN t1
5406      WHERE t1.rowid <= -2 ORDER BY t1.a DESC
5411     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5412      WHERE t2.a=33
5418     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5419      WHERE t2.a=33
5425     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5426      WHERE t2.a=33
5432     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5433      WHERE t2.a=33
5439     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5440      WHERE t2.a=33
5446     SELECT t1.* FROM t1, t2 WHERE t1.rowid=2097152 AND t2.a=t1.a
5451     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000200000'
5456     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=42
5461     SELECT t2.a FROM t1 JOIN t2 USING(a)
5462      WHERE t1.rowid > 2097152 ORDER BY t2.a
5467     SELECT t2.a FROM t2 NATURAL JOIN t1
5468      WHERE t1.rowid > 2097152 ORDER BY t1.a DESC
5473     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5474      WHERE t2.a=42
5480     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5481      WHERE t2.a=42
5487     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5488      WHERE t2.a=42
5494     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5495      WHERE t2.a=42
5501     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5502      WHERE t2.a=42
5508     SELECT t2.a FROM t1 JOIN t2 USING(a)
5509      WHERE t1.rowid >= 2097152 ORDER BY t2.a
5514     SELECT t2.a FROM t2 NATURAL JOIN t1
5515      WHERE t1.rowid >= 2097152 ORDER BY t1.a DESC
5520     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5521      WHERE t2.a=42
5527     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5528      WHERE t2.a=42
5534     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5535      WHERE t2.a=42
5541     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5542      WHERE t2.a=42
5548     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5549      WHERE t2.a=42
5555     SELECT t2.a FROM t1 JOIN t2 USING(a)
5556      WHERE t1.rowid < 2097152 ORDER BY t2.a
5561     SELECT t2.a FROM t2 NATURAL JOIN t1
5562      WHERE t1.rowid < 2097152 ORDER BY t1.a DESC
5567     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5568      WHERE t2.a=42
5574     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5575      WHERE t2.a=42
5581     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5582      WHERE t2.a=42
5588     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5589      WHERE t2.a=42
5595     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5596      WHERE t2.a=42
5602     SELECT t2.a FROM t1 JOIN t2 USING(a)
5603      WHERE t1.rowid <= 2097152 ORDER BY t2.a
5608     SELECT t2.a FROM t2 NATURAL JOIN t1
5609      WHERE t1.rowid <= 2097152 ORDER BY t1.a DESC
5614     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5615      WHERE t2.a=42
5621     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5622      WHERE t2.a=42
5628     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5629      WHERE t2.a=42
5635     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5636      WHERE t2.a=42
5642     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5643      WHERE t2.a=42
5649     SELECT t1.* FROM t1, t2 WHERE t1.rowid=128 AND t2.a=t1.a
5654     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000080'
5659     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=49
5664     SELECT t2.a FROM t1 JOIN t2 USING(a)
5665      WHERE t1.rowid > 128 ORDER BY t2.a
5670     SELECT t2.a FROM t2 NATURAL JOIN t1
5671      WHERE t1.rowid > 128 ORDER BY t1.a DESC
5676     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5677      WHERE t2.a=49
5683     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5684      WHERE t2.a=49
5690     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5691      WHERE t2.a=49
5697     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5698      WHERE t2.a=49
5704     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5705      WHERE t2.a=49
5711     SELECT t2.a FROM t1 JOIN t2 USING(a)
5712      WHERE t1.rowid >= 128 ORDER BY t2.a
5717     SELECT t2.a FROM t2 NATURAL JOIN t1
5718      WHERE t1.rowid >= 128 ORDER BY t1.a DESC
5723     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5724      WHERE t2.a=49
5730     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5731      WHERE t2.a=49
5737     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5738      WHERE t2.a=49
5744     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5745      WHERE t2.a=49
5751     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5752      WHERE t2.a=49
5758     SELECT t2.a FROM t1 JOIN t2 USING(a)
5759      WHERE t1.rowid < 128 ORDER BY t2.a
5764     SELECT t2.a FROM t2 NATURAL JOIN t1
5765      WHERE t1.rowid < 128 ORDER BY t1.a DESC
5770     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5771      WHERE t2.a=49
5777     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5778      WHERE t2.a=49
5784     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5785      WHERE t2.a=49
5791     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5792      WHERE t2.a=49
5798     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5799      WHERE t2.a=49
5805     SELECT t2.a FROM t1 JOIN t2 USING(a)
5806      WHERE t1.rowid <= 128 ORDER BY t2.a
5811     SELECT t2.a FROM t2 NATURAL JOIN t1
5812      WHERE t1.rowid <= 128 ORDER BY t1.a DESC
5817     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5818      WHERE t2.a=49
5824     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5825      WHERE t2.a=49
5831     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5832      WHERE t2.a=49
5838     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5839      WHERE t2.a=49
5845     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5846      WHERE t2.a=49
5852     SELECT t1.* FROM t1, t2 WHERE t1.rowid=255 AND t2.a=t1.a
5857     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00000000000000ff'
5862     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=30
5867     SELECT t2.a FROM t1 JOIN t2 USING(a)
5868      WHERE t1.rowid > 255 ORDER BY t2.a
5873     SELECT t2.a FROM t2 NATURAL JOIN t1
5874      WHERE t1.rowid > 255 ORDER BY t1.a DESC
5879     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5880      WHERE t2.a=30
5886     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5887      WHERE t2.a=30
5893     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5894      WHERE t2.a=30
5900     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5901      WHERE t2.a=30
5907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5908      WHERE t2.a=30
5914     SELECT t2.a FROM t1 JOIN t2 USING(a)
5915      WHERE t1.rowid >= 255 ORDER BY t2.a
5920     SELECT t2.a FROM t2 NATURAL JOIN t1
5921      WHERE t1.rowid >= 255 ORDER BY t1.a DESC
5926     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5927      WHERE t2.a=30
5933     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5934      WHERE t2.a=30
5940     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5941      WHERE t2.a=30
5947     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5948      WHERE t2.a=30
5954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5955      WHERE t2.a=30
5961     SELECT t2.a FROM t1 JOIN t2 USING(a)
5962      WHERE t1.rowid < 255 ORDER BY t2.a
5967     SELECT t2.a FROM t2 NATURAL JOIN t1
5968      WHERE t1.rowid < 255 ORDER BY t1.a DESC
5973     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5974      WHERE t2.a=30
5980     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5981      WHERE t2.a=30
5987     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5988      WHERE t2.a=30
5994     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5995      WHERE t2.a=30
6001     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6002      WHERE t2.a=30
6008     SELECT t2.a FROM t1 JOIN t2 USING(a)
6009      WHERE t1.rowid <= 255 ORDER BY t2.a
6014     SELECT t2.a FROM t2 NATURAL JOIN t1
6015      WHERE t1.rowid <= 255 ORDER BY t1.a DESC
6020     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6021      WHERE t2.a=30
6027     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6028      WHERE t2.a=30
6034     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6035      WHERE t2.a=30
6041     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6042      WHERE t2.a=30
6048     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6049      WHERE t2.a=30
6055     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-2147483648 AND t2.a=t1.a
6060     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffff80000000'
6065     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=11
6070     SELECT t2.a FROM t1 JOIN t2 USING(a)
6071      WHERE t1.rowid > -2147483648 ORDER BY t2.a
6076     SELECT t2.a FROM t2 NATURAL JOIN t1
6077      WHERE t1.rowid > -2147483648 ORDER BY t1.a DESC
6082     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6083      WHERE t2.a=11
6089     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6090      WHERE t2.a=11
6096     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6097      WHERE t2.a=11
6103     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6104      WHERE t2.a=11
6110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6111      WHERE t2.a=11
6117     SELECT t2.a FROM t1 JOIN t2 USING(a)
6118      WHERE t1.rowid >= -2147483648 ORDER BY t2.a
6123     SELECT t2.a FROM t2 NATURAL JOIN t1
6124      WHERE t1.rowid >= -2147483648 ORDER BY t1.a DESC
6129     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6130      WHERE t2.a=11
6136     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6137      WHERE t2.a=11
6143     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6144      WHERE t2.a=11
6150     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6151      WHERE t2.a=11
6157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6158      WHERE t2.a=11
6164     SELECT t2.a FROM t1 JOIN t2 USING(a)
6165      WHERE t1.rowid < -2147483648 ORDER BY t2.a
6170     SELECT t2.a FROM t2 NATURAL JOIN t1
6171      WHERE t1.rowid < -2147483648 ORDER BY t1.a DESC
6176     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6177      WHERE t2.a=11
6183     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6184      WHERE t2.a=11
6190     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6191      WHERE t2.a=11
6197     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6198      WHERE t2.a=11
6204     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6205      WHERE t2.a=11
6211     SELECT t2.a FROM t1 JOIN t2 USING(a)
6212      WHERE t1.rowid <= -2147483648 ORDER BY t2.a
6217     SELECT t2.a FROM t2 NATURAL JOIN t1
6218      WHERE t1.rowid <= -2147483648 ORDER BY t1.a DESC
6223     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6224      WHERE t2.a=11
6230     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6231      WHERE t2.a=11
6237     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6238      WHERE t2.a=11
6244     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6245      WHERE t2.a=11
6251     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6252      WHERE t2.a=11
6258     SELECT t1.* FROM t1, t2 WHERE t1.rowid=34359738367 AND t2.a=t1.a
6263     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00000007ffffffff'
6268     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=39
6273     SELECT t2.a FROM t1 JOIN t2 USING(a)
6274      WHERE t1.rowid > 34359738367 ORDER BY t2.a
6279     SELECT t2.a FROM t2 NATURAL JOIN t1
6280      WHERE t1.rowid > 34359738367 ORDER BY t1.a DESC
6285     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6286      WHERE t2.a=39
6292     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6293      WHERE t2.a=39
6299     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6300      WHERE t2.a=39
6306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6307      WHERE t2.a=39
6313     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6314      WHERE t2.a=39
6320     SELECT t2.a FROM t1 JOIN t2 USING(a)
6321      WHERE t1.rowid >= 34359738367 ORDER BY t2.a
6326     SELECT t2.a FROM t2 NATURAL JOIN t1
6327      WHERE t1.rowid >= 34359738367 ORDER BY t1.a DESC
6332     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6333      WHERE t2.a=39
6339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6340      WHERE t2.a=39
6346     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6347      WHERE t2.a=39
6353     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6354      WHERE t2.a=39
6360     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6361      WHERE t2.a=39
6367     SELECT t2.a FROM t1 JOIN t2 USING(a)
6368      WHERE t1.rowid < 34359738367 ORDER BY t2.a
6373     SELECT t2.a FROM t2 NATURAL JOIN t1
6374      WHERE t1.rowid < 34359738367 ORDER BY t1.a DESC
6379     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6380      WHERE t2.a=39
6386     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6387      WHERE t2.a=39
6393     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6394      WHERE t2.a=39
6400     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6401      WHERE t2.a=39
6407     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6408      WHERE t2.a=39
6414     SELECT t2.a FROM t1 JOIN t2 USING(a)
6415      WHERE t1.rowid <= 34359738367 ORDER BY t2.a
6420     SELECT t2.a FROM t2 NATURAL JOIN t1
6421      WHERE t1.rowid <= 34359738367 ORDER BY t1.a DESC
6426     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6427      WHERE t2.a=39
6433     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6434      WHERE t2.a=39
6440     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6441      WHERE t2.a=39
6447     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6448      WHERE t2.a=39
6454     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6455      WHERE t2.a=39
6461     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-549755813889 AND t2.a=t1.a
6466     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffff7fffffffff'
6471     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=58
6476     SELECT t2.a FROM t1 JOIN t2 USING(a)
6477      WHERE t1.rowid > -549755813889 ORDER BY t2.a
6482     SELECT t2.a FROM t2 NATURAL JOIN t1
6483      WHERE t1.rowid > -549755813889 ORDER BY t1.a DESC
6488     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6489      WHERE t2.a=58
6495     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6496      WHERE t2.a=58
6502     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6503      WHERE t2.a=58
6509     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6510      WHERE t2.a=58
6516     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6517      WHERE t2.a=58
6523     SELECT t2.a FROM t1 JOIN t2 USING(a)
6524      WHERE t1.rowid >= -549755813889 ORDER BY t2.a
6529     SELECT t2.a FROM t2 NATURAL JOIN t1
6530      WHERE t1.rowid >= -549755813889 ORDER BY t1.a DESC
6535     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6536      WHERE t2.a=58
6542     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6543      WHERE t2.a=58
6549     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6550      WHERE t2.a=58
6556     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6557      WHERE t2.a=58
6563     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6564      WHERE t2.a=58
6570     SELECT t2.a FROM t1 JOIN t2 USING(a)
6571      WHERE t1.rowid < -549755813889 ORDER BY t2.a
6576     SELECT t2.a FROM t2 NATURAL JOIN t1
6577      WHERE t1.rowid < -549755813889 ORDER BY t1.a DESC
6582     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6583      WHERE t2.a=58
6589     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6590      WHERE t2.a=58
6596     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6597      WHERE t2.a=58
6603     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6604      WHERE t2.a=58
6610     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6611      WHERE t2.a=58
6617     SELECT t2.a FROM t1 JOIN t2 USING(a)
6618      WHERE t1.rowid <= -549755813889 ORDER BY t2.a
6623     SELECT t2.a FROM t2 NATURAL JOIN t1
6624      WHERE t1.rowid <= -549755813889 ORDER BY t1.a DESC
6629     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6630      WHERE t2.a=58
6636     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6637      WHERE t2.a=58
6643     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6644      WHERE t2.a=58
6650     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6651      WHERE t2.a=58
6657     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6658      WHERE t2.a=58
6664     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-32768 AND t2.a=t1.a
6669     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffff8000'
6674     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=32
6679     SELECT t2.a FROM t1 JOIN t2 USING(a)
6680      WHERE t1.rowid > -32768 ORDER BY t2.a
6685     SELECT t2.a FROM t2 NATURAL JOIN t1
6686      WHERE t1.rowid > -32768 ORDER BY t1.a DESC
6691     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6692      WHERE t2.a=32
6698     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6699      WHERE t2.a=32
6705     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6706      WHERE t2.a=32
6712     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6713      WHERE t2.a=32
6719     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6720      WHERE t2.a=32
6726     SELECT t2.a FROM t1 JOIN t2 USING(a)
6727      WHERE t1.rowid >= -32768 ORDER BY t2.a
6732     SELECT t2.a FROM t2 NATURAL JOIN t1
6733      WHERE t1.rowid >= -32768 ORDER BY t1.a DESC
6738     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6739      WHERE t2.a=32
6745     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6746      WHERE t2.a=32
6752     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6753      WHERE t2.a=32
6759     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6760      WHERE t2.a=32
6766     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6767      WHERE t2.a=32
6773     SELECT t2.a FROM t1 JOIN t2 USING(a)
6774      WHERE t1.rowid < -32768 ORDER BY t2.a
6779     SELECT t2.a FROM t2 NATURAL JOIN t1
6780      WHERE t1.rowid < -32768 ORDER BY t1.a DESC
6785     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6786      WHERE t2.a=32
6792     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6793      WHERE t2.a=32
6799     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6800      WHERE t2.a=32
6806     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6807      WHERE t2.a=32
6813     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6814      WHERE t2.a=32
6820     SELECT t2.a FROM t1 JOIN t2 USING(a)
6821      WHERE t1.rowid <= -32768 ORDER BY t2.a
6826     SELECT t2.a FROM t2 NATURAL JOIN t1
6827      WHERE t1.rowid <= -32768 ORDER BY t1.a DESC
6832     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6833      WHERE t2.a=32
6839     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6840      WHERE t2.a=32
6846     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6847      WHERE t2.a=32
6853     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6854      WHERE t2.a=32
6860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6861      WHERE t2.a=32
6867     SELECT t1.* FROM t1, t2 WHERE t1.rowid=2147483647 AND t2.a=t1.a
6872     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000000007fffffff'
6877     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=20
6882     SELECT t2.a FROM t1 JOIN t2 USING(a)
6883      WHERE t1.rowid > 2147483647 ORDER BY t2.a
6888     SELECT t2.a FROM t2 NATURAL JOIN t1
6889      WHERE t1.rowid > 2147483647 ORDER BY t1.a DESC
6894     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6895      WHERE t2.a=20
6901     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6902      WHERE t2.a=20
6908     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6909      WHERE t2.a=20
6915     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6916      WHERE t2.a=20
6922     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6923      WHERE t2.a=20
6929     SELECT t2.a FROM t1 JOIN t2 USING(a)
6930      WHERE t1.rowid >= 2147483647 ORDER BY t2.a
6935     SELECT t2.a FROM t2 NATURAL JOIN t1
6936      WHERE t1.rowid >= 2147483647 ORDER BY t1.a DESC
6941     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6942      WHERE t2.a=20
6948     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6949      WHERE t2.a=20
6955     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6956      WHERE t2.a=20
6962     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6963      WHERE t2.a=20
6969     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6970      WHERE t2.a=20
6976     SELECT t2.a FROM t1 JOIN t2 USING(a)
6977      WHERE t1.rowid < 2147483647 ORDER BY t2.a
6982     SELECT t2.a FROM t2 NATURAL JOIN t1
6983      WHERE t1.rowid < 2147483647 ORDER BY t1.a DESC
6988     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6989      WHERE t2.a=20
6995     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6996      WHERE t2.a=20
7002     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7003      WHERE t2.a=20
7009     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7010      WHERE t2.a=20
7016     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7017      WHERE t2.a=20
7023     SELECT t2.a FROM t1 JOIN t2 USING(a)
7024      WHERE t1.rowid <= 2147483647 ORDER BY t2.a
7029     SELECT t2.a FROM t2 NATURAL JOIN t1
7030      WHERE t1.rowid <= 2147483647 ORDER BY t1.a DESC
7035     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7036      WHERE t2.a=20
7042     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7043      WHERE t2.a=20
7049     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7050      WHERE t2.a=20
7056     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7057      WHERE t2.a=20
7063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7064      WHERE t2.a=20
7070     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-129 AND t2.a=t1.a
7075     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffffff7f'
7080     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=54
7085     SELECT t2.a FROM t1 JOIN t2 USING(a)
7086      WHERE t1.rowid > -129 ORDER BY t2.a
7091     SELECT t2.a FROM t2 NATURAL JOIN t1
7092      WHERE t1.rowid > -129 ORDER BY t1.a DESC
7097     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7098      WHERE t2.a=54
7104     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7105      WHERE t2.a=54
7111     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7112      WHERE t2.a=54
7118     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7119      WHERE t2.a=54
7125     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7126      WHERE t2.a=54
7132     SELECT t2.a FROM t1 JOIN t2 USING(a)
7133      WHERE t1.rowid >= -129 ORDER BY t2.a
7138     SELECT t2.a FROM t2 NATURAL JOIN t1
7139      WHERE t1.rowid >= -129 ORDER BY t1.a DESC
7144     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7145      WHERE t2.a=54
7151     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7152      WHERE t2.a=54
7158     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7159      WHERE t2.a=54
7165     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7166      WHERE t2.a=54
7172     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7173      WHERE t2.a=54
7179     SELECT t2.a FROM t1 JOIN t2 USING(a)
7180      WHERE t1.rowid < -129 ORDER BY t2.a
7185     SELECT t2.a FROM t2 NATURAL JOIN t1
7186      WHERE t1.rowid < -129 ORDER BY t1.a DESC
7191     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7192      WHERE t2.a=54
7198     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7199      WHERE t2.a=54
7205     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7206      WHERE t2.a=54
7212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7213      WHERE t2.a=54
7219     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7220      WHERE t2.a=54
7226     SELECT t2.a FROM t1 JOIN t2 USING(a)
7227      WHERE t1.rowid <= -129 ORDER BY t2.a
7232     SELECT t2.a FROM t2 NATURAL JOIN t1
7233      WHERE t1.rowid <= -129 ORDER BY t1.a DESC
7238     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7239      WHERE t2.a=54
7245     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7246      WHERE t2.a=54
7252     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7253      WHERE t2.a=54
7259     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7260      WHERE t2.a=54
7266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7267      WHERE t2.a=54
7273     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-128 AND t2.a=t1.a
7278     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffffff80'
7283     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=53
7288     SELECT t2.a FROM t1 JOIN t2 USING(a)
7289      WHERE t1.rowid > -128 ORDER BY t2.a
7294     SELECT t2.a FROM t2 NATURAL JOIN t1
7295      WHERE t1.rowid > -128 ORDER BY t1.a DESC
7300     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7301      WHERE t2.a=53
7307     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7308      WHERE t2.a=53
7314     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7315      WHERE t2.a=53
7321     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7322      WHERE t2.a=53
7328     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7329      WHERE t2.a=53
7335     SELECT t2.a FROM t1 JOIN t2 USING(a)
7336      WHERE t1.rowid >= -128 ORDER BY t2.a
7341     SELECT t2.a FROM t2 NATURAL JOIN t1
7342      WHERE t1.rowid >= -128 ORDER BY t1.a DESC
7347     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7348      WHERE t2.a=53
7354     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7355      WHERE t2.a=53
7361     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7362      WHERE t2.a=53
7368     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7369      WHERE t2.a=53
7375     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7376      WHERE t2.a=53
7382     SELECT t2.a FROM t1 JOIN t2 USING(a)
7383      WHERE t1.rowid < -128 ORDER BY t2.a
7388     SELECT t2.a FROM t2 NATURAL JOIN t1
7389      WHERE t1.rowid < -128 ORDER BY t1.a DESC
7394     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7395      WHERE t2.a=53
7401     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7402      WHERE t2.a=53
7408     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7409      WHERE t2.a=53
7415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7416      WHERE t2.a=53
7422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7423      WHERE t2.a=53
7429     SELECT t2.a FROM t1 JOIN t2 USING(a)
7430      WHERE t1.rowid <= -128 ORDER BY t2.a
7435     SELECT t2.a FROM t2 NATURAL JOIN t1
7436      WHERE t1.rowid <= -128 ORDER BY t1.a DESC
7441     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7442      WHERE t2.a=53
7448     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7449      WHERE t2.a=53
7455     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7456      WHERE t2.a=53
7462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7463      WHERE t2.a=53
7469     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7470      WHERE t2.a=53
7476     SELECT t1.* FROM t1, t2 WHERE t1.rowid=72057594037927936 AND t2.a=t1.a
7481     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0100000000000000'
7486     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=28
7491     SELECT t2.a FROM t1 JOIN t2 USING(a)
7492      WHERE t1.rowid > 72057594037927936 ORDER BY t2.a
7497     SELECT t2.a FROM t2 NATURAL JOIN t1
7498      WHERE t1.rowid > 72057594037927936 ORDER BY t1.a DESC
7503     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7504      WHERE t2.a=28
7510     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7511      WHERE t2.a=28
7517     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7518      WHERE t2.a=28
7524     SELECT t2.a FROM t1 JOIN t2 USING(a)
7525      WHERE t1.rowid >= 72057594037927936 ORDER BY t2.a
7530     SELECT t2.a FROM t2 NATURAL JOIN t1
7531      WHERE t1.rowid >= 72057594037927936 ORDER BY t1.a DESC
7536     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7537      WHERE t2.a=28
7543     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7544      WHERE t2.a=28
7550     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7551      WHERE t2.a=28
7557     SELECT t2.a FROM t1 JOIN t2 USING(a)
7558      WHERE t1.rowid < 72057594037927936 ORDER BY t2.a
7563     SELECT t2.a FROM t2 NATURAL JOIN t1
7564      WHERE t1.rowid < 72057594037927936 ORDER BY t1.a DESC
7569     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7570      WHERE t2.a=28
7576     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7577      WHERE t2.a=28
7583     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7584      WHERE t2.a=28
7590     SELECT t2.a FROM t1 JOIN t2 USING(a)
7591      WHERE t1.rowid <= 72057594037927936 ORDER BY t2.a
7596     SELECT t2.a FROM t2 NATURAL JOIN t1
7597      WHERE t1.rowid <= 72057594037927936 ORDER BY t1.a DESC
7602     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7603      WHERE t2.a=28
7609     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7610      WHERE t2.a=28
7616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7617      WHERE t2.a=28
7623     SELECT t1.* FROM t1, t2 WHERE t1.rowid=2147483648 AND t2.a=t1.a
7628     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000080000000'
7633     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=51
7638     SELECT t2.a FROM t1 JOIN t2 USING(a)
7639      WHERE t1.rowid > 2147483648 ORDER BY t2.a
7644     SELECT t2.a FROM t2 NATURAL JOIN t1
7645      WHERE t1.rowid > 2147483648 ORDER BY t1.a DESC
7650     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7651      WHERE t2.a=51
7657     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7658      WHERE t2.a=51
7664     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7665      WHERE t2.a=51
7671     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7672      WHERE t2.a=51
7678     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7679      WHERE t2.a=51
7685     SELECT t2.a FROM t1 JOIN t2 USING(a)
7686      WHERE t1.rowid >= 2147483648 ORDER BY t2.a
7691     SELECT t2.a FROM t2 NATURAL JOIN t1
7692      WHERE t1.rowid >= 2147483648 ORDER BY t1.a DESC
7697     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7698      WHERE t2.a=51
7704     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7705      WHERE t2.a=51
7711     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7712      WHERE t2.a=51
7718     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7719      WHERE t2.a=51
7725     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7726      WHERE t2.a=51
7732     SELECT t2.a FROM t1 JOIN t2 USING(a)
7733      WHERE t1.rowid < 2147483648 ORDER BY t2.a
7738     SELECT t2.a FROM t2 NATURAL JOIN t1
7739      WHERE t1.rowid < 2147483648 ORDER BY t1.a DESC
7744     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7745      WHERE t2.a=51
7751     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7752      WHERE t2.a=51
7758     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7759      WHERE t2.a=51
7765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7766      WHERE t2.a=51
7772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7773      WHERE t2.a=51
7779     SELECT t2.a FROM t1 JOIN t2 USING(a)
7780      WHERE t1.rowid <= 2147483648 ORDER BY t2.a
7785     SELECT t2.a FROM t2 NATURAL JOIN t1
7786      WHERE t1.rowid <= 2147483648 ORDER BY t1.a DESC
7791     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7792      WHERE t2.a=51
7798     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7799      WHERE t2.a=51
7805     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7806      WHERE t2.a=51
7812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7813      WHERE t2.a=51
7819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7820      WHERE t2.a=51
7826     SELECT t1.* FROM t1, t2 WHERE t1.rowid=549755813887 AND t2.a=t1.a
7831     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000007fffffffff'
7836     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=46
7841     SELECT t2.a FROM t1 JOIN t2 USING(a)
7842      WHERE t1.rowid > 549755813887 ORDER BY t2.a
7847     SELECT t2.a FROM t2 NATURAL JOIN t1
7848      WHERE t1.rowid > 549755813887 ORDER BY t1.a DESC
7853     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7854      WHERE t2.a=46
7860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7861      WHERE t2.a=46
7867     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7868      WHERE t2.a=46
7874     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7875      WHERE t2.a=46
7881     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7882      WHERE t2.a=46
7888     SELECT t2.a FROM t1 JOIN t2 USING(a)
7889      WHERE t1.rowid >= 549755813887 ORDER BY t2.a
7894     SELECT t2.a FROM t2 NATURAL JOIN t1
7895      WHERE t1.rowid >= 549755813887 ORDER BY t1.a DESC
7900     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7901      WHERE t2.a=46
7907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7908      WHERE t2.a=46
7914     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7915      WHERE t2.a=46
7921     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7922      WHERE t2.a=46
7928     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7929      WHERE t2.a=46
7935     SELECT t2.a FROM t1 JOIN t2 USING(a)
7936      WHERE t1.rowid < 549755813887 ORDER BY t2.a
7941     SELECT t2.a FROM t2 NATURAL JOIN t1
7942      WHERE t1.rowid < 549755813887 ORDER BY t1.a DESC
7947     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7948      WHERE t2.a=46
7954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7955      WHERE t2.a=46
7961     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7962      WHERE t2.a=46
7968     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7969      WHERE t2.a=46
7975     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7976      WHERE t2.a=46
7982     SELECT t2.a FROM t1 JOIN t2 USING(a)
7983      WHERE t1.rowid <= 549755813887 ORDER BY t2.a
7988     SELECT t2.a FROM t2 NATURAL JOIN t1
7989      WHERE t1.rowid <= 549755813887 ORDER BY t1.a DESC
7994     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7995      WHERE t2.a=46
8001     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8002      WHERE t2.a=46
8008     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8009      WHERE t2.a=46
8015     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8016      WHERE t2.a=46
8022     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8023      WHERE t2.a=46
8029     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-549755813888 AND t2.a=t1.a
8034     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffff8000000000'
8039     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=63
8044     SELECT t2.a FROM t1 JOIN t2 USING(a)
8045      WHERE t1.rowid > -549755813888 ORDER BY t2.a
8050     SELECT t2.a FROM t2 NATURAL JOIN t1
8051      WHERE t1.rowid > -549755813888 ORDER BY t1.a DESC
8056     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8057      WHERE t2.a=63
8063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8064      WHERE t2.a=63
8070     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8071      WHERE t2.a=63
8077     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8078      WHERE t2.a=63
8084     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8085      WHERE t2.a=63
8091     SELECT t2.a FROM t1 JOIN t2 USING(a)
8092      WHERE t1.rowid >= -549755813888 ORDER BY t2.a
8097     SELECT t2.a FROM t2 NATURAL JOIN t1
8098      WHERE t1.rowid >= -549755813888 ORDER BY t1.a DESC
8103     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8104      WHERE t2.a=63
8110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8111      WHERE t2.a=63
8117     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8118      WHERE t2.a=63
8124     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8125      WHERE t2.a=63
8131     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8132      WHERE t2.a=63
8138     SELECT t2.a FROM t1 JOIN t2 USING(a)
8139      WHERE t1.rowid < -549755813888 ORDER BY t2.a
8144     SELECT t2.a FROM t2 NATURAL JOIN t1
8145      WHERE t1.rowid < -549755813888 ORDER BY t1.a DESC
8150     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8151      WHERE t2.a=63
8157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8158      WHERE t2.a=63
8164     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8165      WHERE t2.a=63
8171     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8172      WHERE t2.a=63
8178     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8179      WHERE t2.a=63
8185     SELECT t2.a FROM t1 JOIN t2 USING(a)
8186      WHERE t1.rowid <= -549755813888 ORDER BY t2.a
8191     SELECT t2.a FROM t2 NATURAL JOIN t1
8192      WHERE t1.rowid <= -549755813888 ORDER BY t1.a DESC
8197     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8198      WHERE t2.a=63
8204     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8205      WHERE t2.a=63
8211     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8212      WHERE t2.a=63
8218     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8219      WHERE t2.a=63
8225     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8226      WHERE t2.a=63
8232     SELECT t1.* FROM t1, t2 WHERE t1.rowid=281474976710655 AND t2.a=t1.a
8237     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000ffffffffffff'
8242     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=10
8247     SELECT t2.a FROM t1 JOIN t2 USING(a)
8248      WHERE t1.rowid > 281474976710655 ORDER BY t2.a
8253     SELECT t2.a FROM t2 NATURAL JOIN t1
8254      WHERE t1.rowid > 281474976710655 ORDER BY t1.a DESC
8259     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8260      WHERE t2.a=10
8266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8267      WHERE t2.a=10
8273     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8274      WHERE t2.a=10
8280     SELECT t2.a FROM t1 JOIN t2 USING(a)
8281      WHERE t1.rowid >= 281474976710655 ORDER BY t2.a
8286     SELECT t2.a FROM t2 NATURAL JOIN t1
8287      WHERE t1.rowid >= 281474976710655 ORDER BY t1.a DESC
8292     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8293      WHERE t2.a=10
8299     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8300      WHERE t2.a=10
8306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8307      WHERE t2.a=10
8313     SELECT t2.a FROM t1 JOIN t2 USING(a)
8314      WHERE t1.rowid < 281474976710655 ORDER BY t2.a
8319     SELECT t2.a FROM t2 NATURAL JOIN t1
8320      WHERE t1.rowid < 281474976710655 ORDER BY t1.a DESC
8325     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8326      WHERE t2.a=10
8332     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8333      WHERE t2.a=10
8339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8340      WHERE t2.a=10
8346     SELECT t2.a FROM t1 JOIN t2 USING(a)
8347      WHERE t1.rowid <= 281474976710655 ORDER BY t2.a
8352     SELECT t2.a FROM t2 NATURAL JOIN t1
8353      WHERE t1.rowid <= 281474976710655 ORDER BY t1.a DESC
8358     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8359      WHERE t2.a=10
8365     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8366      WHERE t2.a=10
8372     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8373      WHERE t2.a=10
8379     SELECT t1.* FROM t1, t2 WHERE t1.rowid=4398046511103 AND t2.a=t1.a
8384     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000003ffffffffff'
8389     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=7
8394     SELECT t2.a FROM t1 JOIN t2 USING(a)
8395      WHERE t1.rowid > 4398046511103 ORDER BY t2.a
8400     SELECT t2.a FROM t2 NATURAL JOIN t1
8401      WHERE t1.rowid > 4398046511103 ORDER BY t1.a DESC
8406     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8407      WHERE t2.a=7
8413     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8414      WHERE t2.a=7
8420     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8421      WHERE t2.a=7
8427     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8428      WHERE t2.a=7
8434     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8435      WHERE t2.a=7
8441     SELECT t2.a FROM t1 JOIN t2 USING(a)
8442      WHERE t1.rowid >= 4398046511103 ORDER BY t2.a
8447     SELECT t2.a FROM t2 NATURAL JOIN t1
8448      WHERE t1.rowid >= 4398046511103 ORDER BY t1.a DESC
8453     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8454      WHERE t2.a=7
8460     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8461      WHERE t2.a=7
8467     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8468      WHERE t2.a=7
8474     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8475      WHERE t2.a=7
8481     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8482      WHERE t2.a=7
8488     SELECT t2.a FROM t1 JOIN t2 USING(a)
8489      WHERE t1.rowid < 4398046511103 ORDER BY t2.a
8494     SELECT t2.a FROM t2 NATURAL JOIN t1
8495      WHERE t1.rowid < 4398046511103 ORDER BY t1.a DESC
8500     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8501      WHERE t2.a=7
8507     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8508      WHERE t2.a=7
8514     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8515      WHERE t2.a=7
8521     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8522      WHERE t2.a=7
8528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8529      WHERE t2.a=7
8535     SELECT t2.a FROM t1 JOIN t2 USING(a)
8536      WHERE t1.rowid <= 4398046511103 ORDER BY t2.a
8541     SELECT t2.a FROM t2 NATURAL JOIN t1
8542      WHERE t1.rowid <= 4398046511103 ORDER BY t1.a DESC
8547     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8548      WHERE t2.a=7
8554     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8555      WHERE t2.a=7
8561     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8562      WHERE t2.a=7
8568     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8569      WHERE t2.a=7
8575     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8576      WHERE t2.a=7
8582     SELECT t1.* FROM t1, t2 WHERE t1.rowid=268435455 AND t2.a=t1.a
8587     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000000000fffffff'
8592     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=12
8597     SELECT t2.a FROM t1 JOIN t2 USING(a)
8598      WHERE t1.rowid > 268435455 ORDER BY t2.a
8603     SELECT t2.a FROM t2 NATURAL JOIN t1
8604      WHERE t1.rowid > 268435455 ORDER BY t1.a DESC
8609     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8610      WHERE t2.a=12
8616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8617      WHERE t2.a=12
8623     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8624      WHERE t2.a=12
8630     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8631      WHERE t2.a=12
8637     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8638      WHERE t2.a=12
8644     SELECT t2.a FROM t1 JOIN t2 USING(a)
8645      WHERE t1.rowid >= 268435455 ORDER BY t2.a
8650     SELECT t2.a FROM t2 NATURAL JOIN t1
8651      WHERE t1.rowid >= 268435455 ORDER BY t1.a DESC
8656     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8657      WHERE t2.a=12
8663     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8664      WHERE t2.a=12
8670     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8671      WHERE t2.a=12
8677     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8678      WHERE t2.a=12
8684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8685      WHERE t2.a=12
8691     SELECT t2.a FROM t1 JOIN t2 USING(a)
8692      WHERE t1.rowid < 268435455 ORDER BY t2.a
8697     SELECT t2.a FROM t2 NATURAL JOIN t1
8698      WHERE t1.rowid < 268435455 ORDER BY t1.a DESC
8703     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8704      WHERE t2.a=12
8710     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8711      WHERE t2.a=12
8717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8718      WHERE t2.a=12
8724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8725      WHERE t2.a=12
8731     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8732      WHERE t2.a=12
8738     SELECT t2.a FROM t1 JOIN t2 USING(a)
8739      WHERE t1.rowid <= 268435455 ORDER BY t2.a
8744     SELECT t2.a FROM t2 NATURAL JOIN t1
8745      WHERE t1.rowid <= 268435455 ORDER BY t1.a DESC
8750     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8751      WHERE t2.a=12
8757     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8758      WHERE t2.a=12
8764     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8765      WHERE t2.a=12
8771     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8772      WHERE t2.a=12
8778     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8779      WHERE t2.a=12
8785     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-9223372036854775808 AND t2.a=t1.a
8790     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='8000000000000000'
8795     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=55
8800     SELECT t2.a FROM t1 JOIN t2 USING(a)
8801      WHERE t1.rowid > -9223372036854775808 ORDER BY t2.a
8806     SELECT t2.a FROM t2 NATURAL JOIN t1
8807      WHERE t1.rowid > -9223372036854775808 ORDER BY t1.a DESC
8812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8813      WHERE t2.a=55
8819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8820      WHERE t2.a=55
8826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8827      WHERE t2.a=55
8833     SELECT t2.a FROM t1 JOIN t2 USING(a)
8834      WHERE t1.rowid >= -9223372036854775808 ORDER BY t2.a
8839     SELECT t2.a FROM t2 NATURAL JOIN t1
8840      WHERE t1.rowid >= -9223372036854775808 ORDER BY t1.a DESC
8845     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8846      WHERE t2.a=55
8852     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8853      WHERE t2.a=55
8859     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8860      WHERE t2.a=55
8866     SELECT t2.a FROM t1 JOIN t2 USING(a)
8867      WHERE t1.rowid < -9223372036854775808 ORDER BY t2.a
8872     SELECT t2.a FROM t2 NATURAL JOIN t1
8873      WHERE t1.rowid < -9223372036854775808 ORDER BY t1.a DESC
8878     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8879      WHERE t2.a=55
8885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8886      WHERE t2.a=55
8892     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8893      WHERE t2.a=55
8899     SELECT t2.a FROM t1 JOIN t2 USING(a)
8900      WHERE t1.rowid <= -9223372036854775808 ORDER BY t2.a
8905     SELECT t2.a FROM t2 NATURAL JOIN t1
8906      WHERE t1.rowid <= -9223372036854775808 ORDER BY t1.a DESC
8911     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8912      WHERE t2.a=55
8918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8919      WHERE t2.a=55
8925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8926      WHERE t2.a=55
8932     SELECT t1.* FROM t1, t2 WHERE t1.rowid=562949953421312 AND t2.a=t1.a
8937     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0002000000000000'
8942     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=43
8947     SELECT t2.a FROM t1 JOIN t2 USING(a)
8948      WHERE t1.rowid > 562949953421312 ORDER BY t2.a
8953     SELECT t2.a FROM t2 NATURAL JOIN t1
8954      WHERE t1.rowid > 562949953421312 ORDER BY t1.a DESC
8959     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8960      WHERE t2.a=43
8966     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8967      WHERE t2.a=43
8973     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8974      WHERE t2.a=43
8980     SELECT t2.a FROM t1 JOIN t2 USING(a)
8981      WHERE t1.rowid >= 562949953421312 ORDER BY t2.a
8986     SELECT t2.a FROM t2 NATURAL JOIN t1
8987      WHERE t1.rowid >= 562949953421312 ORDER BY t1.a DESC
8992     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8993      WHERE t2.a=43
8999     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9000      WHERE t2.a=43
9006     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9007      WHERE t2.a=43
9013     SELECT t2.a FROM t1 JOIN t2 USING(a)
9014      WHERE t1.rowid < 562949953421312 ORDER BY t2.a
9019     SELECT t2.a FROM t2 NATURAL JOIN t1
9020      WHERE t1.rowid < 562949953421312 ORDER BY t1.a DESC
9025     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9026      WHERE t2.a=43
9032     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9033      WHERE t2.a=43
9039     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9040      WHERE t2.a=43
9046     SELECT t2.a FROM t1 JOIN t2 USING(a)
9047      WHERE t1.rowid <= 562949953421312 ORDER BY t2.a
9052     SELECT t2.a FROM t2 NATURAL JOIN t1
9053      WHERE t1.rowid <= 562949953421312 ORDER BY t1.a DESC
9058     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9059      WHERE t2.a=43
9065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9066      WHERE t2.a=43
9072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9073      WHERE t2.a=43
9079     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-8388609 AND t2.a=t1.a
9084     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffff7fffff'
9089     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=1
9094     SELECT t2.a FROM t1 JOIN t2 USING(a)
9095      WHERE t1.rowid > -8388609 ORDER BY t2.a
9100     SELECT t2.a FROM t2 NATURAL JOIN t1
9101      WHERE t1.rowid > -8388609 ORDER BY t1.a DESC
9106     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9107      WHERE t2.a=1
9113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9114      WHERE t2.a=1
9120     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9121      WHERE t2.a=1
9127     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9128      WHERE t2.a=1
9134     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9135      WHERE t2.a=1
9141     SELECT t2.a FROM t1 JOIN t2 USING(a)
9142      WHERE t1.rowid >= -8388609 ORDER BY t2.a
9147     SELECT t2.a FROM t2 NATURAL JOIN t1
9148      WHERE t1.rowid >= -8388609 ORDER BY t1.a DESC
9153     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9154      WHERE t2.a=1
9160     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9161      WHERE t2.a=1
9167     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9168      WHERE t2.a=1
9174     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9175      WHERE t2.a=1
9181     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9182      WHERE t2.a=1
9188     SELECT t2.a FROM t1 JOIN t2 USING(a)
9189      WHERE t1.rowid < -8388609 ORDER BY t2.a
9194     SELECT t2.a FROM t2 NATURAL JOIN t1
9195      WHERE t1.rowid < -8388609 ORDER BY t1.a DESC
9200     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9201      WHERE t2.a=1
9207     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9208      WHERE t2.a=1
9214     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9215      WHERE t2.a=1
9221     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9222      WHERE t2.a=1
9228     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9229      WHERE t2.a=1
9235     SELECT t2.a FROM t1 JOIN t2 USING(a)
9236      WHERE t1.rowid <= -8388609 ORDER BY t2.a
9241     SELECT t2.a FROM t2 NATURAL JOIN t1
9242      WHERE t1.rowid <= -8388609 ORDER BY t1.a DESC
9247     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9248      WHERE t2.a=1
9254     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9255      WHERE t2.a=1
9261     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9262      WHERE t2.a=1
9268     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9269      WHERE t2.a=1
9275     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9276      WHERE t2.a=1
9282     SELECT t1.* FROM t1, t2 WHERE t1.rowid=16777215 AND t2.a=t1.a
9287     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000ffffff'
9292     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=9
9297     SELECT t2.a FROM t1 JOIN t2 USING(a)
9298      WHERE t1.rowid > 16777215 ORDER BY t2.a
9303     SELECT t2.a FROM t2 NATURAL JOIN t1
9304      WHERE t1.rowid > 16777215 ORDER BY t1.a DESC
9309     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9310      WHERE t2.a=9
9316     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9317      WHERE t2.a=9
9323     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9324      WHERE t2.a=9
9330     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9331      WHERE t2.a=9
9337     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9338      WHERE t2.a=9
9344     SELECT t2.a FROM t1 JOIN t2 USING(a)
9345      WHERE t1.rowid >= 16777215 ORDER BY t2.a
9350     SELECT t2.a FROM t2 NATURAL JOIN t1
9351      WHERE t1.rowid >= 16777215 ORDER BY t1.a DESC
9356     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9357      WHERE t2.a=9
9363     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9364      WHERE t2.a=9
9370     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9371      WHERE t2.a=9
9377     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9378      WHERE t2.a=9
9384     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9385      WHERE t2.a=9
9391     SELECT t2.a FROM t1 JOIN t2 USING(a)
9392      WHERE t1.rowid < 16777215 ORDER BY t2.a
9397     SELECT t2.a FROM t2 NATURAL JOIN t1
9398      WHERE t1.rowid < 16777215 ORDER BY t1.a DESC
9403     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9404      WHERE t2.a=9
9410     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9411      WHERE t2.a=9
9417     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9418      WHERE t2.a=9
9424     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9425      WHERE t2.a=9
9431     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9432      WHERE t2.a=9
9438     SELECT t2.a FROM t1 JOIN t2 USING(a)
9439      WHERE t1.rowid <= 16777215 ORDER BY t2.a
9444     SELECT t2.a FROM t2 NATURAL JOIN t1
9445      WHERE t1.rowid <= 16777215 ORDER BY t1.a DESC
9450     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9451      WHERE t2.a=9
9457     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9458      WHERE t2.a=9
9464     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9465      WHERE t2.a=9
9471     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9472      WHERE t2.a=9
9478     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9479      WHERE t2.a=9
9485     SELECT t1.* FROM t1, t2 WHERE t1.rowid=8388608 AND t2.a=t1.a
9490     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000800000'
9495     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=24
9500     SELECT t2.a FROM t1 JOIN t2 USING(a)
9501      WHERE t1.rowid > 8388608 ORDER BY t2.a
9506     SELECT t2.a FROM t2 NATURAL JOIN t1
9507      WHERE t1.rowid > 8388608 ORDER BY t1.a DESC
9512     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9513      WHERE t2.a=24
9519     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9520      WHERE t2.a=24
9526     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9527      WHERE t2.a=24
9533     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9534      WHERE t2.a=24
9540     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9541      WHERE t2.a=24
9547     SELECT t2.a FROM t1 JOIN t2 USING(a)
9548      WHERE t1.rowid >= 8388608 ORDER BY t2.a
9553     SELECT t2.a FROM t2 NATURAL JOIN t1
9554      WHERE t1.rowid >= 8388608 ORDER BY t1.a DESC
9559     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9560      WHERE t2.a=24
9566     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9567      WHERE t2.a=24
9573     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9574      WHERE t2.a=24
9580     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9581      WHERE t2.a=24
9587     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9588      WHERE t2.a=24
9594     SELECT t2.a FROM t1 JOIN t2 USING(a)
9595      WHERE t1.rowid < 8388608 ORDER BY t2.a
9600     SELECT t2.a FROM t2 NATURAL JOIN t1
9601      WHERE t1.rowid < 8388608 ORDER BY t1.a DESC
9606     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9607      WHERE t2.a=24
9613     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9614      WHERE t2.a=24
9620     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9621      WHERE t2.a=24
9627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9628      WHERE t2.a=24
9634     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9635      WHERE t2.a=24
9641     SELECT t2.a FROM t1 JOIN t2 USING(a)
9642      WHERE t1.rowid <= 8388608 ORDER BY t2.a
9647     SELECT t2.a FROM t2 NATURAL JOIN t1
9648      WHERE t1.rowid <= 8388608 ORDER BY t1.a DESC
9653     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9654      WHERE t2.a=24
9660     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9661      WHERE t2.a=24
9667     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9668      WHERE t2.a=24
9674     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9675      WHERE t2.a=24
9681     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9682      WHERE t2.a=24
9688     SELECT t1.* FROM t1, t2 WHERE t1.rowid=16383 AND t2.a=t1.a
9693     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000003fff'
9698     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=8
9703     SELECT t2.a FROM t1 JOIN t2 USING(a)
9704      WHERE t1.rowid > 16383 ORDER BY t2.a
9709     SELECT t2.a FROM t2 NATURAL JOIN t1
9710      WHERE t1.rowid > 16383 ORDER BY t1.a DESC
9715     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9716      WHERE t2.a=8
9722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9723      WHERE t2.a=8
9729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9730      WHERE t2.a=8
9736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9737      WHERE t2.a=8
9743     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9744      WHERE t2.a=8
9750     SELECT t2.a FROM t1 JOIN t2 USING(a)
9751      WHERE t1.rowid >= 16383 ORDER BY t2.a
9756     SELECT t2.a FROM t2 NATURAL JOIN t1
9757      WHERE t1.rowid >= 16383 ORDER BY t1.a DESC
9762     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9763      WHERE t2.a=8
9769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9770      WHERE t2.a=8
9776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9777      WHERE t2.a=8
9783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9784      WHERE t2.a=8
9790     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9791      WHERE t2.a=8
9797     SELECT t2.a FROM t1 JOIN t2 USING(a)
9798      WHERE t1.rowid < 16383 ORDER BY t2.a
9803     SELECT t2.a FROM t2 NATURAL JOIN t1
9804      WHERE t1.rowid < 16383 ORDER BY t1.a DESC
9809     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9810      WHERE t2.a=8
9816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9817      WHERE t2.a=8
9823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9824      WHERE t2.a=8
9830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9831      WHERE t2.a=8
9837     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9838      WHERE t2.a=8
9844     SELECT t2.a FROM t1 JOIN t2 USING(a)
9845      WHERE t1.rowid <= 16383 ORDER BY t2.a
9850     SELECT t2.a FROM t2 NATURAL JOIN t1
9851      WHERE t1.rowid <= 16383 ORDER BY t1.a DESC
9856     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9857      WHERE t2.a=8
9863     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9864      WHERE t2.a=8
9870     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9871      WHERE t2.a=8
9877     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9878      WHERE t2.a=8
9884     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9885      WHERE t2.a=8
9891     SELECT t1.* FROM t1, t2 WHERE t1.rowid=140737488355328 AND t2.a=t1.a
9896     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000800000000000'
9901     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=34
9906     SELECT t2.a FROM t1 JOIN t2 USING(a)
9907      WHERE t1.rowid > 140737488355328 ORDER BY t2.a
9912     SELECT t2.a FROM t2 NATURAL JOIN t1
9913      WHERE t1.rowid > 140737488355328 ORDER BY t1.a DESC
9918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9919      WHERE t2.a=34
9925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9926      WHERE t2.a=34
9932     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9933      WHERE t2.a=34
9939     SELECT t2.a FROM t1 JOIN t2 USING(a)
9940      WHERE t1.rowid >= 140737488355328 ORDER BY t2.a
9945     SELECT t2.a FROM t2 NATURAL JOIN t1
9946      WHERE t1.rowid >= 140737488355328 ORDER BY t1.a DESC
9951     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9952      WHERE t2.a=34
9958     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9959      WHERE t2.a=34
9965     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9966      WHERE t2.a=34
9972     SELECT t2.a FROM t1 JOIN t2 USING(a)
9973      WHERE t1.rowid < 140737488355328 ORDER BY t2.a
9978     SELECT t2.a FROM t2 NATURAL JOIN t1
9979      WHERE t1.rowid < 140737488355328 ORDER BY t1.a DESC
9984     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9985      WHERE t2.a=34
9991     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9992      WHERE t2.a=34
9998     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9999      WHERE t2.a=34
10005     SELECT t2.a FROM t1 JOIN t2 USING(a)
10006      WHERE t1.rowid <= 140737488355328 ORDER BY t2.a
10011     SELECT t2.a FROM t2 NATURAL JOIN t1
10012      WHERE t1.rowid <= 140737488355328 ORDER BY t1.a DESC
10017     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10018      WHERE t2.a=34
10024     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10025      WHERE t2.a=34
10031     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10032      WHERE t2.a=34
10038     SELECT t1.* FROM t1, t2 WHERE t1.rowid=2097151 AND t2.a=t1.a
10043     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00000000001fffff'
10048     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=15
10053     SELECT t2.a FROM t1 JOIN t2 USING(a)
10054      WHERE t1.rowid > 2097151 ORDER BY t2.a
10059     SELECT t2.a FROM t2 NATURAL JOIN t1
10060      WHERE t1.rowid > 2097151 ORDER BY t1.a DESC
10065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10066      WHERE t2.a=15
10072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10073      WHERE t2.a=15
10079     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10080      WHERE t2.a=15
10086     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10087      WHERE t2.a=15
10093     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10094      WHERE t2.a=15
10100     SELECT t2.a FROM t1 JOIN t2 USING(a)
10101      WHERE t1.rowid >= 2097151 ORDER BY t2.a
10106     SELECT t2.a FROM t2 NATURAL JOIN t1
10107      WHERE t1.rowid >= 2097151 ORDER BY t1.a DESC
10112     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10113      WHERE t2.a=15
10119     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10120      WHERE t2.a=15
10126     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10127      WHERE t2.a=15
10133     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10134      WHERE t2.a=15
10140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10141      WHERE t2.a=15
10147     SELECT t2.a FROM t1 JOIN t2 USING(a)
10148      WHERE t1.rowid < 2097151 ORDER BY t2.a
10153     SELECT t2.a FROM t2 NATURAL JOIN t1
10154      WHERE t1.rowid < 2097151 ORDER BY t1.a DESC
10159     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10160      WHERE t2.a=15
10166     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10167      WHERE t2.a=15
10173     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10174      WHERE t2.a=15
10180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10181      WHERE t2.a=15
10187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10188      WHERE t2.a=15
10194     SELECT t2.a FROM t1 JOIN t2 USING(a)
10195      WHERE t1.rowid <= 2097151 ORDER BY t2.a
10200     SELECT t2.a FROM t2 NATURAL JOIN t1
10201      WHERE t1.rowid <= 2097151 ORDER BY t1.a DESC
10206     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10207      WHERE t2.a=15
10213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10214      WHERE t2.a=15
10220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10221      WHERE t2.a=15
10227     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10228      WHERE t2.a=15
10234     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10235      WHERE t2.a=15
10241     SELECT t1.* FROM t1, t2 WHERE t1.rowid=140737488355327 AND t2.a=t1.a
10246     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00007fffffffffff'
10251     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=25
10256     SELECT t2.a FROM t1 JOIN t2 USING(a)
10257      WHERE t1.rowid > 140737488355327 ORDER BY t2.a
10262     SELECT t2.a FROM t2 NATURAL JOIN t1
10263      WHERE t1.rowid > 140737488355327 ORDER BY t1.a DESC
10268     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10269      WHERE t2.a=25
10275     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10276      WHERE t2.a=25
10282     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10283      WHERE t2.a=25
10289     SELECT t2.a FROM t1 JOIN t2 USING(a)
10290      WHERE t1.rowid >= 140737488355327 ORDER BY t2.a
10295     SELECT t2.a FROM t2 NATURAL JOIN t1
10296      WHERE t1.rowid >= 140737488355327 ORDER BY t1.a DESC
10301     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10302      WHERE t2.a=25
10308     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10309      WHERE t2.a=25
10315     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10316      WHERE t2.a=25
10322     SELECT t2.a FROM t1 JOIN t2 USING(a)
10323      WHERE t1.rowid < 140737488355327 ORDER BY t2.a
10328     SELECT t2.a FROM t2 NATURAL JOIN t1
10329      WHERE t1.rowid < 140737488355327 ORDER BY t1.a DESC
10334     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10335      WHERE t2.a=25
10341     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10342      WHERE t2.a=25
10348     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10349      WHERE t2.a=25
10355     SELECT t2.a FROM t1 JOIN t2 USING(a)
10356      WHERE t1.rowid <= 140737488355327 ORDER BY t2.a
10361     SELECT t2.a FROM t2 NATURAL JOIN t1
10362      WHERE t1.rowid <= 140737488355327 ORDER BY t1.a DESC
10367     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10368      WHERE t2.a=25
10374     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10375      WHERE t2.a=25
10381     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10382      WHERE t2.a=25
10388     SELECT t1.* FROM t1, t2 WHERE t1.rowid=281474976710656 AND t2.a=t1.a
10393     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0001000000000000'
10398     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=26
10403     SELECT t2.a FROM t1 JOIN t2 USING(a)
10404      WHERE t1.rowid > 281474976710656 ORDER BY t2.a
10409     SELECT t2.a FROM t2 NATURAL JOIN t1
10410      WHERE t1.rowid > 281474976710656 ORDER BY t1.a DESC
10415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10416      WHERE t2.a=26
10422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10423      WHERE t2.a=26
10429     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10430      WHERE t2.a=26
10436     SELECT t2.a FROM t1 JOIN t2 USING(a)
10437      WHERE t1.rowid >= 281474976710656 ORDER BY t2.a
10442     SELECT t2.a FROM t2 NATURAL JOIN t1
10443      WHERE t1.rowid >= 281474976710656 ORDER BY t1.a DESC
10448     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10449      WHERE t2.a=26
10455     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10456      WHERE t2.a=26
10462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10463      WHERE t2.a=26
10469     SELECT t2.a FROM t1 JOIN t2 USING(a)
10470      WHERE t1.rowid < 281474976710656 ORDER BY t2.a
10475     SELECT t2.a FROM t2 NATURAL JOIN t1
10476      WHERE t1.rowid < 281474976710656 ORDER BY t1.a DESC
10481     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10482      WHERE t2.a=26
10488     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10489      WHERE t2.a=26
10495     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10496      WHERE t2.a=26
10502     SELECT t2.a FROM t1 JOIN t2 USING(a)
10503      WHERE t1.rowid <= 281474976710656 ORDER BY t2.a
10508     SELECT t2.a FROM t2 NATURAL JOIN t1
10509      WHERE t1.rowid <= 281474976710656 ORDER BY t1.a DESC
10514     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10515      WHERE t2.a=26
10521     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10522      WHERE t2.a=26
10528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10529      WHERE t2.a=26
10535     SELECT t1.* FROM t1, t2 WHERE t1.rowid=32767 AND t2.a=t1.a
10540     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000007fff'
10545     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=23
10550     SELECT t2.a FROM t1 JOIN t2 USING(a)
10551      WHERE t1.rowid > 32767 ORDER BY t2.a
10556     SELECT t2.a FROM t2 NATURAL JOIN t1
10557      WHERE t1.rowid > 32767 ORDER BY t1.a DESC
10562     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10563      WHERE t2.a=23
10569     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10570      WHERE t2.a=23
10576     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10577      WHERE t2.a=23
10583     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10584      WHERE t2.a=23
10590     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10591      WHERE t2.a=23
10597     SELECT t2.a FROM t1 JOIN t2 USING(a)
10598      WHERE t1.rowid >= 32767 ORDER BY t2.a
10603     SELECT t2.a FROM t2 NATURAL JOIN t1
10604      WHERE t1.rowid >= 32767 ORDER BY t1.a DESC
10609     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10610      WHERE t2.a=23
10616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10617      WHERE t2.a=23
10623     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10624      WHERE t2.a=23
10630     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10631      WHERE t2.a=23
10637     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10638      WHERE t2.a=23
10644     SELECT t2.a FROM t1 JOIN t2 USING(a)
10645      WHERE t1.rowid < 32767 ORDER BY t2.a
10650     SELECT t2.a FROM t2 NATURAL JOIN t1
10651      WHERE t1.rowid < 32767 ORDER BY t1.a DESC
10656     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10657      WHERE t2.a=23
10663     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10664      WHERE t2.a=23
10670     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10671      WHERE t2.a=23
10677     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10678      WHERE t2.a=23
10684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10685      WHERE t2.a=23
10691     SELECT t2.a FROM t1 JOIN t2 USING(a)
10692      WHERE t1.rowid <= 32767 ORDER BY t2.a
10697     SELECT t2.a FROM t2 NATURAL JOIN t1
10698      WHERE t1.rowid <= 32767 ORDER BY t1.a DESC
10703     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10704      WHERE t2.a=23
10710     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10711      WHERE t2.a=23
10717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10718      WHERE t2.a=23
10724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10725      WHERE t2.a=23
10731     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10732      WHERE t2.a=23
10738     SELECT t1.* FROM t1, t2 WHERE t1.rowid=127 AND t2.a=t1.a
10743     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='000000000000007f'
10748     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=4
10753     SELECT t2.a FROM t1 JOIN t2 USING(a)
10754      WHERE t1.rowid > 127 ORDER BY t2.a
10759     SELECT t2.a FROM t2 NATURAL JOIN t1
10760      WHERE t1.rowid > 127 ORDER BY t1.a DESC
10765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10766      WHERE t2.a=4
10772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10773      WHERE t2.a=4
10779     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10780      WHERE t2.a=4
10786     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10787      WHERE t2.a=4
10793     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10794      WHERE t2.a=4
10800     SELECT t2.a FROM t1 JOIN t2 USING(a)
10801      WHERE t1.rowid >= 127 ORDER BY t2.a
10806     SELECT t2.a FROM t2 NATURAL JOIN t1
10807      WHERE t1.rowid >= 127 ORDER BY t1.a DESC
10812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10813      WHERE t2.a=4
10819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10820      WHERE t2.a=4
10826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10827      WHERE t2.a=4
10833     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10834      WHERE t2.a=4
10840     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10841      WHERE t2.a=4
10847     SELECT t2.a FROM t1 JOIN t2 USING(a)
10848      WHERE t1.rowid < 127 ORDER BY t2.a
10853     SELECT t2.a FROM t2 NATURAL JOIN t1
10854      WHERE t1.rowid < 127 ORDER BY t1.a DESC
10859     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10860      WHERE t2.a=4
10866     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10867      WHERE t2.a=4
10873     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10874      WHERE t2.a=4
10880     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10881      WHERE t2.a=4
10887     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10888      WHERE t2.a=4
10894     SELECT t2.a FROM t1 JOIN t2 USING(a)
10895      WHERE t1.rowid <= 127 ORDER BY t2.a
10900     SELECT t2.a FROM t2 NATURAL JOIN t1
10901      WHERE t1.rowid <= 127 ORDER BY t1.a DESC
10906     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10907      WHERE t2.a=4
10913     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10914      WHERE t2.a=4
10920     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10921      WHERE t2.a=4
10927     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10928      WHERE t2.a=4
10934     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10935      WHERE t2.a=4
10941     SELECT t1.* FROM t1, t2 WHERE t1.rowid=36028797018963967 AND t2.a=t1.a
10946     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='007fffffffffffff'
10951     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=27
10956     SELECT t2.a FROM t1 JOIN t2 USING(a)
10957      WHERE t1.rowid > 36028797018963967 ORDER BY t2.a
10962     SELECT t2.a FROM t2 NATURAL JOIN t1
10963      WHERE t1.rowid > 36028797018963967 ORDER BY t1.a DESC
10968     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10969      WHERE t2.a=27
10975     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10976      WHERE t2.a=27
10982     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10983      WHERE t2.a=27
10989     SELECT t2.a FROM t1 JOIN t2 USING(a)
10990      WHERE t1.rowid >= 36028797018963967 ORDER BY t2.a
10995     SELECT t2.a FROM t2 NATURAL JOIN t1
10996      WHERE t1.rowid >= 36028797018963967 ORDER BY t1.a DESC
11001     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11002      WHERE t2.a=27
11008     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11009      WHERE t2.a=27
11015     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11016      WHERE t2.a=27
11022     SELECT t2.a FROM t1 JOIN t2 USING(a)
11023      WHERE t1.rowid < 36028797018963967 ORDER BY t2.a
11028     SELECT t2.a FROM t2 NATURAL JOIN t1
11029      WHERE t1.rowid < 36028797018963967 ORDER BY t1.a DESC
11034     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11035      WHERE t2.a=27
11041     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11042      WHERE t2.a=27
11048     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11049      WHERE t2.a=27
11055     SELECT t2.a FROM t1 JOIN t2 USING(a)
11056      WHERE t1.rowid <= 36028797018963967 ORDER BY t2.a
11061     SELECT t2.a FROM t2 NATURAL JOIN t1
11062      WHERE t1.rowid <= 36028797018963967 ORDER BY t1.a DESC
11067     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11068      WHERE t2.a=27
11074     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11075      WHERE t2.a=27
11081     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11082      WHERE t2.a=27
11088     SELECT t1.* FROM t1, t2 WHERE t1.rowid=4398046511104 AND t2.a=t1.a
11093     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000040000000000'
11098     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=56
11103     SELECT t2.a FROM t1 JOIN t2 USING(a)
11104      WHERE t1.rowid > 4398046511104 ORDER BY t2.a
11109     SELECT t2.a FROM t2 NATURAL JOIN t1
11110      WHERE t1.rowid > 4398046511104 ORDER BY t1.a DESC
11115     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11116      WHERE t2.a=56
11122     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11123      WHERE t2.a=56
11129     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11130      WHERE t2.a=56
11136     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11137      WHERE t2.a=56
11143     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11144      WHERE t2.a=56
11150     SELECT t2.a FROM t1 JOIN t2 USING(a)
11151      WHERE t1.rowid >= 4398046511104 ORDER BY t2.a
11156     SELECT t2.a FROM t2 NATURAL JOIN t1
11157      WHERE t1.rowid >= 4398046511104 ORDER BY t1.a DESC
11162     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11163      WHERE t2.a=56
11169     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11170      WHERE t2.a=56
11176     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11177      WHERE t2.a=56
11183     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11184      WHERE t2.a=56
11190     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11191      WHERE t2.a=56
11197     SELECT t2.a FROM t1 JOIN t2 USING(a)
11198      WHERE t1.rowid < 4398046511104 ORDER BY t2.a
11203     SELECT t2.a FROM t2 NATURAL JOIN t1
11204      WHERE t1.rowid < 4398046511104 ORDER BY t1.a DESC
11209     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11210      WHERE t2.a=56
11216     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11217      WHERE t2.a=56
11223     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11224      WHERE t2.a=56
11230     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11231      WHERE t2.a=56
11237     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11238      WHERE t2.a=56
11244     SELECT t2.a FROM t1 JOIN t2 USING(a)
11245      WHERE t1.rowid <= 4398046511104 ORDER BY t2.a
11250     SELECT t2.a FROM t2 NATURAL JOIN t1
11251      WHERE t1.rowid <= 4398046511104 ORDER BY t1.a DESC
11256     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11257      WHERE t2.a=56
11263     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11264      WHERE t2.a=56
11270     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11271      WHERE t2.a=56
11277     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11278      WHERE t2.a=56
11284     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11285      WHERE t2.a=56
11291     SELECT t1.* FROM t1, t2 WHERE t1.rowid=1 AND t2.a=t1.a
11296     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000001'
11301     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=60
11306     SELECT t2.a FROM t1 JOIN t2 USING(a)
11307      WHERE t1.rowid > 1 ORDER BY t2.a
11312     SELECT t2.a FROM t2 NATURAL JOIN t1
11313      WHERE t1.rowid > 1 ORDER BY t1.a DESC
11318     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11319      WHERE t2.a=60
11325     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11326      WHERE t2.a=60
11332     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11333      WHERE t2.a=60
11339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11340      WHERE t2.a=60
11346     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11347      WHERE t2.a=60
11353     SELECT t2.a FROM t1 JOIN t2 USING(a)
11354      WHERE t1.rowid >= 1 ORDER BY t2.a
11359     SELECT t2.a FROM t2 NATURAL JOIN t1
11360      WHERE t1.rowid >= 1 ORDER BY t1.a DESC
11365     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11366      WHERE t2.a=60
11372     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11373      WHERE t2.a=60
11379     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11380      WHERE t2.a=60
11386     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11387      WHERE t2.a=60
11393     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11394      WHERE t2.a=60
11400     SELECT t2.a FROM t1 JOIN t2 USING(a)
11401      WHERE t1.rowid < 1 ORDER BY t2.a
11406     SELECT t2.a FROM t2 NATURAL JOIN t1
11407      WHERE t1.rowid < 1 ORDER BY t1.a DESC
11412     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11413      WHERE t2.a=60
11419     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11420      WHERE t2.a=60
11426     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11427      WHERE t2.a=60
11433     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11434      WHERE t2.a=60
11440     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11441      WHERE t2.a=60
11447     SELECT t2.a FROM t1 JOIN t2 USING(a)
11448      WHERE t1.rowid <= 1 ORDER BY t2.a
11453     SELECT t2.a FROM t2 NATURAL JOIN t1
11454      WHERE t1.rowid <= 1 ORDER BY t1.a DESC
11459     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11460      WHERE t2.a=60
11466     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11467      WHERE t2.a=60
11473     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11474      WHERE t2.a=60
11480     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11481      WHERE t2.a=60
11487     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11488      WHERE t2.a=60
11494     SELECT t1.* FROM t1, t2 WHERE t1.rowid=36028797018963968 AND t2.a=t1.a
11499     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0080000000000000'
11504     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=45
11509     SELECT t2.a FROM t1 JOIN t2 USING(a)
11510      WHERE t1.rowid > 36028797018963968 ORDER BY t2.a
11515     SELECT t2.a FROM t2 NATURAL JOIN t1
11516      WHERE t1.rowid > 36028797018963968 ORDER BY t1.a DESC
11521     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11522      WHERE t2.a=45
11528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11529      WHERE t2.a=45
11535     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11536      WHERE t2.a=45
11542     SELECT t2.a FROM t1 JOIN t2 USING(a)
11543      WHERE t1.rowid >= 36028797018963968 ORDER BY t2.a
11548     SELECT t2.a FROM t2 NATURAL JOIN t1
11549      WHERE t1.rowid >= 36028797018963968 ORDER BY t1.a DESC
11554     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11555      WHERE t2.a=45
11561     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11562      WHERE t2.a=45
11568     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11569      WHERE t2.a=45
11575     SELECT t2.a FROM t1 JOIN t2 USING(a)
11576      WHERE t1.rowid < 36028797018963968 ORDER BY t2.a
11581     SELECT t2.a FROM t2 NATURAL JOIN t1
11582      WHERE t1.rowid < 36028797018963968 ORDER BY t1.a DESC
11587     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11588      WHERE t2.a=45
11594     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11595      WHERE t2.a=45
11601     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11602      WHERE t2.a=45
11608     SELECT t2.a FROM t1 JOIN t2 USING(a)
11609      WHERE t1.rowid <= 36028797018963968 ORDER BY t2.a
11614     SELECT t2.a FROM t2 NATURAL JOIN t1
11615      WHERE t1.rowid <= 36028797018963968 ORDER BY t1.a DESC
11620     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11621      WHERE t2.a=45
11627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11628      WHERE t2.a=45
11634     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11635      WHERE t2.a=45
11641     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-2147483649 AND t2.a=t1.a
11646     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffff7fffffff'
11651     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=47
11656     SELECT t2.a FROM t1 JOIN t2 USING(a)
11657      WHERE t1.rowid > -2147483649 ORDER BY t2.a
11662     SELECT t2.a FROM t2 NATURAL JOIN t1
11663      WHERE t1.rowid > -2147483649 ORDER BY t1.a DESC
11668     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11669      WHERE t2.a=47
11675     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11676      WHERE t2.a=47
11682     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11683      WHERE t2.a=47
11689     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11690      WHERE t2.a=47
11696     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11697      WHERE t2.a=47
11703     SELECT t2.a FROM t1 JOIN t2 USING(a)
11704      WHERE t1.rowid >= -2147483649 ORDER BY t2.a
11709     SELECT t2.a FROM t2 NATURAL JOIN t1
11710      WHERE t1.rowid >= -2147483649 ORDER BY t1.a DESC
11715     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11716      WHERE t2.a=47
11722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11723      WHERE t2.a=47
11729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11730      WHERE t2.a=47
11736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11737      WHERE t2.a=47
11743     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11744      WHERE t2.a=47
11750     SELECT t2.a FROM t1 JOIN t2 USING(a)
11751      WHERE t1.rowid < -2147483649 ORDER BY t2.a
11756     SELECT t2.a FROM t2 NATURAL JOIN t1
11757      WHERE t1.rowid < -2147483649 ORDER BY t1.a DESC
11762     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11763      WHERE t2.a=47
11769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11770      WHERE t2.a=47
11776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11777      WHERE t2.a=47
11783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11784      WHERE t2.a=47
11790     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11791      WHERE t2.a=47
11797     SELECT t2.a FROM t1 JOIN t2 USING(a)
11798      WHERE t1.rowid <= -2147483649 ORDER BY t2.a
11803     SELECT t2.a FROM t2 NATURAL JOIN t1
11804      WHERE t1.rowid <= -2147483649 ORDER BY t1.a DESC
11809     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11810      WHERE t2.a=47
11816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11817      WHERE t2.a=47
11823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11824      WHERE t2.a=47
11830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11831      WHERE t2.a=47
11837     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11838      WHERE t2.a=47
11844     SELECT t1.* FROM t1, t2 WHERE t1.rowid=-36028797018963969 AND t2.a=t1.a
11849     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ff7fffffffffffff'
11854     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=2
11859     SELECT t2.a FROM t1 JOIN t2 USING(a)
11860      WHERE t1.rowid > -36028797018963969 ORDER BY t2.a
11865     SELECT t2.a FROM t2 NATURAL JOIN t1
11866      WHERE t1.rowid > -36028797018963969 ORDER BY t1.a DESC
11871     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11872      WHERE t2.a=2
11878     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11879      WHERE t2.a=2
11885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11886      WHERE t2.a=2
11892     SELECT t2.a FROM t1 JOIN t2 USING(a)
11893      WHERE t1.rowid >= -36028797018963969 ORDER BY t2.a
11898     SELECT t2.a FROM t2 NATURAL JOIN t1
11899      WHERE t1.rowid >= -36028797018963969 ORDER BY t1.a DESC
11904     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11905      WHERE t2.a=2
11911     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11912      WHERE t2.a=2
11918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11919      WHERE t2.a=2
11925     SELECT t2.a FROM t1 JOIN t2 USING(a)
11926      WHERE t1.rowid < -36028797018963969 ORDER BY t2.a
11931     SELECT t2.a FROM t2 NATURAL JOIN t1
11932      WHERE t1.rowid < -36028797018963969 ORDER BY t1.a DESC
11937     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11938      WHERE t2.a=2
11944     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11945      WHERE t2.a=2
11951     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11952      WHERE t2.a=2
11958     SELECT t2.a FROM t1 JOIN t2 USING(a)
11959      WHERE t1.rowid <= -36028797018963969 ORDER BY t2.a
11964     SELECT t2.a FROM t2 NATURAL JOIN t1
11965      WHERE t1.rowid <= -36028797018963969 ORDER BY t1.a DESC
11970     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11971      WHERE t2.a=2
11977     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11978      WHERE t2.a=2
11984     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11985      WHERE t2.a=2
11991     SELECT t1.* FROM t1, t2 WHERE t1.rowid=3 AND t2.a=t1.a
11996     SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000003'
12001     SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=5
12006     SELECT t2.a FROM t1 JOIN t2 USING(a)
12007      WHERE t1.rowid > 3 ORDER BY t2.a
12012     SELECT t2.a FROM t2 NATURAL JOIN t1
12013      WHERE t1.rowid > 3 ORDER BY t1.a DESC
12018     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12019      WHERE t2.a=5
12025     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12026      WHERE t2.a=5
12032     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12033      WHERE t2.a=5
12039     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
12040      WHERE t2.a=5
12046     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
12047      WHERE t2.a=5
12053     SELECT t2.a FROM t1 JOIN t2 USING(a)
12054      WHERE t1.rowid >= 3 ORDER BY t2.a
12059     SELECT t2.a FROM t2 NATURAL JOIN t1
12060      WHERE t1.rowid >= 3 ORDER BY t1.a DESC
12065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12066      WHERE t2.a=5
12072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12073      WHERE t2.a=5
12079     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12080      WHERE t2.a=5
12086     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
12087      WHERE t2.a=5
12093     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
12094      WHERE t2.a=5
12100     SELECT t2.a FROM t1 JOIN t2 USING(a)
12101      WHERE t1.rowid < 3 ORDER BY t2.a
12106     SELECT t2.a FROM t2 NATURAL JOIN t1
12107      WHERE t1.rowid < 3 ORDER BY t1.a DESC
12112     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12113      WHERE t2.a=5
12119     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12120      WHERE t2.a=5
12126     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12127      WHERE t2.a=5
12133     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
12134      WHERE t2.a=5
12140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
12141      WHERE t2.a=5
12147     SELECT t2.a FROM t1 JOIN t2 USING(a)
12148      WHERE t1.rowid <= 3 ORDER BY t2.a
12153     SELECT t2.a FROM t2 NATURAL JOIN t1
12154      WHERE t1.rowid <= 3 ORDER BY t1.a DESC
12159     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12160      WHERE t2.a=5
12166     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12167      WHERE t2.a=5
12173     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12174      WHERE t2.a=5
12180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
12181      WHERE t2.a=5
12187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
12188      WHERE t2.a=5
12194     SELECT t2.a FROM t1 JOIN t2 USING(a)
12195      WHERE t1.rowid > 9.22337303685477580800e+18 ORDER BY t2.a
12200     SELECT t2.a FROM t2 NATURAL JOIN t1
12201      WHERE t1.rowid > 9.22337303685477580800e+18 ORDER BY t1.a DESC
12206     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12207      WHERE t2.a=65
12213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12214      WHERE t2.a=65
12220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12221      WHERE t2.a=65
12227     SELECT t2.a FROM t1 JOIN t2 USING(a)
12228      WHERE t1.rowid >= 9.22337303685477580800e+18 ORDER BY t2.a
12233     SELECT t2.a FROM t2 NATURAL JOIN t1
12234      WHERE t1.rowid >= 9.22337303685477580800e+18 ORDER BY t1.a DESC
12239     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12240      WHERE t2.a=65
12246     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12247      WHERE t2.a=65
12253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12254      WHERE t2.a=65
12260     SELECT t2.a FROM t1 JOIN t2 USING(a)
12261      WHERE t1.rowid < 9.22337303685477580800e+18 ORDER BY t2.a
12266     SELECT t2.a FROM t2 NATURAL JOIN t1
12267      WHERE t1.rowid < 9.22337303685477580800e+18 ORDER BY t1.a DESC
12272     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12273      WHERE t2.a=65
12279     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12280      WHERE t2.a=65
12286     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12287      WHERE t2.a=65
12293     SELECT t2.a FROM t1 JOIN t2 USING(a)
12294      WHERE t1.rowid <= 9.22337303685477580800e+18 ORDER BY t2.a
12299     SELECT t2.a FROM t2 NATURAL JOIN t1
12300      WHERE t1.rowid <= 9.22337303685477580800e+18 ORDER BY t1.a DESC
12305     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12306      WHERE t2.a=65
12312     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12313      WHERE t2.a=65
12319     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12320      WHERE t2.a=65
12326     SELECT t2.a FROM t1 JOIN t2 USING(a)
12327      WHERE t1.rowid > -9.22337303685477580800e+18 ORDER BY t2.a
12332     SELECT t2.a FROM t2 NATURAL JOIN t1
12333      WHERE t1.rowid > -9.22337303685477580800e+18 ORDER BY t1.a DESC
12338     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12339      WHERE t2.a=66
12345     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12346      WHERE t2.a=66
12352     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12353      WHERE t2.a=66
12359     SELECT t2.a FROM t1 JOIN t2 USING(a)
12360      WHERE t1.rowid >= -9.22337303685477580800e+18 ORDER BY t2.a
12365     SELECT t2.a FROM t2 NATURAL JOIN t1
12366      WHERE t1.rowid >= -9.22337303685477580800e+18 ORDER BY t1.a DESC
12371     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12372      WHERE t2.a=66
12378     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12379      WHERE t2.a=66
12385     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12386      WHERE t2.a=66
12392     SELECT t2.a FROM t1 JOIN t2 USING(a)
12393      WHERE t1.rowid < -9.22337303685477580800e+18 ORDER BY t2.a
12398     SELECT t2.a FROM t2 NATURAL JOIN t1
12399      WHERE t1.rowid < -9.22337303685477580800e+18 ORDER BY t1.a DESC
12404     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12405      WHERE t2.a=66
12411     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12412      WHERE t2.a=66
12418     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12419      WHERE t2.a=66
12425     SELECT t2.a FROM t1 JOIN t2 USING(a)
12426      WHERE t1.rowid <= -9.22337303685477580800e+18 ORDER BY t2.a
12431     SELECT t2.a FROM t2 NATURAL JOIN t1
12432      WHERE t1.rowid <= -9.22337303685477580800e+18 ORDER BY t1.a DESC
12437     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12438      WHERE t2.a=66
12444     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12445      WHERE t2.a=66
12451     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12452      WHERE t2.a=66