RDBPROD: RMU/EXTRACT does not preserve quotes on column names created with quotes (Doc ID 1135963.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.2 to 7.2.4 [Release 7.2]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Tables created with column names enclosed in quotes are not preserved in view definitions generated from RMU/EXTRACT.


SQL> set trans read write;
SQL> set quoting rules 'SQL92';
SQL> create table TEST_TABLE ("NEXT" char(2), "ENTRY#" integer, "TABLES" char(3));
SQL> commit;
SQL> create view TEST_VIEW as
cont> (select C1."NEXT",C1."TABLES", C1."ENTRY#" from TEST_TABLE C1);
SQL> commit;
SQL> sh view test_view
Information for table TEST_VIEW

Columns for view TEST_VIEW:
Column Name Data Type Domain
----------- --------- ------
NEXT CHAR(2)
TABLES CHAR(3)
ENTRY# INTEGER
Source:
(select C1."NEXT",C1."TABLES", C1."ENTRY#" from TEST_TABLE C1)

SQL> $rmu/extr/item=view/option=(nohead,match:TEST_VIEW%)/out=view.sql test_db
SQL> $type view.sql
set verify;
set language ENGLISH;
set default date format 'SQL92';
set quoting rules 'SQL92';
set date format DATE 001, TIME 001;
attach 'filename DSA3:[Y2A.TEST]MF_PERSONNEL.RDB';
create view TEST_VIEW
("NEXT",
"TABLES",
"ENTRY#") as
(select
C1.NEXT,
C1.TABLES,
C1.ENTRY#
from TEST_TABLE C1);

commit work;
SQL> drop view test_view;
SQL> commit;
SQL> set quoting rules 'SQL92';
SQL> @test.sql
SQL> create view TEST_VIEW
cont> ("NEXT",
cont> "TABLES",
cont> "ENTRY#") as
cont> (select
cont> C1.NEXT,
%SQL-I-DEPR_FEATURE, Deprecated Feature: Keyword NEXT used as an identifier
cont> C1.TABLES,
cont> C1.ENTRY#
%SQL-F-BAD_TOKEN, # is not a valid SQL language element
SQL> from TEST_TABLE C1);
from TEST_TABLE C1);
^
%SQL-F-LOOK_FOR_STMT, Syntax error, looking for a valid SQL statement, found FROM instead
SQL>
SQL> commit work;
%SQL-F-NO_TXNOUT, No transaction outstanding
SQL>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms