dynamobi/adminui — Issue #46: [DADMINUI-13] FlexSQLAdmin is not properly quoting identifiers
Author: dynamobi-build
Created: 2011-12-30 01:16:59+00:00
State: open
Labels: Screens

[reporter="ngoodman", created="Tue, 8 Jun 2010 15:16:45 -0700", resolved="Wed, 9 Jun 2010 18:44:29 -0700"]

Do the following to demonstrate issue with identifier quoting:

0: jdbc:luciddb:http://localhost> create schema "s1";

No rows affected (0.124 seconds)

0: jdbc:luciddb:http://localhost> set schema '"s1"';

No rows affected (0.026 seconds)

0: jdbc:luciddb:http://localhost> create table "lowercase" ( c1 int );

No rows affected (0.3 seconds)

In FlexSQLAdmin, click on the new table, and "Open Table" You'll get the following error.

Error Executing Query: From line 1, column 15 to line 1, column 26: Table 'S1.LOWERCASE' not found

The Schema / Table name needs to properly quote identifiers: "s1"."lowercase"