LEFT() is defined in MSSqlDialect, which is extended by the 2005 dialect (and again 2008 extends 2005). CAST has also stopped working, and is not defined in these Dialect files (CONVERT works).
On Aug 14, 6:47 am, Fabio Maulo <[email protected]> wrote: > have a look to the dialect you are using and let me know if the LEFT > function is there or not.Thanks. > > 2009/8/13 nerode <[email protected]> > > > > > Other than the fact tha I can find no documentation on this (any links > > appreciated), I've found a change from the previous parser: a > > statement that is designed to be executed against MSSqlServer (2000 or > > 2005 dialect) used to accept the function LEFT(value, count). This > > now throws a NoViableAltException. Replacing it with SUBSTRING(value, > > 1, count) works. > > > Is this intended? Can someone identify other functions that once > > worked but will now fail (at runtime)? > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
