Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-3267

Create procedure|function no longer verify that the library exists

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4
    • Component/s: sql-general
    • Labels:
      None

      Description

      In the latest version , create procedure, create table_mapping function, and create function now all fail to verify that the library actually exists. As shown below, the create statements now allow the operation to complete even with a non-existing library 'doesntexist'. This appears to be a regression introduced in a recent version, as they all still return a proper 1389 error in earlier version

      >>drop schema if exists mytest cascade;

      — SQL operation complete.
      >>create schema mytest;

      — SQL operation complete.
      >>set schema mytest;

      — SQL operation complete.
      >>
      >>create procedure myspj()
      +>external name 'abcd.myspj'
      +>library doesntexist
      +>language java
      +>parameter style java;

      — SQL operation complete.
      >>
      >>create table_mapping function mytmudf
      +>(test_what char(100),
      +>test_parm char(100))
      +>external name 'mytmudf'
      +>language cpp
      +>library doesnotexist;

      — SQL operation complete.
      >>
      >>create function myudf
      +>(INVAL char(50))
      +>returns (c_char char(50))
      +>language c
      +>parameter style sql
      +>external name 'myudf'
      +>library doesntexist
      +>deterministic
      +>state area size 1024
      +>allow any parallelism
      +>no sql;

      — SQL operation complete.
      >>
      >>drop schema mytest cascade;

      — SQL operation complete.

        Attachments

          Activity

            People

            • Assignee:
              sandhya Sandhya Sundaresan
              Reporter:
              sandhya Sandhya Sundaresan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: