[MDEV-10593] sql_mode=ORACLE: TYPE .. AS OBJECT: basic functionality - Jira

Details

Type: Technical task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: OTHER
Labels:
- Compatibility

Description

Add support for basic functionality for TYPE .. OBJECT.

Under terms of this tasks we'll implement declaration of objects with members only. Objects with methods are out of scope of this task.

This task will however include implementations of simple constructors to initialize members

  var struct_a_b_t:= struct_a_b_t(1,2);

Example

Creating an object data type and a corresponding table type.

DROP TYPE struct_a_b_t;

CREATE TYPE struct_a_b_t AS OBJECT

  a INT,

  b INT

);

DROP TYPE table_of_struct_a_b_t;

CREATE TYPE table_of_struct_a_b_t AS TABLE OF struct_a_b_t;

Using the new data types:

DROP FUNCTION f1;

CREATE FUNCTION f1 RETURN INT

AS

  tbl table_of_struct_a_b_t:= table_of_struct_a_b_t();

  rec struct_a_b_t:= struct_a_b_t(10,1);

  a INT;

BEGIN

  tbl.extend;

  tbl(1) := rec;

  tbl.extend;

  tbl(2) := struct_a_b_t(20,2);

  SELECT SUM(a+b) INTO a FROM TABLE(tbl);

  RETURN a;

END;

SELECT f1() FROM DUAL;

      F1()

----------

Dropping the data types:

DROP TYPE table_of_struct_a_b_t;

DROP TYPE struct_a_b_t;

Attachments

Issue Links

is blocked by

MDEV-4912 Data type plugin API version 1

Closed

MDEV-10914 ROW data type for stored routine variables

Closed

relates to

MDEV-10592 sql_mode=ORACLE: TYPE .. TABLE OF for scalar data types

Open

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2016-08-18 07:13

Alexander Barkov made changes - 2016-08-18 07:15

Field	Original Value	New Value
Description	Add support for basic functionality for {{TYPE .. OBJECT}}. Under terms of this tasks we'll implement declaration of objects with members only. Objects with methods are out of scope of this task. h2. Example Creating an object data type and a corresponding table type. {code:sql} DROP TYPE struct_a_b_t; CREATE TYPE struct_a_b_t AS OBJECT ( a INT, b INT ); / DROP TYPE table_of_struct_a_b_t; CREATE TYPE table_of_struct_a_b_t AS TABLE OF struct_a_b_t; / {code} Using the new data types: {code:sql} DROP FUNCTION f1; CREATE FUNCTION f1 RETURN INT AS tbl table_of_struct_a_b_t:= table_of_struct_a_b_t(); rec struct_a_b_t:= struct_a_b_t(10,1); a INT; BEGIN tbl.extend; tbl(1) := rec; tbl.extend; tbl(2) := struct_a_b_t(20,2); SELECT SUM(a+b) INTO a FROM TABLE(tbl); RETURN a; END; / SELECT f1() FROM DUAL; {code} {noformat} F1() ---------- 33 {noformat} Dropping the data types: {code:sql} DROP TYPE table_of_struct_a_b_t; DROP TYPE struct_a_b_t; {code}	Add support for basic functionality for {{TYPE .. OBJECT}}. Under terms of this tasks we'll implement declaration of objects with members only. Objects with methods are out of scope of this task. This task will however include simple constructors to initialize members {code:sql} var struct_a_b_t:= struct_a_b_t(1,2); {code} h2. Example Creating an object data type and a corresponding table type. {code:sql} DROP TYPE struct_a_b_t; CREATE TYPE struct_a_b_t AS OBJECT ( a INT, b INT ); / DROP TYPE table_of_struct_a_b_t; CREATE TYPE table_of_struct_a_b_t AS TABLE OF struct_a_b_t; / {code} Using the new data types: {code:sql} DROP FUNCTION f1; CREATE FUNCTION f1 RETURN INT AS tbl table_of_struct_a_b_t:= table_of_struct_a_b_t(); rec struct_a_b_t:= struct_a_b_t(10,1); a INT; BEGIN tbl.extend; tbl(1) := rec; tbl.extend; tbl(2) := struct_a_b_t(20,2); SELECT SUM(a+b) INTO a FROM TABLE(tbl); RETURN a; END; / SELECT f1() FROM DUAL; {code} {noformat} F1() ---------- 33 {noformat} Dropping the data types: {code:sql} DROP TYPE table_of_struct_a_b_t; DROP TYPE struct_a_b_t; {code}

Alexander Barkov made changes - 2016-08-18 07:16

Description

Add support for basic functionality for {{TYPE .. OBJECT}}.

Under terms of this tasks we'll implement declaration of objects with members only. Objects with methods are out of scope of this task.

This task will however include simple constructors to initialize members
{code:sql}
  var struct_a_b_t:= struct_a_b_t(1,2);
{code}

h2. Example
Creating an object data type and a corresponding table type.
{code:sql}
DROP TYPE struct_a_b_t;
CREATE TYPE struct_a_b_t AS OBJECT
(
  a INT,
  b INT
);
/
DROP TYPE table_of_struct_a_b_t;
CREATE TYPE table_of_struct_a_b_t AS TABLE OF struct_a_b_t;
/
{code}

Using the new data types:
{code:sql}
DROP FUNCTION f1;
CREATE FUNCTION f1 RETURN INT
AS
  tbl table_of_struct_a_b_t:= table_of_struct_a_b_t();
  rec struct_a_b_t:= struct_a_b_t(10,1);
  a INT;
