I am using the databricks-sql-go library version 1.5.2. I am trying to run a query with placeholders of type '?'
The query looks like
params, args := databricksParams(values)
sql := fmt.Sprintf(`SELECT COUNT(*) FROM %s.%s WHERE %s IN (%s)`, schema, table, column, strings.Join(params, ", "))
res, err := conn.Exec(sql, args...)
where params is nothing but a slice of '?' and args are the values I want to query.
I am getting the error
[UNBOUND_SQL_PARAMETER] Found the unbound parameter: _58. Please, fix `args` and provide a mapping of the parameter to a SQL literal.; line 1 pos 58
I have tried with $1,$2 type placeholders as well. Is this not supported with Databricks or am I doing something incorrectly.