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

PL/SQL parser

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

    Description

      Add a new parser to understand Oracle PL/SQL dialect.

      This task holds all work done on the infrastructure that is not part of other sub tasks

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12347 Valgrind reports invalid read errors in Item_field_row::element_index_by_name

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-12411 Remove Lex::text_string_is_7bit

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12441 Variables declared after cursors with parameters lose value

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12846 sql_mode=ORACLE: using Oracle-style placeholders in direct query execution makes the server crash

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

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

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

          Task - A task that needs to be done. MDEV-10764 PL/SQL parser - Phase 2

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12962 Testing MDEV-10142 (PL/SQL parser)

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          1.
          		 sql_mode=ORACLE: Providing compatibility for basic SQL data types Technical task Closed Alexander Barkov
          2.
          		 sql_mode=ORACLE: Providing compatibility for basic PL/SQL constructs Technical task Closed Alexander Barkov
          3.
          		 EXECUTE IMMEDIATE statement Technical task Closed Alexander Barkov
          4.
          		 sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] Technical task Closed Alexander Barkov
          5.
          		 sql_mode=ORACLE: Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 Technical task Closed Alexander Barkov
          6.
          		 sql_mode=ORACLE: FOR loop statement Technical task Closed Alexander Barkov
          7.
          		 sql_mode=ORACLE: Explicit cursor FOR LOOP Technical task Closed Alexander Barkov
          8.
          		 sql_mode=ORACLE: Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND Technical task Closed Alexander Barkov
          9.
          		 sql_mode=ORACLE: SQL%ROWCOUNT Technical task Closed Alexander Barkov
          10.
          		 sql_mode=ORACLE: %TYPE in variable declarations Technical task Closed Alexander Barkov
          11.
          		 sql_mode=ORACLE: SP control functions SQLCODE, SQLERRM Technical task Closed Alexander Barkov
          12.
          		 sql_mode=ORACLE: Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause Technical task Closed Alexander Barkov
          13.
          		 sql_mode=ORACLE: Cursors with parameters Technical task Closed Alexander Barkov
          14.
          		 sql_mode=ORACLE: Variable declarations can go after cursor declarations Technical task Closed Alexander Barkov
          15.
          		 sql_mode=ORACLE: Anonymous blocks Technical task Closed Alexander Barkov
          16.
          		 Expressions as parameters to Dynamic SQL Technical task Closed Alexander Barkov
          17.
          		 Introduce Item_param::CONVERSION_INFO Technical task Closed Alexander Barkov
          18.
          		 sql_mode=ORACLE: Dynamic SQL placeholders Technical task Closed Alexander Barkov
          19.
          		 sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX Technical task Closed Alexander Barkov
          20.
          		 sql_mode=ORACLE: RAISE statement for predefined exceptions Technical task Closed Alexander Barkov
          21.
          		 Extend PREPARE and EXECUTE IMMEDIATE to understand expressions Technical task Closed Alexander Barkov
          22.
          		 ROW data type for stored routine variables Technical task Closed Alexander Barkov
          23.
          		 Diagnostics_area refactoring for user defined exceptions Technical task Closed Alexander Barkov
          24.
          		 sql_mode=ORACLE: User defined exceptions Technical task Closed Alexander Barkov
          25.
          		 sql_mode=ORACLE: CAST(..AS VARCHAR(N)) Technical task Closed Alexander Barkov
          26.
          		 Move functions case_stmt_xxx and add_select_to_union_list as methods to LEX Technical task Closed Alexander Barkov
          27.
          		 Move add_create_index_prepare(), add_key_to_list(), set_trigger_new_row(), set_local_variable(), set_system_variable(), create_item_for_sp_var() as methods to LEX Technical task Closed Alexander Barkov
          28.
          		 Allow ROW variables as a cursor FETCH target Technical task Closed Alexander Barkov
          29.
          		 sql_mode=ORACLE: cursor%ROWTYPE in variable declarations Technical task Closed Alexander Barkov
          30.
          		 sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT Technical task Closed Alexander Barkov
          31.
          		 sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause Technical task Closed Alexander Barkov
          32.
          		 sql_mode=ORACLE: Understand optional routine name after the END keyword Technical task Closed Alexander Barkov
          33.
          		 sql_mode=ORACLE: Implicit cursor FOR loop Technical task Closed Alexander Barkov
          34.
          		 sql_mode=ORACLE: Inside routines the CALL keywoard is optional Technical task Closed Alexander Barkov
          35.
          		 sql_mode=ORACLE: table%ROWTYPE in variable declarations Technical task Closed Alexander Barkov
          36.
          		 sql_mode=ORACLE: Syntax error in a OPEN cursor with parameters makes the server crash Technical task Closed Alexander Barkov
          37.
          		 sql_mode=ORACLE: Derive length of VARCHAR SP parameters with no length from actual parameters Technical task Closed Alexander Barkov
          38.
          		 Allow ROW variables as SELECT INTO targets Technical task Closed Alexander Barkov
          39.
          		 sql_mode=ORACLE: GOTO statement Technical task Closed Alexander Barkov
          40.
          		 sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters Technical task Closed Alexander Barkov
          41.
          		 Duplicate code cleanup: add function normalize_db_name() Technical task Closed Alexander Barkov
          42.
          		 Add function mysql_create_routine() Technical task Closed Alexander Barkov
          43.
          		 Add function is_native_function_with_warn() Technical task Closed Alexander Barkov
          44.
          		 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL Technical task Closed Alexander Barkov
          45.
          		 sql_mode=ORACLE: Functions LENGTH() and LENGTHB() Technical task Closed Alexander Barkov
          46.
          		 Parser refactoring for CREATE VIEW,TRIGGER,SP,UDF,EVENT Technical task Closed Alexander Barkov
          47.
          		 Move the code from sp_head::init() to sp_head::sp_head() Technical task Closed Alexander Barkov
          48.
          		 Change sp_head::m_chistics from a pointer to a structure Technical task Closed Alexander Barkov
          49.
          		 Avoid using LEX::spname during CREATE PROCEDURE and CREATE FUNCTION Technical task Closed Alexander Barkov
          50.
          		 Fix the SP code to avoid excessive use of strlen Technical task Closed Alexander Barkov
          51.
          		 Wrap the code in sp.cc into a class Sp_handler Technical task Closed Alexander Barkov
          52.
          		 Cleanup for Sp_handler::show_create_sp Technical task Closed Alexander Barkov
          53.
          		 Cleanup SP code for packages Technical task Closed Alexander Barkov
          54.
          		 sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments Technical task Closed Alexander Barkov
          55.
          		 DELETE statement with the same source and target Technical task Closed Sergei Golubchik
          56.
          		 sql_mode=ORACLE: Make the CONCAT function ignore NULL arguments Technical task Closed Alexander Barkov
          57.
          		 Oracle-compatible function CHR() Technical task Closed Alexander Barkov
          58.
          		 UPDATE statements with the same source and target Technical task Closed Sergei Golubchik
          59.
          		 SHOW CREATE PACKAGE [ BODY ] pkg Technical task Closed Alexander Barkov
          60.
          		 sql_mode=Oracle: substr(): treat position 0 as position 1 Technical task Closed Alexander Barkov
          61.
          		 Change Item_func_case to store the predicant in args[0] Technical task Closed Alexander Barkov
          62.
          		 Remove Lex::text_string_is_7bit Technical task Closed Alexander Barkov
          63.
          		 Anchored data types for variables Technical task Closed Alexander Barkov
          64.
          		 Add Database_qualified_name::copy() Technical task Closed Alexander Barkov
          65.
          		 Add LEX::sp_body_finalize_{procedure|function} Technical task Closed Alexander Barkov
          66.
          		 Add Field_row for SP ROW variables Technical task Closed Alexander Barkov
          67.
          		 Remove the THD parameter from sp_head::init_sp_name() Technical task Closed Alexander Barkov
          68.
          		 sql_mode=EMPTY_STRING_IS_NULL Technical task Closed Alexander Barkov
          69.
          		 Add virtual Field::sp_prepare_and_store_item(), make sp_rcontext symmetric for scalar and ROW Technical task Closed Alexander Barkov
          70.
          		 Oracle-style packages Technical task Closed Alexander Barkov
          71.
          		 Oracle-style packages: Phase#1: Translate packages to databases Technical task Closed Alexander Barkov

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Epic Link MDEV-10137 [ 56868 ]
            monty Michael Widenius made changes -
            Assignee Alexander Barkov [ bar ]
            monty Michael Widenius made changes -
            Assignee Alexander Barkov [ bar ] Michael Widenius [ monty ]
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ] Alexander Barkov [ bar ]
            monty Michael Widenius made changes -
            Assignee Alexander Barkov [ bar ] Michael Widenius [ monty ]
            monty Michael Widenius made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            monty Michael Widenius made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            Comment [ Things already done:

            1. Labels
            2. Different order of IN, OUT, INOUT keywords
            4. AS/IS keyword before a function or a procedure body
            6. Assignment operator
            7. Variable declarations
            9. EXCEPTION handlers
            10 Default variable value: x INT := 10;
            11. NULL as a statement
            12. No parentheses if no arguments
            13. RETURN vs RETURNS
            14. IN OUT instead of INOUT ]
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ] Alexander Barkov [ bar ]
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-1 [ 89 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1 [ 89 ] 10.2.2-1, 10.2.2-2 [ 89, 92 ]
            alvinr Alvin Richards (Inactive) made changes -
            Rank Ranked lower
            mdcallag Mark Callaghan added a comment -

            Don't forget Oracle-style cursor isolation. You need read committed and more. Oracle has special and useful semantics for read committed -> https://github.com/mdcallag/mytools/wiki/Cursor-Isolation

            mdcallag Mark Callaghan added a comment - Don't forget Oracle-style cursor isolation. You need read committed and more. Oracle has special and useful semantics for read committed -> https://github.com/mdcallag/mytools/wiki/Cursor-Isolation
            monty Michael Widenius made changes -
            Description Add a pluggable parser, to be able to more easily add support for SQLsyntax from other databases. Add a pluggable parser, to be able to more easily add support for SQLsyntax from other databases.

            This task holds all work done on the infrastructure that is not part of other sub tasks
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2 [ 89, 92 ] 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 89, 92, 94 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 89, 92, 94 ] 10.2.2-1, 10.2.2-2 [ 89, 92 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2 [ 89, 92 ] 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 89, 92, 96 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 89, 92, 96 ] 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 89, 92, 94 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 89, 92, 94 ] 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 89, 92, 96 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 89, 92, 96 ] 10.2.2-3, 10.2.2-1, 10.2.2-2 [ 83, 89, 92 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-3, 10.2.2-1, 10.2.2-2 [ 83, 89, 92 ] 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 83, 89, 92, 96 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4 [ 83, 89, 92, 96 ] 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.2.2-5 [ 83, 89, 92, 96, 101 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, Compatibility-18 [ 83, 89, 92, 96, 101 ] 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18 [ 83, 89, 92, 96, 98 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            serg Sergei Golubchik made changes -
            Summary Pluggable parser Pluggable parser (?)
            ratzpo Rasmus Johansson (Inactive) made changes -
            Summary Pluggable parser (?) PL/SQL parser
            bar Alexander Barkov made changes -
            Description Add a pluggable parser, to be able to more easily add support for SQLsyntax from other databases.

            This task holds all work done on the infrastructure that is not part of other sub tasks             		Add a new parser to understand Oracle PL/SQL dialect.

            This task holds all work done on the infrastructure that is not part of other sub tasks
            bar Alexander Barkov made changes -
            monty Michael Widenius made changes -
            Epic Link MDEV-10137 [ 56868 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility Compatibility NRE-307517
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            alvinr Alvin Richards (Inactive) made changes -
            NRE Projects NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility NRE-307517 Compatibility
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            anikitin Andrii Nikitin (Inactive) made changes -
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility 10.3-beta Compatibility
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Epic Link MDEV-11070 [ 58519 ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.3.2 [ 22533 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            Component/s Stored routines [ 13905 ]
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75812 ] MariaDB v4 [ 132887 ]

            People

              bar Alexander Barkov
              monty Michael Widenius
              Votes:
              3 Vote for this issue
              Watchers:
              8 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.