That's it exactly!
One of the spaces was a non-breaking space.
Thanks!
But why isn't a non-breaking space considered a whitespace character?
Further would be nice to get some sort of error report other than just
syntax error and stack trace.
- rami
On 25.6.2011 17:32, Thomas Mueller wrote:
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.
