[MDEV-30662] SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.6.8, 10.5(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.8.8, 10.5.22, 10.6.15, 10.9.8, 10.11.5, 11.0.3, 11.1.2, 11.2.1
Component/s: Configuration, Information Schema
Labels:
None
Environment:
Linux CentOs 7

Description

For stored procedures and packages, the text of the object is available in the I_S.ROUTINES table in the routine_definition column. For Oracle SQL/PL packages these are regustered, as expected, in the I_S.ROUTINES table but the ROUTINE_DEFINITION column is empty. The mysql.proc table does keep this in the body column as expected though. The above is true both for PACKAGE and PACKAGE BODY.

Attachments

Issue Links

is duplicated by

MDEV-26480 Add source of PACKAGE and PACKAGE BODY to information_schema.routines(ROUTINE_DEFINITION)

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Anders Karlsson

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-02-16 11:01

Updated:: 2023-09-16 18:50

Resolved:: 2023-07-14 09:58

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1d 0.5h

Git Integration

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