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

union parser cleanup

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2.2
    • Parser
    • None
    • 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5

    Description

      This is a spin-off from MDEV-8380. The corresponding parser changes are too big to go into 10.1

      This task will remove a few "Incorrect usage of ... and ..." errors and will return "syntax error" instead.

      Example#1:

      SELECT * FROM t1 LIMIT 1 UNION SELECT * FROM t1 LIMIT 1;


      ERROR 1221 (HY000): Incorrect usage of UNION and LIMIT

      Example#2:

      SELECT * FROM (SELECT * FROM t1 PROCEDURE ANALYSE());


      ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery

      Example#3:

      SELECT * FROM t1 NATURAL JOIN (SELECT * FROM t2 PROCEDURE ANALYSE());


      ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery

      Example#4

      SELECT (SELECT 1 FROM t1 PROCEDURE ANALYSE()) FROM t2;


      ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-10030 sql_yacc.yy: Split table_expression and remove PROCEDURE from create_select, select_paren_derived, select_derived2, query_specification

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10036 sql_yacc.yy: Split select_part2 to disallow syntactically bad constructs with INTO, PROCEDURE, UNION

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10037 UNION with LIMIT ROWS EXAMINED does not require parentheses

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10051 Fix subselect to return a syntax error instead of "Incorrect usage of UNION and LIMIT"

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10078 sql_yacc.yy: Remove non-parenthesized SELECT from table_factor

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10079 sql_yacc.yy: Remove non-parenthesized SELECT from table_ref

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10080 Derived tables allow double LIMIT clause

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10095 Fix derived table to return a syntax error instead of "Illegal usage of UNION and LIMIT"

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10101 Wrong error message of SELECT 1 UNION (SELECT 1 FROM t1 GROUP BY 1 WITH ROLLUP)

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10102 Disallow CREATE VIEW .. PROCEDURE ANALYSE() syntactically

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10103 Disallow syntactically UNION SELECT .. PROCEDURE ANALYSE()

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10109 Disallow syntactically INSERT .. SELECT .. {ORDER BY ..| LIMIT ..} .. UNION ..

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10124 Incorrect usage of CUBE/ROLLUP and ORDER BY with GROUP_CONCAT(a ORDER BY a)

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8380 Subquery parse error

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10028 Syntax error on ((SELECT ...) UNION (SELECT ...))

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10035 DBUG_ASSERT on CREATE VIEW v1 AS SELECT * FROM t1 FOR UPDATE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10096 Behaviour of SQL_NO_CACHE in derived tables is not consistent

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10120 Wrong result of UNION .. ORDER BY GROUP_CONCAT()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10122 MariaDB does not support group functions in some contexts where MySQL does

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

          Activity

            People

              bar Alexander Barkov
              serg Sergei Golubchik
              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.