Details

    • Epic Link:
    • Sprint:
      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

          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: Implicit cursor FOR LOOP for cursors with parameters Technical task Closed Alexander Barkov
           
          40.
          Duplicate code cleanup: add function normalize_db_name() Technical task Closed Alexander Barkov
           
          41.
          Add function mysql_create_routine() Technical task Closed Alexander Barkov
           
          42.
          Add function is_native_function_with_warn() Technical task Closed Alexander Barkov
           
          43.
          sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL Technical task Closed Alexander Barkov
           
          44.
          sql_mode=ORACLE: Functions LENGTH() and LENGTHB() Technical task Closed Alexander Barkov
           
          45.
          Parser refactoring for CREATE VIEW,TRIGGER,SP,UDF,EVENT Technical task Closed Alexander Barkov
           
          46.
          Move the code from sp_head::init() to sp_head::sp_head() Technical task Closed Alexander Barkov
           
          47.
          Change sp_head::m_chistics from a pointer to a structure Technical task Closed Alexander Barkov
           
          48.
          Avoid using LEX::spname during CREATE PROCEDURE and CREATE FUNCTION Technical task Closed Alexander Barkov
           
          49.
          Fix the SP code to avoid excessive use of strlen Technical task Closed Alexander Barkov
           
          50.
          Wrap the code in sp.cc into a class Sp_handler Technical task Closed Alexander Barkov
           
          51.
          Cleanup for Sp_handler::show_create_sp Technical task Closed Alexander Barkov
           
          52.
          Cleanup SP code for packages Technical task Closed Alexander Barkov
           

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: