Additional reserved words could then include: SQL/XML: XML (already added) | XMLAGG | XMLATTRIBUTES | XMLBINARY | XMLCONCAT | XMLCOMMENT | XMLELEMENT | XMLFOREST | XMLNAMESPACES | XMLPARSE | XMLPI | XMLROOT | XMLSERIALIZE SQL/MED: DATALINK | DLNEWCOPY | DLPREVIOUSCOPY | DLURLCOMPLETE | DLURLCOMPLETEWRITE | DLURLCOMPLETEONLY | DLURLPATH | DLURLPATHWRITE | DLURLPATHONLY | DLURLSCHEME | DLURLSERVER | DLVALUE | IMPORT I could also look into updating the parser to remove unnecessary reserved words, such as oj, fn, timestamp(add|diff), sql_tsi... constants, etc., but since these are unlikely identifiers it seems unnecessary. ----- Original Message ----- From: "John Doyle" <jdoyle(a)redhat.com&gt; To: "Ramesh Reddy" <rareddy(a)redhat.com&gt; Cc: "teiid-users" <teiid-users(a)lists.jboss.org&gt;, "teiid-dev" <teiid-dev(a)lists.jboss.org&gt;, "Steven Hawkins" <shawkins(a)redhat.com&gt; Sent: Monday, March 1, 2010 10:07:24 AM GMT -06:00 US/Canada Central Subject: Re: [teiid-dev] [teiid-users] additional reserved words for Teiid 7.0 I would also add in the SQL/XML keywords. ~jd ----- "Ramesh Reddy" <rareddy(a)redhat.com&gt; wrote: > I would like Teiid to take on the support of data types based on DBMS > like MySQL or H2 or HSQL. As we have the supporting DDL based > metadata > on the road map, it would good to add any of those keywords upfront > (that we know of from SQL DDL) > > +1 for adding the all words from the SQL-2003 list you provided. > > Ramesh.. > > On Sun, 2010-02-28 at 23:19 -0500, Steven Hawkins wrote: > > Hello all, > > > > I would like to propose adding additional reserved words. Some of > which would be used immediately others would be place holders for > future features and would help prevent users from using identifier > names that will conflict. There is the potential for breaking > existing vdbs though that use any of these words as an unqualified > identifier. > > > > This includes: > > > > bigint - type alias for long > > decimal - type alias for bigdecimal > > real - type alias for real > > smallint - type alias for short > > tinyint - type alias for byte > > varchar - type alias for string > > > > call - to be used as a standard alternative to exec/execute a stored > procedure > > > > extract function (to be added) targets: > > > > day > > hour > > minute > > month > > second > > timezone_hour > > timezone_minute > > year > > > > Other possible reserved words could include all of > http://savage.net.au/SQL/sql-2003-2.bnf.html#reserved%20word. One > minor issue is that the reserved word input conflicts with our "input" > variable group used in update procedures. Since it wouldn't be used > as a table reference, it would break existing vdbs, but the generated > output strings for parsed commands would include input in double > quotes. > > > > Any thoughts? > > _______________________________________________ > > teiid-users mailing list > > teiid-users(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/teiid-users > > _______________________________________________ > teiid-dev mailing list > teiid-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/teiid-dev _______________________________________________ teiid-users mailing list teiid-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users