Home
last modified time | relevance | path

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

/titanic_41/usr/src/lib/libsqlite/test/
H A Dlimit.test15 # focus of this file is testing the LIMIT ... OFFSET ... clause
41 execsql {SELECT count(*) FROM t1 LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
53 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
65 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
[all …]
H A Dwhere.test266 SELECT * FROM t1 WHERE 1 LIMIT 1
388 SELECT * FROM t3 ORDER BY a LIMIT 3
393 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
398 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
403 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
408 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
413 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
418 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
423 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
428 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
[all …]
H A Dsubselect.test117 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
122 SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
137 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1);
142 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1);
147 SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1 OFFSET 2);
152 SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1 OFFSET 2);
H A Dformat3.test465 SELECT * FROM t1 WHERE 1 LIMIT 1
587 SELECT * FROM t3 ORDER BY a LIMIT 3
592 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
597 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
602 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
607 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
612 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
617 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
622 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
627 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
[all …]
H A Dview.test131 SELECT * FROM v1 LIMIT 1
136 SELECT * FROM v2 LIMIT 1
143 SELECT * FROM v1 LIMIT 1
149 SELECT * FROM v3 LIMIT 4;
159 SELECT y FROM v4 ORDER BY y LIMIT 4;
171 SELECT 1 FROM t1 LIMIT 1;
181 SELECT 1 FROM v1 LIMIT 1;
363 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
369 SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
381 SELECT DISTINCT a, count(*) FROM t2 GROUP BY a ORDER BY 2 LIMIT 3;
H A Dminmax.test180 # is a LIMIT clause. Ticket #396.
184 SELECT min(a) FROM t2 LIMIT 1
189 SELECT max(a) FROM t2 LIMIT 3
194 SELECT min(a) FROM t2 LIMIT 0,100
199 SELECT max(a) FROM t2 LIMIT 1,100
204 SELECT min(x) FROM t3 LIMIT 1
209 SELECT max(x) FROM t3 LIMIT 0
214 SELECT max(a) FROM t2 LIMIT 0
H A Dmisc3.test257 # Ticket #640: vdbe stack overflow with a LIMIT clause on a SELECT inside
267 INSERT INTO y3(c) SELECT b FROM y2 ORDER BY b LIMIT 1;
H A Dlock.test308 INSERT INTO t1(a,b) SELECT 3, tx_exec('SELECT y FROM t2 LIMIT 1');
319 INSERT INTO t3 SELECT tx_exec('SELECT y FROM t2 LIMIT 1');
H A Dselect4.test463 ORDER BY n LIMIT 2
469 ORDER BY n LIMIT 2
H A Dtable.test496 FROM t7 LIMIT 1;
502 FROM t7 LIMIT 1;
H A Dmisc1.test490 catchsql {SELECT name FROM sqlite_master LIMIT 1}
533 SELECT new.TestString FROM TempTable LIMIT 1;
H A Dmemdb.test394 (SELECT x FROM t6 ORDER BY random() LIMIT 1)"
/titanic_41/usr/src/test/zfs-tests/tests/functional/snapshot/
H A Dsnapshot_008_pos.ksh96 if (( tolerance > LIMIT )); then
H A Dsnapshot.cfg50 export LIMIT=524288 # tolerance measured in bytes, 512K
/titanic_41/usr/src/cmd/zonecfg/
H A Dzonecfg_lex.l257 <TSTATE>limit { return LIMIT; }
258 <CSTATE>limit { return LIMIT; }
H A Dzonecfg_grammar.y135 %token NAME MATCH PRIV LIMIT ACTION VALUE EQUAL OPEN_SQ_BRACKET CLOSE_SQ_BRACKET
146 MATCH ZONENAME ZONEPATH AUTOBOOT POOL LIMITPRIV BOOTARGS VALUE PRIV LIMIT
983 | LIMIT { $$ = PT_LIMIT; }
/titanic_41/usr/src/uts/common/ipp/
H A Dippctl.c405 #define LIMIT 4 in ippctl_open() macro
449 ippctl_alloc(LIMIT); in ippctl_open()
455 #undef LIMIT in ippctl_open()
/titanic_41/usr/src/lib/libsqlite/src/
H A Dparse.y473 limit_opt(A) ::= LIMIT signed(X). {A.limit = X; A.offset = 0;}
474 limit_opt(A) ::= LIMIT signed(X) OFFSET signed(Y).
476 limit_opt(A) ::= LIMIT signed(X) COMMA signed(Y).
/titanic_41/usr/src/cmd/sendmail/cf/
H A DREADME1170 ClientRate:IP.ADD.RE.SS LIMIT
1192 ClientConn:IP.ADD.RE.SS LIMIT