/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/ |
H A D | apply_changes_iter.test | 8 key1 INT NOT NULL, 9 KEY (key1) 16 SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 17 SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 18 SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 19 SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 24 key1 INT NOT NULL, 25 KEY (key1) COMMENT 'rev:cf' 33 SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 34 SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/ |
H A D | apply_changes_iter.test | 8 key1 INT NOT NULL, 9 KEY (key1) 16 SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 DESC; 17 SELECT * FROM t1 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 18 SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; 19 SELECT * FROM t1 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 ASC; 24 key1 INT NOT NULL, 25 KEY (key1) COMMENT 'rev:cf' 33 SELECT * FROM t2 WHERE key1 BETWEEN 4 and 11 ORDER BY KEY1 ASC; 34 SELECT * FROM t2 IGNORE INDEX(key1) WHERE key1 BETWEEN 4 and 11 ORDER BY key1 DESC; [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 35 1 SIMPLE t1 ref key1 key1 5 const # 36 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 38 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 39 select * from t1 where key1 = 1; 40 key1 key2 key3 44 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 77 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 100 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 232 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 273 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 278 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 297 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1027 update t1 set key2=key1,key3=key1; 1150 or key1=18 or key1=60; 1179 or key1 < 3 or key1 > @maxv-11; 1208 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 35 1 SIMPLE t1 ref key1 key1 5 const # 36 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 38 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 39 select * from t1 where key1 = 1; 40 key1 key2 key3 44 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 77 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 100 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 232 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 273 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 278 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 297 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1027 update t1 set key2=key1,key3=key1; 1150 or key1=18 or key1=60; 1179 or key1 < 3 or key1 > @maxv-11; 1208 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 34 1 SIMPLE t1 ref key1 key1 5 const # 35 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 37 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 38 select * from t1 where key1 = 1; 39 key1 key2 key3 43 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 76 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 99 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 231 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 272 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 277 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 296 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1025 update t1 set key2=key1,key3=key1; 1148 or key1=18 or key1=60; 1177 or key1 < 3 or key1 > @maxv-11; 1206 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 35 1 SIMPLE t1 ref key1 key1 5 const # 36 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 38 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 39 select * from t1 where key1 = 1; 40 key1 key2 key3 44 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 77 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 100 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 232 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 273 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 278 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 297 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1027 update t1 set key2=key1,key3=key1; 1150 or key1=18 or key1=60; 1179 or key1 < 3 or key1 > @maxv-11; 1208 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 34 1 SIMPLE t1 ref key1 key1 5 const # 35 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 37 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 38 select * from t1 where key1 = 1; 39 key1 key2 key3 43 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 76 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 99 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 231 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 272 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 277 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 296 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1025 update t1 set key2=key1,key3=key1; 1148 or key1=18 or key1=60; 1177 or key1 < 3 or key1 > @maxv-11; 1206 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/ |
H A D | index_merge_rocksdb.result | 4 key1 INT, 10 KEY(key1), 23 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using intersect(key1,key2); Using where 26 create table t1 (key1 int, key2 int, key3 int, key (key1), key (key2), key(key3)) engine=rocksdb; 35 1 SIMPLE t1 ref key1 key1 5 const # 36 explain select key1,key2 from t1 where key1 = 1 or key2 = 1; 38 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL # Using union(key1,key2); Using where 39 select * from t1 where key1 = 1; 40 key1 key2 key3 44 select key1,key2 from t1 where key1 = 1 or key2 = 1; [all …]
|
H A D | index_merge_rocksdb2.result | 77 select * from t0 where key1<2 or key2<3 or (key1>5 and key1<7) or 100 explain select key1 from t0 where (key1 <=> null) or (key1 < 5) or 232 insert into t4 select key1,key1,key1 div 10, key1 % 10, key1 % 10, key1 from t0; 273 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 278 (t1.key1 = t0.key1 or t1.key8 = t0.key1); 297 update t3 set key9=key1,keyA=key1,keyB=key1,keyC=key1; 1027 update t1 set key2=key1,key3=key1; 1150 or key1=18 or key1=60; 1179 or key1 < 3 or key1 > @maxv-11; 1208 (key1 < 5) or (key1 > 10 and key1 < 15) or (key1 >= 50 and key1 < 55 ) or (key1 > @maxv-10); [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/include/ |
H A D | index_merge_ror.inc | 39 key1 int, 63 key(key1), 136 explain select key1,key2 from t1 where key1=100 and key2=100; 138 select key1,key2 from t1 where key1=100 and key2=100; 165 select key1,key2,filler1 from t1 where key1=100 and key2=100; 170 explain select key1,key2 from t1 where key1=100 and key2=100; 172 select key1,key2 from t1 where key1=100 and key2=100; 202 select key1,key2, filler1 from t1 where key1=100 and key2=100; 204 update t1 set key1=200,key2=200 where key1=100 and key2=100; 248 --replace_result key2,key1 key1,key2 key4,key3 key3,key4 [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/include/ |
H A D | index_merge_ror.inc | 39 key1 int, 63 key(key1), 136 explain select key1,key2 from t1 where key1=100 and key2=100; 138 select key1,key2 from t1 where key1=100 and key2=100; 165 select key1,key2,filler1 from t1 where key1=100 and key2=100; 170 explain select key1,key2 from t1 where key1=100 and key2=100; 172 select key1,key2 from t1 where key1=100 and key2=100; 202 select key1,key2, filler1 from t1 where key1=100 and key2=100; 204 update t1 set key1=200,key2=200 where key1=100 and key2=100; 248 --replace_result key2,key1 key1,key2 key4,key3 key3,key4 [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/include/ |
H A D | index_merge_ror.inc | 39 key1 int, 63 key(key1), 136 explain select key1,key2 from t1 where key1=100 and key2=100; 138 select key1,key2 from t1 where key1=100 and key2=100; 165 select key1,key2,filler1 from t1 where key1=100 and key2=100; 170 explain select key1,key2 from t1 where key1=100 and key2=100; 172 select key1,key2 from t1 where key1=100 and key2=100; 202 select key1,key2, filler1 from t1 where key1=100 and key2=100; 204 update t1 set key1=200,key2=200 where key1=100 and key2=100; 248 --replace_result key2,key1 key1,key2 key4,key3 key3,key4 [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | index_merge_update.result | 4 key1 INT NOT NULL, 12 INDEX i1(key1), 120 UPDATE t1 SET key1=10 WHERE key5<5 OR key8<10 ORDER BY key1; 150 …key2=2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 157 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 160 …key2=2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 161 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 340 …key2=2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 347 …ROM t2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… 350 …key2=2 WHERE key1=25 OR key4=40 AND (key4 < SOME (SELECT key4 FROM t1 WHERE key1<5 OR key4<8) OR k… [all …]
|
/dports/textproc/py-ucl/libucl-0.8.1/tests/basic/ |
H A D | 1.res | 1 key1 = "value"; 2 key1 = "value2"; 3 key1 = "value;"; 4 key1 = 1.0; 5 key1 = -3735928559; 7 key1 = "0xreadbeef"; 8 key1 = -1e-10; 9 key1 = 1; 10 key1 = true; 11 key1 = false; [all …]
|
H A D | 1.in | 2 "key1": value; 3 "key1": value2; 4 "key1": "value;" 5 "key1": 1.0, 6 "key1": -0xdeadbeef 8 "key1": 0xreadbeef 9 "key1": -1e-10, 10 "key1": 1 11 "key1": true 12 "key1": no [all …]
|
/dports/ports-mgmt/pkg/pkg-1.17.5/external/libucl/tests/basic/ |
H A D | 1.res | 1 key1 = "value"; 2 key1 = "value2"; 3 key1 = "value;"; 4 key1 = 1.0; 5 key1 = -3735928559; 7 key1 = "0xreadbeef"; 8 key1 = -1e-10; 9 key1 = 1; 10 key1 = true; 11 key1 = false; [all …]
|
H A D | 1.in | 2 "key1": value; 3 "key1": value2; 4 "key1": "value;" 5 "key1": 1.0, 6 "key1": -0xdeadbeef 8 "key1": 0xreadbeef 9 "key1": -1e-10, 10 "key1": 1 11 "key1": true 12 "key1": no [all …]
|
/dports/textproc/libucl/libucl-0.8.1/tests/basic/ |
H A D | 1.res | 1 key1 = "value"; 2 key1 = "value2"; 3 key1 = "value;"; 4 key1 = 1.0; 5 key1 = -3735928559; 7 key1 = "0xreadbeef"; 8 key1 = -1e-10; 9 key1 = 1; 10 key1 = true; 11 key1 = false; [all …]
|
H A D | 1.in | 2 "key1": value; 3 "key1": value2; 4 "key1": "value;" 5 "key1": 1.0, 6 "key1": -0xdeadbeef 8 "key1": 0xreadbeef 9 "key1": -1e-10, 10 "key1": 1 11 "key1": true 12 "key1": no [all …]
|
/dports/games/xray_re-tools/xray_re-tools-52721d2/sources/plugins/ms3d_export/ |
H A D | ms3d_bone_track.cxx | 89 for (const rot_key *end = key1 + m_num_rot_keys - 1; key1 != end;) { in evaluate() 90 if (time >= key1->time && time < (++key1)->time) { in evaluate() 91 key2 = key1--; in evaluate() 96 double t = double((time - key1->time))/(key2->time - key1->time); in evaluate() 112 for (const pos_key *end = key1 + m_num_pos_keys - 1; key1 != end;) { in evaluate() 113 if (time >= key1->time && time < (++key1)->time) { in evaluate() 114 key2 = key1--; in evaluate() 119 double t = double((time - key1->time))/(key2->time - key1->time), t2 = t*t, t3 = t*t2; in evaluate() 126 mot_xform.c.x = h1*key1->pos.x + h3*key1->tan_out.x + h2*key2->pos.x + h4*key2->tan_in.x; in evaluate() 127 mot_xform.c.y = h1*key1->pos.y + h3*key1->tan_out.y + h2*key2->pos.y + h4*key2->tan_in.y; in evaluate() [all …]
|