Submitted by: Bill Oliver (verbguy)

Tested against 2.0.3, but presume this is present in all versions.

Trivial issue noticed by our tester, and confirmed by Claudio.

Note that trying to create a table with a zero-length identifier fails with descriptive error.

SQL> create table "" (i integer);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-Zero length identifiers are not allowed

Dropping table with zero-length identifier, gives an error message that doesn't look quite right.

SQL> drop table "" ;
Statement failed, SQLCODE = -607
Table does not exist
SQL>

Claudio says...

The problem is that error messages give you the name of the table unquoted and unescaped:

SQL> drop table "oli vier";
Statement failed, SQLCODE = 42S02
Dynamic SQL Error
-SQL error code = -607
-Invalid command
-Table oli vier does not exist
SQL> drop table "o""malley";
Statement failed, SQLCODE = 42S02
Dynamic SQL Error
-SQL error code = -607
-Invalid command
-Table o"malley does not exist

We would need a special case for blank, not sure how many places have to be changed. You guessed right that this is 99% irrelevant for us, compared to other pending tasks we have.