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.
