SQL Server Catalog读表异常

Viewed 106
2.1 catalog

doris版本：selectdb-doris-2.1.5
sqlserver版本：Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
driver_url:mssql-jdbc-11.2.3.jre8.jar
doris catalog 读SQLServer表语句：
1、SELECT COUNT() AS NUM,UDF023 FROM ERP_SQLSERVER.dbo.PURCHASE_ARRIVAL_D GROUP BY UDF023;
image.png
2、SELECT COUNT() AS NUM FROM ERP_SQLSERVER.dbo.PURCHASE_ARRIVAL_D WHERE UDF023=''
image.png
SQLServer 原库读表语句：
1、SELECT COUNT() AS NUMBER,UDF023 FROM PURCHASE_ARRIVAL_D GROUP BY UDF023;
image.png
2、SELECT COUNT() AS NUMBER FROM PURCHASE_ARRIVAL_D WHERE UDF023='';
image.png

  • SQLServer 中 UDF023=''
  • doris SQLServer catalog 会把部分字段值'' 识别成' '
Alstore27
2 Answers

sql server 版本要求2012+
image.png

阿渊@SelectDB5460

如果我没记错的话,sql server建议是2012版本起步

simple1