Lines Matching refs:d1
1641 CREATE TABLE d1(x, y, z);
1643 INSERT INTO d1 VALUES(1, 2, 3);
1644 INSERT INTO d1 VALUES(2, 5, -1);
1645 INSERT INTO d1 VALUES(1, 2, 8);
1646 INSERT INTO d1 VALUES(1, 2, 7);
1647 INSERT INTO d1 VALUES(2, 4, 93);
1648 INSERT INTO d1 VALUES(1, 2, -20);
1649 INSERT INTO d1 VALUES(1, 4, 93);
1650 INSERT INTO d1 VALUES(1, 5, -1);
1670 1 "SELECT * FROM d1 ORDER BY x, y, z" {
1689 2.1 "SELECT * FROM d1 ORDER BY x ASC, y ASC, z ASC" {
1693 2.2 "SELECT * FROM d1 ORDER BY x DESC, y DESC, z DESC" {
1697 2.3 "SELECT * FROM d1 ORDER BY x DESC, y ASC, z DESC" {
1701 2.4 "SELECT * FROM d1 ORDER BY x DESC, y ASC, z ASC" {
1706 3.1 "SELECT * FROM d1 ORDER BY x, y, z" {
1710 3.3 "SELECT * FROM d1 ORDER BY x DESC, y, z DESC" {
1714 3.4 "SELECT * FROM d1 ORDER BY x DESC, y, z" {
1726 1 "SELECT * FROM d1 ORDER BY 1 ASC, 2 ASC, 3 ASC" {
1730 2 "SELECT * FROM d1 ORDER BY 1 DESC, 2 DESC, 3 DESC" {
1734 3 "SELECT * FROM d1 ORDER BY 1 DESC, 2 ASC, 3 DESC" {
1738 4 "SELECT * FROM d1 ORDER BY 1 DESC, 2 ASC, 3 ASC" {
1742 5 "SELECT * FROM d1 ORDER BY 1, 2, 3" {
1746 6 "SELECT * FROM d1 ORDER BY 1 DESC, 2, 3 DESC" {
1750 7 "SELECT * FROM d1 ORDER BY 1 DESC, 2, 3" {
1754 8 "SELECT z, x FROM d1 ORDER BY 2" {
1758 9 "SELECT z, x FROM d1 ORDER BY 1" {
1769 1 "SELECT z+1 AS abc FROM d1 ORDER BY abc" {
1772 2 "SELECT z+1 AS abc FROM d1 ORDER BY abc DESC" {
1775 3 "SELECT z AS x, x AS z FROM d1 ORDER BY z" {
1778 4 "SELECT z AS x, x AS z FROM d1 ORDER BY x" {
1791 1 "SELECT * FROM d1 ORDER BY x+y+z" {
1795 2 "SELECT * FROM d1 ORDER BY x*z" {
1799 3 "SELECT * FROM d1 ORDER BY y*z" {
1813 1 "SELECT x FROM d1 UNION ALL SELECT a FROM d2 ORDER BY x*z" 1st
1814 2 "SELECT x,z FROM d1 UNION ALL SELECT a,b FROM d2 ORDER BY x, x/z" 2nd
1818 1 "SELECT x*z FROM d1 UNION ALL SELECT a FROM d2 ORDER BY x*z" {
1822 2 "SELECT x, x/z FROM d1 UNION ALL SELECT a,b FROM d2 ORDER BY x, x/z" {