Re: New features in HSQLDB version 2.3.4 Release Candidate 2

There is a new INFORMATION_SCHEMA.SYSTEM_SYNONYMS table.

select * from information_schema.system_synonyms

I built and uploaded a new jar just now as the fix for CASCADE was not
in the last jar.

Fred

On Fri, Mar 25, 2016, at 15:28, Thomas Kellerer wrote:
> 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
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
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