Re: Error in Documentation? (Subqueries in CHECK Constraints / SQL92-Assertions)

> We will probably add some support in this area later this year.

Wow, this was unexpected. Can you provide any further details on what this
might look like, or what amount of functionality you will be trying to
cover?

That would add HSQLDB to the list of currently only 2 SQL-based DBMSes that
somewhat support this (one being MS Access/JET(1) and the other MS
SQLServer(2)).

(1) http://support.microsoft.com/kb/201888/en-us

(2)
http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/06/25/scalar-udfs-wrapped-in-check-constraints-are-very-slow-and-may-fail-for-multirow-updates.aspx

(Found those links on
http://stackoverflow.com/questions/6368349/why-dont-dbmss-support-assertion)

2013/2/23 Fred Toussi <[email protected]>

>   The documentation states the Standard and mentions any difference in
> implementation. In this case it misses the fact that subqueries are not yet
> supported in check constraints.
>
>  We will probably add some support in this area later this year.
>
>  Fred
>
>  On Sat, Feb 23, 2013, at 20:31, Timmy Turner wrote:
>
> Hi,
>
>  on
> http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_constraints(or page 48 in the PDF) it says:
>
>  "A CHECK constraint consists of a <search condition> that must not be
> false (can be unknown) for each row of the table. The <search condition>can reference all the columns of the current row, and if it contains a
> <subquery>, other tables and views in the database (excluding its own
> table)."
>
>  Is this actually true or an error in the documentation? Trying a subquery
> in a check constraint gives me a FeatureNotSupportedException.
>
>  Are there any plans to support this functionality (or Assertions in
> general) in the near future?
>
>
> ------------------------------------------------------------------------------
>  Everyone hates slow websites. So do we.
>  Make your web apps faster with AppDynamics
>  Download AppDynamics Lite for free today:
>  http://p.sf.net/sfu/appdyn_d2d_feb
>  *_______________________________________________*
>  Hsqldb-user mailing list
>  [email protected]
>  https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_feb
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user