Home
last modified time | relevance | path

Searched refs:BIT_XOR (Results 1 – 25 of 613) sorted by relevance

12345678910>>...25

/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs155_win_frame_bit_xor.result6 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
8 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) BIT_XOR …
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
10 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) BIT_XOR FROM t1;
11 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
12 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) BIT_XOR FROM t1;
13 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
14 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) BIT_XOR F…
16 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_…
[all …]
H A Dmcs150_window_function_bit_xor.result6 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY a) FROM t1;
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
8 SELECT a, b, BIT_XOR(b) OVER(ORDER BY a) FROM t1;
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs155_win_frame_bit_xor.result6 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
8 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) BIT_XOR …
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
10 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) BIT_XOR FROM t1;
11 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
12 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) BIT_XOR FROM t1;
13 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
14 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) BIT_XOR F…
16 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_…
[all …]
H A Dmcs150_window_function_bit_xor.result6 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY a) FROM t1;
7 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
8 SELECT a, b, BIT_XOR(b) OVER(ORDER BY a) FROM t1;
9 ERROR HY000: Internal error: IDB-9018: Window Function 'BIT_XOR' is currently not supported in Colu…
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs155_win_frame_bit_xor.test2 # BIT_XOR() Window Frame is not supported in Columnstore
18 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
20 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) BIT_XOR …
22 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) BIT_XOR FROM t1;
24 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) BIT_XOR FROM t1;
26 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) BIT_XOR F…
29 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_…
31 SELECT a, b, BIT_XOR(b) OVER(ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
H A Dmcs150_window_function_bit_xor.test2 # BIT_XOR() Window Function currently not supported in Columnstore.
18 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY a) FROM t1;
20 SELECT a, b, BIT_XOR(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 Dmcs155_win_frame_bit_xor.test2 # BIT_XOR() Window Frame is not supported in Columnstore
18 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
20 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) BIT_XOR …
22 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) BIT_XOR FROM t1;
24 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) BIT_XOR FROM t1;
26 SELECT a, b, BIT_XOR(b) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) BIT_XOR F…
29 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_…
31 SELECT a, b, BIT_XOR(b) OVER(ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) BIT_XOR …
H A Dmcs150_window_function_bit_xor.test2 # BIT_XOR() Window Function currently not supported in Columnstore.
18 SELECT a, b, BIT_XOR(b) OVER(PARTITION BY a) FROM t1;
20 SELECT a, b, BIT_XOR(b) OVER(ORDER BY a) FROM t1;
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dwindow_bitwise_ops.result132 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
133 HEX(BIT_XOR(b) OVER w), HEX(BIT_XOR(lb) OVER w),
137 HEX(i) HEX(li) HEX(b) HEX(lb) HEX(BIT_XOR(i) OVER w) HEX(BIT_XOR(li) OVER w) HEX(BIT_XOR(b) OVER w)…
205 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
206 HEX(BIT_XOR(b) OVER w), HEX(BIT_XOR(lb) OVER w),
210 HEX(i) HEX(li) HEX(b) HEX(lb) HEX(BIT_XOR(i) OVER w) HEX(BIT_XOR(li) OVER w) HEX(BIT_XOR(b) OVER w)…
536 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
537 HEX(BIT_XOR(b) OVER w), HEX(BIT_XOR(lb) OVER w),
541 HEX(i) HEX(li) HEX(b) HEX(lb) HEX(BIT_XOR(i) OVER w) HEX(BIT_XOR(li) OVER w) HEX(BIT_XOR(b) OVER w)…
609 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
[all …]
H A Dfunc_bitwise_ops.result1057 HEX(BIT_XOR(a))
1068 HEX(BIT_XOR(a))
1079 HEX(BIT_XOR(a))
1090 HEX(BIT_XOR(a))
1101 HEX(BIT_XOR(a))
1348 0x30 << BIT_XOR(a)
1358 1.0 * BIT_XOR(a)
1377 1.0 * BIT_XOR(a),
1378 CONCAT('My', BIT_XOR(a))
1381 group_id 1.0 * BIT_XOR(a) CONCAT('My', BIT_XOR(a))
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/include/
H A Dwindow_bitwise_ops.inc75 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
76 HEX(BIT_XOR(b) OVER w), HEX(BIT_XOR(lb) OVER w),
97 HEX(BIT_XOR(i) OVER w), HEX(BIT_XOR(li) OVER w),
98 HEX(BIT_XOR(b) OVER w), HEX(BIT_XOR(lb) OVER w),
166 BIT_XOR(c0004) OVER w,
174 BIT_XOR(c0004) OVER w,
191 HEX(BIT_XOR(b) OVER w) AS `XOR`,
208 HEX(BIT_XOR(b) OVER w) AS `XOR`,
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/
H A Dfunc_bitwise_ops.test532 SELECT BIT_XOR(a) FROM t;
536 SELECT HEX(BIT_XOR(a)) FROM t;
543 SELECT HEX(BIT_XOR(a)) FROM t;
550 SELECT HEX(BIT_XOR(a)) FROM t;
585 SELECT BIT_XOR(a) FROM t;
618 SELECT BIT_XOR(a) FROM t;
769 0x30 << BIT_XOR(a)
776 1.0 * BIT_XOR(a)
794 1.0 * BIT_XOR(a),
795 CONCAT('My', BIT_XOR(a))
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/t/
H A Dvarbinary.test171 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 Dfunc_bitwise_ops.test456 SELECT BIT_XOR(a) FROM t;
459 SELECT HEX(BIT_XOR(a)) FROM t;
466 SELECT HEX(BIT_XOR(a)) FROM t;
473 SELECT HEX(BIT_XOR(a)) FROM t;
480 SELECT HEX(BIT_XOR(a)) FROM t;
487 SELECT HEX(BIT_XOR(a)) FROM t;
501 SELECT BIT_XOR(a) FROM t;
518 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
525 SELECT BIT_XOR(a) FROM t;
542 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/t/
H A Dvarbinary.test171 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 Dfunc_bitwise_ops.test456 SELECT BIT_XOR(a) FROM t;
459 SELECT HEX(BIT_XOR(a)) FROM t;
466 SELECT HEX(BIT_XOR(a)) FROM t;
473 SELECT HEX(BIT_XOR(a)) FROM t;
480 SELECT HEX(BIT_XOR(a)) FROM t;
487 SELECT HEX(BIT_XOR(a)) FROM t;
501 SELECT BIT_XOR(a) FROM t;
518 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
525 SELECT BIT_XOR(a) FROM t;
542 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/t/
H A Dvarbinary.test171 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 Dfunc_bitwise_ops.test456 SELECT BIT_XOR(a) FROM t;
459 SELECT HEX(BIT_XOR(a)) FROM t;
466 SELECT HEX(BIT_XOR(a)) FROM t;
473 SELECT HEX(BIT_XOR(a)) FROM t;
480 SELECT HEX(BIT_XOR(a)) FROM t;
487 SELECT HEX(BIT_XOR(a)) FROM t;
501 SELECT BIT_XOR(a) FROM t;
518 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
525 SELECT BIT_XOR(a) FROM t;
542 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/t/
H A Dvarbinary.test171 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 Dfunc_bitwise_ops.test456 SELECT BIT_XOR(a) FROM t;
459 SELECT HEX(BIT_XOR(a)) FROM t;
466 SELECT HEX(BIT_XOR(a)) FROM t;
473 SELECT HEX(BIT_XOR(a)) FROM t;
480 SELECT HEX(BIT_XOR(a)) FROM t;
487 SELECT HEX(BIT_XOR(a)) FROM t;
501 SELECT BIT_XOR(a) FROM t;
518 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
525 SELECT BIT_XOR(a) FROM t;
542 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/t/
H A Dvarbinary.test171 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 Dfunc_bitwise_ops.test456 SELECT BIT_XOR(a) FROM t;
459 SELECT HEX(BIT_XOR(a)) FROM t;
466 SELECT HEX(BIT_XOR(a)) FROM t;
473 SELECT HEX(BIT_XOR(a)) FROM t;
480 SELECT HEX(BIT_XOR(a)) FROM t;
487 SELECT HEX(BIT_XOR(a)) FROM t;
501 SELECT BIT_XOR(a) FROM t;
518 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
525 SELECT BIT_XOR(a) FROM t;
542 PREPARE s6 FROM "SELECT HEX(BIT_XOR(a)) FROM t";
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/t/
H A Dvarbinary.test171 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 Dexpr_parse.y24 %token BIT_XOR
59 %left BIT_XOR
179 | expr BIT_XOR expr
/dports/biology/biosig/biosig-2.3.3/biosig4matlab/maybe-missing/
H A Dbitand.cc39 const unsigned int BIT_XOR = 3; variable
61 else if (op==BIT_XOR) in scalar_bitop()
189 retval=bitop(x,y,BIT_XOR);

12345678910>>...25