Glaring Oracle 9i Bug
From: Jeff Caddel <jcaddel_at_yahoo.com>
Date: 26 Feb 2003 14:49:38 -0800
Message-ID: <b1704b42.0302261449.67669c2_at_posting.google.com>
Date: 26 Feb 2003 14:49:38 -0800
Message-ID: <b1704b42.0302261449.67669c2_at_posting.google.com>
This does not work:
create table foo(id varchar(5), ID varchar(5));
But this does:
create table foo("id" varchar(5), "ID" varchar(5));
The first one produces an error
ERROR at line 1:
ORA-00957: duplicate column name
The second one creates the table and "desc foo" yields: Name Null? Type
----------------- -------- ----------------- id VARCHAR2(5) ID VARCHAR2(5)
This does not seem right at all. After creating this table I can't select from or insert into the lowercase id column. Am I missing something here? I'm doing this using Oracle 9i on Windows 2000 using sqlplus at the command line. Received on Wed Feb 26 2003 - 23:49:38 CET