sqlmock false positive on Exec with ExpectationsWereMet

sqlexec.go

package example

import "database/sql"

func RunExecs(db *sql.DB) {
	_, _ = db.Exec("THE FIRST EXEC")
	_, _ = db.Exec("THE WRONG EXEC")
}

sqlexec_test.go

// All these tests should fail
package example_test

import (
	"testing"

	"github.com/DATA-DOG/go-sqlmock"
	"github.com/SainsburysNDA/example"
)

// False Positive - passes despite mismatched Exec
func TestRunExecsWithOrdered(t *testing.T) {
	db, dbmock, _ := sqlmock.New()
	dbmock.MatchExpectationsInOrder(true) // This is the default
	dbmock.ExpectExec("THE FIRST EXEC")
	dbmock.ExpectExec("THE SECOND EXEC")
	example.RunExecs(db)

	err := dbmock.ExpectationsWereMet()
	if err != nil {
		t.Fatal(err)
	}
}

// Fails as expected
func TestRunExecsWithouOrdered(t *testing.T) {
	db, dbmock, _ := sqlmock.New()
	dbmock.MatchExpectationsInOrder(false)
	dbmock.ExpectExec("THE FIRST EXEC")
	dbmock.ExpectExec("THE SECOND EXEC")
	example.RunExecs(db)

	err := dbmock.ExpectationsWereMet()
	if err != nil {
		t.Fatal(err)
	}
}