Bug in PL/SQL 2.0.18.1.0 with MINUS in WHERE clause of DELETE

From: L. Carl Pedersen <l.carl.pedersen_at_dartmouth.edu>
Date: Wed, 10 Aug 1994 23:53:12 -0500
Message-ID: <l.carl.pedersen-1008942353120001_at_kip-sn-97.dartmouth.edu>

See output below for internal error.

my conclusion is that it blows up when you MINUS a MINUS in the WHERE clause of a DELETE. One MINUS works OK. the same clause works fine in other contexts. Adding parenthesis seems to make it go.

    Last interactive login on Wednesday, 10-AUG-1994 11:05     Last non-interactive login on Wednesday, 10-AUG-1994 16:18     Current time: Wednesday, 10-AUG-1994 21:27

    Dartmouth College                           Kiewit Cluster node CEDAR
    Boot disk: $57$DUA51:                       OpenVMS VAX V5.5-2

$
$ sqlplus scott/tiger

SQL*Plus: Release 3.1.3.1.1 - Production on Wed Aug 10 21:28:53 1994

Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

Connected to:
ORACLE7 Server Release 7.0.16.6.0 - Production With the procedural and Parallel Server options PL/SQL Release 2.0.18.1.0 - Production

ADM> create table t as select 1 x from dual;

Table created.

ADM> desc t

 Name                            Null?    Type
 ------------------------------- -------- ----
 X                                        NUMBER

ADM> create or replace procedure bug as
  2 begin
  3 delete from t

  4     where x in
  5           ( select x from t where x = 1
  6             minus
  7             select x from t where x = 2
  8             minus
  9             select x from t where x = 3 );

 10* end bug;
create or replace procedure bug as
*
ERROR at line 1:
ORA-06501: PL/SQL: internal error 1803, arguments: [], [], [], [], [], [], []

ADM> create or replace procedure bug as
  2 begin
  3 delete from t

  4     where x in
  5           ( ( select x from t where x = 1
  6               minus
  7               select x from t where x = 2 )
  8             minus
  9             select x from t where x = 3 );

 10* end bug;

Procedure created.

ADM> Received on Thu Aug 11 1994 - 06:53:12 CEST