cloudflare-mysql
cloudflare-mysql copied to clipboard
console.log and unknown queries
The library itself is working today, but I found some points that could be improved and checked:
- When executing the connection and queries it has console.log in everything, it seems to me as it always shows me buffer and connection logs. Maybe withdrawing would be an option.
- I had a problem when executing a query with subquery, it was returning [Error: ER_UNKNOWN_COM_ERROR: Unknown command]. My subquery:
SELECT ......, (SELECT GROUP_CONCAT(DISTINCT subd.user_id SEPARATOR ',') FROM deposit AS subd WHERE subd.document = d.document AND subd.paid_commission = 0 AND subd.status IN (?) LIMIT 3) AS groups_userids FROM ......
When I changed it to the original library and running it in aws lambda it worked correctly, even in phpmyadmin it also runs normally.
Unfortunately, as of today we do not have direct compatibility with MySQL along with Workers, so this library gives us a possibility. If it is possible to address these points we would be grateful.