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

View definition corruption

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.3.25, 10.3.26, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.2.37, 10.3.28, 10.4.18, 10.5.9
    • Parser
    • None
    • Debian Buster 64bit

    Description

      Not sure in which version was this bug introduced (at least 10.3.25) but version 10.3.26 draw the attention on it.

      Do this:

      CREATE TABLE `test_table` (`ID` INTEGER(0)) ENGINE=MyISAM;
      		 
       
      CREATE VIEW `test_view` AS SELECT * FROM `test_table` WHERE ISNULL(ID)=0;
      		 
       
      		 
      SHOW CREATE VIEW test_view;

      Result in 10.3.25 (see the changed/corrupted ISNULL() part):

      +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
      		 
      | View      | Create View                                                                                                                                                                           | character_set_client | collation_connection |
      		 
      +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
      		 
      | test_view | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test_view` AS select `test_table`.`ID` AS `ID` from `test_table` where `test_table`.`ID` is null = 0 | latin1               | latin1_swedish_ci    |
      		 
      +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+

      Result in 10.3.26:

      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0' at line 1

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24226 10.3.26 rejects syntax that 10.3.25 accepts

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24254 CHECK (ISNULL(code)=ISNULL(class)) syntax error

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24641 Check constraint parser incorrectly indicates syntax error

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24817 Undocumented IS operator precendence change in 10.3.26

          • Major - Major loss of function.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              azurit azurit
              Votes:
              0 Vote for this issue
              Watchers:
              9 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.