Hi developers,
When viewing the queries sent to the server via SQL: select * from queue order by tag desc; I noticed that the column "query" does NOT lists the original queries sent to the server, but changed ones. It has replaced all single quote characters ' by prefixing them with a backslash , so ' Also it appends a \n; after the SQL statement when no ; character was present at the end. Both changes are undesirable and unneeded.
Due to the added \ characters the content of the query field can no longer be copied into an SQL client (such as mclient or JdbcClient or SQuirreL) and rerun easily. All the \ characters must be manually removed, which is very annoying and error-prone.
Why isn't the original query received by the server stored and returned by sys.queue.query?
Can it be changed to only store the exact received SQL query string, so without any changes/alterations made to the query string? Also no adding of \n; characters.
I am using latest release MonetDB Oct2020-SP5.
Regards, Martin