airbytehq / airbytehq/airbyte

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

Offen
#81,280 4 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
area/connectors autoteam community connectors/source/mssql needs-triage team/extensibility type/bug
Vorherrschende Sprache
Python
Sterne
22.1k
Forks
5.3k
PR-Merge-Kennzahlen
PR-Kennzahlen ausstehend

Beschreibung

### 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

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.