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

Error description regression for derieved table missing alias (mariadb 10.4)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.4.6
    • N/A
    • None
    • Mariadb 10.4.6
      Newest FC 30
      5.1.15-300.fc30.x86_64 #1

    Description

      Hello Everyone, I have found some small regression in error reporting, basically it reports lack of derieved table's alias as syntax error in new version of maria. I think maybe some code was removed in 10.4 and that resulted in generic error being output instead of more descriptive one. Not sure if that's a bug, basically the older server was working better in this regard so reporting as minor bug and maybe it can be made to work the old way...

      Code to reproduce it:

      CREATE TEMPORARY TABLE `test_regr_99182` (
      `x`  varchar(255) NULL );
      SELECT count(*) FROM 
      (SELECT * FROM test_regr_99182 limit 1) 
      

      What new version (10.4.6) does:
      [Err] 1064 - 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 '' at line 7

      What old version (10.1) does:
      [Err] 1248 - Every derived table must have its own alias

      Attachments

        Activity

          People

            serg Sergei Golubchik
            pslawek83 Slawomir Pryczek
            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.