Quelle precedence.result
Sprache: Lisp
|
|
create or replace view v1 as select NOT NULL IS TRUE, NOT (NULL IS TRUE), (NOT NULL) IS TRUE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select NULL is not true AS `NOT NULL IS TRUE`,NULL is not true AS `NOT (NULL IS TRUE)`,!NULL is true AS `(NOT NULL) IS TRUE`
select NOT NULL IS TRUE, NOT (NULL IS TRUE), (NOT NULL) IS TRUE union select * from v1;
NOT NULL IS TRUE NOT (NULL IS TRUE) (NOT NULL) IS TRUE
1 1 0
create or replace view v1 as select ! NULL IS TRUE, ! (NULL IS TRUE), (! NULL) IS TRUE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !NULL is true AS `! NULL IS TRUE`,NULL is not true AS `! (NULL IS TRUE)`,!NULL is true AS `(! NULL) IS TRUE`
select ! NULL IS TRUE, ! (NULL IS TRUE), (! NULL) IS TRUE union select * from v1;
! NULL IS TRUE ! (NULL IS TRUE) (! NULL) IS TRUE
0 1 0
create or replace view v1 as select charset(NOT 2 COLLATE latin1_bin), charset(NOT (2 COLLATE latin1_bin)), charset((NOT 2) COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(!2 collate latin1_bin) AS `charset(NOT 2 COLLATE latin1_bin)`,charset(!2 collate latin1_bin) AS `charset(NOT (2 COLLATE latin1_bin))`,charset((!2) collate latin1_bin) AS `charset((NOT 2) COLLATE latin1_bin)`
select charset(NOT 2 COLLATE latin1_bin), charset(NOT (2 COLLATE latin1_bin)), charset((NOT 2) COLLATE latin1_bin) union select * from v1;
charset(NOT 2 COLLATE latin1_bin) charset(NOT (2 COLLATE latin1_bin)) charset((NOT 2) COLLATE latin1_bin)
binary binary latin1
create or replace view v1 as select NOT 2 IN (0,2), NOT (2 IN (0,2)), (NOT 2) IN (0,2);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 not in (0,2) AS `NOT 2 IN (0,2)`,2 not in (0,2) AS `NOT (2 IN (0,2))`,!2 in (0,2) AS `(NOT 2) IN (0,2)`
select NOT 2 IN (0,2), NOT (2 IN (0,2)), (NOT 2) IN (0,2) union select * from v1;
NOT 2 IN (0,2) NOT (2 IN (0,2)) (NOT 2) IN (0,2)
0 0 1
create or replace view v1 as select NOT 2 OR 3, NOT (2 OR 3), (NOT 2) OR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 or 3 AS `NOT 2 OR 3`,!2 and !3 AS `NOT (2 OR 3)`,!2 or 3 AS `(NOT 2) OR 3`
select NOT 2 OR 3, NOT (2 OR 3), (NOT 2) OR 3 union select * from v1;
NOT 2 OR 3 NOT (2 OR 3) (NOT 2) OR 3
1 0 1
create or replace view v1 as select NOT 2 || 3, NOT (2 || 3), (NOT 2) || 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 or 3 AS `NOT 2 || 3`,!2 and !3 AS `NOT (2 || 3)`,!2 or 3 AS `(NOT 2) || 3`
select NOT 2 || 3, NOT (2 || 3), (NOT 2) || 3 union select * from v1;
NOT 2 || 3 NOT (2 || 3) (NOT 2) || 3
1 0 1
create or replace view v1 as select NOT 2 AND 0, NOT (2 AND 0), (NOT 2) AND 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 and 0 AS `NOT 2 AND 0`,!2 or !0 AS `NOT (2 AND 0)`,!2 and 0 AS `(NOT 2) AND 0`
select NOT 2 AND 0, NOT (2 AND 0), (NOT 2) AND 0 union select * from v1;
NOT 2 AND 0 NOT (2 AND 0) (NOT 2) AND 0
0 1 0
create or replace view v1 as select NOT 2 && 0, NOT (2 && 0), (NOT 2) && 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 and 0 AS `NOT 2 && 0`,!2 or !0 AS `NOT (2 && 0)`,!2 and 0 AS `(NOT 2) && 0`
select NOT 2 && 0, NOT (2 && 0), (NOT 2) && 0 union select * from v1;
NOT 2 && 0 NOT (2 && 0) (NOT 2) && 0
0 1 0
create or replace view v1 as select NOT 2 = 3, NOT (2 = 3), (NOT 2) = 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 <> 3 AS `NOT 2 = 3`,2 <> 3 AS `NOT (2 = 3)`,!2 = 3 AS `(NOT 2) = 3`
select NOT 2 = 3, NOT (2 = 3), (NOT 2) = 3 union select * from v1;
NOT 2 = 3 NOT (2 = 3) (NOT 2) = 3
1 1 0
create or replace view v1 as select NOT 2 <=> 3, NOT (2 <=> 3), (NOT 2) <=> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 <=> 3) AS `NOT 2 <=> 3`,!(2 <=> 3) AS `NOT (2 <=> 3)`,!2 <=> 3 AS `(NOT 2) <=> 3`
select NOT 2 <=> 3, NOT (2 <=> 3), (NOT 2) <=> 3 union select * from v1;
NOT 2 <=> 3 NOT (2 <=> 3) (NOT 2) <=> 3
1 1 0
create or replace view v1 as select NOT 2 >= 3, NOT (2 >= 3), (NOT 2) >= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 < 3 AS `NOT 2 >= 3`,2 < 3 AS `NOT (2 >= 3)`,!2 >= 3 AS `(NOT 2) >= 3`
select NOT 2 >= 3, NOT (2 >= 3), (NOT 2) >= 3 union select * from v1;
NOT 2 >= 3 NOT (2 >= 3) (NOT 2) >= 3
1 1 0
create or replace view v1 as select NOT 2 <= 3, NOT (2 <= 3), (NOT 2) <= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 > 3 AS `NOT 2 <= 3`,2 > 3 AS `NOT (2 <= 3)`,!2 <= 3 AS `(NOT 2) <= 3`
select NOT 2 <= 3, NOT (2 <= 3), (NOT 2) <= 3 union select * from v1;
NOT 2 <= 3 NOT (2 <= 3) (NOT 2) <= 3
0 0 1
create or replace view v1 as select NOT 2 < 3, NOT (2 < 3), (NOT 2) < 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 >= 3 AS `NOT 2 < 3`,2 >= 3 AS `NOT (2 < 3)`,!2 < 3 AS `(NOT 2) < 3`
select NOT 2 < 3, NOT (2 < 3), (NOT 2) < 3 union select * from v1;
NOT 2 < 3 NOT (2 < 3) (NOT 2) < 3
0 0 1
create or replace view v1 as select NOT 2 <> 3, NOT (2 <> 3), (NOT 2) <> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 = 3 AS `NOT 2 <> 3`,2 = 3 AS `NOT (2 <> 3)`,!2 <> 3 AS `(NOT 2) <> 3`
select NOT 2 <> 3, NOT (2 <> 3), (NOT 2) <> 3 union select * from v1;
NOT 2 <> 3 NOT (2 <> 3) (NOT 2) <> 3
0 0 1
create or replace view v1 as select NOT 2 > 3, NOT (2 > 3), (NOT 2) > 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 <= 3 AS `NOT 2 > 3`,2 <= 3 AS `NOT (2 > 3)`,!2 > 3 AS `(NOT 2) > 3`
select NOT 2 > 3, NOT (2 > 3), (NOT 2) > 3 union select * from v1;
NOT 2 > 3 NOT (2 > 3) (NOT 2) > 3
1 1 0
create or replace view v1 as select NOT 2 != 3, NOT (2 != 3), (NOT 2) != 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 = 3 AS `NOT 2 != 3`,2 = 3 AS `NOT (2 != 3)`,!2 <> 3 AS `(NOT 2) != 3`
select NOT 2 != 3, NOT (2 != 3), (NOT 2) != 3 union select * from v1;
NOT 2 != 3 NOT (2 != 3) (NOT 2) != 3
0 0 1
create or replace view v1 as select NOT 2 LIKE 3, NOT (2 LIKE 3), (NOT 2) LIKE 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 not like 3 AS `NOT 2 LIKE 3`,2 not like 3 AS `NOT (2 LIKE 3)`,!2 like 3 AS `(NOT 2) LIKE 3`
select NOT 2 LIKE 3, NOT (2 LIKE 3), (NOT 2) LIKE 3 union select * from v1;
NOT 2 LIKE 3 NOT (2 LIKE 3) (NOT 2) LIKE 3
1 1 0
create or replace view v1 as select NOT 2 REGEXP 3, NOT (2 REGEXP 3), (NOT 2) REGEXP 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 regexp 3) AS `NOT 2 REGEXP 3`,!(2 regexp 3) AS `NOT (2 REGEXP 3)`,!2 regexp 3 AS `(NOT 2) REGEXP 3`
select NOT 2 REGEXP 3, NOT (2 REGEXP 3), (NOT 2) REGEXP 3 union select * from v1;
NOT 2 REGEXP 3 NOT (2 REGEXP 3) (NOT 2) REGEXP 3
1 1 0
create or replace view v1 as select NOT 2 | 3, NOT (2 | 3), (NOT 2) | 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 | 3) AS `NOT 2 | 3`,!(2 | 3) AS `NOT (2 | 3)`,!2 | 3 AS `(NOT 2) | 3`
select NOT 2 | 3, NOT (2 | 3), (NOT 2) | 3 union select * from v1;
NOT 2 | 3 NOT (2 | 3) (NOT 2) | 3
0 0 3
create or replace view v1 as select NOT 0 & 2, NOT (0 & 2), (NOT 0) & 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(0 & 2) AS `NOT 0 & 2`,!(0 & 2) AS `NOT (0 & 2)`,!0 & 2 AS `(NOT 0) & 2`
select NOT 0 & 2, NOT (0 & 2), (NOT 0) & 2 union select * from v1;
NOT 0 & 2 NOT (0 & 2) (NOT 0) & 2
1 1 0
create or replace view v1 as select NOT 0 << 3, NOT (0 << 3), (NOT 0) << 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(0 << 3) AS `NOT 0 << 3`,!(0 << 3) AS `NOT (0 << 3)`,!0 << 3 AS `(NOT 0) << 3`
select NOT 0 << 3, NOT (0 << 3), (NOT 0) << 3 union select * from v1;
NOT 0 << 3 NOT (0 << 3) (NOT 0) << 3
1 1 8
create or replace view v1 as select NOT 2 >> 3, NOT (2 >> 3), (NOT 2) >> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 >> 3) AS `NOT 2 >> 3`,!(2 >> 3) AS `NOT (2 >> 3)`,!2 >> 3 AS `(NOT 2) >> 3`
select NOT 2 >> 3, NOT (2 >> 3), (NOT 2) >> 3 union select * from v1;
NOT 2 >> 3 NOT (2 >> 3) (NOT 2) >> 3
1 1 0
create or replace view v1 as select NOT '2000-01-01' +INTERVAL 1 DAY, NOT ('2000-01-01' +INTERVAL 1 DAY), (NOT '2000-01-01') +INTERVAL 1 DAY;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !('2000-01-01' + interval 1 day) AS `NOT '2000-01-01' +INTERVAL 1 DAY`,!('2000-01-01' + interval 1 day) AS `NOT ('2000-01-01' +INTERVAL 1 DAY)`,!'2000-01-01' + interval 1 day AS `(NOT '2000-01-01') +INTERVAL 1 DAY`
select NOT '2000-01-01' +INTERVAL 1 DAY, NOT ('2000-01-01' +INTERVAL 1 DAY), (NOT '2000-01-01') +INTERVAL 1 DAY union select * from v1;
NOT '2000-01-01' +INTERVAL 1 DAY NOT ('2000-01-01' +INTERVAL 1 DAY) (NOT '2000-01-01') +INTERVAL 1 DAY
0 0 NULL
create or replace view v1 as select NOT 2 + 3, NOT (2 + 3), (NOT 2) + 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 + 3) AS `NOT 2 + 3`,!(2 + 3) AS `NOT (2 + 3)`,!2 + 3 AS `(NOT 2) + 3`
select NOT 2 + 3, NOT (2 + 3), (NOT 2) + 3 union select * from v1;
NOT 2 + 3 NOT (2 + 3) (NOT 2) + 3
0 0 3
create or replace view v1 as select NOT 2 - 3, NOT (2 - 3), (NOT 2) - 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 - 3) AS `NOT 2 - 3`,!(2 - 3) AS `NOT (2 - 3)`,!2 - 3 AS `(NOT 2) - 3`
select NOT 2 - 3, NOT (2 - 3), (NOT 2) - 3 union select * from v1;
NOT 2 - 3 NOT (2 - 3) (NOT 2) - 3
0 0 -3
create or replace view v1 as select NOT 0 * 3, NOT (0 * 3), (NOT 0) * 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(0 * 3) AS `NOT 0 * 3`,!(0 * 3) AS `NOT (0 * 3)`,!0 * 3 AS `(NOT 0) * 3`
select NOT 0 * 3, NOT (0 * 3), (NOT 0) * 3 union select * from v1;
NOT 0 * 3 NOT (0 * 3) (NOT 0) * 3
1 1 3
create or replace view v1 as select NOT 0 / 3, NOT (0 / 3), (NOT 0) / 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(0 / 3) AS `NOT 0 / 3`,!(0 / 3) AS `NOT (0 / 3)`,!0 / 3 AS `(NOT 0) / 3`
select NOT 0 / 3, NOT (0 / 3), (NOT 0) / 3 union select * from v1;
NOT 0 / 3 NOT (0 / 3) (NOT 0) / 3
1 1 0.3333
create or replace view v1 as select NOT 2 DIV 3, NOT (2 DIV 3), (NOT 2) DIV 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 DIV 3) AS `NOT 2 DIV 3`,!(2 DIV 3) AS `NOT (2 DIV 3)`,!2 DIV 3 AS `(NOT 2) DIV 3`
select NOT 2 DIV 3, NOT (2 DIV 3), (NOT 2) DIV 3 union select * from v1;
NOT 2 DIV 3 NOT (2 DIV 3) (NOT 2) DIV 3
1 1 0
create or replace view v1 as select NOT 6 MOD 3, NOT (6 MOD 3), (NOT 6) MOD 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(6 MOD 3) AS `NOT 6 MOD 3`,!(6 MOD 3) AS `NOT (6 MOD 3)`,!6 MOD 3 AS `(NOT 6) MOD 3`
select NOT 6 MOD 3, NOT (6 MOD 3), (NOT 6) MOD 3 union select * from v1;
NOT 6 MOD 3 NOT (6 MOD 3) (NOT 6) MOD 3
1 1 0
create or replace view v1 as select NOT 6 % 3, NOT (6 % 3), (NOT 6) % 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(6 MOD 3) AS `NOT 6 % 3`,!(6 MOD 3) AS `NOT (6 % 3)`,!6 MOD 3 AS `(NOT 6) % 3`
select NOT 6 % 3, NOT (6 % 3), (NOT 6) % 3 union select * from v1;
NOT 6 % 3 NOT (6 % 3) (NOT 6) % 3
1 1 0
create or replace view v1 as select NOT 2 ^ 3, NOT (2 ^ 3), (NOT 2) ^ 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !(2 ^ 3) AS `NOT 2 ^ 3`,!(2 ^ 3) AS `NOT (2 ^ 3)`,!2 ^ 3 AS `(NOT 2) ^ 3`
select NOT 2 ^ 3, NOT (2 ^ 3), (NOT 2) ^ 3 union select * from v1;
NOT 2 ^ 3 NOT (2 ^ 3) (NOT 2) ^ 3
0 0 3
create or replace view v1 as select NOT 2 BETWEEN 3 AND 4, NOT (2 BETWEEN 3 AND 4), (NOT 2) BETWEEN 3 AND 4;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 not between 3 and 4 AS `NOT 2 BETWEEN 3 AND 4`,2 not between 3 and 4 AS `NOT (2 BETWEEN 3 AND 4)`,!2 between 3 and 4 AS `(NOT 2) BETWEEN 3 AND 4`
select NOT 2 BETWEEN 3 AND 4, NOT (2 BETWEEN 3 AND 4), (NOT 2) BETWEEN 3 AND 4 union select * from v1;
NOT 2 BETWEEN 3 AND 4 NOT (2 BETWEEN 3 AND 4) (NOT 2) BETWEEN 3 AND 4
1 1 0
create or replace view v1 as select - 2 IS TRUE, - (2 IS TRUE), (- 2) IS TRUE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 is true AS `- 2 IS TRUE`,-(2 is true) AS `- (2 IS TRUE)`,-2 is true AS `(- 2) IS TRUE`
select - 2 IS TRUE, - (2 IS TRUE), (- 2) IS TRUE union select * from v1;
- 2 IS TRUE - (2 IS TRUE) (- 2) IS TRUE
1 -1 1
create or replace view v1 as select charset(- "2" COLLATE latin1_bin), charset(- ("2" COLLATE latin1_bin)), charset((- "2") COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(-'2' collate latin1_bin) AS `charset(- "2" COLLATE latin1_bin)`,charset(-'2' collate latin1_bin) AS `charset(- ("2" COLLATE latin1_bin))`,charset((-'2') collate latin1_bin) AS `charset((- "2") COLLATE latin1_bin)`
select charset(- "2" COLLATE latin1_bin), charset(- ("2" COLLATE latin1_bin)), charset((- "2") COLLATE latin1_bin) union select * from v1;
charset(- "2" COLLATE latin1_bin) charset(- ("2" COLLATE latin1_bin)) charset((- "2") COLLATE latin1_bin)
binary binary latin1
create or replace view v1 as select - 2 IN (2,1), - (2 IN (2,1)), (- 2) IN (2,1);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 in (2,1) AS `- 2 IN (2,1)`,-(2 in (2,1)) AS `- (2 IN (2,1))`,-2 in (2,1) AS `(- 2) IN (2,1)`
select - 2 IN (2,1), - (2 IN (2,1)), (- 2) IN (2,1) union select * from v1;
- 2 IN (2,1) - (2 IN (2,1)) (- 2) IN (2,1)
0 -1 0
create or replace view v1 as select - 2 OR 3, - (2 OR 3), (- 2) OR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 or 3 AS `- 2 OR 3`,-(2 or 3) AS `- (2 OR 3)`,-2 or 3 AS `(- 2) OR 3`
select - 2 OR 3, - (2 OR 3), (- 2) OR 3 union select * from v1;
- 2 OR 3 - (2 OR 3) (- 2) OR 3
1 -1 1
create or replace view v1 as select - 2 || 3, - (2 || 3), (- 2) || 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 or 3 AS `- 2 || 3`,-(2 or 3) AS `- (2 || 3)`,-2 or 3 AS `(- 2) || 3`
select - 2 || 3, - (2 || 3), (- 2) || 3 union select * from v1;
- 2 || 3 - (2 || 3) (- 2) || 3
1 -1 1
create or replace view v1 as select - 0 XOR 3, - (0 XOR 3), (- 0) XOR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 xor 3 AS `- 0 XOR 3`,-(0 xor 3) AS `- (0 XOR 3)`,0 xor 3 AS `(- 0) XOR 3`
select - 0 XOR 3, - (0 XOR 3), (- 0) XOR 3 union select * from v1;
- 0 XOR 3 - (0 XOR 3) (- 0) XOR 3
1 -1 1
create or replace view v1 as select - 2 AND 3, - (2 AND 3), (- 2) AND 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 and 3 AS `- 2 AND 3`,-(2 and 3) AS `- (2 AND 3)`,-2 and 3 AS `(- 2) AND 3`
select - 2 AND 3, - (2 AND 3), (- 2) AND 3 union select * from v1;
- 2 AND 3 - (2 AND 3) (- 2) AND 3
1 -1 1
create or replace view v1 as select - 2 && 3, - (2 && 3), (- 2) && 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 and 3 AS `- 2 && 3`,-(2 and 3) AS `- (2 && 3)`,-2 and 3 AS `(- 2) && 3`
select - 2 && 3, - (2 && 3), (- 2) && 3 union select * from v1;
- 2 && 3 - (2 && 3) (- 2) && 3
1 -1 1
create or replace view v1 as select - 2 = 2, - (2 = 2), (- 2) = 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 = 2 AS `- 2 = 2`,-(2 = 2) AS `- (2 = 2)`,-2 = 2 AS `(- 2) = 2`
select - 2 = 2, - (2 = 2), (- 2) = 2 union select * from v1;
- 2 = 2 - (2 = 2) (- 2) = 2
0 -1 0
create or replace view v1 as select - 2 <=> 2, - (2 <=> 2), (- 2) <=> 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 <=> 2 AS `- 2 <=> 2`,-(2 <=> 2) AS `- (2 <=> 2)`,-2 <=> 2 AS `(- 2) <=> 2`
select - 2 <=> 2, - (2 <=> 2), (- 2) <=> 2 union select * from v1;
- 2 <=> 2 - (2 <=> 2) (- 2) <=> 2
0 -1 0
create or replace view v1 as select - 2 >= 1, - (2 >= 1), (- 2) >= 1;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 >= 1 AS `- 2 >= 1`,-(2 >= 1) AS `- (2 >= 1)`,-2 >= 1 AS `(- 2) >= 1`
select - 2 >= 1, - (2 >= 1), (- 2) >= 1 union select * from v1;
- 2 >= 1 - (2 >= 1) (- 2) >= 1
0 -1 0
create or replace view v1 as select - 2 <= 3, - (2 <= 3), (- 2) <= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 <= 3 AS `- 2 <= 3`,-(2 <= 3) AS `- (2 <= 3)`,-2 <= 3 AS `(- 2) <= 3`
select - 2 <= 3, - (2 <= 3), (- 2) <= 3 union select * from v1;
- 2 <= 3 - (2 <= 3) (- 2) <= 3
1 -1 1
create or replace view v1 as select - 2 < 3, - (2 < 3), (- 2) < 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 < 3 AS `- 2 < 3`,-(2 < 3) AS `- (2 < 3)`,-2 < 3 AS `(- 2) < 3`
select - 2 < 3, - (2 < 3), (- 2) < 3 union select * from v1;
- 2 < 3 - (2 < 3) (- 2) < 3
1 -1 1
create or replace view v1 as select - 2 <> 3, - (2 <> 3), (- 2) <> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 <> 3 AS `- 2 <> 3`,-(2 <> 3) AS `- (2 <> 3)`,-2 <> 3 AS `(- 2) <> 3`
select - 2 <> 3, - (2 <> 3), (- 2) <> 3 union select * from v1;
- 2 <> 3 - (2 <> 3) (- 2) <> 3
1 -1 1
create or replace view v1 as select - 2 > 1, - (2 > 1), (- 2) > 1;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 > 1 AS `- 2 > 1`,-(2 > 1) AS `- (2 > 1)`,-2 > 1 AS `(- 2) > 1`
select - 2 > 1, - (2 > 1), (- 2) > 1 union select * from v1;
- 2 > 1 - (2 > 1) (- 2) > 1
0 -1 0
create or replace view v1 as select - 2 != 3, - (2 != 3), (- 2) != 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 <> 3 AS `- 2 != 3`,-(2 <> 3) AS `- (2 != 3)`,-2 <> 3 AS `(- 2) != 3`
select - 2 != 3, - (2 != 3), (- 2) != 3 union select * from v1;
- 2 != 3 - (2 != 3) (- 2) != 3
1 -1 1
create or replace view v1 as select - 2 LIKE 2, - (2 LIKE 2), (- 2) LIKE 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 like 2 AS `- 2 LIKE 2`,-(2 like 2) AS `- (2 LIKE 2)`,-2 like 2 AS `(- 2) LIKE 2`
select - 2 LIKE 2, - (2 LIKE 2), (- 2) LIKE 2 union select * from v1;
- 2 LIKE 2 - (2 LIKE 2) (- 2) LIKE 2
0 -1 0
create or replace view v1 as select - 2 REGEXP 2, - (2 REGEXP 2), (- 2) REGEXP 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 regexp 2 AS `- 2 REGEXP 2`,-(2 regexp 2) AS `- (2 REGEXP 2)`,-2 regexp 2 AS `(- 2) REGEXP 2`
select - 2 REGEXP 2, - (2 REGEXP 2), (- 2) REGEXP 2 union select * from v1;
- 2 REGEXP 2 - (2 REGEXP 2) (- 2) REGEXP 2
1 -1 1
create or replace view v1 as select - 2 | 3, - (2 | 3), (- 2) | 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 | 3 AS `- 2 | 3`,-(2 | 3) AS `- (2 | 3)`,-2 | 3 AS `(- 2) | 3`
select - 2 | 3, - (2 | 3), (- 2) | 3 union select * from v1;
- 2 | 3 - (2 | 3) (- 2) | 3
18446744073709551615 -3 18446744073709551615
create or replace view v1 as select - 2 & 3, - (2 & 3), (- 2) & 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 & 3 AS `- 2 & 3`,-(2 & 3) AS `- (2 & 3)`,-2 & 3 AS `(- 2) & 3`
select - 2 & 3, - (2 & 3), (- 2) & 3 union select * from v1;
- 2 & 3 - (2 & 3) (- 2) & 3
2 -2 2
create or replace view v1 as select - 2 << 3, - (2 << 3), (- 2) << 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 << 3 AS `- 2 << 3`,-(2 << 3) AS `- (2 << 3)`,-2 << 3 AS `(- 2) << 3`
select - 2 << 3, - (2 << 3), (- 2) << 3 union select * from v1;
- 2 << 3 - (2 << 3) (- 2) << 3
18446744073709551600 -16 18446744073709551600
create or replace view v1 as select - 2 >> 3, - (2 >> 3), (- 2) >> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 >> 3 AS `- 2 >> 3`,-(2 >> 3) AS `- (2 >> 3)`,-2 >> 3 AS `(- 2) >> 3`
select - 2 >> 3, - (2 >> 3), (- 2) >> 3 union select * from v1;
- 2 >> 3 - (2 >> 3) (- 2) >> 3
2305843009213693951 0 2305843009213693951
create or replace view v1 as select - '2000-01-01' +INTERVAL 1 DAY, - ('2000-01-01' +INTERVAL 1 DAY), (- '2000-01-01') +INTERVAL 1 DAY;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -'2000-01-01' + interval 1 day AS `- '2000-01-01' +INTERVAL 1 DAY`,-('2000-01-01' + interval 1 day) AS `- ('2000-01-01' +INTERVAL 1 DAY)`,-'2000-01-01' + interval 1 day AS `(- '2000-01-01') +INTERVAL 1 DAY`
select - '2000-01-01' +INTERVAL 1 DAY, - ('2000-01-01' +INTERVAL 1 DAY), (- '2000-01-01') +INTERVAL 1 DAY union select * from v1;
- '2000-01-01' +INTERVAL 1 DAY - ('2000-01-01' +INTERVAL 1 DAY) (- '2000-01-01') +INTERVAL 1 DAY
NULL -20000102 NULL
create or replace view v1 as select - 2 + 3, - (2 + 3), (- 2) + 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 + 3 AS `- 2 + 3`,-(2 + 3) AS `- (2 + 3)`,-2 + 3 AS `(- 2) + 3`
select - 2 + 3, - (2 + 3), (- 2) + 3 union select * from v1;
- 2 + 3 - (2 + 3) (- 2) + 3
1 -5 1
create or replace view v1 as select - 2 - 3, - (2 - 3), (- 2) - 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 - 3 AS `- 2 - 3`,-(2 - 3) AS `- (2 - 3)`,-2 - 3 AS `(- 2) - 3`
select - 2 - 3, - (2 - 3), (- 2) - 3 union select * from v1;
- 2 - 3 - (2 - 3) (- 2) - 3
-5 1 -5
create or replace view v1 as select - 2 ^ 3, - (2 ^ 3), (- 2) ^ 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 ^ 3 AS `- 2 ^ 3`,-(2 ^ 3) AS `- (2 ^ 3)`,-2 ^ 3 AS `(- 2) ^ 3`
select - 2 ^ 3, - (2 ^ 3), (- 2) ^ 3 union select * from v1;
- 2 ^ 3 - (2 ^ 3) (- 2) ^ 3
18446744073709551613 -1 18446744073709551613
create or replace view v1 as select - 2 BETWEEN 1 AND 3, - (2 BETWEEN 1 AND 3), (- 2) BETWEEN 1 AND 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select -2 between 1 and 3 AS `- 2 BETWEEN 1 AND 3`,-(2 between 1 and 3) AS `- (2 BETWEEN 1 AND 3)`,-2 between 1 and 3 AS `(- 2) BETWEEN 1 AND 3`
select - 2 BETWEEN 1 AND 3, - (2 BETWEEN 1 AND 3), (- 2) BETWEEN 1 AND 3 union select * from v1;
- 2 BETWEEN 1 AND 3 - (2 BETWEEN 1 AND 3) (- 2) BETWEEN 1 AND 3
0 -1 0
create or replace view v1 as select ~ 2 IS TRUE, ~ (2 IS TRUE), (~ 2) IS TRUE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 is true AS `~ 2 IS TRUE`,~(2 is true) AS `~ (2 IS TRUE)`,~2 is true AS `(~ 2) IS TRUE`
select ~ 2 IS TRUE, ~ (2 IS TRUE), (~ 2) IS TRUE union select * from v1;
~ 2 IS TRUE ~ (2 IS TRUE) (~ 2) IS TRUE
1 18446744073709551614 1
create or replace view v1 as select charset(~ 2 COLLATE latin1_bin), charset(~ (2 COLLATE latin1_bin)), charset((~ 2) COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(~2 collate latin1_bin) AS `charset(~ 2 COLLATE latin1_bin)`,charset(~2 collate latin1_bin) AS `charset(~ (2 COLLATE latin1_bin))`,charset((~2) collate latin1_bin) AS `charset((~ 2) COLLATE latin1_bin)`
select charset(~ 2 COLLATE latin1_bin), charset(~ (2 COLLATE latin1_bin)), charset((~ 2) COLLATE latin1_bin) union select * from v1;
charset(~ 2 COLLATE latin1_bin) charset(~ (2 COLLATE latin1_bin)) charset((~ 2) COLLATE latin1_bin)
binary binary latin1
create or replace view v1 as select ~ 2 IN (0,1), ~ (2 IN (0,1)), (~ 2) IN (0,1);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 in (0,1) AS `~ 2 IN (0,1)`,~(2 in (0,1)) AS `~ (2 IN (0,1))`,~2 in (0,1) AS `(~ 2) IN (0,1)`
select ~ 2 IN (0,1), ~ (2 IN (0,1)), (~ 2) IN (0,1) union select * from v1;
~ 2 IN (0,1) ~ (2 IN (0,1)) (~ 2) IN (0,1)
0 18446744073709551615 0
create or replace view v1 as select ~ 2 OR 3, ~ (2 OR 3), (~ 2) OR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 or 3 AS `~ 2 OR 3`,~(2 or 3) AS `~ (2 OR 3)`,~2 or 3 AS `(~ 2) OR 3`
select ~ 2 OR 3, ~ (2 OR 3), (~ 2) OR 3 union select * from v1;
~ 2 OR 3 ~ (2 OR 3) (~ 2) OR 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 || 3, ~ (2 || 3), (~ 2) || 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 or 3 AS `~ 2 || 3`,~(2 or 3) AS `~ (2 || 3)`,~2 or 3 AS `(~ 2) || 3`
select ~ 2 || 3, ~ (2 || 3), (~ 2) || 3 union select * from v1;
~ 2 || 3 ~ (2 || 3) (~ 2) || 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 XOR 3, ~ (2 XOR 3), (~ 2) XOR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 xor 3 AS `~ 2 XOR 3`,~(2 xor 3) AS `~ (2 XOR 3)`,~2 xor 3 AS `(~ 2) XOR 3`
select ~ 2 XOR 3, ~ (2 XOR 3), (~ 2) XOR 3 union select * from v1;
~ 2 XOR 3 ~ (2 XOR 3) (~ 2) XOR 3
0 18446744073709551615 0
create or replace view v1 as select ~ 2 AND 3, ~ (2 AND 3), (~ 2) AND 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 and 3 AS `~ 2 AND 3`,~(2 and 3) AS `~ (2 AND 3)`,~2 and 3 AS `(~ 2) AND 3`
select ~ 2 AND 3, ~ (2 AND 3), (~ 2) AND 3 union select * from v1;
~ 2 AND 3 ~ (2 AND 3) (~ 2) AND 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 && 3, ~ (2 && 3), (~ 2) && 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 and 3 AS `~ 2 && 3`,~(2 and 3) AS `~ (2 && 3)`,~2 and 3 AS `(~ 2) && 3`
select ~ 2 && 3, ~ (2 && 3), (~ 2) && 3 union select * from v1;
~ 2 && 3 ~ (2 && 3) (~ 2) && 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 = 3, ~ (2 = 3), (~ 2) = 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 = 3 AS `~ 2 = 3`,~(2 = 3) AS `~ (2 = 3)`,~2 = 3 AS `(~ 2) = 3`
select ~ 2 = 3, ~ (2 = 3), (~ 2) = 3 union select * from v1;
~ 2 = 3 ~ (2 = 3) (~ 2) = 3
0 18446744073709551615 0
create or replace view v1 as select ~ 2 <=> 3, ~ (2 <=> 3), (~ 2) <=> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 <=> 3 AS `~ 2 <=> 3`,~(2 <=> 3) AS `~ (2 <=> 3)`,~2 <=> 3 AS `(~ 2) <=> 3`
select ~ 2 <=> 3, ~ (2 <=> 3), (~ 2) <=> 3 union select * from v1;
~ 2 <=> 3 ~ (2 <=> 3) (~ 2) <=> 3
0 18446744073709551615 0
create or replace view v1 as select ~ 2 >= 3, ~ (2 >= 3), (~ 2) >= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 >= 3 AS `~ 2 >= 3`,~(2 >= 3) AS `~ (2 >= 3)`,~2 >= 3 AS `(~ 2) >= 3`
select ~ 2 >= 3, ~ (2 >= 3), (~ 2) >= 3 union select * from v1;
~ 2 >= 3 ~ (2 >= 3) (~ 2) >= 3
1 18446744073709551615 1
create or replace view v1 as select ~ 2 <= 3, ~ (2 <= 3), (~ 2) <= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 <= 3 AS `~ 2 <= 3`,~(2 <= 3) AS `~ (2 <= 3)`,~2 <= 3 AS `(~ 2) <= 3`
select ~ 2 <= 3, ~ (2 <= 3), (~ 2) <= 3 union select * from v1;
~ 2 <= 3 ~ (2 <= 3) (~ 2) <= 3
0 18446744073709551614 0
create or replace view v1 as select ~ 2 < 3, ~ (2 < 3), (~ 2) < 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 < 3 AS `~ 2 < 3`,~(2 < 3) AS `~ (2 < 3)`,~2 < 3 AS `(~ 2) < 3`
select ~ 2 < 3, ~ (2 < 3), (~ 2) < 3 union select * from v1;
~ 2 < 3 ~ (2 < 3) (~ 2) < 3
0 18446744073709551614 0
create or replace view v1 as select ~ 2 <> 3, ~ (2 <> 3), (~ 2) <> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 <> 3 AS `~ 2 <> 3`,~(2 <> 3) AS `~ (2 <> 3)`,~2 <> 3 AS `(~ 2) <> 3`
select ~ 2 <> 3, ~ (2 <> 3), (~ 2) <> 3 union select * from v1;
~ 2 <> 3 ~ (2 <> 3) (~ 2) <> 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 > 3, ~ (2 > 3), (~ 2) > 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 > 3 AS `~ 2 > 3`,~(2 > 3) AS `~ (2 > 3)`,~2 > 3 AS `(~ 2) > 3`
select ~ 2 > 3, ~ (2 > 3), (~ 2) > 3 union select * from v1;
~ 2 > 3 ~ (2 > 3) (~ 2) > 3
1 18446744073709551615 1
create or replace view v1 as select ~ 2 != 3, ~ (2 != 3), (~ 2) != 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 <> 3 AS `~ 2 != 3`,~(2 <> 3) AS `~ (2 != 3)`,~2 <> 3 AS `(~ 2) != 3`
select ~ 2 != 3, ~ (2 != 3), (~ 2) != 3 union select * from v1;
~ 2 != 3 ~ (2 != 3) (~ 2) != 3
1 18446744073709551614 1
create or replace view v1 as select ~ 2 LIKE 3, ~ (2 LIKE 3), (~ 2) LIKE 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 like 3 AS `~ 2 LIKE 3`,~(2 like 3) AS `~ (2 LIKE 3)`,~2 like 3 AS `(~ 2) LIKE 3`
select ~ 2 LIKE 3, ~ (2 LIKE 3), (~ 2) LIKE 3 union select * from v1;
~ 2 LIKE 3 ~ (2 LIKE 3) (~ 2) LIKE 3
0 18446744073709551615 0
create or replace view v1 as select ~ 2 REGEXP 3, ~ (2 REGEXP 3), (~ 2) REGEXP 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 regexp 3 AS `~ 2 REGEXP 3`,~(2 regexp 3) AS `~ (2 REGEXP 3)`,~2 regexp 3 AS `(~ 2) REGEXP 3`
select ~ 2 REGEXP 3, ~ (2 REGEXP 3), (~ 2) REGEXP 3 union select * from v1;
~ 2 REGEXP 3 ~ (2 REGEXP 3) (~ 2) REGEXP 3
1 18446744073709551615 1
create or replace view v1 as select ~ 2 | 3, ~ (2 | 3), (~ 2) | 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 | 3 AS `~ 2 | 3`,~(2 | 3) AS `~ (2 | 3)`,~2 | 3 AS `(~ 2) | 3`
select ~ 2 | 3, ~ (2 | 3), (~ 2) | 3 union select * from v1;
~ 2 | 3 ~ (2 | 3) (~ 2) | 3
18446744073709551615 18446744073709551612 18446744073709551615
create or replace view v1 as select ~ 2 & 3, ~ (2 & 3), (~ 2) & 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 & 3 AS `~ 2 & 3`,~(2 & 3) AS `~ (2 & 3)`,~2 & 3 AS `(~ 2) & 3`
select ~ 2 & 3, ~ (2 & 3), (~ 2) & 3 union select * from v1;
~ 2 & 3 ~ (2 & 3) (~ 2) & 3
1 18446744073709551613 1
create or replace view v1 as select ~ 2 << 3, ~ (2 << 3), (~ 2) << 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 << 3 AS `~ 2 << 3`,~(2 << 3) AS `~ (2 << 3)`,~2 << 3 AS `(~ 2) << 3`
select ~ 2 << 3, ~ (2 << 3), (~ 2) << 3 union select * from v1;
~ 2 << 3 ~ (2 << 3) (~ 2) << 3
18446744073709551592 18446744073709551599 18446744073709551592
create or replace view v1 as select ~ 2 >> 3, ~ (2 >> 3), (~ 2) >> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 >> 3 AS `~ 2 >> 3`,~(2 >> 3) AS `~ (2 >> 3)`,~2 >> 3 AS `(~ 2) >> 3`
select ~ 2 >> 3, ~ (2 >> 3), (~ 2) >> 3 union select * from v1;
~ 2 >> 3 ~ (2 >> 3) (~ 2) >> 3
2305843009213693951 18446744073709551615 2305843009213693951
create or replace view v1 as select ~ '2000-01-01' +INTERVAL 1 DAY, ~ ('2000-01-01' +INTERVAL 1 DAY), (~ '2000-01-01') +INTERVAL 1 DAY;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~'2000-01-01' + interval 1 day AS `~ '2000-01-01' +INTERVAL 1 DAY`,~('2000-01-01' + interval 1 day) AS `~ ('2000-01-01' +INTERVAL 1 DAY)`,~'2000-01-01' + interval 1 day AS `(~ '2000-01-01') +INTERVAL 1 DAY`
select ~ '2000-01-01' +INTERVAL 1 DAY, ~ ('2000-01-01' +INTERVAL 1 DAY), (~ '2000-01-01') +INTERVAL 1 DAY union select * from v1;
~ '2000-01-01' +INTERVAL 1 DAY ~ ('2000-01-01' +INTERVAL 1 DAY) (~ '2000-01-01') +INTERVAL 1 DAY
NULL 18446744073689551513 NULL
create or replace view v1 as select ~ 10000 + 3, ~ (10000 + 3), (~ 10000) + 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~10000 + 3 AS `~ 10000 + 3`,~(10000 + 3) AS `~ (10000 + 3)`,~10000 + 3 AS `(~ 10000) + 3`
select ~ 10000 + 3, ~ (10000 + 3), (~ 10000) + 3 union select * from v1;
~ 10000 + 3 ~ (10000 + 3) (~ 10000) + 3
18446744073709541618 18446744073709541612 18446744073709541618
create or replace view v1 as select ~ 2 - 3, ~ (2 - 3), (~ 2) - 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 - 3 AS `~ 2 - 3`,~(2 - 3) AS `~ (2 - 3)`,~2 - 3 AS `(~ 2) - 3`
select ~ 2 - 3, ~ (2 - 3), (~ 2) - 3 union select * from v1;
~ 2 - 3 ~ (2 - 3) (~ 2) - 3
18446744073709551610 0 18446744073709551610
create or replace view v1 as select ~ 10000000000000000000 * 2, ~ (100 * 2), (~ 10000000000000000000) * 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~10000000000000000000 * 2 AS `~ 10000000000000000000 * 2`,~(100 * 2) AS `~ (100 * 2)`,~10000000000000000000 * 2 AS `(~ 10000000000000000000) * 2`
select ~ 10000000000000000000 * 2, ~ (100 * 2), (~ 10000000000000000000) * 2 union select * from v1;
~ 10000000000000000000 * 2 ~ (100 * 2) (~ 10000000000000000000) * 2
16893488147419103230 18446744073709551415 16893488147419103230
create or replace view v1 as select ~ 2 / 3, ~ (2 / 3), (~ 2) / 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 / 3 AS `~ 2 / 3`,~(2 / 3) AS `~ (2 / 3)`,~2 / 3 AS `(~ 2) / 3`
select ~ 2 / 3, ~ (2 / 3), (~ 2) / 3 union select * from v1;
~ 2 / 3 ~ (2 / 3) (~ 2) / 3
6148914691236517204.3333 18446744073709551614 6148914691236517204.3333
create or replace view v1 as select ~ 2 DIV 3, ~ (2 DIV 3), (~ 2) DIV 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 DIV 3 AS `~ 2 DIV 3`,~(2 DIV 3) AS `~ (2 DIV 3)`,~2 DIV 3 AS `(~ 2) DIV 3`
select ~ 2 DIV 3, ~ (2 DIV 3), (~ 2) DIV 3 union select * from v1;
~ 2 DIV 3 ~ (2 DIV 3) (~ 2) DIV 3
6148914691236517204 18446744073709551615 6148914691236517204
create or replace view v1 as select ~ 2 MOD 3, ~ (2 MOD 3), (~ 2) MOD 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 MOD 3 AS `~ 2 MOD 3`,~(2 MOD 3) AS `~ (2 MOD 3)`,~2 MOD 3 AS `(~ 2) MOD 3`
select ~ 2 MOD 3, ~ (2 MOD 3), (~ 2) MOD 3 union select * from v1;
~ 2 MOD 3 ~ (2 MOD 3) (~ 2) MOD 3
1 18446744073709551613 1
create or replace view v1 as select ~ 2 % 3, ~ (2 % 3), (~ 2) % 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 MOD 3 AS `~ 2 % 3`,~(2 MOD 3) AS `~ (2 % 3)`,~2 MOD 3 AS `(~ 2) % 3`
select ~ 2 % 3, ~ (2 % 3), (~ 2) % 3 union select * from v1;
~ 2 % 3 ~ (2 % 3) (~ 2) % 3
1 18446744073709551613 1
create or replace view v1 as select ~ 2 BETWEEN 1 AND 3, ~ (2 BETWEEN 1 AND 3), (~ 2) BETWEEN 1 AND 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select ~2 between 1 and 3 AS `~ 2 BETWEEN 1 AND 3`,~(2 between 1 and 3) AS `~ (2 BETWEEN 1 AND 3)`,~2 between 1 and 3 AS `(~ 2) BETWEEN 1 AND 3`
select ~ 2 BETWEEN 1 AND 3, ~ (2 BETWEEN 1 AND 3), (~ 2) BETWEEN 1 AND 3 union select * from v1;
~ 2 BETWEEN 1 AND 3 ~ (2 BETWEEN 1 AND 3) (~ 2) BETWEEN 1 AND 3
0 18446744073709551614 0
create or replace view v1 as select charset(! 2 COLLATE latin1_bin), charset(! (2 COLLATE latin1_bin)), charset((! 2) COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(!2 collate latin1_bin) AS `charset(! 2 COLLATE latin1_bin)`,charset(!2 collate latin1_bin) AS `charset(! (2 COLLATE latin1_bin))`,charset((!2) collate latin1_bin) AS `charset((! 2) COLLATE latin1_bin)`
select charset(! 2 COLLATE latin1_bin), charset(! (2 COLLATE latin1_bin)), charset((! 2) COLLATE latin1_bin) union select * from v1;
charset(! 2 COLLATE latin1_bin) charset(! (2 COLLATE latin1_bin)) charset((! 2) COLLATE latin1_bin)
binary binary latin1
create or replace view v1 as select ! 2 IN (0,2), ! (2 IN (0,2)), (! 2) IN (0,2);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 in (0,2) AS `! 2 IN (0,2)`,2 not in (0,2) AS `! (2 IN (0,2))`,!2 in (0,2) AS `(! 2) IN (0,2)`
select ! 2 IN (0,2), ! (2 IN (0,2)), (! 2) IN (0,2) union select * from v1;
! 2 IN (0,2) ! (2 IN (0,2)) (! 2) IN (0,2)
1 0 1
create or replace view v1 as select ! 2 OR 3, ! (2 OR 3), (! 2) OR 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 or 3 AS `! 2 OR 3`,!2 and !3 AS `! (2 OR 3)`,!2 or 3 AS `(! 2) OR 3`
select ! 2 OR 3, ! (2 OR 3), (! 2) OR 3 union select * from v1;
! 2 OR 3 ! (2 OR 3) (! 2) OR 3
1 0 1
create or replace view v1 as select ! 2 || 3, ! (2 || 3), (! 2) || 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 or 3 AS `! 2 || 3`,!2 and !3 AS `! (2 || 3)`,!2 or 3 AS `(! 2) || 3`
select ! 2 || 3, ! (2 || 3), (! 2) || 3 union select * from v1;
! 2 || 3 ! (2 || 3) (! 2) || 3
1 0 1
create or replace view v1 as select ! 2 AND 0, ! (2 AND 0), (! 2) AND 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 and 0 AS `! 2 AND 0`,!2 or !0 AS `! (2 AND 0)`,!2 and 0 AS `(! 2) AND 0`
select ! 2 AND 0, ! (2 AND 0), (! 2) AND 0 union select * from v1;
! 2 AND 0 ! (2 AND 0) (! 2) AND 0
0 1 0
create or replace view v1 as select ! 2 && 0, ! (2 && 0), (! 2) && 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 and 0 AS `! 2 && 0`,!2 or !0 AS `! (2 && 0)`,!2 and 0 AS `(! 2) && 0`
select ! 2 && 0, ! (2 && 0), (! 2) && 0 union select * from v1;
! 2 && 0 ! (2 && 0) (! 2) && 0
0 1 0
create or replace view v1 as select ! 2 = 3, ! (2 = 3), (! 2) = 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 = 3 AS `! 2 = 3`,2 <> 3 AS `! (2 = 3)`,!2 = 3 AS `(! 2) = 3`
select ! 2 = 3, ! (2 = 3), (! 2) = 3 union select * from v1;
! 2 = 3 ! (2 = 3) (! 2) = 3
0 1 0
create or replace view v1 as select ! 2 <=> 3, ! (2 <=> 3), (! 2) <=> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 <=> 3 AS `! 2 <=> 3`,!(2 <=> 3) AS `! (2 <=> 3)`,!2 <=> 3 AS `(! 2) <=> 3`
select ! 2 <=> 3, ! (2 <=> 3), (! 2) <=> 3 union select * from v1;
! 2 <=> 3 ! (2 <=> 3) (! 2) <=> 3
0 1 0
create or replace view v1 as select ! 2 >= 3, ! (2 >= 3), (! 2) >= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 >= 3 AS `! 2 >= 3`,2 < 3 AS `! (2 >= 3)`,!2 >= 3 AS `(! 2) >= 3`
select ! 2 >= 3, ! (2 >= 3), (! 2) >= 3 union select * from v1;
! 2 >= 3 ! (2 >= 3) (! 2) >= 3
0 1 0
create or replace view v1 as select ! 2 <= 3, ! (2 <= 3), (! 2) <= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 <= 3 AS `! 2 <= 3`,2 > 3 AS `! (2 <= 3)`,!2 <= 3 AS `(! 2) <= 3`
select ! 2 <= 3, ! (2 <= 3), (! 2) <= 3 union select * from v1;
! 2 <= 3 ! (2 <= 3) (! 2) <= 3
1 0 1
create or replace view v1 as select ! 2 < 3, ! (2 < 3), (! 2) < 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 < 3 AS `! 2 < 3`,2 >= 3 AS `! (2 < 3)`,!2 < 3 AS `(! 2) < 3`
select ! 2 < 3, ! (2 < 3), (! 2) < 3 union select * from v1;
! 2 < 3 ! (2 < 3) (! 2) < 3
1 0 1
create or replace view v1 as select ! 2 <> 3, ! (2 <> 3), (! 2) <> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 <> 3 AS `! 2 <> 3`,2 = 3 AS `! (2 <> 3)`,!2 <> 3 AS `(! 2) <> 3`
select ! 2 <> 3, ! (2 <> 3), (! 2) <> 3 union select * from v1;
! 2 <> 3 ! (2 <> 3) (! 2) <> 3
1 0 1
create or replace view v1 as select ! 2 > 3, ! (2 > 3), (! 2) > 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 > 3 AS `! 2 > 3`,2 <= 3 AS `! (2 > 3)`,!2 > 3 AS `(! 2) > 3`
select ! 2 > 3, ! (2 > 3), (! 2) > 3 union select * from v1;
! 2 > 3 ! (2 > 3) (! 2) > 3
0 1 0
create or replace view v1 as select ! 2 != 3, ! (2 != 3), (! 2) != 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 <> 3 AS `! 2 != 3`,2 = 3 AS `! (2 != 3)`,!2 <> 3 AS `(! 2) != 3`
select ! 2 != 3, ! (2 != 3), (! 2) != 3 union select * from v1;
! 2 != 3 ! (2 != 3) (! 2) != 3
1 0 1
create or replace view v1 as select ! 2 LIKE 3, ! (2 LIKE 3), (! 2) LIKE 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 like 3 AS `! 2 LIKE 3`,2 not like 3 AS `! (2 LIKE 3)`,!2 like 3 AS `(! 2) LIKE 3`
select ! 2 LIKE 3, ! (2 LIKE 3), (! 2) LIKE 3 union select * from v1;
! 2 LIKE 3 ! (2 LIKE 3) (! 2) LIKE 3
0 1 0
create or replace view v1 as select ! 2 REGEXP 3, ! (2 REGEXP 3), (! 2) REGEXP 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 regexp 3 AS `! 2 REGEXP 3`,!(2 regexp 3) AS `! (2 REGEXP 3)`,!2 regexp 3 AS `(! 2) REGEXP 3`
select ! 2 REGEXP 3, ! (2 REGEXP 3), (! 2) REGEXP 3 union select * from v1;
! 2 REGEXP 3 ! (2 REGEXP 3) (! 2) REGEXP 3
0 1 0
create or replace view v1 as select ! 2 | 3, ! (2 | 3), (! 2) | 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 | 3 AS `! 2 | 3`,!(2 | 3) AS `! (2 | 3)`,!2 | 3 AS `(! 2) | 3`
select ! 2 | 3, ! (2 | 3), (! 2) | 3 union select * from v1;
! 2 | 3 ! (2 | 3) (! 2) | 3
3 0 3
create or replace view v1 as select ! 2 & 0, ! (2 & 0), (! 2) & 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 & 0 AS `! 2 & 0`,!(2 & 0) AS `! (2 & 0)`,!2 & 0 AS `(! 2) & 0`
select ! 2 & 0, ! (2 & 0), (! 2) & 0 union select * from v1;
! 2 & 0 ! (2 & 0) (! 2) & 0
0 1 0
create or replace view v1 as select ! 0 << 3, ! (0 << 3), (! 0) << 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !0 << 3 AS `! 0 << 3`,!(0 << 3) AS `! (0 << 3)`,!0 << 3 AS `(! 0) << 3`
select ! 0 << 3, ! (0 << 3), (! 0) << 3 union select * from v1;
! 0 << 3 ! (0 << 3) (! 0) << 3
8 1 8
create or replace view v1 as select ! 2 >> 3, ! (2 >> 3), (! 2) >> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 >> 3 AS `! 2 >> 3`,!(2 >> 3) AS `! (2 >> 3)`,!2 >> 3 AS `(! 2) >> 3`
select ! 2 >> 3, ! (2 >> 3), (! 2) >> 3 union select * from v1;
! 2 >> 3 ! (2 >> 3) (! 2) >> 3
0 1 0
create or replace view v1 as select ! '2000-01-01' +INTERVAL 1 DAY, ! ('2000-01-01' +INTERVAL 1 DAY), (! '2000-01-01') +INTERVAL 1 DAY;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !'2000-01-01' + interval 1 day AS `! '2000-01-01' +INTERVAL 1 DAY`,!('2000-01-01' + interval 1 day) AS `! ('2000-01-01' +INTERVAL 1 DAY)`,!'2000-01-01' + interval 1 day AS `(! '2000-01-01') +INTERVAL 1 DAY`
select ! '2000-01-01' +INTERVAL 1 DAY, ! ('2000-01-01' +INTERVAL 1 DAY), (! '2000-01-01') +INTERVAL 1 DAY union select * from v1;
! '2000-01-01' +INTERVAL 1 DAY ! ('2000-01-01' +INTERVAL 1 DAY) (! '2000-01-01') +INTERVAL 1 DAY
NULL 0 NULL
create or replace view v1 as select ! 2 + 3, ! (2 + 3), (! 2) + 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 + 3 AS `! 2 + 3`,!(2 + 3) AS `! (2 + 3)`,!2 + 3 AS `(! 2) + 3`
select ! 2 + 3, ! (2 + 3), (! 2) + 3 union select * from v1;
! 2 + 3 ! (2 + 3) (! 2) + 3
3 0 3
create or replace view v1 as select ! 2 - 3, ! (2 - 3), (! 2) - 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 - 3 AS `! 2 - 3`,!(2 - 3) AS `! (2 - 3)`,!2 - 3 AS `(! 2) - 3`
select ! 2 - 3, ! (2 - 3), (! 2) - 3 union select * from v1;
! 2 - 3 ! (2 - 3) (! 2) - 3
-3 0 -3
create or replace view v1 as select ! 0 * 3, ! (0 * 3), (! 0) * 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !0 * 3 AS `! 0 * 3`,!(0 * 3) AS `! (0 * 3)`,!0 * 3 AS `(! 0) * 3`
select ! 0 * 3, ! (0 * 3), (! 0) * 3 union select * from v1;
! 0 * 3 ! (0 * 3) (! 0) * 3
3 1 3
create or replace view v1 as select ! 0 / 3, ! (0 / 3), (! 0) / 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !0 / 3 AS `! 0 / 3`,!(0 / 3) AS `! (0 / 3)`,!0 / 3 AS `(! 0) / 3`
select ! 0 / 3, ! (0 / 3), (! 0) / 3 union select * from v1;
! 0 / 3 ! (0 / 3) (! 0) / 3
0.3333 1 0.3333
create or replace view v1 as select ! 2 DIV 3, ! (2 DIV 3), (! 2) DIV 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 DIV 3 AS `! 2 DIV 3`,!(2 DIV 3) AS `! (2 DIV 3)`,!2 DIV 3 AS `(! 2) DIV 3`
select ! 2 DIV 3, ! (2 DIV 3), (! 2) DIV 3 union select * from v1;
! 2 DIV 3 ! (2 DIV 3) (! 2) DIV 3
0 1 0
create or replace view v1 as select ! 6 MOD 3, ! (6 MOD 3), (! 6) MOD 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !6 MOD 3 AS `! 6 MOD 3`,!(6 MOD 3) AS `! (6 MOD 3)`,!6 MOD 3 AS `(! 6) MOD 3`
select ! 6 MOD 3, ! (6 MOD 3), (! 6) MOD 3 union select * from v1;
! 6 MOD 3 ! (6 MOD 3) (! 6) MOD 3
0 1 0
create or replace view v1 as select ! 6 % 3, ! (6 % 3), (! 6) % 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !6 MOD 3 AS `! 6 % 3`,!(6 MOD 3) AS `! (6 % 3)`,!6 MOD 3 AS `(! 6) % 3`
select ! 6 % 3, ! (6 % 3), (! 6) % 3 union select * from v1;
! 6 % 3 ! (6 % 3) (! 6) % 3
0 1 0
create or replace view v1 as select ! 2 ^ 3, ! (2 ^ 3), (! 2) ^ 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 ^ 3 AS `! 2 ^ 3`,!(2 ^ 3) AS `! (2 ^ 3)`,!2 ^ 3 AS `(! 2) ^ 3`
select ! 2 ^ 3, ! (2 ^ 3), (! 2) ^ 3 union select * from v1;
! 2 ^ 3 ! (2 ^ 3) (! 2) ^ 3
3 0 3
create or replace view v1 as select ! 2 BETWEEN 3 AND 4, ! (2 BETWEEN 3 AND 4), (! 2) BETWEEN 3 AND 4;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select !2 between 3 and 4 AS `! 2 BETWEEN 3 AND 4`,2 not between 3 and 4 AS `! (2 BETWEEN 3 AND 4)`,!2 between 3 and 4 AS `(! 2) BETWEEN 3 AND 4`
select ! 2 BETWEEN 3 AND 4, ! (2 BETWEEN 3 AND 4), (! 2) BETWEEN 3 AND 4 union select * from v1;
! 2 BETWEEN 3 AND 4 ! (2 BETWEEN 3 AND 4) (! 2) BETWEEN 3 AND 4
0 1 0
create or replace view v1 as select CHARSET(BINARY '2' COLLATE latin1_bin), CHARSET(BINARY ('2' COLLATE latin1_bin)), 'error'/*CHARSET((BINARY '2') COLLATE latin1_bin)*/;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(cast('2' collate latin1_bin as char charset binary)) AS `CHARSET(BINARY '2' COLLATE latin1_bin)`,charset(cast('2' collate latin1_bin as char charset binary)) AS `CHARSET(BINARY ('2' COLLATE latin1_bin))`,'error' AS `error`
select CHARSET(BINARY '2' COLLATE latin1_bin), CHARSET(BINARY ('2' COLLATE latin1_bin)), 'error'/*CHARSET((BINARY '2') COLLATE latin1_bin)*/ union select * from v1;
CHARSET(BINARY '2' COLLATE latin1_bin) CHARSET(BINARY ('2' COLLATE latin1_bin)) error
binary binary error
create or replace view v1 as select BINARY 'c' IN ('C','X'), BINARY ('c' IN ('C','X')), (BINARY 'c') IN ('C','X');
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) in ('C','X') AS `BINARY 'c' IN ('C','X')`,cast('c' in ('C','X') as char charset binary) AS `BINARY ('c' IN ('C','X'))`,cast('c' as char charset binary) in ('C','X') AS `(BINARY 'c') IN ('C','X')`
select BINARY 'c' IN ('C','X'), BINARY ('c' IN ('C','X')), (BINARY 'c') IN ('C','X') union select * from v1;
BINARY 'c' IN ('C','X') BINARY ('c' IN ('C','X')) (BINARY 'c') IN ('C','X')
0 1 0
create or replace view v1 as select BINARY 'c' = 'C', BINARY ('c' = 'C'), (BINARY 'c') = 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) = 'C' AS `BINARY 'c' = 'C'`,cast('c' = 'C' as char charset binary) AS `BINARY ('c' = 'C')`,cast('c' as char charset binary) = 'C' AS `(BINARY 'c') = 'C'`
select BINARY 'c' = 'C', BINARY ('c' = 'C'), (BINARY 'c') = 'C' union select * from v1;
BINARY 'c' = 'C' BINARY ('c' = 'C') (BINARY 'c') = 'C'
0 1 0
create or replace view v1 as select BINARY 'c' <=> 'C', BINARY ('c' <=> 'C'), (BINARY 'c') <=> 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) <=> 'C' AS `BINARY 'c' <=> 'C'`,cast('c' <=> 'C' as char charset binary) AS `BINARY ('c' <=> 'C')`,cast('c' as char charset binary) <=> 'C' AS `(BINARY 'c') <=> 'C'`
select BINARY 'c' <=> 'C', BINARY ('c' <=> 'C'), (BINARY 'c') <=> 'C' union select * from v1;
BINARY 'c' <=> 'C' BINARY ('c' <=> 'C') (BINARY 'c') <=> 'C'
0 1 0
create or replace view v1 as select BINARY 'c' >= 'D', BINARY ('c' >= 'D'), (BINARY 'c') >= 'D';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) >= 'D' AS `BINARY 'c' >= 'D'`,cast('c' >= 'D' as char charset binary) AS `BINARY ('c' >= 'D')`,cast('c' as char charset binary) >= 'D' AS `(BINARY 'c') >= 'D'`
select BINARY 'c' >= 'D', BINARY ('c' >= 'D'), (BINARY 'c') >= 'D' union select * from v1;
BINARY 'c' >= 'D' BINARY ('c' >= 'D') (BINARY 'c') >= 'D'
1 0 1
create or replace view v1 as select BINARY 'c' <= 'C', BINARY ('c' <= 'C'), (BINARY 'c') <= 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) <= 'C' AS `BINARY 'c' <= 'C'`,cast('c' <= 'C' as char charset binary) AS `BINARY ('c' <= 'C')`,cast('c' as char charset binary) <= 'C' AS `(BINARY 'c') <= 'C'`
select BINARY 'c' <= 'C', BINARY ('c' <= 'C'), (BINARY 'c') <= 'C' union select * from v1;
BINARY 'c' <= 'C' BINARY ('c' <= 'C') (BINARY 'c') <= 'C'
0 1 0
create or replace view v1 as select BINARY 'c' < 'D', BINARY ('c' < 'D'), (BINARY 'c') < 'D';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) < 'D' AS `BINARY 'c' < 'D'`,cast('c' < 'D' as char charset binary) AS `BINARY ('c' < 'D')`,cast('c' as char charset binary) < 'D' AS `(BINARY 'c') < 'D'`
select BINARY 'c' < 'D', BINARY ('c' < 'D'), (BINARY 'c') < 'D' union select * from v1;
BINARY 'c' < 'D' BINARY ('c' < 'D') (BINARY 'c') < 'D'
0 1 0
create or replace view v1 as select BINARY 'c' <> 'C', BINARY ('c' <> 'C'), (BINARY 'c') <> 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) <> 'C' AS `BINARY 'c' <> 'C'`,cast('c' <> 'C' as char charset binary) AS `BINARY ('c' <> 'C')`,cast('c' as char charset binary) <> 'C' AS `(BINARY 'c') <> 'C'`
select BINARY 'c' <> 'C', BINARY ('c' <> 'C'), (BINARY 'c') <> 'C' union select * from v1;
BINARY 'c' <> 'C' BINARY ('c' <> 'C') (BINARY 'c') <> 'C'
1 0 1
create or replace view v1 as select BINARY 'c' > 'C', BINARY ('c' > 'C'), (BINARY 'c') > 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) > 'C' AS `BINARY 'c' > 'C'`,cast('c' > 'C' as char charset binary) AS `BINARY ('c' > 'C')`,cast('c' as char charset binary) > 'C' AS `(BINARY 'c') > 'C'`
select BINARY 'c' > 'C', BINARY ('c' > 'C'), (BINARY 'c') > 'C' union select * from v1;
BINARY 'c' > 'C' BINARY ('c' > 'C') (BINARY 'c') > 'C'
1 0 1
create or replace view v1 as select BINARY 'c' != 'C', BINARY ('c' != 'C'), (BINARY 'c') != 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) <> 'C' AS `BINARY 'c' != 'C'`,cast('c' <> 'C' as char charset binary) AS `BINARY ('c' != 'C')`,cast('c' as char charset binary) <> 'C' AS `(BINARY 'c') != 'C'`
select BINARY 'c' != 'C', BINARY ('c' != 'C'), (BINARY 'c') != 'C' union select * from v1;
BINARY 'c' != 'C' BINARY ('c' != 'C') (BINARY 'c') != 'C'
1 0 1
create or replace view v1 as select BINARY 'c' LIKE 'C', BINARY ('c' LIKE 'C'), (BINARY 'c') LIKE 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) like 'C' AS `BINARY 'c' LIKE 'C'`,cast('c' like 'C' as char charset binary) AS `BINARY ('c' LIKE 'C')`,cast('c' as char charset binary) like 'C' AS `(BINARY 'c') LIKE 'C'`
select BINARY 'c' LIKE 'C', BINARY ('c' LIKE 'C'), (BINARY 'c') LIKE 'C' union select * from v1;
BINARY 'c' LIKE 'C' BINARY ('c' LIKE 'C') (BINARY 'c') LIKE 'C'
0 1 0
create or replace view v1 as select BINARY 'c' REGEXP 'C', BINARY ('c' REGEXP 'C'), (BINARY 'c') REGEXP 'C';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) regexp 'C' AS `BINARY 'c' REGEXP 'C'`,cast('c' regexp 'C' as char charset binary) AS `BINARY ('c' REGEXP 'C')`,cast('c' as char charset binary) regexp 'C' AS `(BINARY 'c') REGEXP 'C'`
select BINARY 'c' REGEXP 'C', BINARY ('c' REGEXP 'C'), (BINARY 'c') REGEXP 'C' union select * from v1;
BINARY 'c' REGEXP 'C' BINARY ('c' REGEXP 'C') (BINARY 'c') REGEXP 'C'
0 1 0
create or replace view v1 as select BINARY 'c' BETWEEN 'A' AND 'D', BINARY ('c' BETWEEN 'A' AND 'D'), (BINARY 'c') BETWEEN 'A' AND 'D';
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select cast('c' as char charset binary) between 'A' and 'D' AS `BINARY 'c' BETWEEN 'A' AND 'D'`,cast('c' between 'A' and 'D' as char charset binary) AS `BINARY ('c' BETWEEN 'A' AND 'D')`,cast('c' as char charset binary) between 'A' and 'D' AS `(BINARY 'c') BETWEEN 'A' AND 'D'`
select BINARY 'c' BETWEEN 'A' AND 'D', BINARY ('c' BETWEEN 'A' AND 'D'), (BINARY 'c') BETWEEN 'A' AND 'D' union select * from v1;
BINARY 'c' BETWEEN 'A' AND 'D' BINARY ('c' BETWEEN 'A' AND 'D') (BINARY 'c') BETWEEN 'A' AND 'D'
0 1 0
create or replace view v1 as select 2 OR 3 IS FALSE, 2 OR (3 IS FALSE), (2 OR 3) IS FALSE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 is false AS `2 OR 3 IS FALSE`,2 or 3 is false AS `2 OR (3 IS FALSE)`,(2 or 3) is false AS `(2 OR 3) IS FALSE`
select 2 OR 3 IS FALSE, 2 OR (3 IS FALSE), (2 OR 3) IS FALSE union select * from v1;
2 OR 3 IS FALSE 2 OR (3 IS FALSE) (2 OR 3) IS FALSE
1 1 0
create or replace view v1 as select charset(2 OR 3 COLLATE latin1_bin), charset(2 OR (3 COLLATE latin1_bin)), charset((2 OR 3) COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(2 or 3 collate latin1_bin) AS `charset(2 OR 3 COLLATE latin1_bin)`,charset(2 or 3 collate latin1_bin) AS `charset(2 OR (3 COLLATE latin1_bin))`,charset((2 or 3) collate latin1_bin) AS `charset((2 OR 3) COLLATE latin1_bin)`
select charset(2 OR 3 COLLATE latin1_bin), charset(2 OR (3 COLLATE latin1_bin)), charset((2 OR 3) COLLATE latin1_bin) union select * from v1;
charset(2 OR 3 COLLATE latin1_bin) charset(2 OR (3 COLLATE latin1_bin)) charset((2 OR 3) COLLATE latin1_bin)
binary binary latin1
create or replace view v1 as select 0 OR 3 IN (3,10), 0 OR (3 IN (3,10)), (0 OR 3) IN (3,10);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 3 in (3,10) AS `0 OR 3 IN (3,10)`,0 or 3 in (3,10) AS `0 OR (3 IN (3,10))`,(0 or 3) in (3,10) AS `(0 OR 3) IN (3,10)`
select 0 OR 3 IN (3,10), 0 OR (3 IN (3,10)), (0 OR 3) IN (3,10) union select * from v1;
0 OR 3 IN (3,10) 0 OR (3 IN (3,10)) (0 OR 3) IN (3,10)
1 1 0
create or replace view v1 as select 1 OR 0 XOR 1, 1 OR (0 XOR 1), (1 OR 0) XOR 1;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 1 or 0 xor 1 AS `1 OR 0 XOR 1`,1 or 0 xor 1 AS `1 OR (0 XOR 1)`,(1 or 0) xor 1 AS `(1 OR 0) XOR 1`
select 1 OR 0 XOR 1, 1 OR (0 XOR 1), (1 OR 0) XOR 1 union select * from v1;
1 OR 0 XOR 1 1 OR (0 XOR 1) (1 OR 0) XOR 1
1 1 0
create or replace view v1 as select 1 OR 1 AND 0, 1 OR (1 AND 0), (1 OR 1) AND 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 1 or 1 and 0 AS `1 OR 1 AND 0`,1 or 1 and 0 AS `1 OR (1 AND 0)`,(1 or 1) and 0 AS `(1 OR 1) AND 0`
select 1 OR 1 AND 0, 1 OR (1 AND 0), (1 OR 1) AND 0 union select * from v1;
1 OR 1 AND 0 1 OR (1 AND 0) (1 OR 1) AND 0
1 1 0
create or replace view v1 as select 1 OR 1 && 0, 1 OR (1 && 0), (1 OR 1) && 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 1 or 1 and 0 AS `1 OR 1 && 0`,1 or 1 and 0 AS `1 OR (1 && 0)`,(1 or 1) and 0 AS `(1 OR 1) && 0`
select 1 OR 1 && 0, 1 OR (1 && 0), (1 OR 1) && 0 union select * from v1;
1 OR 1 && 0 1 OR (1 && 0) (1 OR 1) && 0
1 1 0
create or replace view v1 as select 2 OR 3 = 3, 2 OR (3 = 3), (2 OR 3) = 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 = 3 AS `2 OR 3 = 3`,2 or 3 = 3 AS `2 OR (3 = 3)`,(2 or 3) = 3 AS `(2 OR 3) = 3`
select 2 OR 3 = 3, 2 OR (3 = 3), (2 OR 3) = 3 union select * from v1;
2 OR 3 = 3 2 OR (3 = 3) (2 OR 3) = 3
1 1 0
create or replace view v1 as select 2 OR 3 <=> 3, 2 OR (3 <=> 3), (2 OR 3) <=> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 <=> 3 AS `2 OR 3 <=> 3`,2 or 3 <=> 3 AS `2 OR (3 <=> 3)`,(2 or 3) <=> 3 AS `(2 OR 3) <=> 3`
select 2 OR 3 <=> 3, 2 OR (3 <=> 3), (2 OR 3) <=> 3 union select * from v1;
2 OR 3 <=> 3 2 OR (3 <=> 3) (2 OR 3) <=> 3
1 1 0
create or replace view v1 as select 2 OR 3 >= 3, 2 OR (3 >= 3), (2 OR 3) >= 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 >= 3 AS `2 OR 3 >= 3`,2 or 3 >= 3 AS `2 OR (3 >= 3)`,(2 or 3) >= 3 AS `(2 OR 3) >= 3`
select 2 OR 3 >= 3, 2 OR (3 >= 3), (2 OR 3) >= 3 union select * from v1;
2 OR 3 >= 3 2 OR (3 >= 3) (2 OR 3) >= 3
1 1 0
create or replace view v1 as select 2 OR 3 <= 0, 2 OR (3 <= 0), (2 OR 3) <= 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 <= 0 AS `2 OR 3 <= 0`,2 or 3 <= 0 AS `2 OR (3 <= 0)`,(2 or 3) <= 0 AS `(2 OR 3) <= 0`
select 2 OR 3 <= 0, 2 OR (3 <= 0), (2 OR 3) <= 0 union select * from v1;
2 OR 3 <= 0 2 OR (3 <= 0) (2 OR 3) <= 0
1 1 0
create or replace view v1 as select 2 OR 3 < 0, 2 OR (3 < 0), (2 OR 3) < 0;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 < 0 AS `2 OR 3 < 0`,2 or 3 < 0 AS `2 OR (3 < 0)`,(2 or 3) < 0 AS `(2 OR 3) < 0`
select 2 OR 3 < 0, 2 OR (3 < 0), (2 OR 3) < 0 union select * from v1;
2 OR 3 < 0 2 OR (3 < 0) (2 OR 3) < 0
1 1 0
create or replace view v1 as select 0 OR 3 <> 3, 0 OR (3 <> 3), (0 OR 3) <> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 3 <> 3 AS `0 OR 3 <> 3`,0 or 3 <> 3 AS `0 OR (3 <> 3)`,(0 or 3) <> 3 AS `(0 OR 3) <> 3`
select 0 OR 3 <> 3, 0 OR (3 <> 3), (0 OR 3) <> 3 union select * from v1;
0 OR 3 <> 3 0 OR (3 <> 3) (0 OR 3) <> 3
0 0 1
create or replace view v1 as select 2 OR 3 > 3, 2 OR (3 > 3), (2 OR 3) > 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 > 3 AS `2 OR 3 > 3`,2 or 3 > 3 AS `2 OR (3 > 3)`,(2 or 3) > 3 AS `(2 OR 3) > 3`
select 2 OR 3 > 3, 2 OR (3 > 3), (2 OR 3) > 3 union select * from v1;
2 OR 3 > 3 2 OR (3 > 3) (2 OR 3) > 3
1 1 0
create or replace view v1 as select 0 OR 3 != 3, 0 OR (3 != 3), (0 OR 3) != 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 3 <> 3 AS `0 OR 3 != 3`,0 or 3 <> 3 AS `0 OR (3 != 3)`,(0 or 3) <> 3 AS `(0 OR 3) != 3`
select 0 OR 3 != 3, 0 OR (3 != 3), (0 OR 3) != 3 union select * from v1;
0 OR 3 != 3 0 OR (3 != 3) (0 OR 3) != 3
0 0 1
create or replace view v1 as select 2 OR 3 LIKE 3, 2 OR (3 LIKE 3), (2 OR 3) LIKE 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 like 3 AS `2 OR 3 LIKE 3`,2 or 3 like 3 AS `2 OR (3 LIKE 3)`,(2 or 3) like 3 AS `(2 OR 3) LIKE 3`
select 2 OR 3 LIKE 3, 2 OR (3 LIKE 3), (2 OR 3) LIKE 3 union select * from v1;
2 OR 3 LIKE 3 2 OR (3 LIKE 3) (2 OR 3) LIKE 3
1 1 0
create or replace view v1 as select 2 OR 3 REGEXP 3, 2 OR (3 REGEXP 3), (2 OR 3) REGEXP 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 regexp 3 AS `2 OR 3 REGEXP 3`,2 or 3 regexp 3 AS `2 OR (3 REGEXP 3)`,(2 or 3) regexp 3 AS `(2 OR 3) REGEXP 3`
select 2 OR 3 REGEXP 3, 2 OR (3 REGEXP 3), (2 OR 3) REGEXP 3 union select * from v1;
2 OR 3 REGEXP 3 2 OR (3 REGEXP 3) (2 OR 3) REGEXP 3
1 1 0
create or replace view v1 as select 2 OR 3 | 3, 2 OR (3 | 3), (2 OR 3) | 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 | 3 AS `2 OR 3 | 3`,2 or 3 | 3 AS `2 OR (3 | 3)`,(2 or 3) | 3 AS `(2 OR 3) | 3`
select 2 OR 3 | 3, 2 OR (3 | 3), (2 OR 3) | 3 union select * from v1;
2 OR 3 | 3 2 OR (3 | 3) (2 OR 3) | 3
1 1 3
create or replace view v1 as select 0 OR 2 & 2, 0 OR (2 & 2), (0 OR 2) & 2;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 2 & 2 AS `0 OR 2 & 2`,0 or 2 & 2 AS `0 OR (2 & 2)`,(0 or 2) & 2 AS `(0 OR 2) & 2`
select 0 OR 2 & 2, 0 OR (2 & 2), (0 OR 2) & 2 union select * from v1;
0 OR 2 & 2 0 OR (2 & 2) (0 OR 2) & 2
1 1 0
create or replace view v1 as select 2 OR 3 << 3, 2 OR (3 << 3), (2 OR 3) << 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 << 3 AS `2 OR 3 << 3`,2 or 3 << 3 AS `2 OR (3 << 3)`,(2 or 3) << 3 AS `(2 OR 3) << 3`
select 2 OR 3 << 3, 2 OR (3 << 3), (2 OR 3) << 3 union select * from v1;
2 OR 3 << 3 2 OR (3 << 3) (2 OR 3) << 3
1 1 8
create or replace view v1 as select 2 OR 3 >> 3, 2 OR (3 >> 3), (2 OR 3) >> 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 >> 3 AS `2 OR 3 >> 3`,2 or 3 >> 3 AS `2 OR (3 >> 3)`,(2 or 3) >> 3 AS `(2 OR 3) >> 3`
select 2 OR 3 >> 3, 2 OR (3 >> 3), (2 OR 3) >> 3 union select * from v1;
2 OR 3 >> 3 2 OR (3 >> 3) (2 OR 3) >> 3
1 1 0
create or replace view v1 as select 2 OR '2000-01-01' +INTERVAL 1 DAY, 2 OR ('2000-01-01' +INTERVAL 1 DAY), (2 OR '2000-01-01') +INTERVAL 1 DAY;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or '2000-01-01' + interval 1 day AS `2 OR '2000-01-01' +INTERVAL 1 DAY`,2 or '2000-01-01' + interval 1 day AS `2 OR ('2000-01-01' +INTERVAL 1 DAY)`,(2 or '2000-01-01') + interval 1 day AS `(2 OR '2000-01-01') +INTERVAL 1 DAY`
select 2 OR '2000-01-01' +INTERVAL 1 DAY, 2 OR ('2000-01-01' +INTERVAL 1 DAY), (2 OR '2000-01-01') +INTERVAL 1 DAY union select * from v1;
2 OR '2000-01-01' +INTERVAL 1 DAY 2 OR ('2000-01-01' +INTERVAL 1 DAY) (2 OR '2000-01-01') +INTERVAL 1 DAY
1 1 NULL
create or replace view v1 as select 2 OR 3 + 3, 2 OR (3 + 3), (2 OR 3) + 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 + 3 AS `2 OR 3 + 3`,2 or 3 + 3 AS `2 OR (3 + 3)`,(2 or 3) + 3 AS `(2 OR 3) + 3`
select 2 OR 3 + 3, 2 OR (3 + 3), (2 OR 3) + 3 union select * from v1;
2 OR 3 + 3 2 OR (3 + 3) (2 OR 3) + 3
1 1 4
create or replace view v1 as select 2 OR 3 - 3, 2 OR (3 - 3), (2 OR 3) - 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 - 3 AS `2 OR 3 - 3`,2 or 3 - 3 AS `2 OR (3 - 3)`,(2 or 3) - 3 AS `(2 OR 3) - 3`
select 2 OR 3 - 3, 2 OR (3 - 3), (2 OR 3) - 3 union select * from v1;
2 OR 3 - 3 2 OR (3 - 3) (2 OR 3) - 3
1 1 -2
create or replace view v1 as select 2 OR 3 * 3, 2 OR (3 * 3), (2 OR 3) * 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 * 3 AS `2 OR 3 * 3`,2 or 3 * 3 AS `2 OR (3 * 3)`,(2 or 3) * 3 AS `(2 OR 3) * 3`
select 2 OR 3 * 3, 2 OR (3 * 3), (2 OR 3) * 3 union select * from v1;
2 OR 3 * 3 2 OR (3 * 3) (2 OR 3) * 3
1 1 3
create or replace view v1 as select 2 OR 3 / 3, 2 OR (3 / 3), (2 OR 3) / 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 / 3 AS `2 OR 3 / 3`,2 or 3 / 3 AS `2 OR (3 / 3)`,(2 or 3) / 3 AS `(2 OR 3) / 3`
select 2 OR 3 / 3, 2 OR (3 / 3), (2 OR 3) / 3 union select * from v1;
2 OR 3 / 3 2 OR (3 / 3) (2 OR 3) / 3
1 1 0.3333
create or replace view v1 as select 2 OR 3 DIV 3, 2 OR (3 DIV 3), (2 OR 3) DIV 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 DIV 3 AS `2 OR 3 DIV 3`,2 or 3 DIV 3 AS `2 OR (3 DIV 3)`,(2 or 3) DIV 3 AS `(2 OR 3) DIV 3`
select 2 OR 3 DIV 3, 2 OR (3 DIV 3), (2 OR 3) DIV 3 union select * from v1;
2 OR 3 DIV 3 2 OR (3 DIV 3) (2 OR 3) DIV 3
1 1 0
create or replace view v1 as select 0 OR 3 MOD 3, 0 OR (3 MOD 3), (0 OR 3) MOD 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 3 MOD 3 AS `0 OR 3 MOD 3`,0 or 3 MOD 3 AS `0 OR (3 MOD 3)`,(0 or 3) MOD 3 AS `(0 OR 3) MOD 3`
select 0 OR 3 MOD 3, 0 OR (3 MOD 3), (0 OR 3) MOD 3 union select * from v1;
0 OR 3 MOD 3 0 OR (3 MOD 3) (0 OR 3) MOD 3
0 0 1
create or replace view v1 as select 0 OR 3 % 3, 0 OR (3 % 3), (0 OR 3) % 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 0 or 3 MOD 3 AS `0 OR 3 % 3`,0 or 3 MOD 3 AS `0 OR (3 % 3)`,(0 or 3) MOD 3 AS `(0 OR 3) % 3`
select 0 OR 3 % 3, 0 OR (3 % 3), (0 OR 3) % 3 union select * from v1;
0 OR 3 % 3 0 OR (3 % 3) (0 OR 3) % 3
0 0 1
create or replace view v1 as select 2 OR 3 ^ 3, 2 OR (3 ^ 3), (2 OR 3) ^ 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 ^ 3 AS `2 OR 3 ^ 3`,2 or 3 ^ 3 AS `2 OR (3 ^ 3)`,(2 or 3) ^ 3 AS `(2 OR 3) ^ 3`
select 2 OR 3 ^ 3, 2 OR (3 ^ 3), (2 OR 3) ^ 3 union select * from v1;
2 OR 3 ^ 3 2 OR (3 ^ 3) (2 OR 3) ^ 3
1 1 2
create or replace view v1 as select 2 OR 3 BETWEEN 2 AND 3, 2 OR (3 BETWEEN 2 AND 3), (2 OR 3) BETWEEN 2 AND 3;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 between 2 and 3 AS `2 OR 3 BETWEEN 2 AND 3`,2 or 3 between 2 and 3 AS `2 OR (3 BETWEEN 2 AND 3)`,(2 or 3) between 2 and 3 AS `(2 OR 3) BETWEEN 2 AND 3`
select 2 OR 3 BETWEEN 2 AND 3, 2 OR (3 BETWEEN 2 AND 3), (2 OR 3) BETWEEN 2 AND 3 union select * from v1;
2 OR 3 BETWEEN 2 AND 3 2 OR (3 BETWEEN 2 AND 3) (2 OR 3) BETWEEN 2 AND 3
1 1 0
create or replace view v1 as select 2 || 3 IS FALSE, 2 || (3 IS FALSE), (2 || 3) IS FALSE;
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select 2 or 3 is false AS `2 || 3 IS FALSE`,2 or 3 is false AS `2 || (3 IS FALSE)`,(2 or 3) is false AS `(2 || 3) IS FALSE`
select 2 || 3 IS FALSE, 2 || (3 IS FALSE), (2 || 3) IS FALSE union select * from v1;
2 || 3 IS FALSE 2 || (3 IS FALSE) (2 || 3) IS FALSE
1 1 0
create or replace view v1 as select charset(2 || 3 COLLATE latin1_bin), charset(2 || (3 COLLATE latin1_bin)), charset((2 || 3) COLLATE latin1_bin);
Select view_definition from information_schema.views where table_schema='test' and table_name='v1';
view_definition
select charset(2 or 3 collate latin1_bin) AS `charset(2 || 3 COLLATE latin1_bin)`,charset(2 or 3 collate latin1_bin) AS `charset(2 || (3 COLLATE latin1_bin))`,charset((2 or 3) collate latin1_bin) AS `charset((2 || 3) COLLATE latin1_bin)`
select charset(2 || 3 COLLATE latin1_bin), charset(2 || (3 COLLATE latin1_bin)), charset((2 || 3) COLLATE latin1_bin) union select * from v1;
charset(2 || 3 COLLATE latin1_bin) charset(2 || (3 COLLATE latin1_bin)) charset((2 || 3) COLLATE latin1_bin) | |
