[jira] Commented: (DERBY-1809) Built-in functions not working in views.

["Daniel John Debrunner (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-1809?page=comments#action_12433304 ] 
            
Daniel John Debrunner commented on DERBY-1809:
----------------------------------------------

Simple fix, the AliasDescriptor's isPersistent() method was always reporting true, which means the descriptor was expected to be on disk,
however these builtin functions do no exist in SYSALIASES, so when the schema of an AliasDescriptor is SYSFUN, its isPersistent() method should return false.

> Built-in functions not working in views.
> ----------------------------------------
>
>                 Key: DERBY-1809
>                 URL: http://issues.apache.org/jira/browse/DERBY-1809
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.1.0, 10.3.0.0
>            Reporter: Richard Wheeldon
>         Assigned To: Daniel John Debrunner
>         Attachments: broken.sql, working.sql
>
>
> The built-in functions acos, asin, degrees, radians, log, floor, etc. all fail to work when used in views. The following transcript demonstrates the problem:
> ij version 10.3
> ij> connect 'jdbc:derby:test;create=true';
> ij> create table simple_tab (
>   x integer
> );
> 0 rows inserted/updated/deleted
> ij> insert into simple_tab values (1);
> 1 row inserted/updated/deleted
> ij> select acos(x) y from simple_tab;
> Y                     
> ----------------------
> 0.0                   
> 1 row selected
> ij> create view simple_acos_view as (
> 	select acos(x) y from simple_tab
> );
> ERROR 42X94: OBJECT '2fb0c07e-010d-6f90-2909-00000012ff18' does not exist.
> ij> 
> quit;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira