Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16508

spider: sql_mode not maintained between spider node and data nodes

    Details

      Description

      This was noticed some time ago and I believe is still present. No explicit bug report was made at the time.

      If the spider node and data nodes have a different sql_mode setup then this may cause issues.

      Example seen was to have sql_mode = STRICT_TRANS_TABLES on data nodes and the spider node and some input data which was accepted on the spider node was rejected by the data node as not being valid. This broke the data load. Other mismatches could also trigger issues.

      My expectation would for the spider node to validate the data nodes' sql_mode matches the spider node, or to push out the spider node's current sql_mode setting (or when it changes as we can have session local sql_nodes) to the data nodes on connection or as the value changes.

      I think this still applies in spider on 10.3.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Kentoku Kentoku
                Reporter:
                sjmudd Simon Mudd
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: