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

different behaviour with "INTO @var1" for MySQL and MariaDB

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      MySQL 5.7
      		 
       
      		 
      mysql> (SELECT 1 INTO @var1);
      		 
      Query OK, 1 row affected (0.00 sec)


      MariaDB (tested with 10.4 and 10.8)
      		 
       
      		 
      MariaDB [d1]> (SELECT 1 INTO @var1);
      		 
      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 'into @var1)' at line 1

      Attachments

        Activity

          People

            ralf.gebhardt Ralf Gebhardt
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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