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?

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