Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
1.2.1
-
None
Description
This is a general comment and a known issue of the current code but I think it's worth making the issue more visible as it may cause some confusion.
A colleague recently issued this query to a binlog server:
mysql> select @@server_uuid, @@server_id, @@global.hostname;
|
+--------------------------------------+
|
| @@server_uuid |
|
+--------------------------------------+
|
| 6800aaaa-0869-1aa5-8550-1458aaaaeed0 |
|
+--------------------------------------+
|
The result as you see gives a single column resultset whereas the query requested 3 columns of data. The parsing of the statements by the binlog router is rather basic at the moment. It would be good if this could be more complete, and at least in the case above, if the query does not match what the binlog router understands it should probably give an error rather than partially respond with an answer as that may confuse the client (in this case orchestrator).
So please consider improving the parsing of the statements and reporting any issues appropriately.
Note: the BLR is not a RDBMS so it's not expected that it can understand all SQL commands. All that we want is that it is able to parse enough commands to be able to provide the right responses to a slave and also some status output needed for monitoring or some commands needed to manage the BLR's state.
Attachments
Issue Links
- relates to
-
MXS-584 binlog_router disconnects client after wrong sql
- Closed