Details
Description
When executing a prepared statement in the Go SDK, we first prepare it by prefixing PREPARE, then we follow through by actually executing the plan. We do this by passing a the prepared and encoded_plan fields. When executing a query which includes no where clause, this works as expected. Each ‘invocation’ of the same prepared plan executes correctly, however upon introducing a where clause to the query, the plan only executes once successfully, and all following executions return success but no results. This behaviour is confirmed to occur in our C/C++ SDK as well.
Works:
SELECT airportname FROM `travel-sample` ORDER BY airportname ASC LIMIT 20
Fails:
SELECT airportname FROM `travel-sample` WHERE type='airport' ORDER BY airport name ASC LIMIT 20