Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.16
-
None
-
Linux version 2.6.32-754.2.1.el6.x86_64 (mockbuild@x86-031.build.eng.bos.redhat.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-23) (GCC) ) #1 SMP Tue Jul 3 16:37:52 EDT 2018
Description
A select on a view crash the server 10.2.16. It works on 10.2.14.
The original query and view is more complex than the test case but backtraces are identical as you can see in files attached.
Test case:
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))); |