airbytehq / airbytehq/airbyte

[source-MSSQL] MSSQL source columns prefixed with '_' are loaded as NULL in destination

未關閉
#81,280 4 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
area/connectors autoteam community connectors/source/mssql needs-triage team/extensibility type/bug
主要語言
Python
星號
22.1k
分支
5.4k
平均合併
5 小時
30 天內合併 PR
671

描述

### Connector Name

source-mssql

### Connector Version

Microsoft SQL Server (MSSQL) v5.0.0

### What step the error happened?

During the sync

### Relevant information

CREATE TABLE dbo.airbyte_bug_test (
id INT
);

INSERT INTO dbo.airbyte_bug_test
VALUES (1),(2),(3);

CREATE VIEW dbo.airbyte_bug_test_view AS
SELECT
id,
'UNDER' AS _test_under,
'NORMAL' AS test_normal
FROM dbo.airbyte_bug_test;

Expected:
id, _test_under, test_normal
1, UNDER, NORMAL
2, UNDER, NORMAL
3, UNDER, NORMAL

Actual:
id, _test_under, test_normal
1, NULL, NORMAL
2, NULL, NORMAL
3, NULL, NORMAL

Notes:

- Source query returns correct values for both columns.
- Airbyte sync completes successfully.
- Destination table contains values for test_normal.
- Destination table contains NULL for every row in _test_under.
- Renaming _test_under to x_test_under causes values to sync correctly.

### Relevant log output

```shell

```

### Contribute

- [ ] Yes, I want to contribute

---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/13016

貢獻指南

開啟貢獻指南

研究方向

Start with the source-mssql connector and reproduce the sync using the provided CREATE TABLE, view, and INSERT statements. Trace how the view columns are read and mapped, focusing on the leading-underscore column, then verify that _test_under contains UNDER rather than NULL while test_normal remains unchanged.

由索引模型根據 Issue 內容生成。

評估

技術堆疊
sql
領域
data-engineering, databases
Issue 類型
缺陷
難度
3/5
預估耗時
1-2 天
活躍度
冷清
描述清晰度
基本清楚
新手友好度
55/100

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。