[source-MSSQL] MSSQL source columns prefixed with '_' are loaded as NULL in destination
- 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
Bewertung
Dieses Issue wurde noch nicht bewertet.