/dports/databases/sqlite3/sqlite-src-3350500/test/ |
H A D | types2.test | 49 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 D | types2.test | 49 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 D | types2.test | 49 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 D | types2.test | 49 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 D | bool.sql | 3 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 …]
|