Home
last modified time | relevance | path

Searched refs:key1 (Results 201 – 225 of 13650) sorted by relevance

12345678910>>...546

/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/
H A Dapply_changes_iter.test8 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 Dapply_changes_iter.test8 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result77 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result77 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result76 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result77 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result76 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 Dindex_merge_rocksdb.result4 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 Dindex_merge_rocksdb2.result77 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 Dindex_merge_ror.inc39 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 Dindex_merge_ror.inc39 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 Dindex_merge_ror.inc39 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 Dindex_merge_update.result4 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 D1.res1 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 D1.in2 "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 D1.res1 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 D1.in2 "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 D1.res1 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 D1.in2 "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 Dms3d_bone_track.cxx89 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 …]

12345678910>>...546