[teiid-dev] [teiid-users] additional reserved words for Teiid 7.0

[John Doyle]

I would also add in the SQL/XML keywords.

~jd 
----- "Ramesh Reddy" <rareddy at redhat.com> 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 at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/teiid-users
> 
> _______________________________________________
> teiid-dev mailing list
> teiid-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev