Error in Documentation? (Subqueries in CHECK Constraints / SQL92-Assertions)
Timmy Turner <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <CA+uKMZBZ5DHbApOjHiX475GUkJTE4s_=QuvrmsRCzWDViC-Myg@mail.gmail.com> |
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