Hi, Could you check if it's a 'special character' (for example a non-breaking space, or another strange character that looks like a space but is in fact not)? There was a change in 1.3.156 (The SQL parser silently ignored characters such as '^' or '\'. Now a syntax error is thrown. )
Regards, Thomas On Sat, Jun 25, 2011 at 4:29 PM, Rami Ojares <[email protected]> wrote: > Hi, > > I noticed a problem with concatenation || operator in the newest version. > I could not come up with a simple use case so the it must be a subtle bug in > the parser. > Anyway here is a statement that fails after the concatenation operator in > the FULLTITLE column. > The way to fix it is to remove all whitespace around the concatenation > operator like this: > TYPE||': '||DISPLAY_NAME AS FULLTITLE, and then the statement works. > > Syntax error in SQL statement "CREATE TABLE > EXODUS_VIEW.FLEXIBLE_PROGRAM_VIEW AS SELECT * FROM (SELECT > *, > DISPLAY_NAME AS TITLE, > TYPE || ': ' ||[*] DISPLAY_NAME AS FULLTITLE > FROM ( > SELECT > PN.PNID, > PN.NAME, > PN.LANG_ID, > PN.DISPLAY_NAME, > PN.PARENT_ID, > PN.CAPTION, > PN.DESCRIPTION, > PN.NOTES, > PN.IMAGE_ID, > > PN.DEFAULT_DURATION_5MIN, > > PN.SERIES_ID, > SPN.DISPLAY_NAME AS SERIES_NAME, > C.CATEGORY_ID, > C.NAME AS CATEGORY_NAME, > PN.PATH, > C.COLOR, > 'JOUSTAVA_OHJELMA' AS TYPE > FROM ( > EXODUS_VIEW.PROGRAM_NODES PN > LEFT JOIN EXODUS_VIEW.PROGRAM_NODES SPN ON PN.SERIES_ID = SPN.PNID > > JOIN EXODUS.FLEXIBLE_PROGRAM FP ON PN.PNID = FP.PNID > > LEFT JOIN EXODUS.CATEGORY C ON PN.CATEGORY_ID = C.CATEGORY_ID > ) > > )) WHERE FALSE > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" 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/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en.
