mysql: In some cases, the generated sql statement has a BUG

[sanrentai]

1. What version of Go and system type/arch are you using?

go version go1.20.3 windows/amd64

2. What version of GoFrame are you using?

v2.4.1

3. Can this issue be re-produced with the latest release?

yes

4. What did you do?

// CREATE TABLE `tt` (
//	`id` INT(10) NULL DEFAULT NULL,
//	`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci',
//	`value` INT(10) NULL DEFAULT NULL,
//	`dept` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci'
//)
//COLLATE='utf8mb4_0900_ai_ci'
// ENGINE=InnoDB
g.DB().Model("tt").As("s").
		Fields(
			"s.name", // 这field写上会导致BUG出现
			"replace(concat_ws(',',lpad(s.id, 6, '0'),s.name),',','') `code`",
		).
		All()
g.DB().Model("tt").As("s").
		Fields(
			"CASE WHEN dept='物资部' THEN '物资部' ELSE '其他' END dept",
			"sum(s.value)",
		).Group("CASE WHEN dept='物资部' THEN '物资部' ELSE '其他' END"). // 这个CASE 会被引号包围
		All()

5. What did you expect to see?

SELECT s.name,replace(concat_ws(',',lpad(s.id,6,'0'),s.name),',','') `code` FROM `tt` AS s

SELECT CASE WHEN dept='物资部' THEN '物资部' ELSE '其他' END dept,sum(s.value) FROM `tt` AS s GROUP BY CASE WHEN dept='物资部' THEN '物资部' ELSE '其他' END

6. What did you see instead?

SELECT s.name,replace(concat_ws(',',lpad(s.id,'0'),s.name),',','') `code` FROM `tt` AS s

SELECT CASE WHEN dept='物资部' THEN '物资部' ELSE '其他' END dept,sum(s.value) FROM `tt` AS s GROUP BY `CASE` WHEN dept='物资部' THEN '物资部' ELSE '其他' END

[gqcn]

#3304