ektravel commented on code in PR #17593:
URL: https://github.com/apache/druid/pull/17593#discussion_r1894416488
##########
docs/api-reference/sql-api.md:
##########
@@ -85,20 +85,15 @@ The request body takes the following properties:
* `context`: JSON object containing optional [SQL query context
parameters](../querying/sql-query-context.md), such as to set the query ID,
time zone, and whether to use an approximation algorithm for distinct count.
-* `parameters`: List of query parameters for parameterized queries. Each
parameter in the array should be a JSON object containing the parameter's SQL
data type and parameter value. For a list of supported SQL types, see [Data
types](../querying/sql-data-types.md).
+* `parameters`: List of query parameters for parameterized queries. Each
parameter in the array should be a JSON object containing the parameter's SQL
data type and parameter value. For more information on using dynamic
parameters, see [Dynamic parameters](../querying/sql.md#dynamic-parameters).
For a list of supported SQL types, see [Data
types](../querying/sql-data-types.md).
For example:
+
```json
- "parameters": [
- {
- "type": "VARCHAR",
- "value": "bar"
- },
- {
- "type": "ARRAY",
- "value": [-25.7, null, 36.85]
- }
- ]
+ {
+ "query": "SELECT \"arrayDouble\" FROM \"array_example\" WHERE
ARRAY_CONTAINS(\"arrayDouble\", ?)",
+ "parameters": [{"type": "ARRAY", "value": [999, null, 5.5]}]
Review Comment:
The query works for me with or without `0`. Updating it to use `999.0` to
ensure compatibility with a broader audience
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
