Re: New features in HSQLDB version 2.3.4 Release Candidate 2

Fred Toussi schrieb am 21.03.2016 um 14:21:
> See the changelist:
>
> http://hsqldb.org/doc/2.0/changelist_2_0.txt
>
> Important new capabilities such as UUID type and SYNONYM have been
> added.


Where can I retrieve information about existing synonyms?

I can't find a table in information_schema that contains this information.

Also when dropping a table that is used by a synonym, this gives an exception:

   create table foo (id integer);
   create synonym syn_foo for foo;

   drop table foo cascade;

results in:


Caused by: org.hsqldb.HsqlException: java.lang.RuntimeException: unsupported internal operation: SchemaManager
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.result.Result.newErrorResult(Unknown Source)
     at org.hsqldb.StatementSchema.execute(Unknown Source)
     at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
     at org.hsqldb.Session.executeDirectStatement(Unknown Source)
     at org.hsqldb.Session.execute(Unknown Source)
     ... 7 more
Caused by: java.lang.RuntimeException: unsupported internal operation: SchemaManager
     at org.hsqldb.error.Error.runtimeError(Unknown Source)
     at org.hsqldb.SchemaManager.removeSchemaObject(Unknown Source)
     at org.hsqldb.SchemaManager.removeSchemaObjects(Unknown Source)
     at org.hsqldb.SchemaManager.dropTable(Unknown Source)
     at org.hsqldb.SchemaManager.dropTableOrView(Unknown Source)
     at org.hsqldb.StatementSchema.dropTable(Unknown Source)
     at org.hsqldb.StatementSchema.getResult(Unknown Source)
     ... 11 more




------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140