Home
last modified time | relevance | path

Searched refs:test_bool (Results 1 – 25 of 804) sorted by relevance

12345678910>>...33

/dports/databases/sqlite3/sqlite-src-3350500/test/
H A Dtypes2.test49 proc test_bool {testname vars expr res} {
66 test_bool types2-1.1 "" {500 = 500.0} 1
67 test_bool types2-1.2 "" {'500' = 500.0} 0
68 test_bool types2-1.3 "" {500 = '500.0'} 0
69 test_bool types2-1.4 "" {'500' = '500.0'} 0
72 test_bool types2-1.5 {t1=500} {500 = t1} 1
82 test_bool types2-1.13 {n1=500} {500 = n1} 1
164 test_bool types2-4.1 "" {500 > 60.0} 1
165 test_bool types2-4.2 "" {'500' > 60.0} 1
166 test_bool types2-4.3 "" {500 > '60.0'} 0
[all …]
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/
H A Dtypes2.test49 proc test_bool {testname vars expr res} {
66 test_bool types2-1.1 "" {500 = 500.0} 1
67 test_bool types2-1.2 "" {'500' = 500.0} 0
68 test_bool types2-1.3 "" {500 = '500.0'} 0
69 test_bool types2-1.4 "" {'500' = '500.0'} 0
72 test_bool types2-1.5 {t1=500} {500 = t1} 1
82 test_bool types2-1.13 {n1=500} {500 = n1} 1
164 test_bool types2-4.1 "" {500 > 60.0} 1
165 test_bool types2-4.2 "" {'500' > 60.0} 1
166 test_bool types2-4.3 "" {500 > '60.0'} 0
[all …]
/dports/databases/db5/db-5.3.28/lang/sql/sqlite/test/
H A Dtypes2.test49 proc test_bool {testname vars expr res} {
66 test_bool types2-1.1 "" {500 = 500.0} 1
67 test_bool types2-1.2 "" {'500' = 500.0} 0
68 test_bool types2-1.3 "" {500 = '500.0'} 0
69 test_bool types2-1.4 "" {'500' = '500.0'} 0
72 test_bool types2-1.5 {t1=500} {500 = t1} 1
82 test_bool types2-1.13 {n1=500} {500 = n1} 1
164 test_bool types2-4.1 "" {500 > 60.0} 1
165 test_bool types2-4.2 "" {'500' > 60.0} 1
166 test_bool types2-4.3 "" {500 > '60.0'} 0
[all …]
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/
H A Dtypes2.test49 proc test_bool {testname vars expr res} {
66 test_bool types2-1.1 "" {500 = 500.0} 1
67 test_bool types2-1.2 "" {'500' = 500.0} 0
68 test_bool types2-1.3 "" {500 = '500.0'} 0
69 test_bool types2-1.4 "" {'500' = '500.0'} 0
72 test_bool types2-1.5 {t1=500} {500 = t1} 1
82 test_bool types2-1.13 {n1=500} {500 = n1} 1
164 test_bool types2-4.1 "" {500 > 60.0} 1
165 test_bool types2-4.2 "" {'500' > 60.0} 1
166 test_bool types2-4.3 "" {500 > '60.0'} 0
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool (
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-server/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql11-client/postgresql-11.14/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool (
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql13-docs/postgresql-13.5/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool (
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql13-client/postgresql-13.5/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/contrib/btree_gin/sql/
H A Dbool.sql3 CREATE TABLE test_bool ( table
7 INSERT INTO test_bool VALUES (false),(true),(null);
9 CREATE INDEX idx_bool ON test_bool USING gin (i);
11 SELECT * FROM test_bool WHERE i<true ORDER BY i;
12 SELECT * FROM test_bool WHERE i<=true ORDER BY i;
13 SELECT * FROM test_bool WHERE i=true ORDER BY i;
14 SELECT * FROM test_bool WHERE i>=true ORDER BY i;
15 SELECT * FROM test_bool WHERE i>true ORDER BY i;
17 SELECT * FROM test_bool WHERE i<false ORDER BY i;
19 SELECT * FROM test_bool WHERE i=false ORDER BY i;
[all …]

12345678910>>...33