hhyo / hhyo/Archery

查询排序规则为Chinese_PRC_CS_AI_WS的sql server数据库,提示('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]对象名 'blocklog' 无效。 (208) (SQLExecDirectW)")

Open
#2,189 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
7k
Forks
1.9k
Avg merge
2d 11h
Merged PRs (30d)
6

Description

### 重现步骤

1、数据库配置的排序规则是
![image](https://github.com/hhyo/Archery/assets/27276951/d8a1f91c-fd4a-4495-91ce-25064c722e34)
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.