Chinese and Japanese comment text affects the execution of SQL statements

What did you do?

i created a sample SQL statement, and add some comment:

CREATE TABLE "FileDetails" (
	"id"	INTEGER UNIQUE,
	"Field1"	TEXT,
	"Field3"	TEXT,
	PRIMARY KEY("id" AUTOINCREMENT)
)
--Test SQL: 有列FileName, Field1, Field2. 冩一條sql語句根據FileName 模糊查詢: 首先根據 Fields1, 然後根據每個分組的Fields2值倒序, 然後合並所有
select * from FileDetails

What did you expect to see?

Get the results

What did you see instead?

Video_2024-09-12_175401.mp4

DB4S Version

3.13.0

What OS are you seeing the problem on?

Windows

OS version

Windows10

Relevant log output

No response

Prevention against duplicate issues

  • I have searched for similar issues