sql.Result.RowsAffected() can't return correct result when execute multiple sql.

[guoyuanchao1202]

Issue description

When execute multiple sql like following

Example code

CREATE TABLE `test_binlog`
(
    `id`          bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_type_unsigned`  tinyint unsigned NOT NULL,
    `order_type`  tinyint NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

result, err := db.Exec("INSERT INTO `test_db`.`test_binlog` VALUES (1,2,3);INSERT INTO `test_db`.`test_binlog` VALUES (2,3,4);" )

Result

if success, then expect result is 2 but return 1

[guoyuanchao1202]

Hi, masters Do we accumulate each read instead of equal? Or give a configuration for the user to choose? Because in some scenarios we really need the summed result, thanks

[methane]

#1309 will solve this issue. I just not have time to review it carefully for now.
Please wait.

[guoyuanchao1202]

okay, see it, thanks:)