Bug? Sub selects require their own semicolons

[finn-matti]

This sql makes it necessary to include three semicolons in the end to terminate syntax highlighting:

                SELECT
                    CONCAT(
                        z.expected,
                        IF(
                            z.got-1>z.expected,
                            CONCAT(' bis ',z.got-1),
                            ''
                        )
                    ) AS missing
                FROM (
                    SELECT
                        @rownum:=@rownum+1 AS expected,
                        IF(
                            @rownum=CAST(SUBSTR(bestellId, 2) AS UNSIGNED),
                            0,
                            @rownum:=CAST(SUBSTR(bestellId, 2) AS UNSIGNED)
                        ) AS got
                    FROM (
                        SELECT @rownum:=$lastId
                    ) AS a
                    JOIN $tname
                    ORDER BY CAST(SUBSTR(bestellId, 2) AS UNSIGNED)
                    -- TODO: exclude lower ids (> minIds)
                    -- WHERE CAST(SUBSTR(bestellId, 2) AS UNSIGNED) > $lastId
                    ) AS z
                WHERE z.got!=0;;;

Mysql is not my strong suit, so I'm unsure if this is correct behavior. What I can tell is, that adding semicolons in the end of every sub select and the root statement is not working/produces an sql syntax error.

[iuyoy]

Hi finn-matti, I can't get the same issue with your code in Python. What language are you using?

[finn-matti]

Sorry, this is so long ago, that I can't remember this issue at all. Please close if you think it was a mistake on my part. I sadly don't have the time to investigate.

[iuyoy]

Never mind.