Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16803

select on a view crash the server

    XMLWordPrintable

Details

    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)));
      

      Attachments

        Activity

          People

            shagalla Galina Shalygina
            marc.langevin@usherbrooke.ca Marc
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.