You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Richard Wheeldon (JIRA)" <de...@db.apache.org> on 2006/09/02 21:23:22 UTC
[jira] Created: (DERBY-1809) Built-in functions not working in
views.
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.3.0.0
Reporter: Richard Wheeldon
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
[jira] Commented: (DERBY-1809) Built-in functions not working in
views.
Posted by "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
[jira] Updated: (DERBY-1809) Built-in functions not working in
views.
Posted by "Rajesh Kartha (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Rajesh Kartha updated DERBY-1809:
---------------------------------
Affects Version/s: 10.2.1.0
10.2.2.0
The issue exists in 10.2 also, updating the Affects Verisons accordingly.
> 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.3.0.0, 10.2.1.0, 10.2.2.0
> Reporter: Richard Wheeldon
> 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
[jira] Updated: (DERBY-1809) Built-in functions not working in
views.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Daniel John Debrunner updated DERBY-1809:
-----------------------------------------
Affects Version/s: (was: 10.2.2.0)
10.2.2.0 doesn't exist yet so the bug doesn't exist there!
> 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
> 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
[jira] Assigned: (DERBY-1809) Built-in functions not working in
views.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Daniel John Debrunner reassigned DERBY-1809:
--------------------------------------------
Assignee: Daniel John Debrunner
> 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
[jira] Updated: (DERBY-1809) Built-in functions not working in
views.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Daniel John Debrunner updated DERBY-1809:
-----------------------------------------
Fix Version/s: 10.3.0.0
patch committed to trunk Committed revision 441601
> 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.3.0.0, 10.2.1.0
> Reporter: Richard Wheeldon
> Assigned To: Daniel John Debrunner
> Fix For: 10.3.0.0
>
> Attachments: broken.sql, derby1809_diff.txt, 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
[jira] Resolved: (DERBY-1809) Built-in functions not working in
views.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Daniel John Debrunner resolved DERBY-1809.
------------------------------------------
Fix Version/s: 10.2.1.0
Resolution: Fixed
> 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
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: broken.sql, derby1809_diff.txt, 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
[jira] Updated: (DERBY-1809) Built-in functions not working in
views.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1809?page=all ]
Daniel John Debrunner updated DERBY-1809:
-----------------------------------------
Attachment: derby1809_diff.txt
Patch that adds an isPersistent() method to AliasDescriptor and has a simple test case of two builtin functions in a view.
> 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.3.0.0, 10.2.1.0
> Reporter: Richard Wheeldon
> Assigned To: Daniel John Debrunner
> Attachments: broken.sql, derby1809_diff.txt, 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