dotnetcore / dotnetcore/FreeSql
KingbaseESV008R006 数据库 在MySQL兼容模式下 同步表结构报错
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
**问题描述及重现代码:**
fsql.CodeFirst.SyncStructure(tables)
**安装的Nuget包**
FreeSql.Provider.KingbaseES 3.5.105.0
**运行环境:** .net framework 4.8
**数据库版本:** KingbaseESV008R006
**SyncStructure内执行的SQL:**
select d.description
from sys_class a
inner join sys_namespace b on b.oid = a.relnamespace
left join sys_description d on d.objoid = a.oid and objsubid = 0
where upper(b.nspname) not in ('SYS_CATALOG', 'INFORMATION_SCHEMA', 'TOPOLOGY', 'SYSAUDIT', 'SYSLOGICAL', 'SYS_TEMP_1', 'SYS_TOAST', 'SYS_TOAST_TEMP_1', 'XLOG_RECORD_READ') and a.relkind in ('r') and b.nspname = 'PUBLIC' and a.relname = 'TStationVersion'
and upper(b.nspname || '.' || a.relname) not in ('PUBLIC.GEOGRAPHY_COLUMNS','PUBLIC.GEOMETRY_COLUMNS','PUBLIC.RASTER_COLUMNS','PUBLIC.RASTER_OVERVIEWS')
**错误信息:** function upper(boolean) is not unique
**初步猜测 mysql兼容模式下, upper(b.nspname || '.' || a.relname) 中的||会被视为OR而不是连接串**
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.