Comment Re:Isn't this a sales pitch? (Score 4, Informative) 22
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.
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.
