sql mode multiline comment lead to more than one sql string split error

[hiliny]

Is there an existing issue for this?

• I have searched the existing issues

Description

what i expect is where i use sql mode, multiline comment dont cause multi sql string split failed

Steps To Reproduce

copy this sql below to demo.gethue.com editor and you will get the error

/**

1. some1
2. some2
   **/
   -- selet *

SELECT * FROM employee1;

-- some else
SELECT * FROM employee_txt;

Logs

No response

Hue version

open source current master

[hiliny]

I mean the current highlight rows is not right! ; I doubt the multiline comment end double * cause this problem。

[bjornalm]

@hiliny thanks for reporting. I can reproduce that multi line comments are not working as expected.
@JohanAhlen, do you know if multiline comments should be supported?

[JohanAhlen]

@hiliny it indeed can't parse the statements with the example you provided.

The issue appears when you use two '*' in the multi line comment delimiters, if you change it to:

/*

some1
some2
*/
-- selet *
SELECT * FROM employee1;

-- some else
SELECT * FROM employee_txt;

It works.

I'll see if we can adjust the parsers to also accept /** and **/.

[github-actions]

This issue is stale because it has been open 30 days with no activity and is not labeled "Prevent stale". Remove "stale" label or comment or this will be closed in 10 days.