[MDEV-10764] PL/SQL parser - Phase 2 - Jira

XML

Word

Printable

Details

Type: Task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: Parser
Labels:
- Compatibility
- Oracle

Description

Second Phase of Pluggable Parser work - to complete compatibility.

Attachments

Issue Links

is part of

MDEV-11070 Providing compatibility to other databases - Phase 2

Open

relates to

MDEV-10142 PL/SQL parser

Closed

MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy

Closed

Sub-Tasks

1.	sql_mode=ORACLE: Functions with no parameters can be called without parentheses	Open	Unassigned
2.	IN, OUT, INOUT parameters in CREATE FUNCTION	Closed	Alexander Barkov
3.	sql_mode=ORACLE: SQLERRM(errcode)	Open	Unassigned
4.	sql_mode=ORACLE: Predefined exceptions (part 2)	Open	Unassigned
5.	Put user defined exceptions to the same name space with variables	Open	Unassigned
6.	%TYPE in stored function RETURN data type	Open	Unassigned
7.	sql_mode=ORACLE: IN, OUT, IN OUT modes for dynamic SQL bind arguments	Open	Unassigned
8.	sql_mode=ORACLE: AUTHID clause	Open	Unassigned
9.	sql_mode=ORACLE: Translate NUMBER, FLOAT and DOUBLE to subtypes of DECIMAL	Open	Alexander Barkov
10.	sql_mode=ORACLE: recursive stored functions	Open	Unassigned
11.	sql_mode=ORACLE: transactions in stored functions	Open	Unassigned
12.	Dynamic SQL in stored functions	Open	Unassigned
13.	sql_mode=ORACLE: a new option to make dash-dash to start a comment	Open	Unassigned
14.	sql_mode=ORACLE: identifier naming convention	Open	Unassigned
15.	"Unreserve" MariaDB reserved keywords that are not reserved in the other databases	Open	Unassigned
16.	ROW data type for stored function return values	Open	Unassigned
17.	NOT NULL routine variables	Open	Unassigned
18.	sql_mode=ORACLE: IS NULL and empty strings	Open	Unassigned
19.	Allow %ROWTYPE variable fields as SELECT INTO targets	Open	Unassigned
20.	Accessing ROW type function fields	Open	Unassigned
21.	sql_mode=ORACLE: Built-in package DBMS_OUTPUT	Open	Unassigned
22.	Providing compatibility for basic SQL built-in functions	Needs Feedback	Unassigned
23.	Oracle style multi-table UPDATE syntax	Open	Unassigned
24.	sql_mode=ORACLE: TYPE .. TABLE OF for scalar data types	Open	Unassigned
25.	sql_mode=ORACLE: TYPE .. AS OBJECT: basic functionality	Open	Unassigned
26.	sql_mode=ORACLE: LOG ERRORS clause in INSERT, DELETE, UPDATE	Stalled	Unassigned
27.	Automatic transaction start for sql_mode=ORACLE	Open	Unassigned
28.	Allow %ROWTYPE variable fields as FETCH INTO targets	Open	Unassigned
29.	Add support for TRIGGERS that fire on multiple events	Open	Unassigned
30.	sql_mode=ORACLE: allow derived tables not to have aliases	Open	Unassigned
31.	sql_mode=ORACLE: CURRENT_DATE function	Open	Dmitry Tolpeko
32.	ROW data type for built-in function return values	Open	Alexander Barkov
33.	sql_mode=ORACLE: Package metadata views	Open	Unassigned
34.	Make INSTR understand optional parameters for position and occurence	Open	Unassigned
35.	sql_mode=ORACLE: Date and timestamp formats	Open	Unassigned
36.	sql_mode=ORACLE: Make TRIM return NULL instead of empty string	Closed	Alexander Barkov
37.	sql_mode=ORACLE: Make LPAD and RPLAD return NULL instead of empty string	Closed	Alexander Barkov
38.	Package-wide variables in CREATE PACKAGE	Stalled	Alexander Barkov

Activity

People

Assignee:: Unassigned

Reporter:: Alvin Richards (Inactive)

Votes:: 3 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2016-09-07 16:24

Updated:: 2023-09-16 10:32

Git Integration

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