gf-casbin icon indicating copy to clipboard operation
gf-casbin copied to clipboard

SQLite使用时报错,SQL logic error: near "=": syntax error (1)

Open lexno opened this issue 1 year ago • 0 comments

如果使用SQLite时,会执行SQL: CREATE TABLE IF NOT EXISTS %s ( ptype VARCHAR(10) NOT NULL DEFAULT '', v0 VARCHAR(256) NOT NULL DEFAULT '', v1 VARCHAR(256) NOT NULL DEFAULT '', v2 VARCHAR(256) NOT NULL DEFAULT '', v3 VARCHAR(256) NOT NULL DEFAULT '', v4 VARCHAR(256) NOT NULL DEFAULT '', v5 VARCHAR(256) NOT NULL DEFAULT '' ) COMMENT = 'policy table'; 但是SQLite不支持COMMENT 指令,导致执行此条SQL时报错: SQL logic error: near "=": syntax error (1)

解决方案,将COMMENT = 'policy table'删除。

lexno avatar Oct 14 '24 07:10 lexno