Azure / Azure/azure-functions-host
SQL Input Binding parameters does not support single query parameter with comma-separated values
- Dominant language
- C#
- Stars
- 2k
- Forks
- 482
- Avg merge
- 2d 12h
- Merged PRs (30d)
- 38
Description
```
export const sqlInputFlashReportData = input.sql({
commandText: "SOME STORED PROCEDURE",
commandType: "StoredProcedure",
parameters:
"@LotIDs={Query.LotIDs}",
connectionStringSetting: "SqlConnectionString",
});
```
Where LotIDs =` 5659d42f-cdca-44b0-9799-6f1e60fbf6fa,17abde92-9e3a-49bd-b67d-6065ff7a624`
I tried to do solve by below example, but it still does not work. It seems to take only LotIDs = 789
multiple parameters with the same key, like:
`LotIDs=123&LotIDs=456&LotIDs=789`
Pls help
Contributor guide
Research direction
The issue provides no repository file, test, or entry point to start from. Reproduce the SQL input binding configuration with a comma-separated LotIDs value and the repeated-key form, then trace the parameter handling to determine the expected behavior. Done means the supported behavior is implemented and covered by a regression test, or the limitation is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, csharp, sql
- Domain
- backend, cloud, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100