While running an external function, the following error message is received:
Error: Function received the wrong number of rows
What is causing this to occur?
While running an external function, the following error message is received:
Error: Function received the wrong number of rows
What is causing this to occur?
The error message indicates that the function received the wrong number of rows. This suggests that there is a mismatch between the number of rows expected and the number actually processed by the function. The correct answer is that the return message did not produce the same number of rows that it received.
The remote service tried to return more or fewer rows than it received. Even though the function is nominally scalar, it might receive multiple rows in the body field of the event parameter, and should return exactly as many rows as it received.