Re: Oracle Bug?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sun, 24 Apr 2005 14:38:25 +0100
Message-ID: <5r7n611ek1ieefahdlg1vl5joou4j9ou7q@4ax.com>

On 24 Apr 2005 06:18:21 -0700, "hpuxrac" <johnbhurley_at_sbcglobal.net> wrote:

>Perhaps if Mr. Morgan sets the silver bullet undocumented parameter
>_return_scn_now_of_some_future_time he will get the results he is
>looking for.

 This parameter also enables the new Flashforward Query option, allowing potentially highly profitable queries.

SQL> SELECT winning_number
  2 FROM lottery
  3 WHERE draw_date > sysdate
  4 AS OF TIMESTAMP (SYSTIMESTAMP + INTERVAL '30' DAY); AS OF TIMESTAMP (SYSTIMESTAMP + INTERVAL '30' DAY);

                              *

ERROR at line 4:
ORA-50283: space/time paradox detected, universe destroyed

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Sun Apr 24 2005 - 08:38:25 CDT