CREATE TABLE `bug10_2_16` (

  `value1` int(11) DEFAULT NULL,

  `value2` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO bug10_2_16 (value1, value2) VALUES (3, 3);

INSERT INTO bug10_2_16 (value1, value2) VALUES (3, 2);

INSERT INTO bug10_2_16 (value1, value2) VALUES (3, 1);

INSERT INTO bug10_2_16 (value1, value2) VALUES (1, 1);

INSERT INTO bug10_2_16 (value1, value2) VALUES (2, 2);

INSERT INTO bug10_2_16 (value1, value2) VALUES (1, 3);

INSERT INTO bug10_2_16 (value1, value2) VALUES (2, 3);

INSERT INTO bug10_2_16 (value1, value2) VALUES (1, 2);

INSERT INTO bug10_2_16 (value1, value2) VALUES (2, 1);

create or replace view view_bug10_2_16 (id,val1,val2) 

as 

select 1 as id, value1 as val1, value2 as val2 from bug10_2_16 

union all 

select 2 as id, value1 as val1, value2 as val2 from bug10_2_16 ;

select id,val1,val2 from view_bug10_2_16

where ( (val1,val2) in ((1,-1),(2,2)));