| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/ |
| H A D | varbinary.test | 372 d + BIT_OR(vb), f + BIT_OR(vb), dd + BIT_OR(vb), CAST(BIT_OR(vb) AS DECIMAL(10,2)),
373 d + BIT_OR(i), f + BIT_OR(i), dd + BIT_OR(i), CAST(BIT_OR(i) AS DECIMAL(10,2))
378 d * BIT_OR(vb), f * BIT_OR(vb), dd * BIT_OR(vb), BIT_OR(vb) / d,
380 d * BIT_OR(i), f * BIT_OR(i), dd * BIT_OR(i), BIT_OR(i) / d,
381 CAST(BIT_OR(i) AS DECIMAL(10,2)), BIT_OR(i) / f, BIT_OR(i) / dd
386 d + BIT_OR(vb), f + BIT_OR(vb), dd + BIT_OR(vb),
387 d + BIT_OR(i), f + BIT_OR(i), dd + BIT_OR(i)
393 d * BIT_OR(vb), f * BIT_OR(vb), dd * BIT_OR(vb), BIT_OR(vb) / d,
394 BIT_OR(vb) / f, BIT_OR(vb) / dd,
395 d * BIT_OR(i), f * BIT_OR(i), dd * BIT_OR(i), BIT_OR(i) / d,
[all …]
|
| H A D | func_bitwise_ops.test | 531 SELECT BIT_OR(a) FROM t;
535 SELECT HEX(BIT_OR(a)) FROM t;
542 SELECT HEX(BIT_OR(a)) FROM t;
583 SELECT BIT_OR(a) FROM t;
616 SELECT BIT_OR(a) FROM t;
721 SELECT BIT_OR(a) FROM t2;
744 1.0 * BIT_OR(a)
753 0x30 << BIT_OR(a)
762 CONCAT('My', BIT_OR(a))
824 1.0 * BIT_OR(a)
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
| H A D | varbinary.result | 681 d + BIT_OR(i), f + BIT_OR(i), dd + BIT_OR(i), CAST(BIT_OR(i) AS DECIMAL(10,2))
684 d + BIT_OR(vb) f + BIT_OR(vb) dd + BIT_OR(vb) CAST(BIT_OR(vb) AS DECIMAL(10,2)) d + BIT_OR(i) f + B…
687 d * BIT_OR(vb), f * BIT_OR(vb), dd * BIT_OR(vb), BIT_OR(vb) / d,
689 d * BIT_OR(i), f * BIT_OR(i), dd * BIT_OR(i), BIT_OR(i) / d,
693 …BIT_OR(vb) f * BIT_OR(vb) dd * BIT_OR(vb) BIT_OR(vb) / d CAST(BIT_OR(vb) AS DECIMAL(10,2)) BIT_OR(…
696 d + BIT_OR(vb), f + BIT_OR(vb), dd + BIT_OR(vb),
697 d + BIT_OR(i), f + BIT_OR(i), dd + BIT_OR(i)
701 d + BIT_OR(vb) f + BIT_OR(vb) dd + BIT_OR(vb) d + BIT_OR(i) f + BIT_OR(i) dd + BIT_OR(i)
704 d * BIT_OR(vb), f * BIT_OR(vb), dd * BIT_OR(vb), BIT_OR(vb) / d,
706 d * BIT_OR(i), f * BIT_OR(i), dd * BIT_OR(i), BIT_OR(i) / d,
[all …]
|
| H A D | window_bitwise_ops.result | 39 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
40 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
44 HEX(i) HEX(li) HEX(b) HEX(lb) HEX(BIT_OR(i) OVER w) HEX(BIT_OR(li) OVER w) HEX(BIT_OR(b) OVER w) HE…
70 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
71 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
181 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
182 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
186 HEX(i) HEX(li) HEX(b) HEX(lb) HEX(BIT_OR(i) OVER w) HEX(BIT_OR(li) OVER w) HEX(BIT_OR(b) OVER w) HE…
444 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
445 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
[all …]
|
| H A D | func_bitwise_ops.result | 1054 HEX(BIT_OR(a))
1065 HEX(BIT_OR(a))
1076 HEX(BIT_OR(a))
1087 HEX(BIT_OR(a))
1098 HEX(BIT_OR(a))
1288 BIT_OR(a)
1292 1.0 * BIT_OR(a)
1295 gid BIT_OR(a)
1317 1.0 * BIT_OR(a)
1417 1.0 * BIT_OR(a)
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
| H A D | mcs154_win_frame_bit_or.result | 6 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
8 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) bit_or FR…
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
10 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) bit_or FROM t1;
11 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
12 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) bit_or FROM t1;
13 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
14 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) bit_or FRO…
15 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
[all …]
|
| H A D | mcs148_window_function_bit_or.result | 6 SELECT a, b, BIT_OR(b) OVER(PARTITION BY a) FROM t1;
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
8 SELECT a, b, BIT_OR(b) OVER(ORDER BY a) FROM t1;
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
| H A D | mcs154_win_frame_bit_or.result | 6 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
8 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) bit_or FR…
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
10 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) bit_or FROM t1;
11 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
12 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) bit_or FROM t1;
13 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
14 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) bit_or FRO…
15 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
[all …]
|
| H A D | mcs148_window_function_bit_or.result | 6 SELECT a, b, BIT_OR(b) OVER(PARTITION BY a) FROM t1;
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
8 SELECT a, b, BIT_OR(b) OVER(ORDER BY a) FROM t1;
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_OR' is currently not supported in Colum…
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
| H A D | mcs154_win_frame_bit_or.test | 2 # BIT_OR() Window Frame is not supported in Columnstore
18 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
20 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) bit_or FR…
22 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) bit_or FROM t1;
24 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) bit_or FROM t1;
26 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) bit_or FRO…
29 SELECT a, b, BIT_OR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_o…
31 SELECT a, b, BIT_OR(b) OVER(ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
|
| H A D | mcs148_window_function_bit_or.test | 2 # BIT_OR() Window Function currently not supported in Columnstore.
18 SELECT a, b, BIT_OR(b) OVER(PARTITION BY a) FROM t1;
20 SELECT a, b, BIT_OR(b) OVER(ORDER BY a) FROM t1;
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
| H A D | mcs154_win_frame_bit_or.test | 2 # BIT_OR() Window Frame is not supported in Columnstore
18 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
20 SELECT a, b, BIT_OR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) bit_or FR…
22 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) bit_or FROM t1;
24 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) bit_or FROM t1;
26 SELECT a, b, BIT_OR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) bit_or FRO…
29 SELECT a, b, BIT_OR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_o…
31 SELECT a, b, BIT_OR(b) OVER(ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) bit_or FR…
|
| H A D | mcs148_window_function_bit_or.test | 2 # BIT_OR() Window Function currently not supported in Columnstore.
18 SELECT a, b, BIT_OR(b) OVER(PARTITION BY a) FROM t1;
20 SELECT a, b, BIT_OR(b) OVER(ORDER BY a) FROM t1;
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/include/ |
| H A D | window_bitwise_ops.inc | 55 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
56 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
67 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
68 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
90 HEX(BIT_OR(i) OVER w), HEX(BIT_OR(li) OVER w),
91 HEX(BIT_OR(b) OVER w), HEX(BIT_OR(lb) OVER w),
165 BIT_OR(c0004) OVER w,
173 BIT_OR(c0004) OVER w,
189 HEX(BIT_OR(b) OVER w) AS `OR`,
206 HEX(BIT_OR(b) OVER w) AS `OR`,
|
| /dports/biology/biosig/biosig-2.3.3/biosig4matlab/maybe-missing/ |
| H A D | bitand.cc | 38 const unsigned int BIT_OR = 2; variable
55 else if (op>=BIT_OR) in scalar_bitop()
59 if (op==BIT_OR) in scalar_bitop()
160 retval=bitop(x,y,BIT_OR);
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| H A D | func_bitwise_ops.test | 455 SELECT BIT_OR(a) FROM t;
458 SELECT HEX(BIT_OR(a)) FROM t;
465 SELECT HEX(BIT_OR(a)) FROM t;
472 SELECT HEX(BIT_OR(a)) FROM t;
479 SELECT HEX(BIT_OR(a)) FROM t;
486 SELECT HEX(BIT_OR(a)) FROM t;
500 SELECT BIT_OR(a) FROM t;
515 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
524 SELECT BIT_OR(a) FROM t;
539 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| H A D | func_bitwise_ops.test | 455 SELECT BIT_OR(a) FROM t;
458 SELECT HEX(BIT_OR(a)) FROM t;
465 SELECT HEX(BIT_OR(a)) FROM t;
472 SELECT HEX(BIT_OR(a)) FROM t;
479 SELECT HEX(BIT_OR(a)) FROM t;
486 SELECT HEX(BIT_OR(a)) FROM t;
500 SELECT BIT_OR(a) FROM t;
515 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
524 SELECT BIT_OR(a) FROM t;
539 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| H A D | func_bitwise_ops.test | 455 SELECT BIT_OR(a) FROM t;
458 SELECT HEX(BIT_OR(a)) FROM t;
465 SELECT HEX(BIT_OR(a)) FROM t;
472 SELECT HEX(BIT_OR(a)) FROM t;
479 SELECT HEX(BIT_OR(a)) FROM t;
486 SELECT HEX(BIT_OR(a)) FROM t;
500 SELECT BIT_OR(a) FROM t;
515 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
524 SELECT BIT_OR(a) FROM t;
539 PREPARE s5 FROM "SELECT HEX(BIT_OR(a)) FROM t";
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/t/ |
| H A D | varbinary.test | 171 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
172 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
195 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
203 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
229 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a";
234 PREPARE s2 from "SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1";
258 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1 GROUP BY a;
264 SELECT BIT_AND(b), BIT_OR(b), BIT_XOR(b) FROM t1;
293 SELECT a, BIT_AND(a), BIT_OR(a), BIT_XOR(a),
|
| /dports/devel/cook/cook-2.30/cook/builtin/ |
| H A D | expr_parse.y | 23 %token BIT_OR
58 %left BIT_OR
181 | expr BIT_OR expr
|