SAP / SAP/node-hdb

Crashes with LOBs with Duplicated Alias

Open
#212 0 comments 0 reactions 0 assignees View on GitHub

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.