Invalid parameter: 'parameter (5)' contains different types.
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 322
- Forks
- 99
- PR merge metrics
- No merged PRs in 30d
Description
Hi Colleague,
This is a consulting issue. I got an error message when attempting to inserting data into a hdb table as below.
It seems that if the data type of attribute to be inserted is different from what it defines in db, then the error message will be reported. Even if the data type is string in db, and input data type is number, the data type conversion will be not handled by hana client automatically. I am not sure if it is a normal behavior. Could you please help to clarify?
Thank you very much.
BR,
Qin
| Your Project Name | https://github.tools.sap/ROCKETS/sample-cap-change-history-fe |
|---|---|
| OData version | v4 |
| Node.js version | v14.18.0 |
| @sap/cds | 5.6.1 |
| @sap/hana-client | 2.11.14 |
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
The report names no repository file, test, or entry point; begin by reproducing the insert against an HDB table using the listed Node.js, @sap/cds, and @sap/hana-client versions. Compare the table attribute types with the inserted values, then establish whether conversion is expected and document the behavior that should be considered done.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, node.js
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100