[MDEV-10142] PL/SQL parser - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Fix Version/s: 10.3.2
Component/s: Parser, Stored routines
Labels:
- 10.3-beta
- Compatibility

Epic Link:
Compatibility
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

is blocked by

MDEV-12347 Valgrind reports invalid read errors in Item_field_row::element_index_by_name

Closed

MDEV-12411 Remove Lex::text_string_is_7bit

Closed

MDEV-12441 Variables declared after cursors with parameters lose value

Closed

MDEV-12846 sql_mode=ORACLE: using Oracle-style placeholders in direct query execution makes the server crash

Closed

is part of

MDEV-10137 Providing compatibility to other databases

Open

relates to

MDEV-10764 PL/SQL parser - Phase 2

Open

MDEV-12962 Testing MDEV-10142 (PL/SQL parser)

Open

MDEV-12518 Unify sql_yacc.yy and sql_yacc_ora.yy

Closed

(3 relates to)

Sub-Tasks

1.	sql_mode=ORACLE: Providing compatibility for basic SQL data types	Closed	Alexander Barkov
2.	sql_mode=ORACLE: Providing compatibility for basic PL/SQL constructs	Closed	Alexander Barkov
3.	EXECUTE IMMEDIATE statement	Closed	Alexander Barkov
4.	sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP\|REUSE} STORAGE ]	Closed	Alexander Barkov
5.	sql_mode=ORACLE: Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1	Closed	Alexander Barkov
6.	sql_mode=ORACLE: FOR loop statement	Closed	Alexander Barkov
7.	sql_mode=ORACLE: Explicit cursor FOR LOOP	Closed	Alexander Barkov
8.	sql_mode=ORACLE: Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND	Closed	Alexander Barkov
9.	sql_mode=ORACLE: SQL%ROWCOUNT	Closed	Alexander Barkov
10.	sql_mode=ORACLE: %TYPE in variable declarations	Closed	Alexander Barkov
11.	sql_mode=ORACLE: SP control functions SQLCODE, SQLERRM	Closed	Alexander Barkov
12.	sql_mode=ORACLE: Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause	Closed	Alexander Barkov
13.	sql_mode=ORACLE: Cursors with parameters	Closed	Alexander Barkov
14.	sql_mode=ORACLE: Variable declarations can go after cursor declarations	Closed	Alexander Barkov
15.	sql_mode=ORACLE: Anonymous blocks	Closed	Alexander Barkov
16.	Expressions as parameters to Dynamic SQL	Closed	Alexander Barkov
17.	Introduce Item_param::CONVERSION_INFO	Closed	Alexander Barkov
18.	sql_mode=ORACLE: Dynamic SQL placeholders	Closed	Alexander Barkov
19.	sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX	Closed	Alexander Barkov
20.	sql_mode=ORACLE: RAISE statement for predefined exceptions	Closed	Alexander Barkov
21.	Extend PREPARE and EXECUTE IMMEDIATE to understand expressions	Closed	Alexander Barkov
22.	ROW data type for stored routine variables	Closed	Alexander Barkov
23.	Diagnostics_area refactoring for user defined exceptions	Closed	Alexander Barkov
24.	sql_mode=ORACLE: User defined exceptions	Closed	Alexander Barkov
25.	sql_mode=ORACLE: CAST(..AS VARCHAR(N))	Closed	Alexander Barkov
26.	Move functions case_stmt_xxx and add_select_to_union_list as methods to LEX	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	Closed	Alexander Barkov
28.	Allow ROW variables as a cursor FETCH target	Closed	Alexander Barkov
29.	sql_mode=ORACLE: cursor%ROWTYPE in variable declarations	Closed	Alexander Barkov
30.	sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT	Closed	Alexander Barkov
31.	sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause	Closed	Alexander Barkov
32.	sql_mode=ORACLE: Understand optional routine name after the END keyword	Closed	Alexander Barkov
33.	sql_mode=ORACLE: Implicit cursor FOR loop	Closed	Alexander Barkov
34.	sql_mode=ORACLE: Inside routines the CALL keywoard is optional	Closed	Alexander Barkov
35.	sql_mode=ORACLE: table%ROWTYPE in variable declarations	Closed	Alexander Barkov
36.	sql_mode=ORACLE: Syntax error in a OPEN cursor with parameters makes the server crash	Closed	Alexander Barkov
37.	sql_mode=ORACLE: Derive length of VARCHAR SP parameters with no length from actual parameters	Closed	Alexander Barkov
38.	Allow ROW variables as SELECT INTO targets	Closed	Alexander Barkov
39.	sql_mode=ORACLE: GOTO statement	Closed	Alexander Barkov
40.	sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters	Closed	Alexander Barkov
41.	Duplicate code cleanup: add function normalize_db_name()	Closed	Alexander Barkov
42.	Add function mysql_create_routine()	Closed	Alexander Barkov
43.	Add function is_native_function_with_warn()	Closed	Alexander Barkov
44.	sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL	Closed	Alexander Barkov
45.	sql_mode=ORACLE: Functions LENGTH() and LENGTHB()	Closed	Alexander Barkov
46.	Parser refactoring for CREATE VIEW,TRIGGER,SP,UDF,EVENT	Closed	Alexander Barkov
47.	Move the code from sp_head::init() to sp_head::sp_head()	Closed	Alexander Barkov
48.	Change sp_head::m_chistics from a pointer to a structure	Closed	Alexander Barkov
49.	Avoid using LEX::spname during CREATE PROCEDURE and CREATE FUNCTION	Closed	Alexander Barkov
50.	Fix the SP code to avoid excessive use of strlen	Closed	Alexander Barkov
51.	Wrap the code in sp.cc into a class Sp_handler	Closed	Alexander Barkov
52.	Cleanup for Sp_handler::show_create_sp	Closed	Alexander Barkov
53.	Cleanup SP code for packages	Closed	Alexander Barkov
54.	sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments	Closed	Alexander Barkov
55.	DELETE statement with the same source and target	Closed	Sergei Golubchik
56.	sql_mode=ORACLE: Make the CONCAT function ignore NULL arguments	Closed	Alexander Barkov
57.	Oracle-compatible function CHR()	Closed	Alexander Barkov
58.	UPDATE statements with the same source and target	Closed	Sergei Golubchik
59.	SHOW CREATE PACKAGE [ BODY ] pkg	Closed	Alexander Barkov
60.	sql_mode=Oracle: substr(): treat position 0 as position 1	Closed	Alexander Barkov
61.	Change Item_func_case to store the predicant in args[0]	Closed	Alexander Barkov
62.	Remove Lex::text_string_is_7bit	Closed	Alexander Barkov
63.	Anchored data types for variables	Closed	Alexander Barkov
64.	Add Database_qualified_name::copy()	Closed	Alexander Barkov
65.	Add LEX::sp_body_finalize_{procedure\|function}	Closed	Alexander Barkov
66.	Add Field_row for SP ROW variables	Closed	Alexander Barkov
67.	Remove the THD parameter from sp_head::init_sp_name()	Closed	Alexander Barkov
68.	sql_mode=EMPTY_STRING_IS_NULL	Closed	Alexander Barkov
69.	Add virtual Field::sp_prepare_and_store_item(), make sp_rcontext symmetric for scalar and ROW	Closed	Alexander Barkov
70.	Oracle-style packages	Closed	Alexander Barkov
71.	Oracle-style packages: Phase#1: Translate packages to databases	Closed	Alexander Barkov

Activity

People

Assignee:: Alexander Barkov

Reporter:: Michael Widenius

Votes:: 3 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2016-05-27 17:34

Updated:: 2018-08-31 15:29

Resolved:: 2017-10-06 03:11

Git Integration

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