/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/devel/ding-libs/ding-libs-0.6.1/ini/ini.d/ |
H A D | first.conf | 2 key1 = first file, key1 single value 3 key1 = first file, key1 first multi value 4 key1 = first file, key1 second multi value 10 key1 = first file, key1 single value 11 key1 = first file, key1 first multi value 12 key1 = first file, key1 second multi value 18 key1 = key1 single value 19 key1 = key1 first multi value 20 key1 = key1 second multi value
|
H A D | second.conf | 2 key1 = second file, key1 single value 3 key1 = second file, key1 first multi value 4 key1 = second file, key1 second multi value 10 key1 = key1 single value 11 key1 = key1 first multi value 12 key1 = key1 second multi value 21 key1 = second file, key1 single value 22 key1 = second file, key1 first multi value 23 key1 = second file, key1 second multi value
|
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-client/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/pl/tcl/sql/ |
H A D | pltcl_queries.sql | 48 delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; 49 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 53 delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; 54 delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; 61 select tcl_avg(key1) from T_pkey1; 62 select tcl_sum(key1) from T_pkey1; 63 select tcl_avg(key1) from T_pkey2; 64 select tcl_sum(key1) from T_pkey2; 67 select tcl_avg(key1) from T_pkey1 where key1 = 99; 68 select tcl_sum(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/include/ |
H A D | index_merge_ror.inc | 37 key1 int, 61 key(key1), 128 explain select key1,key2 from t1 where key1=100 and key2=100; 129 select key1,key2 from t1 where key1=100 and key2=100; 146 select key1,key2,filler1 from t1 where key1=100 and key2=100; 149 explain select key1,key2 from t1 where key1=100 and key2=100; 150 select key1,key2 from t1 where key1=100 and key2=100; 168 select key1,key2, filler1 from t1 where key1=100 and key2=100; 170 update t1 set key1=200,key2=200 where key1=100 and key2=100; 197 explain select key1,key2 from t1 where key1=100 and key2=100; [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/include/ |
H A D | index_merge_ror.inc | 37 key1 int, 61 key(key1), 128 explain select key1,key2 from t1 where key1=100 and key2=100; 129 select key1,key2 from t1 where key1=100 and key2=100; 146 select key1,key2,filler1 from t1 where key1=100 and key2=100; 149 explain select key1,key2 from t1 where key1=100 and key2=100; 150 select key1,key2 from t1 where key1=100 and key2=100; 168 select key1,key2, filler1 from t1 where key1=100 and key2=100; 170 update t1 set key1=200,key2=200 where key1=100 and key2=100; 197 explain select key1,key2 from t1 where key1=100 and key2=100; [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 232 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 245 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 262 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 269 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 272 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 273 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 549 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 566 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/deskutils/egroupware/egroupware/vendor/simplesamlphp/simplesamlphp/modules/core/lib/Storage/ |
H A D | SQLPermanentStorage.php | 73 * @param mixed $key1 91 * @param mixed $key1 117 * @param mixed $key1 142 * @param mixed $key1 167 * @param mixed $key1 183 * @param mixed $key1 200 * @param mixed $key1 225 * @param mixed $key1 257 * @param mixed $key1 288 * @param mixed $key1 [all …]
|
/dports/databases/p5-DBIx-Custom/DBIx-Custom-0.40/t/ |
H A D | sqlite.t | 44 $dbi->execute('create table table1 (key1 varchar, key2 varchar, primary key(key1));'); 61 is($row->{key1}, $row->{key2}); 62 is($row->{key1}, $row->{key3}); 73 is($row->{key1}, $row->{key2}); 74 is($row->{key1}, $row->{key3}); 86 is($row->{key1}, $row->{key2}); 87 is($row->{key1}, $row->{key3}); 99 is($row->{key1}, $row->{key2}); 113 is($row->{key1}, $row->{key2}); 114 is($row->{key1}, $row->{key3}); [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 220 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 231 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 246 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 251 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 254 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 255 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 513 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 528 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 220 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 231 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 246 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 251 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 254 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 255 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 513 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 528 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 220 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 231 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 246 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 251 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 254 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 255 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 513 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 528 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 220 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 231 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 246 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 251 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 254 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 255 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 513 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 528 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/r/ |
H A D | index_merge_delete.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 220 DELETE FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1; 231 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 246 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 251 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 254 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 255 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 513 DELETE FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4; 528 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|
/dports/databases/postgresql96-client/postgresql-9.6.24/src/pl/tcl/expected/ |
H A D | pltcl_queries.out | 57 trec 1 | 1 | key1-1 58 trec 2 | 1 | key1-2 59 trec 3 | 1 | key1-3 71 update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 74 delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 117 select tcl_avg(key1) from T_pkey1; 123 select tcl_sum(key1) from T_pkey1; 129 select tcl_avg(key1) from T_pkey2; 135 select tcl_sum(key1) from T_pkey2; 142 select tcl_avg(key1) from T_pkey1 where key1 = 99; [all …]
|