BEGIN
  tbl.extend;
  tbl(1) := rec;
  tbl.extend;
  tbl(2) := struct_a_b_t(20,2);
  SELECT SUM(a+b) INTO a FROM TABLE(tbl);
  RETURN a;
END;
/
SELECT f1() FROM DUAL;
{code}
{noformat}
      F1()
----------
33
{noformat}

Dropping the data types:
{code:sql}
DROP TYPE table_of_struct_a_b_t;
DROP TYPE struct_a_b_t;
{code}

Add support for basic functionality for {{TYPE .. OBJECT}}.

Under terms of this tasks we'll implement declaration of objects with members only. Objects with methods are out of scope of this task.

This task will however include implementations of simple constructors to initialize members
{code:sql}
  var struct_a_b_t:= struct_a_b_t(1,2);
{code}

h2. Example
Creating an object data type and a corresponding table type.
{code:sql}
DROP TYPE struct_a_b_t;
CREATE TYPE struct_a_b_t AS OBJECT
(
  a INT,
  b INT
);
/
DROP TYPE table_of_struct_a_b_t;
CREATE TYPE table_of_struct_a_b_t AS TABLE OF struct_a_b_t;
/
{code}

Using the new data types:
{code:sql}
DROP FUNCTION f1;
CREATE FUNCTION f1 RETURN INT
AS
  tbl table_of_struct_a_b_t:= table_of_struct_a_b_t();
  rec struct_a_b_t:= struct_a_b_t(10,1);
  a INT;
BEGIN
  tbl.extend;
  tbl(1) := rec;
  tbl.extend;
  tbl(2) := struct_a_b_t(20,2);
  SELECT SUM(a+b) INTO a FROM TABLE(tbl);
  RETURN a;
END;
/
SELECT f1() FROM DUAL;
{code}
{noformat}
      F1()
----------
33
{noformat}

Dropping the data types:
{code:sql}
DROP TYPE table_of_struct_a_b_t;
DROP TYPE struct_a_b_t;
{code}

Michael Widenius made changes - 2016-08-18 11:22

Link

This issue is part of MDEV-10137 [ MDEV-10137 ]

Michael Widenius made changes - 2016-08-18 12:15

Link

This issue is part of ~~MDEV-10142~~ [ ~~MDEV-10142~~ ]

Michael Widenius made changes - 2016-08-18 12:15

Link

This issue is part of MDEV-10137 [ MDEV-10137 ]

Michael Widenius made changes - 2016-08-18 12:22

Parent		~~MDEV-10142~~ [ 56873 ]
Issue Type	Task [ 3 ]	Technical task [ 7 ]

Michael Widenius made changes - 2016-08-18 12:22

Link

This issue is part of ~~MDEV-10142~~ [ ~~MDEV-10142~~ ]

Alvin Richards (Inactive) made changes - 2016-08-18 16:25

Labels

Compatibility

Alvin Richards (Inactive) made changes - 2016-08-18 16:32

Labels

Compatibility

Alvin Richards (Inactive) made changes - 2016-09-01 07:16

Labels

Compatibility

Alvin Richards (Inactive) made changes - 2016-09-01 17:27

Labels

Compatibility

Sergei Golubchik made changes - 2016-09-20 16:47

Labels

Compatibility

Alexander Barkov made changes - 2016-10-04 06:39

Link

This issue is blocked by ~~MDEV-10914~~ [ ~~MDEV-10914~~ ]

Alvin Richards (Inactive) made changes - 2016-11-07 23:32

Labels

Compatibility

Compatibility NRE-307517

Alvin Richards (Inactive) made changes - 2016-12-21 19:29

NRE Projects

NRE-307517

Alvin Richards (Inactive) made changes - 2016-12-21 19:40

Labels

Compatibility NRE-307517

Compatibility

Alexander Barkov made changes - 2017-03-16 16:11

Link

This issue relates to MDEV-10592 [ MDEV-10592 ]

Alexander Barkov made changes - 2017-03-16 16:11

Link

This issue is blocked by ~~MDEV-4912~~ [ ~~MDEV-4912~~ ]

Elena Stepanova added a comment - 2017-04-23 18:37

Should probably be 10.3

Elena Stepanova added a comment - 2017-04-23 18:37 Should probably be 10.3

Alexander Barkov made changes - 2017-04-23 19:34

Fix Version/s		10.3 [ 22126 ]
Fix Version/s	10.2 [ 14601 ]

Alvin Richards (Inactive) made changes - 2017-09-22 18:03

Parent

~~MDEV-10142~~ [ 56873 ]

MDEV-10764 [ 57940 ]

Sergei Golubchik made changes - 2018-02-14 15:40

Fix Version/s

10.3 [ 22126 ]

Ralf Gebhardt made changes - 2019-02-14 09:48

Support case ID

not-26307

Ralf Gebhardt made changes - 2019-02-14 10:00

NRE Projects

AC-2610/DEFERRED

Jira Update Service made changes - 2019-04-03 02:49

Support case ID

26767 not-26307

not-26307 not-26767

Sergei Golubchik made changes - 2021-12-06 21:32

Workflow

MariaDB v3 [ 76699 ]

MariaDB v4 [ 140043 ]

Jira Automation (IT) made changes - 2024-07-04 08:52

Zendesk Related Tickets

128135

People

Assignee:: Unassigned

Reporter:: Alexander Barkov

Votes:: 4 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2016-08-18 07:13

Updated:: 2024-07-08 01:11

Git Integration

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

MariaDB Server

Details

Description

Example

Attachments

Issue Links

Activity

People

Dates

Git Integration