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

Reply via email to