Skip to content

SQL Server image data type is not supported #1578

@nj1973

Description

@nj1973

We have a customer validating SQL Server and PostgreSQL data. They have some columns of "image" data type. When working on #1577 I added a table of many SQL Server data types, the image column caused errors.

To reproduce errors we can add "col_image" back into the test constant DVT_SQL_SERVER_TYPES_COLUMNS.

FAILED tests/system/data_sources/test_sql_server.py::test_column_validation_sql_server_types - sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Operand data type image is invalid...
FAILED tests/system/data_sources/test_sql_server.py::test_row_validation_sql_server_types - sqlalchemy.exc.DataError: (pyodbc.DataError) ('22018', '[22018] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Explicit conversion from data type image to varc...

Metadata

Metadata

Assignees

Labels

type: feature request'Nice-to-have' improvement, new feature or different behavior or design.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions