why invoke "SHOW VARIABLES LIKE 'auto_increment_increment'" after repo.InsertAll?

[hxgdzyuyi]

step 1

	if err = repo.InsertAll(ctx, &beInsertedAnswers); err != nil {
		return
	}

step 2

2022/07/06 18:19:17 [duration: 1.442817ms op: adapter-exec] INSERT INTO `answers` (`answer_text`,`attempt_id`,....) VALUES (?,?,?,?,?,?,?);
2022/07/06 18:19:17 [duration: 1.398397ms op: adapter-query] SHOW VARIABLES LIKE 'auto_increment_increment';

why invoke "SHOW VARIABLES LIKE 'auto_increment_increment'" after repo.InsertAll?

[Fs02]

because MySQL database driver only returns the last inserted id, and (depending on config), inserted id won't always incremented by 1, therefore we need to know the increment setting to populate the id for the rest of inserted records

[hxgdzyuyi]

how can i close this feature ?

[Fs02]

do you mean close this issue? or stop using "SHOW VARIABLES LIKE 'auto_increment_increment'" query?

[hxgdzyuyi]

stop using "SHOW VARIABLES LIKE 'auto_increment_increment'" query?

[hxgdzyuyi]

stop using "SHOW VARIABLES LIKE 'auto_increment_increment'" query

[Fs02]

it's not supported at the moment, please open a PR to allow specifying custom increment function
https://github.com/go-rel/mysql/blob/main/mysql.go#L52

[hxgdzyuyi]

IncrementFunc only invoke in insertAll ?

[Fs02]

yes

[hxgdzyuyi]

Can I do that?

			dsn := fmt.Sprintf(
				"%s:%s@tcp(%s:%s)/%s?charset=utf8&parseTime=True&loc=Local",
				ko.String("DB_USERNAME"),
				ko.String("DB_PASSWORD"),
				ko.String("DB_HOST"),
				ko.String("DB_PORT"),
				ko.String("DB_DATABASE"),
			)

			adapter, err := mysql.Open(dsn)

			if err != nil {
				return nil, err
			}

			sp, ok := adapter.(*sql.SQL)

			if !ok {
				return nil, errors.New("adapter 获取错误")
			}

			(*sp).IncrementFunc = nil

			return adapter, nil

[Fs02]

I guess you can, just try it
if you do that, auto_increment_increment will be set to 1

[hxgdzyuyi]

yes~

[hxgdzyuyi]

thanks