Skip to content

MySQL missing update args ON DUPLICATE KEY UPDATE #921

@koodimetsa

Description

@koodimetsa

Generated code is missing args for the update part on duplicate key update.
For example:

/* name: UpdateDeviceOnlineTime :exec */
INSERT INTO devices_online_status
  (device_id, last_online)
VALUES
    (?, ?)
ON DUPLICATE KEY UPDATE
last_online = ?;

generates

func (q *Queries) UpdateDeviceOnlineTime(ctx context.Context, arg UpdateDeviceOnlineTimeParams) (sql.Result, error) {
	return q.db.ExecContext(ctx, updateDeviceOnlineTime, arg.DeviceID, arg.LastOnline)
}

arg.LastOnline should be twice, but is now once.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions