sqlite-src-3350500/test/orderby1.test

28       aid INTEGER PRIMARY KEY,
33       aid INTEGER NOT NULL REFERENCES album,
36       UNIQUE(aid, tn)
51     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
60     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn
69     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
78     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
88     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
94     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
104     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
109     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn
115     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
121     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
126     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
132     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
138     SELECT name FROM album CROSS JOIN track USING (aid)
144     SELECT name FROM album CROSS JOIN track USING (aid)
151     SELECT name FROM album CROSS JOIN track USING (aid)
165       aid INT PRIMARY KEY,
168     CREATE INDEX album_i1 ON album(title, aid);
170       aid INTEGER NOT NULL REFERENCES album,
173       UNIQUE(aid, tn)
188     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
197     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
199 } {/ORDER BY/}  ;# ORDER BY required because of missing aid term in ORDER BY
203     SELECT name FROM album JOIN track USING (aid) ORDER BY title, aid, tn
209     SELECT name FROM album JOIN track USING (aid) ORDER BY title, aid, tn
218     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
227     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
237     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
243     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
253     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
258     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn
264     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
271     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
276     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
282     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
288     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
293     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn DESC
299     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
312       aid INTEGER PRIMARY KEY,
317       aid INTEGER NOT NULL REFERENCES album,
320       UNIQUE(aid ASC, tn DESC)
335     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn DESC
344     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn DESC
353     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
362     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
372     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
378     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
388     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
393     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
399     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
405     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
410     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn DESC
416     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
423     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title DESC, tn
428     SELECT name FROM album CROSS JOIN track USING (aid)
435     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title DESC, tn