If your use " then the upper/lower case is considered significant and the errors are indeed correct. On 20/01/16 11:33, Pierre-Adrien Coustillas wrote:
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
-- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35 // 09 54 38 70 90
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list