create table uppercase with " "

Hello,

bug or feature ?

* PETER in uppercase :

sql>CREATE TABLE "PETER" ( nom varchar(20) ); operation successful (2.545ms)

sql>DROP TABLE PETER; DROP TABLE: no such table 'peter'

sql>DROP TABLE "PETER"; operation successful (1.947ms)

* peter in lowercase :

sql>CREATE TABLE "peter" ( nom varchar(20) ); operation successful (2.917ms)

sql>DROP TABLE peter; operation successful (1.882ms)

* peter in lowercase and uppercase :

sql>CREATE TABLE "peter" ( nom varchar(20) ); operation successful (2.900ms)

sql>CREATE TABLE PETER ( nom varchar(20) ); CREATE TABLE: name 'peter' already in use

sql>CREATE TABLE "PETER" ( nom varchar(20) ); operation successful (9.339ms)

Conclusion : PETER is convert in peter "PETER" is not convert

Pierre Coustillas