I have written a stored procedure and called it from the voltdb node client. I am getting following response
{"type":2,"error":false,"buffer":{"type":"Buffer","data":[0,0,0,206,0,48,48,48,48,48,48,48,50,0,1,128,0,0,0,1,0,4,0,0,0,43,0,0,0,23,128,0,1,6,0,0,0,15,109,111,100,105,102,105,101,100,95,116,117,112,108,101,115,0,0,0,1,0,0,0,8,0,0,0,0,0,0,0,1,0,0,0,43,0,0,0,23,128,0,1,6,0,0,0,15,109,111,100,105,102,105,101,100,95,116,117,112,108,101,115,0,0,0,1,0,0,0,8,0,0,0,0,0,0,0,1,0,0,0,43,0,0,0,23,128,0,1,6,0,0,0,15,109,111,100,105,102,105,101,100,95,116,117,112,108,101,115,0,0,0,1,0,0,0,8,0,0,0,0,0,0,0,1,0,0,0,43,0,0,0,23,128,0,1,6,0,0,0,15,109,111,100,105,102,105,101,100,95,116,117,112,108,101,115,0,0,0,1,0,0,0,8,0,0,0,0,0,0,0,1]},"position":69,"length":206,"protocol":0,"uid":"00000002","fieldsPresent":0,"status":1,"statusString":"SUCCESS","appStatus":-128,"appStatusString":"","exceptionLength":1,"table":[[{"modified_tuples":1}]]}
Now, in table field it always returns "modified_tuples": 1 irrespective of how many elements I insert or update.
Can anyone tell me how to get the affected rows count in the query response?
click to view stored procedure code here
