This feature is about providing finer control over auto-batched DML statements.
Reference (java-spanner & go-sql-spanner):
These libraries support AUTO_BATCH_DML_UPDATE_COUNT and AUTO_BATCH_DML_UPDATE_COUNT_VERIFICATION as system variables. This allows users to specify the expected update count for buffered DML and to verify it against the actual count returned by Spanner.
Implementation suggestion for spanner-mycli:
- Add
AUTO_BATCH_DML_UPDATE_COUNT and AUTO_BATCH_DML_UPDATE_COUNT_VERIFICATION to the system variable map.
- Implement the
read/write logic for these variables, affecting the behavior of DML statements when AUTO_BATCH_DML is enabled.
This feature is about providing finer control over auto-batched DML statements.
Reference (
java-spanner&go-sql-spanner):These libraries support
AUTO_BATCH_DML_UPDATE_COUNTandAUTO_BATCH_DML_UPDATE_COUNT_VERIFICATIONas system variables. This allows users to specify the expected update count for buffered DML and to verify it against the actual count returned by Spanner.Implementation suggestion for
spanner-mycli:AUTO_BATCH_DML_UPDATE_COUNTandAUTO_BATCH_DML_UPDATE_COUNT_VERIFICATIONto the system variable map.read/writelogic for these variables, affecting the behavior of DML statements whenAUTO_BATCH_DMLis enabled.