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