Slashdot Mirror

← Back to Stories (view on slashdot.org)

SQL Validator

Posted by michael on from the select-foo-from-bar dept.

clever writes: "Since open standards are good for pretty much everyone except closed source, multi billion, software companies that try to lock their customers into their proprietary technology I thought that the Slashdot readers might welcome a chance to help shape the next SQL-standard. The Mimer SQL Validator lets you validate any given SQL-statement against SQL-92, SQL-99 and, get this, SQL-200x (Draft spec, 2002-01-11). It stores your statement, if you'll allow it, and it will be used by the ISO SQL-200x standards committee to make statistics on commonly used features and errors to be used in the standards work. So, don't ask what SQL can do for you. Ask what you can do for SQL. In the process you will find out the proprietary features that you are already using."

2 of 22 comments (clear)

  1. SQL validator by possible · · Score: 3, Informative
    If ANSI and ISO really wanted to help SQL, they would make the fricking SQL standards available in electronic form without cost, instead of charging hundreds of dollars for them.

    I remember at the last company I worked for, we had one battered copy of the SQL92 standard (which is basically just an annotated BNF grammar) that we shared among the whole office.

  2. Re:Isn't this a sales pitch? by fredrika · · Score: 4, Informative

    No, this is exactly the point. The sql validator validate the SQL and tells you what is and what isn't standard SQL. If Mimer specific SQL is used that's printed. It's the examples that's not standard SQL that is interesting as far as I can see.
    For example, the following example gives to warnings saying that Mimer SQL vendor extension is used and that Constraint management is used:
    CREATE TABLE t (c BIGINT CONSTRAINT c_gt_0 CHECK(c > 0))

    If you change it to the following it will say that Constraint management is used and that a vendor reserved word is used (varchar2 is Oracle specifik I think).
    CREATE TABLE t (c VARCHAR2 CONSTRAINT c_gt_0 CHECK(c > 0))

    That the result says the statement is outside Core SQL 99 doesn't mean it's not standard SQL. The Core SQL 99 is just a part of SQL 99.

    Mimer SQL is just a relational database.