CI: Add revive

[dveeden]

Using revive as linter might be good. However this would need a reasonable config and probably fixing of some issues like missing comments on exported functions.

@lance6716 @atercattus what do you think?

[lance6716]

Do you mean turn on revive in current CI framework

go-mysql/.github/workflows/ci.yml

Lines 84 to 93 in 5acb569

	golangci:
	name: golangci
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- name: golangci-lint
	uses: golangci/golangci-lint-action@v6
	with:
	version: latest
	args: --timeout=3m

https://golangci-lint.run/usage/linters/#revive

LGTM then.