occur err when using dameng

[fanspace]

gomod
github.com/casbin/xorm-adapter/v3 v3.4.0
github.com/casbin/casbin/v2 v2.88.0

code
a, err = xormadapter.NewAdapter("dm", settings.Database.DamengSettings.Url, true)

errs
{"level":"error","msg":"sql: Scan error on column index 1, name "DATA_DEFAULT": cannot convert string as dmClobScanner"}

[hsluoyz]

@fanspace can you provide a dameng test env?

[fanspace]

`Casbin init error
{"level":"error","msg":"Error -4097: 单行子查询返回多行\nstack info:\n 1). mydm.(*dm_build_151).dm_build_184\n \tD:/myproject/backgate/723\n 2). mydm.(*dm_build_151).dm_build_140\n \tD:/myproject/backgate/dm/zq.go:710\n 3). mydm.(*dm_build_151).dm_build_143\n \tD:/myproject/backgate/dm/zq.go:764\n 4). mydm.(*dm_build_1345).dm_build_1388\n \tD:/myproject/backgate/dm/a.go:275\n 5). mydm.(*dm_build
_1345).Dm_build_1456\n \tD:/myproject/backgate/dm/a.go:480\n 6). mydm.(*DmStatement).executeInner\n \tD:/myproject/backgate/d d
m/u.go:998\n 7). mydm.(*DmStatement).query\n \tD:/myproject/backgate/dm/u.go:414\n 8). mydm.(*DmConnection).queryContext\n \tD:/m
ystone/backgate/dm/m.go:653\n 9). mydm.(filterChain).DmConnectionQueryContext\n \tD:/myproject/backgate/dm/zd.go:169\n 10). mydm.(
reconnectFilter).DmConnectionQueryContext\n \tD:/myproject/backgate/dm/zf.go:259\n 11). mydm.(*filterChain).DmConnectionQueryContext\n
\tD:/myproject/backgate/dm/zd.go:166\n 12). mydm.(*DmConnection).QueryContext\n \tD:/myproject/backgate/dm/m.go:303\n 13). database
/sql.ctxDriverQuery\n \tC:/Users/dell/.g/go/src/database/sql/ctxutil.go:48\n 14). database/sql.(*DB).queryDC.func1\n \tC:/Users/de
ll/.g/go/src/database/sql/sql.go:1748\n 15). database/sql.withLock\n \tC:/Users/dell/.g/go/src/database/sql/sql.go:3502\n 16). dat
abase/sql.(*DB).queryDC\n \tC:/Users/dell/.g/go/src/database/sql/sql.go:1743\n 17). database/sql.(*DB).query\n \tC:/Users/dell/.g/
go/src/database/sql/sql.go:1726\n 18). database/sql.(*DB).QueryContext.func1\n \tC:/Users/dell/.g/go/src/database/sql/sql.go:1704\n
19). database/sql.(*DB).retry\n \tC:/Users/dell/.g/go/src/database/sql/sql.go:1538\n 20). database/sql.(*DB).QueryContext\n \tC:
/Users/dell/.g/go/src/database/sql/sql.go:1703\n 21). xorm.io/xorm/core.(*DB).QueryContext\n \tD:/gosrc/pkg/mod/xorm.io/xorm@v1.3.2/c
ore/db.go:151\n 22). xorm.io/xorm/dialects.(*dameng).GetColumns\n \tD:/gosrc/pkg/mod/xorm.io/xorm@v1.3.2/dialects/dameng.go:847\n 2
3). xorm.io/xorm.(*Engine).loadTableInfo\n \tD:/gosrc/pkg/mod/xorm.io/xorm@v1.3.2/engine.go:359\n 24). xorm.io/xorm.(*Session).Sync
n \tD:/gosrc/pkg/mod/xorm.io/xorm@v1.3.2/session_schema.go:315\n 25). xorm.io/xorm.(*Engine).Sync\n \tD:/gosrc/pkg/mod/xorm.io/xor
m@v1.3.2/engine.go:1122\n 26). xorm.io/xorm.(*Engine).Sync2\n \tD:/gosrc/pkg/mod/xorm.io/xorm@v1.3.2/engine.go:1128\n 27). github.
com/casbin/xorm-adapter/v3.(*Adapter).createTable\n \tD:/gosrc/pkg/mod/github.com/casbin/xorm-adapter/v3@v3.4.0/adapter.go:245\n 28).
github.com/casbin/xorm-adapter/v3.(*Adapter).open\n \tD:/gosrc/pkg/mod/github.com/casbin/xorm-adapter/v3@v3.4.0/adapter.go:241\n 29).
github.com/casbin/xorm-adapter/v3.NewAdapter\n \tD:/gosrc/pkg/mod/github.com/casbin/xorm-adapter/v3@v3.4.0/adapter.go:105\n 30). ba
ckgate/rbac.InitCasbin\n \tD:/myproject/backgate/rbac/casbin.go:25\n 31). main.main\n \tD:/myproject/backgate/main.go:18\n 32). runtime.main\n \tC:/Users/dell/.g/go/src/runtime/proc.go:267\n"}

`

[hsluoyz]

@fanspace what's your dameng DB version? Where to download a free version for testing? If not, can you provide a connect string for test?

[fanspace]

the version of dameng is 8.1.3 , you'll get the driver from https://gitee.com/forxing/dm
the free download url of dameng database is https://eco.dameng.com/download/
they also provide a docker version

[MuZhou233]

I believe this is not adapter's problem. Here your could see the lines raised this error.

xorm-adapter/adapter.go

Lines 244 to 246 in 634e6df

	func (a *Adapter) createTable() error {
	return a.engine.Sync2(&CasbinRule{tableName: a.getFullTableName()})
	}

As Sync2 is provided by xorm, I suggest you refer to them for help.