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

PL/SQL parser

    XMLWordPrintable

Details

    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

          100%
          Original Estimate - 2d
          Time Spent - 0.5d Time Not Required
          2.
          		 sql_mode=ORACLE: Providing compatibility for basic PL/SQL constructs Technical task Closed Alexander Barkov

          100%
          Original Estimate - 15d Original Estimate - 15d
          Time Spent - 15.5d
          3.
          		 EXECUTE IMMEDIATE statement Technical task Closed Alexander Barkov

          60%
          Original Estimate - 5d
          Time Spent - 3d 20m Remaining Estimate - 1d 7h 40m
          4.
          		 sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] Technical task Closed Alexander Barkov

          50%
          Original Estimate - 1h
          Time Spent - 0.5h Remaining Estimate - 0.5h
          5.
          		 sql_mode=ORACLE: Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1h Original Estimate - 1h
          Time Spent - 0.75d
          6.
          		 sql_mode=ORACLE: FOR loop statement Technical task Closed Alexander Barkov

          100%
          Original Estimate - 3d
          Time Spent - 2d Time Not Required
          7.
          		 sql_mode=ORACLE: Explicit cursor FOR LOOP Technical task Closed Alexander Barkov

          47%
          Original Estimate - 10d
          Time Spent - 4.75d Remaining Estimate - 5.25d
          8.
          		 sql_mode=ORACLE: Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d
          Time Spent - 1d
          9.
          		 sql_mode=ORACLE: SQL%ROWCOUNT Technical task Closed Alexander Barkov

          50%
          Original Estimate - 1d
          Time Spent - 0.5d Remaining Estimate - 0.5d
          10.
          		 sql_mode=ORACLE: %TYPE in variable declarations Technical task Closed Alexander Barkov

          100%
          Original Estimate - 3d Original Estimate - 3d
          Time Spent - 17d
          11.
          		 sql_mode=ORACLE: SP control functions SQLCODE, SQLERRM Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d Original Estimate - 1d
          Time Spent - 1.25d
          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

          100%
          Original Estimate - 0.5d
          Time Spent - 0.5d
          13.
          		 sql_mode=ORACLE: Cursors with parameters Technical task Closed Alexander Barkov

          100%
          Original Estimate - 5d Original Estimate - 5d
          Time Spent - 7d
          14.
          		 sql_mode=ORACLE: Variable declarations can go after cursor declarations Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5d Original Estimate - 0.5d
          Time Spent - 1d
          15.
          		 sql_mode=ORACLE: Anonymous blocks Technical task Closed Alexander Barkov

          18%
          Original Estimate - 2d
          Time Spent - 3h Remaining Estimate - 1d 5h
          16.
          		 Expressions as parameters to Dynamic SQL Technical task Closed Alexander Barkov

          100%
          Original Estimate - 3d Original Estimate - 3d
          Time Spent - 3d 7h
          17.
          		 Introduce Item_param::CONVERSION_INFO Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5h
          18.
          		 sql_mode=ORACLE: Dynamic SQL placeholders Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5d Original Estimate - 0.5d
          Time Spent - 0.75d
          19.
          		 sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5d
          Time Spent - 0.5d
          20.
          		 sql_mode=ORACLE: RAISE statement for predefined exceptions Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d
          Time Spent - 1d
          21.
          		 Extend PREPARE and EXECUTE IMMEDIATE to understand expressions Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 3d 3h
          22.
          		 ROW data type for stored routine variables Technical task Closed Alexander Barkov

          100%
          Original Estimate - 5d Original Estimate - 5d
          Time Spent - 8d 4.5h
          23.
          		 Diagnostics_area refactoring for user defined exceptions Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d
          Time Spent - 1d
          24.
          		 sql_mode=ORACLE: User defined exceptions Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d Original Estimate - 1d
          Time Spent - 3d
          25.
          		 sql_mode=ORACLE: CAST(..AS VARCHAR(N)) Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          26.
          		 Move functions case_stmt_xxx and add_select_to_union_list as methods to LEX Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 1h
          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

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 1h
          28.
          		 Allow ROW variables as a cursor FETCH target Technical task Closed Alexander Barkov

          62%
          Original Estimate - 1d
          Time Spent - 5h Remaining Estimate - 3h
          29.
          		 sql_mode=ORACLE: cursor%ROWTYPE in variable declarations Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 4d 5h
          30.
          		 sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 10m
          31.
          		 sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 0.5h
          32.
          		 sql_mode=ORACLE: Understand optional routine name after the END keyword Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 0.5d
          33.
          		 sql_mode=ORACLE: Implicit cursor FOR loop Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 1d
          34.
          		 sql_mode=ORACLE: Inside routines the CALL keywoard is optional Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 0.5d
          35.
          		 sql_mode=ORACLE: table%ROWTYPE in variable declarations Technical task Closed Alexander Barkov

          74%
          Original Estimate - 8d Original Estimate - 8d
          Time Spent - 9d 5h Remaining Estimate - 3d 3h
          36.
          		 sql_mode=ORACLE: Syntax error in a OPEN cursor with parameters makes the server crash Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 0.25d
          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

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1d
          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

          75%
          Original Estimate - 1d
          Time Spent - 0.75d Remaining Estimate - 0.25d
          41.
          		 Duplicate code cleanup: add function normalize_db_name() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1h
          Time Spent - 1h
          42.
          		 Add function mysql_create_routine() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1h
          Time Spent - 1h
          43.
          		 Add function is_native_function_with_warn() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1h
          Time Spent - 1h
          44.
          		 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 3h
          45.
          		 sql_mode=ORACLE: Functions LENGTH() and LENGTHB() Technical task Closed Alexander Barkov

          50%
          Original Estimate - 0.5d
          Time Spent - 0.25d Remaining Estimate - 0.25d
          46.
          		 Parser refactoring for CREATE VIEW,TRIGGER,SP,UDF,EVENT Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1d
          47.
          		 Move the code from sp_head::init() to sp_head::sp_head() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.25d
          Time Spent - 0.25d
          48.
          		 Change sp_head::m_chistics from a pointer to a structure Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1d
          49.
          		 Avoid using LEX::spname during CREATE PROCEDURE and CREATE FUNCTION Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.25d
          Time Spent - 0.25d
          50.
          		 Fix the SP code to avoid excessive use of strlen Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d
          Time Spent - 1d
          51.
          		 Wrap the code in sp.cc into a class Sp_handler Technical task Closed Alexander Barkov

          100%
          Original Estimate - 2d
          Time Spent - 2d
          52.
          		 Cleanup for Sp_handler::show_create_sp Technical task Closed Alexander Barkov

          0%
          Original Estimate - 3h
          Remaining Estimate - 3h
          53.
          		 Cleanup SP code for packages Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.25d
          54.
          		 sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 2.75h
          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

          50%
          Original Estimate - 3h
          Time Spent - 1.5h Remaining Estimate - 1.5h
          57.
          		 Oracle-compatible function CHR() Technical task Closed Alexander Barkov

          25%
          Original Estimate - 0.5d
          Time Spent - 1h Remaining Estimate - 3h
          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

          100%
          Original Estimate - 1d
          Time Spent - 1d
          62.
          		 Remove Lex::text_string_is_7bit Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.75d
          Time Spent - 0.75d
          63.
          		 Anchored data types for variables Technical task Closed Alexander Barkov

          100%
          Original Estimate - 1d Original Estimate - 1d
          Time Spent - 1.25d
          64.
          		 Add Database_qualified_name::copy() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5h
          Time Spent - 0.5h
          65.
          		 Add LEX::sp_body_finalize_{procedure|function} Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5h
          Time Spent - 0.5h
          66.
          		 Add Field_row for SP ROW variables Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1d
          67.
          		 Remove the THD parameter from sp_head::init_sp_name() Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0.5h
          Time Spent - 0.5h
          68.
          		 sql_mode=EMPTY_STRING_IS_NULL Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5d
          69.
          		 Add virtual Field::sp_prepare_and_store_item(), make sp_rcontext symmetric for scalar and ROW Technical task Closed Alexander Barkov

          100%
          Original Estimate - 0d Original Estimate - 0d
          Time Spent - 1.25d
          70.
          		 Oracle-style packages Technical task Closed Alexander Barkov

          100%
          Original Estimate - 20d Original Estimate - 20d
          Time Spent - 30d 4h 50m
          71.
          		 Oracle-style packages: Phase#1: Translate packages to databases Technical task Closed Alexander Barkov

          100%
          Original Estimate - 5d
          Time Spent - 3d Time Not Required

          Activity

            People

              bar Alexander Barkov
              monty Michael Widenius
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 109d 1.5h Original Estimate - 109d 1.5h
                  109d 1.5h
                  Remaining:
                  Time Spent - 147d 7h 5m Remaining Estimate - 17d 2h 40m
                  17d 2h 40m
                  Logged:
                  Time Spent - 147d 7h 5m Remaining Estimate - 17d 2h 40m
                  147d 7h 5m

                  Git Integration

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