查询排序规则为Chinese_PRC_CS_AI_WS的sql server数据库,提示('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]对象名 'blocklog' 无效。 (208) (SQLExecDirectW)")
Open
- Dominant language
- Python
- Stars
- 7k
- Forks
- 1.9k
- Avg merge
- 2d 11h
- Merged PRs (30d)
- 6
Description
### 重现步骤
1、数据库配置的排序规则是

2、Archery上查询报错
('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]对象名 'blocklog' 无效。 (208) (SQLExecDirectW)")
### 预期外的结果
同上。
### 日志文本
_No response_
### 版本
1.9.1
### 部署方式
Docker
### 是否还有其他可以辅助定位问题的信息?比如数据库版本等
_No response_
Contributor guide
Research direction
Reproduce the query against a SQL Server database using the Chinese_PRC_CS_AI_WS collation and inspect the SQL Server query path that produces the invalid object name 'blocklog'. No source files or tests are identified in the issue; done means the query no longer fails with this 42S02 error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100