Closed censujiang closed 4 months ago
https://github.com/go-admin-team/go-admin
$ ./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))
sys_casbin_rule
id
ptype
v0
v1
v2
v3
v4
v5
v6
v7
能够正常链接clickhouse
Error 48: Code: 48. DB::Exception: Command [ERRFMT] is not implemented. (NOT_IMPLEMENTED)
当前不支持clickhouse
wenjianzhang
commented
1 year ago wenjianzhang
commented
1 year ago
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(idbigint unsigned AUTO_INCREMENT,ptypevarchar(100),v0varchar(100),v1varchar(100),v2varchar(100),v3varchar(100),v4varchar(100),v5varchar(100),v6varchar(25),v7varchar(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)