Possible SQLPLUS bug

From: <sloan_at_nrlvx1.nrl.navy.mil>
Date: 21 Feb 92 09:47:33 -0400
Message-ID: <1992Feb21.094733.669_at_nrlvx1.nrl.navy.mil>

The possible bug has to do with the COMPUTE statement. If you have a column name such as ON_*, and try to do the following COMPUTE :  

     COMPUTE SUM OF ON_SITE_HRS ON NAME   you get the following message : COMPUTE ON KEYWORD SPECIFIED ALREADY It seems that its mistaking the ON (in ON_SITE_HRS) for the keyword ON. I have run into this on the following platforms :  

• sqlplus : 3.0.6 rdbms : 6.0.30 os : VAX/VMS 5.4
• sqlplus : 3.0.9 rdbms : 6.2.6 os : VAX/VMS 5.4

Also interesting, is if you have a column named ON*, then the COMPUTE does not have a problem : COMPUTE SUM OF ONSITEHRS ON NAME  

Two work-arounds that I have found :  

• modify SELECT statement to use an alias : SELECT ON_SITE_HRS HOURS, ... and then COMPUTE SUM OF HOURS ON NAME
• modify COMPUTE statement only to treat column as string : COMPUTE SUM OF 'ON_SITE_HRS' ON NAME

Has anyone else run into this and/or has then been reported before?  

JC Sloan Received on Fri Feb 21 1992 - 14:47:33 CET