We were wondering why we sometimes get less than our LIMIT 100 results on our queries, even though the should still have been more results. This is important because we paginate through a big dataset and would like to detect the fact when we reached the last page (which would be signalled by returning less then LIMIT results).

As it turned out this is due to our setting of SET MAX_EXECUTION_TIME=10; to limit the execution time of our queries, which correctly causes timeout errors in MySQL clients (error code 3024) but not with this library. Instead ocaml-mysql returns fewer results without any obvious indication (like an exception) that the underlying query actually failed.

Is there a way to make this library signal errors when this problem happens?