Pagination Issues With bridge.list_community_roles
When attempting to use pagination with bridge.list_community_roles, a sql error occurs. Example query:
curl -s --data '{"jsonrpc":"2.0", "method":"bridge.list_community_roles", "params" : {"community" : "hive-169321","last" : "xves", "limit" : 100}, "id" : 1}' https://api.deathwing.me
Returned Response:
{"jsonrpc":"2.0","error":{"code":-32000,"message":"Server error","data":"CardinalityViolation: more than one row returned by a subquery used as an expression\nCONTEXT: SQL statement \"SELECT COALESCE((\r\n SELECT role_id\r\n FROM hive_roles\r\n WHERE account_id = (SELECT id from hive_accounts WHERE name = _last)\r\n ),0)\"\nPL\/pgSQL function bridge_list_community_roles(character varying,character varying,integer) line 10 at SQL statement\n"},"id":1}
This only occurs when the last parameter is supplied.