timestamp/view strangeness

[oleaka]

Hi,

can someone explaint to me what is going on here:
When I execute the query:
select interval('sec', current_timestamp);
it gives the number of seconds since 1970 (6.339706057700001E10), as I expect.

Then I define a view based on this query:
create view timestamp_test as select interval('sec', current_timestamp) value;

When I then try to query this view I get an error:
select * from timestamp_test;
=> com.ingres.gcf.util.SqlEx: the interval function does not work on absolute dates.

Why doesn't this work? Why is current_timestamp interpreted as an 'absolute date' in the view, but not in the original query?

I'm running Ingres II 9.1.1.

Thanks
Ole

[kiria01]

Hi Ole,
You have hit bug 121098 which I recently fixed in 9.2.0.
Regards,
Ian

[oleaka]

Ah, ok.

Thank you for the reply. I managed to work around the problem.

Regards
Ole