Home
last modified time | relevance | path

Searched refs:BETWEEN (Results 1 – 18 of 18) sorted by relevance

/titanic_50/usr/src/lib/libsqlite/test/
H A Din.test15 # focus of this file is testing the IN and BETWEEN operator.
38 # Do basic testing of BETWEEN.
41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
H A Dlimit.test136 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
144 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
H A Dexpr.test496 test_expr2 expr-7.41 {a BETWEEN -1 AND 1} {1}
497 test_expr2 expr-7.42 {a NOT BETWEEN 2 AND 100} {1}
498 test_expr2 expr-7.43 {(b+1234)||'this is a string that is at least 32 characters long' BETWEEN 1 AN…
499 test_expr2 expr-7.44 {123||'xabcdefghijklmnopqrstuvwyxz01234567890'||a BETWEEN '123a' AND '123b'} {}
500 test_expr2 expr-7.45 {((123||'xabcdefghijklmnopqrstuvwyxz01234567890'||a) BETWEEN '123a' AND '123b'…
501 test_expr2 expr-7.46 {((123||'xabcdefghijklmnopqrstuvwyxz01234567890'||a) BETWEEN '123a' AND '123z'…
H A Dmisc2.test30 SELECT CASE WHEN (NOT new.bar BETWEEN 0 AND 20)
H A Dformat3.test347 # Need to work on optimizing the BETWEEN operator.
350 # count {SELECT w FROM t1 WHERE x=3 AND y BETWEEN 121 AND 196}
H A Dwhere.test137 # Need to work on optimizing the BETWEEN operator.
140 # count {SELECT w FROM t1 WHERE x=3 AND y BETWEEN 121 AND 196}
H A Dselect1.test507 SELECT f1 FROM test1 WHERE ('x' || f1) BETWEEN 'x10' AND 'x20'
/titanic_50/usr/src/cmd/geniconvtbl/
H A Ditm_comp.l194 "@between", BETWEEN,
229 "between", BETWEEN,
H A Ditm_comp.y109 %token BETWEEN
347 : BETWEEN range_list
/titanic_50/usr/src/uts/common/sys/rsm/
H A Drsm.h83 #define BETWEEN(x, lo, hi) (((x) >= (lo)) && ((x) <= (hi))) macro
/titanic_50/usr/src/uts/common/io/ipw/fw-ipw2100/
H A DLICENSE80 OTHER LEGAL RIGHTS THAT VARY BETWEEN JURISDICTIONS.
183 BETWEEN JURISDICTIONS.
/titanic_50/usr/src/uts/common/io/iwi/fw-ipw2200/
H A DLICENSE83 OTHER LEGAL RIGHTS THAT VARY BETWEEN JURISDICTIONS.
186 BETWEEN JURISDICTIONS.
/titanic_50/usr/src/lib/libsqlite/src/
H A Dparse.y141 %left EQ NE ISNULL NOTNULL IS LIKE GLOB BETWEEN IN.
646 expr(A) ::= expr(W) BETWEEN expr(X) AND expr(Y). {
653 expr(A) ::= expr(W) NOT BETWEEN expr(X) AND expr(Y). {
/titanic_50/usr/src/lib/librsm/common/
H A Drsmlib.c1032 BETWEEN (*seg_id, RSM_USER_APP_ID_BASE, RSM_USER_APP_ID_END))) { in rsm_memseg_export_publish()
/titanic_50/usr/src/cmd/fs.d/ufs/mkfs/
H A Dmkfs.c300 #define BETWEEN(x, l, h) ((x) >= (l) && (x) <= (h)) macro
/titanic_50/usr/src/uts/common/io/rsm/
H A Drsm.c2914 } else if BETWEEN(msg->key, RSM_RSMLIB_ID_BASE, RSM_RSMLIB_ID_END) in rsm_publish()
/titanic_50/usr/src/cmd/localedef/data/
H A DUTF-8.cm7618 <BETWEEN> \xE2\x89\xAC
H A DGB18030.cm7146 <BETWEEN> \x81\x36\xD9\…