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>


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

Original text of this message