Hello AsterixDB team, I am posting a request from post man along with named and positioned parameters. But somewhere I am making a mistake. Could you please help me with this?
1. Named parameters *Request* http://localhost:19002/query/service statement: use TinySocial; select * from Trailers where carrierId = *$p_str* ; p_str: WM *Response:* { "requestID": "7008c7f2-1579-4a81-9cb7-4e9033d42b41", "errors": [ { "code": 1, "msg": "ASX1086: No value for parameter: $p_str (in line 1, at column 59)" } ], "status": "fatal", "metrics": { "elapsedTime": "2.551659ms", "executionTime": "2.225153ms", "resultCount": 0, "resultSize": 0, "processedObjects": 0, "errorCount": 1 } } 2. Positioned parameters *Request* http://localhost:19002/query/service statement: use TinySocial; select * from Trailers where carrierId = *?*; args: ['WM'] *Response* { "requestID": "0a5971e6-c749-46a5-bd62-c1bd68e0f437", "errors": [ { "code": 1, "msg": "ASX1086: No value for parameter: $p_str (in line 1, at column 59)" } ], "status": "fatal", "metrics": { "elapsedTime": "3.27977ms", "executionTime": "2.913792ms", "resultCount": 0, "resultSize": 0, "processedObjects": 0, "errorCount": 1 } } Thank you, Bhukailas
