Skip to content

Crashes with LOBs with Duplicated Alias #212

@fort-j

Description

@fort-j

The module appears to catastrophically crash when executing a query asking for two or more fields with the same Alias with the type of the first one being db_Memo (an LOB) and the other one being something different, e.g.:

SELECT TOP 1 OCLG."Notes", OCRD."Notes"
FROM [DB].OCRD OCRD
JOIN [DB].OCLG OCLG ON OCLG."CardCode" = OCRD."CardCode"

This issue should occur for fields of all non-LOB types if an LOB is asked first with the same alias. While having fields with the same alias is not ideal, at the very least it shouldn't crash the module. Also, this same query works without any issue when run on HDB Studio and even brings back both coulmns.

I hope this issue can be fixed as the module is very useful otherwise.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions