Opened 7 years ago

Last modified 6 years ago

#927 new defect

SQL Server FDO provider crashes when querying a table with an 'image' column

Reported by: jng Owned by: jng
Priority: major Milestone: 4.1.0
Component: SQLServer Spatial Version:
Severity: 3 Keywords:
Cc: External ID:

Description

Attached is DDL for a SQL Server table with an image column

If you do a basic ISelect query against this table the client application (be that MapGuide, FDO Toolbox, etc) will crash.

This column does show up in any class definitions requested as a FDO BLOB property

Attachments (2)

db.sql (82.3 KB ) - added by jng 7 years ago.
DDL for example table
GdbiQueryResult.cpp.patch (2.2 KB ) - added by jng 6 years ago.
Patch GdbiQueryResult to ignore RDBI_BLOB and ensure consistent new/delete

Download all attachments as: .zip

Change History (4)

by jng, 7 years ago

Attachment: db.sql added

DDL for example table

by jng, 6 years ago

Attachment: GdbiQueryResult.cpp.patch added

Patch GdbiQueryResult to ignore RDBI_BLOB and ensure consistent new/delete

comment:1 by jng, 6 years ago

The SQL Server image column resolves to type RDBI_BLOB, which causes causes GdbiQueryResult to crash in the destructor due to inconsistent ordering of new/delete operations, which happened to slip under the radar with other RDBI column types, but the inconsistency was exposed with RDBI_BLOB where the destructor will try to delete[] colInfo->value under the current logic

Attached is a patch that will ensure consistent new/delete.

However this still does not make queries that involve SQL Server image columns work as the size reported by SQL Server for RDBI_BLOB is 2^31, which will generally fail allocation with std::bad_alloc under the current allocation code paths in define_exec

So this patch will also skip over RDBI_BLOB in define_exec and ~GdbiQueryResult and no-ops GdbiQueryResult::GetBinaryValue if the column type is RDBI_BLOB. Not desirable, but still a net gain over what currently happens.

Version 0, edited 6 years ago by jng (next)

comment:2 by jng, 6 years ago

Owner: changed from danstoica to jng

Actually, since image is effectively a deprecated column type and slated for removal in a future version of SQL Server (https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql) and since we can't get the FDO provider working with image columns anyways, a better approach to this would be to simply make sure image columns are properly skipped over.

Note: See TracTickets for help on using tickets.