无法链接clickhouse

[censujiang]

Reproduction link

https://github.com/go-admin-team/go-admin

Steps to reproduce

$ ./go-admin.exe server
2022-11-11 22:01:00.088 0800 info * => default:default@tcp(127.0.0.1:9004)/goadmin?charset=utf8&parseTime=True&loc=Local&timeout=1000ms
2022-11-11 22:01:00.106 0800 info mysql connect success !
2022-11-11 22:01:00.107 0800 trace C:/Users/A/go/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [0.000ms] [rows:-] SELECT DATABASE()
2022-11-11 22:01:00.107 0800 trace C:/Users/A/go/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 Error 48: Code: 48. DB::Exception: Command [ERRFMT] is not implemented. (NOT_IMPLEMENTED) (version 22.10.2.11 (official build)) [0.000ms] [rows:-] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'goadmin%' ORDER BY SCHEMA_NAME='goadmin' DESC,SCHEMA_NAME limit 1
2022-11-11 22:01:00.108 0800 trace C:/Users/A/go/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 [1.001ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = '' AND table_name = 'sys_casbin_rule' AND table_type = 'BASE TABLE'
2022-11-11 22:01:00.108 0800 trace C:/Users/A/go/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 Error 119: Code: 119. DB::Exception: Table engine is not specified in CREATE query. (ENGINE_REQUIRED) (version 22.10.2.11 (official build)) [0.000ms] [rows:0] CREATE TABLE sys_casbin_rule (id bigint unsigned AUTO_INCREMENT,ptype varchar(100),v0 varchar(100),v1 varchar(100),v2 varchar(100),v3 varchar(100),v4 varchar(100),v5 varchar(100),v6 varchar(25),v7 varchar(25),PRIMARY KEY (id))
panic: Error 119: Code: 119. DB::Exception: Table engine is not specified in CREATE query. (ENGINE_REQUIRED) (version 22.10.2.11 (official build))

What is expected?

能够正常链接clickhouse

What is actually happening?

Error 48: Code: 48. DB::Exception: Command [ERRFMT] is not implemented. (NOT_IMPLEMENTED)

Environment	Info
go-admin	undefined
Go	1.19.3
System	win10
Browser	chrome104

[wenjianzhang]

当前不支持clickhouse