Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1809

Built-in functions not working in views.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      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 y from simple_tab;
      Y
      ----------------------
      0.0

      1 row selected
      ij> create view simple_acos_view as (
      select acos y from simple_tab
      );

      ERROR 42X94: OBJECT '2fb0c07e-010d-6f90-2909-00000012ff18' does not exist.
      ij>
      quit;

        Attachments

        1. derby1809_diff.txt
          2 kB
          Daniel John Debrunner
        2. ASF.LICENSE.NOT.GRANTED--working.sql
          0.6 kB
          Richard Wheeldon
        3. ASF.LICENSE.NOT.GRANTED--broken.sql
          1 kB
          Richard Wheeldon

          Activity

            People

            • Assignee:
              djd Daniel John Debrunner
              Reporter:
              zcacrgw Richard Wheeldon
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: