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

PL/SQL parser - Phase 2

    XMLWordPrintable

Details

    Description

      Second Phase of Pluggable Parser work - to complete compatibility.

      Attachments

        Issue Links

          includes

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12090 Make INSTR understand optional parameters for position and occurence

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32496 TIMESTAMP variant to support YEAR range -4713 and +9999

          • Major - Major loss of function.
          • Open
          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-11070 Providing compatibility to other databases - Phase 2

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

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

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

          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
          split to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10574 sql_mode=ORACLE: IS NULL and empty strings

          • Major - Major loss of function.
          • Open
          1.
          		 sql_mode=ORACLE: Functions with no parameters can be called without parentheses Technical task Open Unassigned  
          2.
          		 IN, OUT, INOUT parameters in CREATE FUNCTION Technical task Closed Alexander Barkov

          100%
          Original Estimate - 2d Original Estimate - 2d
          Time Spent - 2d 20m
          3.
          		 sql_mode=ORACLE: SQLERRM(errcode) Technical task Open Unassigned  
          4.
          		 sql_mode=ORACLE: Predefined exceptions (part 2) Technical task Open Unassigned

          0%
          Original Estimate - 1d
          Remaining Estimate - 1d
          5.
          		 Put user defined exceptions to the same name space with variables Technical task Open Unassigned  
          6.
          		 TYPE OF and %TYPE in stored function RETURN data type Technical task Open Unassigned

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          7.
          		 sql_mode=ORACLE: IN, OUT, IN OUT modes for dynamic SQL bind arguments Technical task Open Unassigned

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          8.
          		 sql_mode=ORACLE: AUTHID clause Technical task Open Unassigned  
          9.
          		 sql_mode=ORACLE: Translate NUMBER, FLOAT and DOUBLE to subtypes of DECIMAL Technical task Open Alexander Barkov  
          10.
          		 sql_mode=ORACLE: recursive stored functions Technical task Open Unassigned

          0%
          Original Estimate - 5d
          Remaining Estimate - 5d
          11.
          		 sql_mode=ORACLE: transactions in stored functions Technical task Open Unassigned  
          12.
          		 Dynamic SQL in stored functions Technical task Open Unassigned

          0%
          Original Estimate - 15d
          Remaining Estimate - 15d
          13.
          		 sql_mode=ORACLE: a new option to make dash-dash to start a comment Technical task Open Unassigned

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          14.
          		 sql_mode=ORACLE: identifier naming convention Technical task Open Unassigned  
          15.
          		 "Unreserve" MariaDB reserved keywords that are not reserved in the other databases Technical task Open Unassigned

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          16.
          		 ROW data type for stored function return values Technical task Closed Alexander Barkov

          100%
          Original Estimate - 3d Original Estimate - 3d
          Time Spent - 8d 3.5h
          17.
          		 NOT NULL routine variables Technical task Open Unassigned  
          18.
          		 Allow %ROWTYPE variable fields as SELECT INTO targets Technical task Open Unassigned

          0%
          Original Estimate - 5d
          Remaining Estimate - 5d
          19.
          		 Accessing ROW type function fields Technical task Open Unassigned

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          20.
          		 sql_mode=ORACLE: Built-in package DBMS_OUTPUT Technical task Closed Alexander Barkov

          0%
          Original Estimate - 10d
          Time Not Required
          21.
          		 Providing compatibility for basic SQL built-in functions Technical task Closed Unassigned

          7%
          Original Estimate - 10d
          Time Spent - 0.75d Remaining Estimate - 9.25d
          22.
          		 Oracle style multi-table UPDATE syntax Technical task Open Unassigned

          0%
          Original Estimate - 1d
          Remaining Estimate - 1d
          23.
          		 sql_mode=ORACLE: TYPE .. TABLE OF for scalar data types Technical task Open Alexander Barkov

          0%
          Original Estimate - 15d
          Remaining Estimate - 15d
          24.
          		 sql_mode=ORACLE: TYPE .. AS OBJECT: basic functionality Technical task Open Unassigned

          0%
          Original Estimate - 15d
          Remaining Estimate - 15d
          25.
          		 sql_mode=ORACLE: LOG ERRORS clause in INSERT, DELETE, UPDATE Technical task Stalled Unassigned

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          26.
          		 Automatic transaction start for sql_mode=ORACLE Technical task Open Unassigned

          0%
          Original Estimate - 1d
          Remaining Estimate - 1d
          27.
          		 Allow %ROWTYPE variable fields as FETCH INTO targets Technical task Open Unassigned

          0%
          Original Estimate - 1d
          Remaining Estimate - 1d
          28.
          		 sql_mode=ORACLE: allow derived tables not to have aliases Technical task Open Unassigned  
          29.
          		 sql_mode=ORACLE: CURRENT_DATE function Technical task Open Dmitry Tolpeko  
          30.
          		 ROW data type for built-in function return values Technical task Stalled Alexander Barkov

          0%
          Original Estimate - 3d
          Remaining Estimate - 3d
          31.
          		 sql_mode=ORACLE: Package metadata views Technical task Closed Alexander Barkov

          0%
          Original Estimate - 5d
          Time Not Required
          32.
          		 sql_mode=ORACLE: Date and timestamp formats Technical task Open Unassigned

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.25d
          33.
          		 sql_mode=ORACLE: Make TRIM return NULL instead of empty string Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.25d
          34.
          		 sql_mode=ORACLE: Make LPAD and RPLAD return NULL instead of empty string Technical task Closed Alexander Barkov

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          35.
          		 Implement anchored data types in ROW members Technical task Open Unassigned

          1%
          Original Estimate - 5d
          Time Spent - 0.5h Remaining Estimate - 4d 7.5h

          Activity

            People

              Unassigned Unassigned
              alvinr Alvin Richards (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 112d
                  112d
                  Remaining:
                  Time Spent - 12d 20m Remaining Estimate - 91d 1.5h
                  91d 1.5h
                  Logged:
                  Time Spent - 12d 20m Remaining Estimate - 91d 1.5h Time Not Required
                  12d 20m

                  Git Integration

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