[antlr-interest] Re: MS SQL parser - please help testing

[tdjastrzebski]

Thanks. Yes, I am going to upload it to antlr grammar repository when 
it is good enough.
Tom

--- In antlr-interest at yahoogroups.com, "Andrew Deren" <andrew at a...> 
wrote:
> I've run a quick test of few queries.
> The longest one I could find that I use caused parse error, but I 
could
> reduce it to a small example:
> select * from item where createdOn between {ts '2001-08-07 
14:43:32'} and
> {ts '2003-08-07 14:43:32'}
> 
> it doesn't seem to parse time/date values of this format, but when 
I tried
> putting invalid date/time (by mistake)
> select * from item where createdOn between #start_date# and 
#end_date# it
> parsed it fine.
> 
> When I removed the {ts from the query it run fine. I have some more
> complicated queries that I will test.
> 
> Are you going to make the grammar file available? I would be really
> interested in using one.
> Andrew
> 
> -----Original Message-----
> From: tdjastrzebski [mailto:tdjastrzebski at y...] 
> Sent: Thursday, August 07, 2003 12:25 PM
> To: antlr-interest at yahoogroups.com
> 
> Hello everybody,
> I am performing an open test of my MS SQL parser.
> It is simple. If you have any complicated or unusual "select" 
> statement just browse to:
> http://jastrzebski.europe.webmatrixhosting.net/mssqlparser.aspx
> , paste your statement into the textbox, press the "parse" button 
and 
> see results.
> 
> All parse errors are being logged which will help me to improve my 
> parser.
> 
> Thanks in advance for your help.
> 
> Tomasz Jastrzebski
> 
> 
>  
> 
> Your use of Yahoo! Groups is subject to 
http://docs.yahoo.com/info/terms/


 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/