Re: Error in Documentation? (Subqueries in CHECK Constraints / SQL92-Assertions)
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1361652328.12456.140661195855957.5AEC7408@webmail.messagingengine.com> |
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 [1]http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_co nstraints (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: [2]http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Hsqldb-user mailing list [3][email protected] [4]https://lists.sourceforge.net/lists/listinfo/hsqldb-user References 1. http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_constraints 2. http://p.sf.net/sfu/appdyn_d2d_feb 3. mailto:[email protected] 4. 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