Skip to content

MySQL missing update args ON DUPLICATE KEY UPDATE #921

Closed
@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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions