Details
Description
Hi Colm ,
Not sure if this is expected behaviour or not.
1. Create prepared stmt
prepare kg1234 from select * from default limit 2 - Success
|
2. Run named prepared kg1234 - Success
Ketakis-MacBook-Pro:testrunner ketaki$ curl -v 10.6.2.164:8093/query/service -u Administrator:password -d 'prepared="kg1234"'
|
3. trying to redefine kg1234 with a different clause
cbq> prepare kg1234 from select * from default where i_id>0;
|
{
|
"requestID": "caaa9e38-38e4-44b7-bb2c-a4c338e5cdde",
|
"errors": [
|
{
|
"code": 4060,
|
"msg": "Unable to add name: duplicate name: kg1234"
|
}
|
],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "4.101727ms",
|
"executionTime": "3.939084ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"errorCount": 1
|
}
|
}
|
Does the above mean - kg1234 can never again be used elsewhere?
It was my understanding that I can re-use the same name ( replace in place of a drop prepared stmt)
Is the above expected to work? Or will this be a error code testing.