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

Crash in INTERVAL(ROW(..),ROW(..))

Details

    Description

      This query crashes the server:

      SELECT INTERVAL(ROW(1,1),ROW(1,2));

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14228 MariaDB crashes with function

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29184 Assertion `0' in Item_row::illegal_method_call, Type_handler_row::Item_update_null_value, Item::update_null_value

          • Major - Major loss of function.
          • Closed

          Activity

            bar Alexander Barkov added a comment -

            A related problem:

            This script erroneously return a result, it should return an error instead,
            as it mixes ROW and scalar expressions in the INTERVAL function:

            SET sql_mode=DEFAULT;
            		 
            DELIMITER $$
            		 
            BEGIN NOT ATOMIC
            		 
              DECLARE v ROW(a INT);
            		 
              SELECT INTERVAL(v,'a','b');
            		 
            END $$
            		 
            DELIMITER ;


            +---------------------+
            		 
            | INTERVAL(v,'a','b') |
            		 
            +---------------------+
            		 
            |                  -1 |
            		 
            +---------------------+

            bar Alexander Barkov added a comment - A related problem: This script erroneously return a result, it should return an error instead, as it mixes ROW and scalar expressions in the INTERVAL function: SET sql_mode= DEFAULT ; DELIMITER $$ BEGIN NOT ATOMIC DECLARE v ROW(a INT ); SELECT INTERVAL(v, 'a' , 'b' ); END $$ DELIMITER ; +---------------------+ | INTERVAL(v,'a','b') | +---------------------+ | -1 | +---------------------+

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.