Lines Matching refs:f1
2005 CREATE TABLE f1(a, b);
2006 INSERT INTO f1 VALUES(26, 'z');
2007 INSERT INTO f1 VALUES(25, 'y');
2008 INSERT INTO f1 VALUES(24, 'x');
2009 INSERT INTO f1 VALUES(23, 'w');
2010 INSERT INTO f1 VALUES(22, 'v');
2011 INSERT INTO f1 VALUES(21, 'u');
2012 INSERT INTO f1 VALUES(20, 't');
2013 INSERT INTO f1 VALUES(19, 's');
2014 INSERT INTO f1 VALUES(18, 'r');
2015 INSERT INTO f1 VALUES(17, 'q');
2016 INSERT INTO f1 VALUES(16, 'p');
2017 INSERT INTO f1 VALUES(15, 'o');
2018 INSERT INTO f1 VALUES(14, 'n');
2019 INSERT INTO f1 VALUES(13, 'm');
2020 INSERT INTO f1 VALUES(12, 'l');
2021 INSERT INTO f1 VALUES(11, 'k');
2022 INSERT INTO f1 VALUES(10, 'j');
2023 INSERT INTO f1 VALUES(9, 'i');
2024 INSERT INTO f1 VALUES(8, 'h');
2025 INSERT INTO f1 VALUES(7, 'g');
2026 INSERT INTO f1 VALUES(6, 'f');
2027 INSERT INTO f1 VALUES(5, 'e');
2028 INSERT INTO f1 VALUES(4, 'd');
2029 INSERT INTO f1 VALUES(3, 'c');
2030 INSERT INTO f1 VALUES(2, 'b');
2031 INSERT INTO f1 VALUES(1, 'a');
2039 1 { SELECT b FROM f1 ORDER BY a LIMIT 5 } {a b c d e}
2040 2 { SELECT b FROM f1 ORDER BY a LIMIT 2+3 } {a b c d e}
2041 3 { SELECT b FROM f1 ORDER BY a LIMIT (SELECT a FROM f1 WHERE b = 'e') }
2043 4 { SELECT b FROM f1 ORDER BY a LIMIT 5.0 } {a b c d e}
2044 5 { SELECT b FROM f1 ORDER BY a LIMIT '5' } {a b c d e}
2053 1 { SELECT b FROM f1 ORDER BY a LIMIT 'hello' } {}
2054 2 { SELECT b FROM f1 ORDER BY a LIMIT NULL } {}
2055 3 { SELECT b FROM f1 ORDER BY a LIMIT X'ABCD' } {}
2056 4 { SELECT b FROM f1 ORDER BY a LIMIT 5.1 } {}
2057 5 { SELECT b FROM f1 ORDER BY a LIMIT (SELECT group_concat(b) FROM f1) } {}
2065 1 { SELECT b FROM f1 ORDER BY a LIMIT -1 }
2067 2 { SELECT b FROM f1 ORDER BY a LIMIT length('abc')-100 }
2069 3 { SELECT b FROM f1 ORDER BY a LIMIT (SELECT count(*) FROM f1)/2 - 14 }
2078 1 { SELECT b FROM f1 ORDER BY a LIMIT 0 } {}
2079 2 { SELECT b FROM f1 ORDER BY a DESC LIMIT 4 } {z y x w}
2080 3 { SELECT b FROM f1 ORDER BY a DESC LIMIT 8 } {z y x w v u t s}
2081 4 { SELECT b FROM f1 ORDER BY a DESC LIMIT '12.0' } {z y x w v u t s r q p o}
2089 1 { SELECT b FROM f1 WHERE a>21 ORDER BY a LIMIT 10 } {v w x y z}
2090 2 { SELECT count(*) FROM f1 GROUP BY a/5 ORDER BY 1 LIMIT 10 } {2 4 5 5 5 5}
2099 1 { SELECT b FROM f1 ORDER BY a LIMIT 2 OFFSET 'hello' }
2100 2 { SELECT b FROM f1 ORDER BY a LIMIT 2 OFFSET NULL }
2101 3 { SELECT b FROM f1 ORDER BY a LIMIT 2 OFFSET X'ABCD' }
2102 4 { SELECT b FROM f1 ORDER BY a LIMIT 2 OFFSET 5.1 }
2103 5 { SELECT b FROM f1 ORDER BY a
2104 LIMIT 2 OFFSET (SELECT group_concat(b) FROM f1)
2117 1 { SELECT b FROM f1 ORDER BY a LIMIT 10 OFFSET 5} {f g h i j k l m n o}
2118 2 { SELECT b FROM f1 ORDER BY a LIMIT 2+3 OFFSET 10} {k l m n o}
2119 3 { SELECT b FROM f1 ORDER BY a
2120 LIMIT (SELECT a FROM f1 WHERE b='j')
2121 OFFSET (SELECT a FROM f1 WHERE b='b')
2123 4 { SELECT b FROM f1 ORDER BY a LIMIT '5' OFFSET 3.0 } {d e f g h}
2124 5 { SELECT b FROM f1 ORDER BY a LIMIT '5' OFFSET 0 } {a b c d e}
2125 6 { SELECT b FROM f1 ORDER BY a LIMIT 0 OFFSET 10 } {}
2126 7 { SELECT b FROM f1 ORDER BY a LIMIT 3 OFFSET '1'||'5' } {p q r}
2134 1 { SELECT b FROM f1 ORDER BY a LIMIT 10 OFFSET 20} {u v w x y z}
2135 2 { SELECT a FROM f1 ORDER BY a DESC LIMIT 100 OFFSET 18+4} {4 3 2 1}
2144 1 { SELECT b FROM f1 ORDER BY a LIMIT 5 OFFSET -1 } {a b c d e}
2145 2 { SELECT b FROM f1 ORDER BY a LIMIT 5 OFFSET -500 } {a b c d e}
2146 3 { SELECT b FROM f1 ORDER BY a LIMIT 5 OFFSET 0 } {a b c d e}
2156 1 { SELECT b FROM f1 ORDER BY a LIMIT 5, 10 } {f g h i j k l m n o}
2157 2 { SELECT b FROM f1 ORDER BY a LIMIT 10, 2+3 } {k l m n o}
2158 3 { SELECT b FROM f1 ORDER BY a
2159 LIMIT (SELECT a FROM f1 WHERE b='b'), (SELECT a FROM f1 WHERE b='j')
2161 4 { SELECT b FROM f1 ORDER BY a LIMIT 3.0, '5' } {d e f g h}
2162 5 { SELECT b FROM f1 ORDER BY a LIMIT 0, '5' } {a b c d e}
2163 6 { SELECT b FROM f1 ORDER BY a LIMIT 10, 0 } {}
2164 7 { SELECT b FROM f1 ORDER BY a LIMIT '1'||'5', 3 } {p q r}
2166 8 { SELECT b FROM f1 ORDER BY a LIMIT 20, 10 } {u v w x y z}
2167 9 { SELECT a FROM f1 ORDER BY a DESC LIMIT 18+4, 100 } {4 3 2 1}
2169 10 { SELECT b FROM f1 ORDER BY a LIMIT -1, 5 } {a b c d e}
2170 11 { SELECT b FROM f1 ORDER BY a LIMIT -500, 5 } {a b c d e}
2171 12 { SELECT b FROM f1 ORDER BY a LIMIT 0, 5 } {a b c d e}