Post reply

sql parser is forgiving

  • September 23, 2005 at 2:42 pm

    #90004

    --northwind - how weird is this?

    select *from Products where UnitPrice>30ORDER BY ProductID

    select * from Products where UnitPrice > 30 ORDER BY ProductID

     

  • September 23, 2005 at 2:51 pm

    #592788

    Most parsers get rid of the spaces internally and tokens are the ones that define the "limits" on the language. Depending on the way the parsing is done it may be perfectly acceptable. For example no variable name can start with a number therefore the 0 of 30 and the "O" of order by have a natural boundary for which space is not required, still the parser is able to Identify the tokens correctly

    Cheers

     


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply