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

Lines Matching refs:t1
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);
92     CREATE INDEX t1i2 ON t1(x);
97     SELECT count(*) FROM t1
103     INSERT INTO t2 SELECT rowid, a FROM t1;
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
142      ORDER BY t1.rowid
147     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
149      ORDER BY t1.rowid DESC
154     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
175      ORDER BY t1.rowid
180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
182      ORDER BY t1.rowid DESC
187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
208      ORDER BY t1.rowid
213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
215      ORDER BY t1.rowid DESC
220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
241      ORDER BY t1.rowid
246     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
248      ORDER BY t1.rowid DESC
253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
289      ORDER BY t1.rowid
294     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
296      ORDER BY t1.rowid DESC
301     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
308     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
310      ORDER BY t1.rowid
315     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
317      ORDER BY t1.rowid DESC
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
336      ORDER BY t1.rowid
341     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
343      ORDER BY t1.rowid DESC
348     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
355     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
357      ORDER BY t1.rowid
362     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
364      ORDER BY t1.rowid DESC
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
383      ORDER BY t1.rowid
388     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
390      ORDER BY t1.rowid DESC
395     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
402     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
404      ORDER BY t1.rowid
409     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
411      ORDER BY t1.rowid DESC
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
430      ORDER BY t1.rowid
435     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
437      ORDER BY t1.rowid DESC
442     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
449     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
451      ORDER BY t1.rowid
456     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
458      ORDER BY t1.rowid DESC
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
492      ORDER BY t1.rowid
497     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
499      ORDER BY t1.rowid DESC
504     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
511     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
513      ORDER BY t1.rowid
518     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
520      ORDER BY t1.rowid DESC
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
539      ORDER BY t1.rowid
544     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
546      ORDER BY t1.rowid DESC
551     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
558     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
560      ORDER BY t1.rowid
565     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
567      ORDER BY t1.rowid DESC
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
586      ORDER BY t1.rowid
591     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
593      ORDER BY t1.rowid DESC
598     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
605     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
607      ORDER BY t1.rowid
612     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
614      ORDER BY t1.rowid DESC
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
633      ORDER BY t1.rowid
638     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
640      ORDER BY t1.rowid DESC
645     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
652     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
654      ORDER BY t1.rowid
659     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
661      ORDER BY t1.rowid DESC
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
695      ORDER BY t1.rowid
700     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
702      ORDER BY t1.rowid DESC
707     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
714     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
716      ORDER BY t1.rowid
721     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
723      ORDER BY t1.rowid DESC
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
742      ORDER BY t1.rowid
747     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
749      ORDER BY t1.rowid DESC
754     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
761     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
763      ORDER BY t1.rowid
768     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
770      ORDER BY t1.rowid DESC
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
789      ORDER BY t1.rowid
794     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
796      ORDER BY t1.rowid DESC
801     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
808     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
810      ORDER BY t1.rowid
815     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
817      ORDER BY t1.rowid DESC
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
836      ORDER BY t1.rowid
841     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
843      ORDER BY t1.rowid DESC
848     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
855     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
857      ORDER BY t1.rowid
862     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
864      ORDER BY t1.rowid DESC
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
898      ORDER BY t1.rowid
903     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
905      ORDER BY t1.rowid DESC
910     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
917     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
919      ORDER BY t1.rowid
924     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
926      ORDER BY t1.rowid DESC
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
945      ORDER BY t1.rowid
950     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
952      ORDER BY t1.rowid DESC
957     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
964     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
966      ORDER BY t1.rowid
971     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
973      ORDER BY t1.rowid DESC
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
992      ORDER BY t1.rowid
997     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
999      ORDER BY t1.rowid DESC
1004     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1011     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1013      ORDER BY t1.rowid
1018     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1020      ORDER BY t1.rowid DESC
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
1039      ORDER BY t1.rowid
1044     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1046      ORDER BY t1.rowid DESC
1051     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1058     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1060      ORDER BY t1.rowid
1065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1067      ORDER BY t1.rowid DESC
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
1101      ORDER BY t1.rowid
1106     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1108      ORDER BY t1.rowid DESC
1113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
1134      ORDER BY t1.rowid
1139     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1141      ORDER BY t1.rowid DESC
1146     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
1167      ORDER BY t1.rowid
1172     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1174      ORDER BY t1.rowid DESC
1179     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
1200      ORDER BY t1.rowid
1205     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1207      ORDER BY t1.rowid DESC
1212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
1248      ORDER BY t1.rowid
1253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1255      ORDER BY t1.rowid DESC
1260     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1267     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1269      ORDER BY t1.rowid
1274     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1276      ORDER BY t1.rowid DESC
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
1295      ORDER BY t1.rowid
1300     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1302      ORDER BY t1.rowid DESC
1307     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1314     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1316      ORDER BY t1.rowid
1321     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1323      ORDER BY t1.rowid DESC
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
1342      ORDER BY t1.rowid
1347     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1349      ORDER BY t1.rowid DESC
1354     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1361     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1363      ORDER BY t1.rowid
1368     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1370      ORDER BY t1.rowid DESC
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
1389      ORDER BY t1.rowid
1394     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1396      ORDER BY t1.rowid DESC
1401     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1408     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1410      ORDER BY t1.rowid
1415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1417      ORDER BY t1.rowid DESC
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
1451      ORDER BY t1.rowid
1456     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1458      ORDER BY t1.rowid DESC
1463     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1470     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1472      ORDER BY t1.rowid
1477     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1479      ORDER BY t1.rowid DESC
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
1498      ORDER BY t1.rowid
1503     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1505      ORDER BY t1.rowid DESC
1510     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1517     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1519      ORDER BY t1.rowid
1524     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1526      ORDER BY t1.rowid DESC
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
1545      ORDER BY t1.rowid
1550     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1552      ORDER BY t1.rowid DESC
1557     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1564     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1566      ORDER BY t1.rowid
1571     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1573      ORDER BY t1.rowid DESC
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
1592      ORDER BY t1.rowid
1597     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1599      ORDER BY t1.rowid DESC
1604     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1611     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1613      ORDER BY t1.rowid
1618     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1620      ORDER BY t1.rowid DESC
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
1654      ORDER BY t1.rowid
1659     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1661      ORDER BY t1.rowid DESC
1666     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
1687      ORDER BY t1.rowid
1692     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1694      ORDER BY t1.rowid DESC
1699     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
1720      ORDER BY t1.rowid
1725     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1727      ORDER BY t1.rowid DESC
1732     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
1753      ORDER BY t1.rowid
1758     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1760      ORDER BY t1.rowid DESC
1765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
1801      ORDER BY t1.rowid
1806     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1808      ORDER BY t1.rowid DESC
1813     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
1820     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1822      ORDER BY t1.rowid
1827     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
1829      ORDER BY t1.rowid DESC
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
1848      ORDER BY t1.rowid
1853     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1855      ORDER BY t1.rowid DESC
1860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
1867     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1869      ORDER BY t1.rowid
1874     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
1876      ORDER BY t1.rowid DESC
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
1895      ORDER BY t1.rowid
1900     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1902      ORDER BY t1.rowid DESC
1907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
1914     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1916      ORDER BY t1.rowid
1921     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
1923      ORDER BY t1.rowid DESC
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
1942      ORDER BY t1.rowid
1947     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1949      ORDER BY t1.rowid DESC
1954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
1961     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1963      ORDER BY t1.rowid
1968     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
1970      ORDER BY t1.rowid DESC
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
2004      ORDER BY t1.rowid
2009     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2011      ORDER BY t1.rowid DESC
2016     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2023     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2025      ORDER BY t1.rowid
2030     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2032      ORDER BY t1.rowid DESC
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
2051      ORDER BY t1.rowid
2056     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2058      ORDER BY t1.rowid DESC
2063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2070     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2072      ORDER BY t1.rowid
2077     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2079      ORDER BY t1.rowid DESC
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
2098      ORDER BY t1.rowid
2103     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2105      ORDER BY t1.rowid DESC
2110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2117     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2119      ORDER BY t1.rowid
2124     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2126      ORDER BY t1.rowid DESC
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
2145      ORDER BY t1.rowid
2150     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2152      ORDER BY t1.rowid DESC
2157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2164     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2166      ORDER BY t1.rowid
2171     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2173      ORDER BY t1.rowid DESC
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
2207      ORDER BY t1.rowid
2212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2214      ORDER BY t1.rowid DESC
2219     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2226     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2228      ORDER BY t1.rowid
2233     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2235      ORDER BY t1.rowid DESC
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
2254      ORDER BY t1.rowid
2259     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2261      ORDER BY t1.rowid DESC
2266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2273     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2275      ORDER BY t1.rowid
2280     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2282      ORDER BY t1.rowid DESC
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
2301      ORDER BY t1.rowid
2306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2308      ORDER BY t1.rowid DESC
2313     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2320     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2322      ORDER BY t1.rowid
2327     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2329      ORDER BY t1.rowid DESC
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
2348      ORDER BY t1.rowid
2353     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2355      ORDER BY t1.rowid DESC
2360     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2367     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2369      ORDER BY t1.rowid
2374     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2376      ORDER BY t1.rowid DESC
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
2410      ORDER BY t1.rowid
2415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2417      ORDER BY t1.rowid DESC
2422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2429     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2431      ORDER BY t1.rowid
2436     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2438      ORDER BY t1.rowid DESC
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
2457      ORDER BY t1.rowid
2462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2464      ORDER BY t1.rowid DESC
2469     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2476     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2478      ORDER BY t1.rowid
2483     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2485      ORDER BY t1.rowid DESC
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
2504      ORDER BY t1.rowid
2509     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2511      ORDER BY t1.rowid DESC
2516     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2523     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2525      ORDER BY t1.rowid
2530     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2532      ORDER BY t1.rowid DESC
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
2551      ORDER BY t1.rowid
2556     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2558      ORDER BY t1.rowid DESC
2563     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2570     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2572      ORDER BY t1.rowid
2577     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2579      ORDER BY t1.rowid DESC
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
2613      ORDER BY t1.rowid
2618     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2620      ORDER BY t1.rowid DESC
2625     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
2646      ORDER BY t1.rowid
2651     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2653      ORDER BY t1.rowid DESC
2658     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
2679      ORDER BY t1.rowid
2684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2686      ORDER BY t1.rowid DESC
2691     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
2712      ORDER BY t1.rowid
2717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2719      ORDER BY t1.rowid DESC
2724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
2760      ORDER BY t1.rowid
2765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2767      ORDER BY t1.rowid DESC
2772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2779     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2781      ORDER BY t1.rowid
2786     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
2788      ORDER BY t1.rowid DESC
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
2807      ORDER BY t1.rowid
2812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2814      ORDER BY t1.rowid DESC
2819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2828      ORDER BY t1.rowid
2833     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
2835      ORDER BY t1.rowid DESC
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
2854      ORDER BY t1.rowid
2859     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2861      ORDER BY t1.rowid DESC
2866     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
2873     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2875      ORDER BY t1.rowid
2880     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
2882      ORDER BY t1.rowid DESC
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
2901      ORDER BY t1.rowid
2906     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2908      ORDER BY t1.rowid DESC
2913     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
2920     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2922      ORDER BY t1.rowid
2927     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
2929      ORDER BY t1.rowid DESC
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
2948      ORDER BY t1.rowid
2953     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
2955      ORDER BY t1.rowid DESC
2960     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
2981      ORDER BY t1.rowid
2986     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
2988      ORDER BY t1.rowid DESC
2993     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
3014      ORDER BY t1.rowid
3019     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3021      ORDER BY t1.rowid DESC
3026     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
3047      ORDER BY t1.rowid
3052     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3054      ORDER BY t1.rowid DESC
3059     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
3095      ORDER BY t1.rowid
3100     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3102      ORDER BY t1.rowid DESC
3107     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3114     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3116      ORDER BY t1.rowid
3121     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3123      ORDER BY t1.rowid DESC
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
3142      ORDER BY t1.rowid
3147     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3149      ORDER BY t1.rowid DESC
3154     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3161     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3163      ORDER BY t1.rowid
3168     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3170      ORDER BY t1.rowid DESC
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
3189      ORDER BY t1.rowid
3194     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3196      ORDER BY t1.rowid DESC
3201     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3208     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3210      ORDER BY t1.rowid
3215     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3217      ORDER BY t1.rowid DESC
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
3236      ORDER BY t1.rowid
3241     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3243      ORDER BY t1.rowid DESC
3248     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3255     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3257      ORDER BY t1.rowid
3262     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3264      ORDER BY t1.rowid DESC
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
3298      ORDER BY t1.rowid
3303     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3305      ORDER BY t1.rowid DESC
3310     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
3331      ORDER BY t1.rowid
3336     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3338      ORDER BY t1.rowid DESC
3343     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
3364      ORDER BY t1.rowid
3369     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3371      ORDER BY t1.rowid DESC
3376     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
3397      ORDER BY t1.rowid
3402     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3404      ORDER BY t1.rowid DESC
3409     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
3445      ORDER BY t1.rowid
3450     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3452      ORDER BY t1.rowid DESC
3457     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3464     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3466      ORDER BY t1.rowid
3471     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3473      ORDER BY t1.rowid DESC
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
3492      ORDER BY t1.rowid
3497     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3499      ORDER BY t1.rowid DESC
3504     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3511     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3513      ORDER BY t1.rowid
3518     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3520      ORDER BY t1.rowid DESC
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
3539      ORDER BY t1.rowid
3544     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3546      ORDER BY t1.rowid DESC
3551     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3558     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3560      ORDER BY t1.rowid
3565     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3567      ORDER BY t1.rowid DESC
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
3586      ORDER BY t1.rowid
3591     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3593      ORDER BY t1.rowid DESC
3598     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3605     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3607      ORDER BY t1.rowid
3612     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3614      ORDER BY t1.rowid DESC
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
3648      ORDER BY t1.rowid
3653     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3655      ORDER BY t1.rowid DESC
3660     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3667     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3669      ORDER BY t1.rowid
3674     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3676      ORDER BY t1.rowid DESC
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
3695      ORDER BY t1.rowid
3700     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3702      ORDER BY t1.rowid DESC
3707     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3714     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3716      ORDER BY t1.rowid
3721     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3723      ORDER BY t1.rowid DESC
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
3742      ORDER BY t1.rowid
3747     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3749      ORDER BY t1.rowid DESC
3754     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3761     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3763      ORDER BY t1.rowid
3768     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3770      ORDER BY t1.rowid DESC
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
3789      ORDER BY t1.rowid
3794     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3796      ORDER BY t1.rowid DESC
3801     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3808     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3810      ORDER BY t1.rowid
3815     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
3817      ORDER BY t1.rowid DESC
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
3851      ORDER BY t1.rowid
3856     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3858      ORDER BY t1.rowid DESC
3863     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
3870     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3872      ORDER BY t1.rowid
3877     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
3879      ORDER BY t1.rowid DESC
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
3898      ORDER BY t1.rowid
3903     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3905      ORDER BY t1.rowid DESC
3910     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
3917     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3919      ORDER BY t1.rowid
3924     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
3926      ORDER BY t1.rowid DESC
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
3945      ORDER BY t1.rowid
3950     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3952      ORDER BY t1.rowid DESC
3957     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
3964     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3966      ORDER BY t1.rowid
3971     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
3973      ORDER BY t1.rowid DESC
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
3992      ORDER BY t1.rowid
3997     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
3999      ORDER BY t1.rowid DESC
4004     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4011     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4013      ORDER BY t1.rowid
4018     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4020      ORDER BY t1.rowid DESC
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
4054      ORDER BY t1.rowid
4059     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4061      ORDER BY t1.rowid DESC
4066     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4073     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4075      ORDER BY t1.rowid
4080     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4082      ORDER BY t1.rowid DESC
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
4101      ORDER BY t1.rowid
4106     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4108      ORDER BY t1.rowid DESC
4113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4120     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4122      ORDER BY t1.rowid
4127     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4129      ORDER BY t1.rowid DESC
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
4148      ORDER BY t1.rowid
4153     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4155      ORDER BY t1.rowid DESC
4160     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4167     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4169      ORDER BY t1.rowid
4174     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4176      ORDER BY t1.rowid DESC
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
4195      ORDER BY t1.rowid
4200     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4202      ORDER BY t1.rowid DESC
4207     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4214     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4216      ORDER BY t1.rowid
4221     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4223      ORDER BY t1.rowid DESC
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
4257      ORDER BY t1.rowid
4262     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4264      ORDER BY t1.rowid DESC
4269     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4276     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4278      ORDER BY t1.rowid
4283     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4285      ORDER BY t1.rowid DESC
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
4304      ORDER BY t1.rowid
4309     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4311      ORDER BY t1.rowid DESC
4316     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4323     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4325      ORDER BY t1.rowid
4330     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4332      ORDER BY t1.rowid DESC
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
4351      ORDER BY t1.rowid
4356     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4358      ORDER BY t1.rowid DESC
4363     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4370     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4372      ORDER BY t1.rowid
4377     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4379      ORDER BY t1.rowid DESC
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
4398      ORDER BY t1.rowid
4403     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4405      ORDER BY t1.rowid DESC
4410     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4417     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4419      ORDER BY t1.rowid
4424     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4426      ORDER BY t1.rowid DESC
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
4460      ORDER BY t1.rowid
4465     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4467      ORDER BY t1.rowid DESC
4472     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4479     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4481      ORDER BY t1.rowid
4486     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4488      ORDER BY t1.rowid DESC
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
4507      ORDER BY t1.rowid
4512     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4514      ORDER BY t1.rowid DESC
4519     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4526     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4528      ORDER BY t1.rowid
4533     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4535      ORDER BY t1.rowid DESC
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
4554      ORDER BY t1.rowid
4559     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4561      ORDER BY t1.rowid DESC
4566     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4573     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4575      ORDER BY t1.rowid
4580     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4582      ORDER BY t1.rowid DESC
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
4601      ORDER BY t1.rowid
4606     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4608      ORDER BY t1.rowid DESC
4613     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4620     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4622      ORDER BY t1.rowid
4627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4629      ORDER BY t1.rowid DESC
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
4663      ORDER BY t1.rowid
4668     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4670      ORDER BY t1.rowid DESC
4675     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4682     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4684      ORDER BY t1.rowid
4689     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4691      ORDER BY t1.rowid DESC
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
4710      ORDER BY t1.rowid
4715     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4717      ORDER BY t1.rowid DESC
4722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4731      ORDER BY t1.rowid
4736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4738      ORDER BY t1.rowid DESC
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
4757      ORDER BY t1.rowid
4762     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4764      ORDER BY t1.rowid DESC
4769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4778      ORDER BY t1.rowid
4783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4785      ORDER BY t1.rowid DESC
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
4804      ORDER BY t1.rowid
4809     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4811      ORDER BY t1.rowid DESC
4816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
4823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4825      ORDER BY t1.rowid
4830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
4832      ORDER BY t1.rowid DESC
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
4866      ORDER BY t1.rowid
4871     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4873      ORDER BY t1.rowid DESC
4878     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
4885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4887      ORDER BY t1.rowid
4892     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
4894      ORDER BY t1.rowid DESC
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
4913      ORDER BY t1.rowid
4918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4920      ORDER BY t1.rowid DESC
4925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
4932     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4934      ORDER BY t1.rowid
4939     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
4941      ORDER BY t1.rowid DESC
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
4960      ORDER BY t1.rowid
4965     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4967      ORDER BY t1.rowid DESC
4972     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
4979     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4981      ORDER BY t1.rowid
4986     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
4988      ORDER BY t1.rowid DESC
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
5007      ORDER BY t1.rowid
5012     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5014      ORDER BY t1.rowid DESC
5019     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5026     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5028      ORDER BY t1.rowid
5033     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5035      ORDER BY t1.rowid DESC
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
5069      ORDER BY t1.rowid
5074     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5076      ORDER BY t1.rowid DESC
5081     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5088     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5090      ORDER BY t1.rowid
5095     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5097      ORDER BY t1.rowid DESC
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
5116      ORDER BY t1.rowid
5121     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5123      ORDER BY t1.rowid DESC
5128     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5135     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5137      ORDER BY t1.rowid
5142     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5144      ORDER BY t1.rowid DESC
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
5163      ORDER BY t1.rowid
5168     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5170      ORDER BY t1.rowid DESC
5175     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5182     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5184      ORDER BY t1.rowid
5189     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5191      ORDER BY t1.rowid DESC
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
5210      ORDER BY t1.rowid
5215     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5217      ORDER BY t1.rowid DESC
5222     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5229     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5231      ORDER BY t1.rowid
5236     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5238      ORDER BY t1.rowid DESC
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
5272      ORDER BY t1.rowid
5277     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5279      ORDER BY t1.rowid DESC
5284     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5291     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5293      ORDER BY t1.rowid
5298     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5300      ORDER BY t1.rowid DESC
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
5319      ORDER BY t1.rowid
5324     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5326      ORDER BY t1.rowid DESC
5331     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5338     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5340      ORDER BY t1.rowid
5345     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5347      ORDER BY t1.rowid DESC
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
5366      ORDER BY t1.rowid
5371     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5373      ORDER BY t1.rowid DESC
5378     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5385     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5387      ORDER BY t1.rowid
5392     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5394      ORDER BY t1.rowid DESC
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
5413      ORDER BY t1.rowid
5418     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5420      ORDER BY t1.rowid DESC
5425     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5432     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5434      ORDER BY t1.rowid
5439     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5441      ORDER BY t1.rowid DESC
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
5475      ORDER BY t1.rowid
5480     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5482      ORDER BY t1.rowid DESC
5487     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5494     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5496      ORDER BY t1.rowid
5501     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5503      ORDER BY t1.rowid DESC
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
5522      ORDER BY t1.rowid
5527     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5529      ORDER BY t1.rowid DESC
5534     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5541     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5543      ORDER BY t1.rowid
5548     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5550      ORDER BY t1.rowid DESC
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
5569      ORDER BY t1.rowid
5574     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5576      ORDER BY t1.rowid DESC
5581     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5588     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5590      ORDER BY t1.rowid
5595     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5597      ORDER BY t1.rowid DESC
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
5616      ORDER BY t1.rowid
5621     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5623      ORDER BY t1.rowid DESC
5628     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5635     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5637      ORDER BY t1.rowid
5642     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5644      ORDER BY t1.rowid DESC
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
5678      ORDER BY t1.rowid
5683     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5685      ORDER BY t1.rowid DESC
5690     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5697     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5699      ORDER BY t1.rowid
5704     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5706      ORDER BY t1.rowid DESC
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
5725      ORDER BY t1.rowid
5730     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5732      ORDER BY t1.rowid DESC
5737     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5744     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5746      ORDER BY t1.rowid
5751     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5753      ORDER BY t1.rowid DESC
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
5772      ORDER BY t1.rowid
5777     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5779      ORDER BY t1.rowid DESC
5784     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5791     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5793      ORDER BY t1.rowid
5798     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5800      ORDER BY t1.rowid DESC
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
5819      ORDER BY t1.rowid
5824     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5826      ORDER BY t1.rowid DESC
5831     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
5838     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5840      ORDER BY t1.rowid
5845     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
5847      ORDER BY t1.rowid DESC
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
5881      ORDER BY t1.rowid
5886     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5888      ORDER BY t1.rowid DESC
5893     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
5900     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5902      ORDER BY t1.rowid
5907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
5909      ORDER BY t1.rowid DESC
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
5928      ORDER BY t1.rowid
5933     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5935      ORDER BY t1.rowid DESC
5940     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
5947     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5949      ORDER BY t1.rowid
5954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
5956      ORDER BY t1.rowid DESC
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
5975      ORDER BY t1.rowid
5980     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5982      ORDER BY t1.rowid DESC
5987     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
5994     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
5996      ORDER BY t1.rowid
6001     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6003      ORDER BY t1.rowid DESC
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
6022      ORDER BY t1.rowid
6027     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6029      ORDER BY t1.rowid DESC
6034     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6041     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6043      ORDER BY t1.rowid
6048     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6050      ORDER BY t1.rowid DESC
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
6084      ORDER BY t1.rowid
6089     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6091      ORDER BY t1.rowid DESC
6096     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6103     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6105      ORDER BY t1.rowid
6110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6112      ORDER BY t1.rowid DESC
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
6131      ORDER BY t1.rowid
6136     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6138      ORDER BY t1.rowid DESC
6143     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6150     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6152      ORDER BY t1.rowid
6157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6159      ORDER BY t1.rowid DESC
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
6178      ORDER BY t1.rowid
6183     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6185      ORDER BY t1.rowid DESC
6190     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6197     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6199      ORDER BY t1.rowid
6204     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6206      ORDER BY t1.rowid DESC
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
6225      ORDER BY t1.rowid
6230     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6232      ORDER BY t1.rowid DESC
6237     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6244     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6246      ORDER BY t1.rowid
6251     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6253      ORDER BY t1.rowid DESC
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
6287      ORDER BY t1.rowid
6292     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6294      ORDER BY t1.rowid DESC
6299     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6308      ORDER BY t1.rowid
6313     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6315      ORDER BY t1.rowid DESC
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
6334      ORDER BY t1.rowid
6339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6341      ORDER BY t1.rowid DESC
6346     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6353     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6355      ORDER BY t1.rowid
6360     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6362      ORDER BY t1.rowid DESC
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
6381      ORDER BY t1.rowid
6386     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6388      ORDER BY t1.rowid DESC
6393     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6400     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6402      ORDER BY t1.rowid
6407     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6409      ORDER BY t1.rowid DESC
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
6428      ORDER BY t1.rowid
6433     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6435      ORDER BY t1.rowid DESC
6440     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6447     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6449      ORDER BY t1.rowid
6454     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6456      ORDER BY t1.rowid DESC
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
6490      ORDER BY t1.rowid
6495     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6497      ORDER BY t1.rowid DESC
6502     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6509     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6511      ORDER BY t1.rowid
6516     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6518      ORDER BY t1.rowid DESC
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
6537      ORDER BY t1.rowid
6542     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6544      ORDER BY t1.rowid DESC
6549     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6556     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6558      ORDER BY t1.rowid
6563     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6565      ORDER BY t1.rowid DESC
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
6584      ORDER BY t1.rowid
6589     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6591      ORDER BY t1.rowid DESC
6596     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6603     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6605      ORDER BY t1.rowid
6610     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6612      ORDER BY t1.rowid DESC
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
6631      ORDER BY t1.rowid
6636     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6638      ORDER BY t1.rowid DESC
6643     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6650     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6652      ORDER BY t1.rowid
6657     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6659      ORDER BY t1.rowid DESC
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
6693      ORDER BY t1.rowid
6698     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6700      ORDER BY t1.rowid DESC
6705     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6712     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6714      ORDER BY t1.rowid
6719     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6721      ORDER BY t1.rowid DESC
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
6740      ORDER BY t1.rowid
6745     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6747      ORDER BY t1.rowid DESC
6752     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6759     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6761      ORDER BY t1.rowid
6766     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6768      ORDER BY t1.rowid DESC
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
6787      ORDER BY t1.rowid
6792     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6794      ORDER BY t1.rowid DESC
6799     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6806     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6808      ORDER BY t1.rowid
6813     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
6815      ORDER BY t1.rowid DESC
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
6834      ORDER BY t1.rowid
6839     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6841      ORDER BY t1.rowid DESC
6846     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
6853     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6855      ORDER BY t1.rowid
6860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
6862      ORDER BY t1.rowid DESC
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
6896      ORDER BY t1.rowid
6901     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6903      ORDER BY t1.rowid DESC
6908     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
6915     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6917      ORDER BY t1.rowid
6922     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
6924      ORDER BY t1.rowid DESC
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
6943      ORDER BY t1.rowid
6948     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6950      ORDER BY t1.rowid DESC
6955     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
6962     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6964      ORDER BY t1.rowid
6969     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
6971      ORDER BY t1.rowid DESC
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
6990      ORDER BY t1.rowid
6995     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
6997      ORDER BY t1.rowid DESC
7002     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7009     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7011      ORDER BY t1.rowid
7016     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7018      ORDER BY t1.rowid DESC
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
7037      ORDER BY t1.rowid
7042     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7044      ORDER BY t1.rowid DESC
7049     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7056     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7058      ORDER BY t1.rowid
7063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7065      ORDER BY t1.rowid DESC
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
7099      ORDER BY t1.rowid
7104     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7106      ORDER BY t1.rowid DESC
7111     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7118     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7120      ORDER BY t1.rowid
7125     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7127      ORDER BY t1.rowid DESC
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
7146      ORDER BY t1.rowid
7151     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7153      ORDER BY t1.rowid DESC
7158     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7165     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7167      ORDER BY t1.rowid
7172     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7174      ORDER BY t1.rowid DESC
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
7193      ORDER BY t1.rowid
7198     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7200      ORDER BY t1.rowid DESC
7205     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7212     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7214      ORDER BY t1.rowid
7219     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7221      ORDER BY t1.rowid DESC
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
7240      ORDER BY t1.rowid
7245     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7247      ORDER BY t1.rowid DESC
7252     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7259     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7261      ORDER BY t1.rowid
7266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7268      ORDER BY t1.rowid DESC
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
7302      ORDER BY t1.rowid
7307     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7309      ORDER BY t1.rowid DESC
7314     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7321     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7323      ORDER BY t1.rowid
7328     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7330      ORDER BY t1.rowid DESC
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
7349      ORDER BY t1.rowid
7354     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7356      ORDER BY t1.rowid DESC
7361     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7368     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7370      ORDER BY t1.rowid
7375     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7377      ORDER BY t1.rowid DESC
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
7396      ORDER BY t1.rowid
7401     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7403      ORDER BY t1.rowid DESC
7408     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7415     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7417      ORDER BY t1.rowid
7422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7424      ORDER BY t1.rowid DESC
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
7443      ORDER BY t1.rowid
7448     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7450      ORDER BY t1.rowid DESC
7455     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7464      ORDER BY t1.rowid
7469     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7471      ORDER BY t1.rowid DESC
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
7505      ORDER BY t1.rowid
7510     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7512      ORDER BY t1.rowid DESC
7517     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
7538      ORDER BY t1.rowid
7543     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7545      ORDER BY t1.rowid DESC
7550     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
7571      ORDER BY t1.rowid
7576     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7578      ORDER BY t1.rowid DESC
7583     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
7604      ORDER BY t1.rowid
7609     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7611      ORDER BY t1.rowid DESC
7616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
7652      ORDER BY t1.rowid
7657     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7659      ORDER BY t1.rowid DESC
7664     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7671     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7673      ORDER BY t1.rowid
7678     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7680      ORDER BY t1.rowid DESC
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
7699      ORDER BY t1.rowid
7704     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7706      ORDER BY t1.rowid DESC
7711     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7718     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7720      ORDER BY t1.rowid
7725     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7727      ORDER BY t1.rowid DESC
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
7746      ORDER BY t1.rowid
7751     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7753      ORDER BY t1.rowid DESC
7758     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7765     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7767      ORDER BY t1.rowid
7772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7774      ORDER BY t1.rowid DESC
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
7793      ORDER BY t1.rowid
7798     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7800      ORDER BY t1.rowid DESC
7805     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
7812     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7814      ORDER BY t1.rowid
7819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
7821      ORDER BY t1.rowid DESC
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
7855      ORDER BY t1.rowid
7860     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7862      ORDER BY t1.rowid DESC
7867     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
7874     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7876      ORDER BY t1.rowid
7881     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
7883      ORDER BY t1.rowid DESC
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
7902      ORDER BY t1.rowid
7907     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7909      ORDER BY t1.rowid DESC
7914     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
7921     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7923      ORDER BY t1.rowid
7928     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
7930      ORDER BY t1.rowid DESC
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
7949      ORDER BY t1.rowid
7954     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7956      ORDER BY t1.rowid DESC
7961     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
7968     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7970      ORDER BY t1.rowid
7975     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
7977      ORDER BY t1.rowid DESC
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
7996      ORDER BY t1.rowid
8001     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8003      ORDER BY t1.rowid DESC
8008     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8015     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8017      ORDER BY t1.rowid
8022     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8024      ORDER BY t1.rowid DESC
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
8058      ORDER BY t1.rowid
8063     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8065      ORDER BY t1.rowid DESC
8070     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8077     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8079      ORDER BY t1.rowid
8084     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8086      ORDER BY t1.rowid DESC
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
8105      ORDER BY t1.rowid
8110     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8112      ORDER BY t1.rowid DESC
8117     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8124     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8126      ORDER BY t1.rowid
8131     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8133      ORDER BY t1.rowid DESC
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
8152      ORDER BY t1.rowid
8157     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8159      ORDER BY t1.rowid DESC
8164     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8171     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8173      ORDER BY t1.rowid
8178     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8180      ORDER BY t1.rowid DESC
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
8199      ORDER BY t1.rowid
8204     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8206      ORDER BY t1.rowid DESC
8211     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8218     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8220      ORDER BY t1.rowid
8225     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8227      ORDER BY t1.rowid DESC
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
8261      ORDER BY t1.rowid
8266     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8268      ORDER BY t1.rowid DESC
8273     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
8294      ORDER BY t1.rowid
8299     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8301      ORDER BY t1.rowid DESC
8306     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
8327      ORDER BY t1.rowid
8332     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8334      ORDER BY t1.rowid DESC
8339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
8360      ORDER BY t1.rowid
8365     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8367      ORDER BY t1.rowid DESC
8372     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
8408      ORDER BY t1.rowid
8413     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8415      ORDER BY t1.rowid DESC
8420     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8427     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8429      ORDER BY t1.rowid
8434     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8436      ORDER BY t1.rowid DESC
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
8455      ORDER BY t1.rowid
8460     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8462      ORDER BY t1.rowid DESC
8467     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8474     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8476      ORDER BY t1.rowid
8481     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8483      ORDER BY t1.rowid DESC
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
8502      ORDER BY t1.rowid
8507     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8509      ORDER BY t1.rowid DESC
8514     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8521     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8523      ORDER BY t1.rowid
8528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8530      ORDER BY t1.rowid DESC
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
8549      ORDER BY t1.rowid
8554     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8556      ORDER BY t1.rowid DESC
8561     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8568     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8570      ORDER BY t1.rowid
8575     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8577      ORDER BY t1.rowid DESC
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
8611      ORDER BY t1.rowid
8616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8618      ORDER BY t1.rowid DESC
8623     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8630     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8632      ORDER BY t1.rowid
8637     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
8639      ORDER BY t1.rowid DESC
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
8658      ORDER BY t1.rowid
8663     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8665      ORDER BY t1.rowid DESC
8670     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8677     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8679      ORDER BY t1.rowid
8684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
8686      ORDER BY t1.rowid DESC
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
8705      ORDER BY t1.rowid
8710     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8712      ORDER BY t1.rowid DESC
8717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8726      ORDER BY t1.rowid
8731     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
8733      ORDER BY t1.rowid DESC
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
8752      ORDER BY t1.rowid
8757     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8759      ORDER BY t1.rowid DESC
8764     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8771     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8773      ORDER BY t1.rowid
8778     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
8780      ORDER BY t1.rowid DESC
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
8814      ORDER BY t1.rowid
8819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8821      ORDER BY t1.rowid DESC
8826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
8847      ORDER BY t1.rowid
8852     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
8854      ORDER BY t1.rowid DESC
8859     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
8880      ORDER BY t1.rowid
8885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
8887      ORDER BY t1.rowid DESC
8892     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
8913      ORDER BY t1.rowid
8918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
8920      ORDER BY t1.rowid DESC
8925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
8961      ORDER BY t1.rowid
8966     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
8968      ORDER BY t1.rowid DESC
8973     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
8994      ORDER BY t1.rowid
8999     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9001      ORDER BY t1.rowid DESC
9006     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
9027      ORDER BY t1.rowid
9032     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9034      ORDER BY t1.rowid DESC
9039     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
9060      ORDER BY t1.rowid
9065     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9067      ORDER BY t1.rowid DESC
9072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
9108      ORDER BY t1.rowid
9113     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9115      ORDER BY t1.rowid DESC
9120     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9127     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9129      ORDER BY t1.rowid
9134     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9136      ORDER BY t1.rowid DESC
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
9155      ORDER BY t1.rowid
9160     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9162      ORDER BY t1.rowid DESC
9167     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9174     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9176      ORDER BY t1.rowid
9181     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9183      ORDER BY t1.rowid DESC
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
9202      ORDER BY t1.rowid
9207     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9209      ORDER BY t1.rowid DESC
9214     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9221     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9223      ORDER BY t1.rowid
9228     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9230      ORDER BY t1.rowid DESC
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
9249      ORDER BY t1.rowid
9254     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9256      ORDER BY t1.rowid DESC
9261     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9268     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9270      ORDER BY t1.rowid
9275     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9277      ORDER BY t1.rowid DESC
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
9311      ORDER BY t1.rowid
9316     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9318      ORDER BY t1.rowid DESC
9323     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9330     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9332      ORDER BY t1.rowid
9337     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9339      ORDER BY t1.rowid DESC
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
9358      ORDER BY t1.rowid
9363     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9365      ORDER BY t1.rowid DESC
9370     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9377     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9379      ORDER BY t1.rowid
9384     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9386      ORDER BY t1.rowid DESC
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
9405      ORDER BY t1.rowid
9410     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9412      ORDER BY t1.rowid DESC
9417     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9424     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9426      ORDER BY t1.rowid
9431     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9433      ORDER BY t1.rowid DESC
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
9452      ORDER BY t1.rowid
9457     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9459      ORDER BY t1.rowid DESC
9464     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9471     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9473      ORDER BY t1.rowid
9478     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9480      ORDER BY t1.rowid DESC
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
9514      ORDER BY t1.rowid
9519     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9521      ORDER BY t1.rowid DESC
9526     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9533     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9535      ORDER BY t1.rowid
9540     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9542      ORDER BY t1.rowid DESC
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
9561      ORDER BY t1.rowid
9566     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9568      ORDER BY t1.rowid DESC
9573     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9580     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9582      ORDER BY t1.rowid
9587     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9589      ORDER BY t1.rowid DESC
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
9608      ORDER BY t1.rowid
9613     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9615      ORDER BY t1.rowid DESC
9620     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9629      ORDER BY t1.rowid
9634     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9636      ORDER BY t1.rowid DESC
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
9655      ORDER BY t1.rowid
9660     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9662      ORDER BY t1.rowid DESC
9667     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9674     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9676      ORDER BY t1.rowid
9681     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9683      ORDER BY t1.rowid DESC
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
9717      ORDER BY t1.rowid
9722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9724      ORDER BY t1.rowid DESC
9729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9738      ORDER BY t1.rowid
9743     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
9745      ORDER BY t1.rowid DESC
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
9764      ORDER BY t1.rowid
9769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9771      ORDER BY t1.rowid DESC
9776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9785      ORDER BY t1.rowid
9790     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
9792      ORDER BY t1.rowid DESC
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
9811      ORDER BY t1.rowid
9816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9818      ORDER BY t1.rowid DESC
9823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9832      ORDER BY t1.rowid
9837     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
9839      ORDER BY t1.rowid DESC
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
9858      ORDER BY t1.rowid
9863     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9865      ORDER BY t1.rowid DESC
9870     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
9877     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9879      ORDER BY t1.rowid
9884     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
9886      ORDER BY t1.rowid DESC
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
9920      ORDER BY t1.rowid
9925     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
9927      ORDER BY t1.rowid DESC
9932     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
9953      ORDER BY t1.rowid
9958     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
9960      ORDER BY t1.rowid DESC
9965     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
9986      ORDER BY t1.rowid
9991     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
9993      ORDER BY t1.rowid DESC
9998     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
10019      ORDER BY t1.rowid
10024     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10026      ORDER BY t1.rowid DESC
10031     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
10067      ORDER BY t1.rowid
10072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10074      ORDER BY t1.rowid DESC
10079     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10086     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10088      ORDER BY t1.rowid
10093     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10095      ORDER BY t1.rowid DESC
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
10114      ORDER BY t1.rowid
10119     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10121      ORDER BY t1.rowid DESC
10126     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10133     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10135      ORDER BY t1.rowid
10140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10142      ORDER BY t1.rowid DESC
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
10161      ORDER BY t1.rowid
10166     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10168      ORDER BY t1.rowid DESC
10173     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10182      ORDER BY t1.rowid
10187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10189      ORDER BY t1.rowid DESC
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
10208      ORDER BY t1.rowid
10213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10215      ORDER BY t1.rowid DESC
10220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10227     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10229      ORDER BY t1.rowid
10234     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10236      ORDER BY t1.rowid DESC
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
10270      ORDER BY t1.rowid
10275     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10277      ORDER BY t1.rowid DESC
10282     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
10303      ORDER BY t1.rowid
10308     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10310      ORDER BY t1.rowid DESC
10315     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
10336      ORDER BY t1.rowid
10341     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10343      ORDER BY t1.rowid DESC
10348     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
10369      ORDER BY t1.rowid
10374     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10376      ORDER BY t1.rowid DESC
10381     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
10417      ORDER BY t1.rowid
10422     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10424      ORDER BY t1.rowid DESC
10429     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
10450      ORDER BY t1.rowid
10455     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10457      ORDER BY t1.rowid DESC
10462     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
10483      ORDER BY t1.rowid
10488     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10490      ORDER BY t1.rowid DESC
10495     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
10516      ORDER BY t1.rowid
10521     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10523      ORDER BY t1.rowid DESC
10528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
10564      ORDER BY t1.rowid
10569     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10571      ORDER BY t1.rowid DESC
10576     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10583     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10585      ORDER BY t1.rowid
10590     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10592      ORDER BY t1.rowid DESC
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
10611      ORDER BY t1.rowid
10616     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10618      ORDER BY t1.rowid DESC
10623     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10630     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10632      ORDER BY t1.rowid
10637     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10639      ORDER BY t1.rowid DESC
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
10658      ORDER BY t1.rowid
10663     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10665      ORDER BY t1.rowid DESC
10670     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10677     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10679      ORDER BY t1.rowid
10684     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10686      ORDER BY t1.rowid DESC
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
10705      ORDER BY t1.rowid
10710     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10712      ORDER BY t1.rowid DESC
10717     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10724     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10726      ORDER BY t1.rowid
10731     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10733      ORDER BY t1.rowid DESC
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
10767      ORDER BY t1.rowid
10772     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10774      ORDER BY t1.rowid DESC
10779     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10786     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10788      ORDER BY t1.rowid
10793     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
10795      ORDER BY t1.rowid DESC
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
10814      ORDER BY t1.rowid
10819     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10821      ORDER BY t1.rowid DESC
10826     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
10833     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10835      ORDER BY t1.rowid
10840     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
10842      ORDER BY t1.rowid DESC
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
10861      ORDER BY t1.rowid
10866     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10868      ORDER BY t1.rowid DESC
10873     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
10880     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10882      ORDER BY t1.rowid
10887     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
10889      ORDER BY t1.rowid DESC
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
10908      ORDER BY t1.rowid
10913     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10915      ORDER BY t1.rowid DESC
10920     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
10927     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10929      ORDER BY t1.rowid
10934     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
10936      ORDER BY t1.rowid DESC
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
10970      ORDER BY t1.rowid
10975     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
10977      ORDER BY t1.rowid DESC
10982     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
11003      ORDER BY t1.rowid
11008     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11010      ORDER BY t1.rowid DESC
11015     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
11036      ORDER BY t1.rowid
11041     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11043      ORDER BY t1.rowid DESC
11048     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
11069      ORDER BY t1.rowid
11074     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11076      ORDER BY t1.rowid DESC
11081     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
11117      ORDER BY t1.rowid
11122     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11124      ORDER BY t1.rowid DESC
11129     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11136     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11138      ORDER BY t1.rowid
11143     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11145      ORDER BY t1.rowid DESC
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
11164      ORDER BY t1.rowid
11169     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11171      ORDER BY t1.rowid DESC
11176     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11183     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11185      ORDER BY t1.rowid
11190     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11192      ORDER BY t1.rowid DESC
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
11211      ORDER BY t1.rowid
11216     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11218      ORDER BY t1.rowid DESC
11223     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11230     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11232      ORDER BY t1.rowid
11237     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11239      ORDER BY t1.rowid DESC
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
11258      ORDER BY t1.rowid
11263     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11265      ORDER BY t1.rowid DESC
11270     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11277     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11279      ORDER BY t1.rowid
11284     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11286      ORDER BY t1.rowid DESC
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
11320      ORDER BY t1.rowid
11325     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11327      ORDER BY t1.rowid DESC
11332     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11339     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11341      ORDER BY t1.rowid
11346     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11348      ORDER BY t1.rowid DESC
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
11367      ORDER BY t1.rowid
11372     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11374      ORDER BY t1.rowid DESC
11379     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11386     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11388      ORDER BY t1.rowid
11393     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11395      ORDER BY t1.rowid DESC
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
11414      ORDER BY t1.rowid
11419     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11421      ORDER BY t1.rowid DESC
11426     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11433     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11435      ORDER BY t1.rowid
11440     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11442      ORDER BY t1.rowid DESC
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
11461      ORDER BY t1.rowid
11466     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11468      ORDER BY t1.rowid DESC
11473     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11480     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11482      ORDER BY t1.rowid
11487     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11489      ORDER BY t1.rowid DESC
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
11523      ORDER BY t1.rowid
11528     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11530      ORDER BY t1.rowid DESC
11535     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
11556      ORDER BY t1.rowid
11561     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11563      ORDER BY t1.rowid DESC
11568     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
11589      ORDER BY t1.rowid
11594     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11596      ORDER BY t1.rowid DESC
11601     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
11622      ORDER BY t1.rowid
11627     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11629      ORDER BY t1.rowid DESC
11634     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
11670      ORDER BY t1.rowid
11675     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11677      ORDER BY t1.rowid DESC
11682     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11689     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11691      ORDER BY t1.rowid
11696     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
11698      ORDER BY t1.rowid DESC
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
11717      ORDER BY t1.rowid
11722     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11724      ORDER BY t1.rowid DESC
11729     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11736     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11738      ORDER BY t1.rowid
11743     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
11745      ORDER BY t1.rowid DESC
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
11764      ORDER BY t1.rowid
11769     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11771      ORDER BY t1.rowid DESC
11776     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11783     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11785      ORDER BY t1.rowid
11790     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
11792      ORDER BY t1.rowid DESC
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
11811      ORDER BY t1.rowid
11816     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11818      ORDER BY t1.rowid DESC
11823     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11830     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11832      ORDER BY t1.rowid
11837     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
11839      ORDER BY t1.rowid DESC
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
11873      ORDER BY t1.rowid
11878     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
11880      ORDER BY t1.rowid DESC
11885     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
11906      ORDER BY t1.rowid
11911     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
11913      ORDER BY t1.rowid DESC
11918     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
11939      ORDER BY t1.rowid
11944     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
11946      ORDER BY t1.rowid DESC
11951     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
11972      ORDER BY t1.rowid
11977     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
11979      ORDER BY t1.rowid DESC
11984     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
12020      ORDER BY t1.rowid
12025     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12027      ORDER BY t1.rowid DESC
12032     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12039     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
12041      ORDER BY t1.rowid
12046     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
12048      ORDER BY t1.rowid DESC
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
12067      ORDER BY t1.rowid
12072     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12074      ORDER BY t1.rowid DESC
12079     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12086     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
12088      ORDER BY t1.rowid
12093     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
12095      ORDER BY t1.rowid DESC
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
12114      ORDER BY t1.rowid
12119     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12121      ORDER BY t1.rowid DESC
12126     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12133     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
12135      ORDER BY t1.rowid
12140     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
12142      ORDER BY t1.rowid DESC
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
12161      ORDER BY t1.rowid
12166     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12168      ORDER BY t1.rowid DESC
12173     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12180     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
12182      ORDER BY t1.rowid
12187     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)
12189      ORDER BY t1.rowid DESC
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
12208      ORDER BY t1.rowid
12213     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12215      ORDER BY t1.rowid DESC
12220     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
12241      ORDER BY t1.rowid
12246     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12248      ORDER BY t1.rowid DESC
12253     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
12274      ORDER BY t1.rowid
12279     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12281      ORDER BY t1.rowid DESC
12286     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
12307      ORDER BY t1.rowid
12312     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12314      ORDER BY t1.rowid DESC
12319     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
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
12340      ORDER BY t1.rowid
12345     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
12347      ORDER BY t1.rowid DESC
12352     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
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
12373      ORDER BY t1.rowid
12378     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
12380      ORDER BY t1.rowid DESC
12385     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r
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
12406      ORDER BY t1.rowid
12411     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
12413      ORDER BY t1.rowid DESC
12418     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
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
12439      ORDER BY t1.rowid
12444     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r
12446      ORDER BY t1.rowid DESC
12451     SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r