Table names with escaped double quotes are rejected

[monetdb-team]

Date: 2014-09-16 15:27:49 +0200
From: @hannesmuehleisen
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2014-10-31 14:13:51 +0100

Comment 20161

Date: 2014-09-16 15:27:49 +0200
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2150.5 Safari/537.36
Build Identifier:

SQL99 allows double quotes in SQL identifiers, encoded as "". for example, the identifier a"b would be escaped as "a""b". However, MonetDB does not support this.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE "a""b";

Actual Results:

Invalid identifier 'a"b'

Expected Results:

Table being created.

Comment 20183

Date: 2014-09-21 18:02:08 +0200
From: @njnes

properly check for " in valid_ident ("" conversion is already done in the step before)

Comment 20341

Date: 2014-10-31 14:13:51 +0100
From: @sjoerdmullender

Oct2014 has been released.