Home
last modified time | relevance | path

Searched refs:LIMIT (Results 1 – 19 of 19) sorted by relevance

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dlimit.test13 # focus of this file is testing the LIMIT ... OFFSET ... clause
39 execsql {SELECT count(*) FROM t1 LIMIT 5}
42 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
45 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
48 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
51 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
54 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
57 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
60 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
63 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
[all …]
H A Dwhere.test264 SELECT * FROM t1 WHERE 1 LIMIT 1
386 SELECT * FROM t3 ORDER BY a LIMIT 3
391 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
396 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
401 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
406 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
411 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
416 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
421 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
426 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
[all …]
H A Dformat3.test463 SELECT * FROM t1 WHERE 1 LIMIT 1
585 SELECT * FROM t3 ORDER BY a LIMIT 3
590 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
595 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
600 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
605 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
610 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
615 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
620 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
625 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
[all …]
H A Dview.test129 SELECT * FROM v1 LIMIT 1
134 SELECT * FROM v2 LIMIT 1
141 SELECT * FROM v1 LIMIT 1
147 SELECT * FROM v3 LIMIT 4;
157 SELECT y FROM v4 ORDER BY y LIMIT 4;
169 SELECT 1 FROM t1 LIMIT 1;
179 SELECT 1 FROM v1 LIMIT 1;
361 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
367 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
379 SELECT DISTINCT a, count(*) FROM t2 GROUP BY a ORDER BY 2 LIMIT 3;
H A Dsubselect.test115 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
120 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
135 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1);
140 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1);
145 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1 OFFSET 2);
150 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1 OFFSET 2);
H A Dminmax.test178 # is a LIMIT clause. Ticket #396.
182 SELECT min(a) FROM t2 LIMIT 1
187 SELECT max(a) FROM t2 LIMIT 3
192 SELECT min(a) FROM t2 LIMIT 0,100
197 SELECT max(a) FROM t2 LIMIT 1,100
202 SELECT min(x) FROM t3 LIMIT 1
207 SELECT max(x) FROM t3 LIMIT 0
212 SELECT max(a) FROM t2 LIMIT 0
H A Dmisc3.test255 # Ticket #640: vdbe stack overflow with a LIMIT clause on a SELECT inside
265 INSERT INTO y3(c) SELECT b FROM y2 ORDER BY b LIMIT 1;
H A Dlock.test306 INSERT INTO t1(a,b) SELECT 3, tx_exec('SELECT y FROM t2 LIMIT 1');
317 INSERT INTO t3 SELECT tx_exec('SELECT y FROM t2 LIMIT 1');
H A Dselect4.test461 ORDER BY n LIMIT 2
467 ORDER BY n LIMIT 2
H A Dtable.test494 FROM t7 LIMIT 1;
500 FROM t7 LIMIT 1;
H A Dmisc1.test488 catchsql {SELECT name FROM sqlite_master LIMIT 1}
531 SELECT new.TestString FROM TempTable LIMIT 1;
H A Dmemdb.test392 (SELECT x FROM t6 ORDER BY random() LIMIT 1)"
/illumos-gate/usr/src/test/zfs-tests/tests/functional/snapshot/
H A Dsnapshot_008_pos.ksh98 if (( tolerance > LIMIT )); then
H A Dsnapshot.cfg50 export LIMIT=524288 # tolerance measured in bytes, 512K
/illumos-gate/usr/src/cmd/zonecfg/
H A Dzonecfg_lex.l259 <TSTATE>limit { return LIMIT; }
260 <CSTATE>limit { return LIMIT; }
H A Dzonecfg_grammar.y135 %token NAME MATCH PRIV LIMIT ACTION VALUE EQUAL OPEN_SQ_BRACKET CLOSE_SQ_BRACKET
147 MATCH ZONENAME ZONEPATH AUTOBOOT POOL LIMITPRIV BOOTARGS VALUE PRIV LIMIT
985 | LIMIT { $$ = PT_LIMIT; }
/illumos-gate/usr/src/uts/common/ipp/
H A Dippctl.c404 #define LIMIT 4 in ippctl_open() macro
448 ippctl_alloc(LIMIT); in ippctl_open()
454 #undef LIMIT in ippctl_open()
/illumos-gate/usr/src/lib/libsqlite/src/
H A Dparse.y471 limit_opt(A) ::= LIMIT signed(X). {A.limit = X; A.offset = 0;}
472 limit_opt(A) ::= LIMIT signed(X) OFFSET signed(Y).
474 limit_opt(A) ::= LIMIT signed(X) COMMA signed(Y).
/illumos-gate/usr/src/cmd/sendmail/cf/
H A DREADME1170 ClientRate:IP.ADD.RE.SS LIMIT
1192 ClientConn:IP.ADD.RE.SS LIMIT