CRUD SQL Result set problems

[Peter Huszar]

In connection with table.select() I have three questions and I haven't found anything after reading
https://dev.mysql.com/doc/x-devapi-userguide/en and searching the internet:


- How can I see and handle that a table.select has an empty result set? In the node.js xdevapi implementation I do not get the result set, only result rows one after another and my .execute(callback) is not even once called.

- Because my callback is called several times I do not know when it is called the last time i.e., when do I get the last row from the result set. How can I see and handle it?

- COUNT(*) / * is not accepted in the select string throwing an unexpected token error at the * character both cases. This is standard SQL, though. I can see that I can use session.sql('SELECT COUNT(*) FROM table') but I am curious to know why not in CRUD then?