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

prepared view crash server (unit.conc_view)

    XMLWordPrintable

Details

    Description

      Reduced test case (reproducable only with first solution of MDEV-29662):

      CREATE TABLE LTDX (
      		 
       USERNAME varchar(12) NOT NULL,
      		 
       SRTF2 int(11) NOT NULL);
      		 
      CREATE VIEW V_LTDX AS
      		 
        select T0001.USERNAME AS USERNAME
      		 
          from LTDX T0001 where (T0001.SRTF2 = 0);
      		 
       
      		 
      set @a1="1";
      		 
      set @a2="1";
      		 
       
      		 
      prepare stmt from
      		 
      "select username from V_LTDX where username in ( ? , ? )";
      		 
       
      		 
      execute stmt using @a1,@a2;
      		 
       
      		 
      deallocate prepare stmt;
      		 
       
      		 
      DROP VIEW V_LTDX;
      		 
      DROP TABLE LTDX;

      caused by 5027cb2b74a0b37cbdd3ad190cb8b2bf738c0cde

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29662 same values in `IN` set vs equal comparison produces the different performance

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17869 AddressSanitizer: use-after-poison in Item_change_list::rollback_item_tree_changes

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.