Details

    • 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.
          Providing compatibility for basic SQL built-in functions Technical task In Progress Alexander Barkov
           
          2.
          sql_mode=ORACLE: Providing compatibility for basic SQL data types Technical task Closed Alexander Barkov
           
          3.
          sql_mode=ORACLE: Providing compatibility for basic PL/SQL constructs Technical task Closed Alexander Barkov
           
          4.
          Automatic transaction start for sql_mode=ORACLE Technical task Open Unassigned
           
          5.
          sql_mode=ORACLE: LOG ERRORS clause in INSERT, DELETE, UPDATE Technical task Stalled Alexander Barkov
           
          6.
          sql_mode=ORACLE: Built-in package DBMS_OUTPUT Technical task Open Unassigned
           
          7.
          Oracle-style packages Technical task In Progress Alexander Barkov
           
          8.
          sql_mode=ORACLE: TYPE .. TABLE OF for scalar data types Technical task Open Unassigned
           
          9.
          sql_mode=ORACLE: TYPE .. AS OBJECT: basic functionality Technical task Open Unassigned
           
          10.
          EXECUTE IMMEDIATE statement Technical task Closed Alexander Barkov
           
          11.
          Oracle style multi-table UPDATE syntax Technical task Open Unassigned
           
          12.
          sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] Technical task Closed Alexander Barkov
           
          13.
          sql_mode=ORACLE: Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 Technical task Closed Alexander Barkov
           
          14.
          sql_mode=ORACLE: FOR loop statement Technical task Closed Alexander Barkov
           
          15.
          sql_mode=ORACLE: Explicit cursor FOR LOOP Technical task Closed Alexander Barkov
           
          16.
          sql_mode=ORACLE: Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND Technical task Closed Alexander Barkov
           
          17.
          sql_mode=ORACLE: SQL%ROWCOUNT Technical task Closed Alexander Barkov
           
          18.
          sql_mode=ORACLE: %TYPE in variable declarations Technical task Closed Alexander Barkov
           
          19.
          sql_mode=ORACLE: SP control functions SQLCODE, SQLERRM Technical task Closed Alexander Barkov
           
          20.
          sql_mode=ORACLE: IS NULL and empty strings Technical task Open Alexander Barkov
           
          21.
          sql_mode=ORACLE: Date and timestamp formats Technical task Open Dmitry Tolpeko
           
          22.
          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
           
          23.
          sql_mode=ORACLE: Cursors with parameters Technical task Closed Alexander Barkov
           
          24.
          sql_mode=ORACLE: Variable declarations can go after cursor declarations Technical task Closed Alexander Barkov
           
          25.
          sql_mode=ORACLE: Anonymous blocks Technical task Closed Alexander Barkov
           
          26.
          Add support for TRIGGERS that fire on multiple events Technical task Open Unassigned
           
          27.
          Expressions as parameters to Dynamic SQL Technical task Closed Alexander Barkov
           
          28.
          Introduce Item_param::CONVERSION_INFO Technical task Closed Alexander Barkov
           
          29.
          sql_mode=ORACLE: Dynamic SQL placeholders Technical task Closed Alexander Barkov
           
          30.
          sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX Technical task Closed Alexander Barkov
           
          31.
          sql_mode=ORACLE: RAISE statement for predefined exceptions Technical task Closed Alexander Barkov
           
          32.
          Extend PREPARE and EXECUTE IMMEDIATE to understand expressions Technical task Closed Alexander Barkov
           
          33.
          ROW data type for stored routine variables Technical task Closed Alexander Barkov
           
          34.
          Diagnostics_area refactoring for user defined exceptions Technical task Closed Alexander Barkov
           
          35.
          sql_mode=ORACLE: User defined exceptions Technical task Closed Alexander Barkov
           
          36.
          sql_mode=ORACLE: CAST(..AS VARCHAR(N)) Technical task Closed Alexander Barkov
           
          37.
          sql_mode=ORACLE: CURRENT_DATE function Technical task Open Dmitry Tolpeko
           
          38.
          Move functions case_stmt_xxx and add_select_to_union_list as methods to LEX Technical task Closed Alexander Barkov
           
          39.
          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
           
          40.
          Oracle-style packages: Phase#1: Translate packages to databases Technical task Stalled Alexander Barkov
           
          41.
          Allow ROW variables as a cursor FETCH target Technical task Closed Alexander Barkov
           
          42.
          sql_mode=ORACLE: cursor%ROWTYPE in variable declarations Technical task Closed Alexander Barkov
           
          43.
          sql_mode=ORACLE: allow derived tables not to have aliases Technical task Open Alexander Barkov
           
          44.
          sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT Technical task Closed Alexander Barkov
           
          45.
          sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause Technical task Closed Alexander Barkov
           
          46.
          sql_mode=ORACLE: Understand optional routine name after the END keyword Technical task Closed Alexander Barkov
           
          47.
          Make INSTR understand optional parameters for position and occurence Technical task Open Alexander Barkov
           
          48.
          sql_mode=ORACLE: Implicit cursor FOR loop Technical task Closed Alexander Barkov
           
          49.
          sql_mode=ORACLE: Inside routines the CALL keywoard is optional Technical task Closed Alexander Barkov
           
          50.
          sql_mode=ORACLE: table%ROWTYPE in variable declarations Technical task Closed Alexander Barkov
           
          51.
          sql_mode=ORACLE: Package metadata views Technical task Open Alexander Barkov
           
          52.
          sql_mode=ORACLE: Syntax error in a OPEN cursor with parameters makes the server crash Technical task Closed Alexander Barkov
           
          53.
          Allow ROW variables as SELECT INTO targets Technical task Closed Alexander Barkov
           
          54.
          sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters Technical task Closed Alexander Barkov
           
          55.
          ROW data type for built-in function return values Technical task Open Alexander Barkov
           
          56.
          Accessing ROW type function fields Technical task Open Alexander Barkov
           
          57.
          Allow %ROWTYPE variable fields as FETCH INTO targets Technical task Open Alexander Barkov
           
          58.
          Allow %ROWTYPE variable fields as SELECT INTO targets Technical task Open Alexander Barkov
           
          59.
          Duplicate code cleanup: add function normalize_db_name() Technical task Closed Alexander Barkov
           
          60.
          Add function mysql_create_routine() Technical task Closed Alexander Barkov
           
          61.
          Add function is_native_function_with_warn() Technical task Closed Alexander Barkov
           
          62.
          sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL Technical task Closed Alexander Barkov
           
          63.
          sql_mode=ORACLE: Functions LENGTH() and LENGTHB() Technical task Open Alexander Barkov
           

            Activity

              People

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

                Dates

                • Created:
                  Updated: