db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1809) Built-in functions not working in views.
Date Fri, 08 Sep 2006 03:18:23 GMT
    [ 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

        

Mime
View raw message