Crashes with LOBs with Duplicated Alias
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 322
- Forks
- 99
- PR merge metrics
- No merged PRs in 30d
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the supplied SAP HANA query in node-hdb, focusing on duplicate aliases where the first selected field is a LOB. Trace the crash through the query result handling and compare it with the same query in HDB Studio. Done means the module no longer crashes and returns both columns, including when the LOB appears first.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, node.js
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100