MYSQL using LIKE doesn't allow for wildcards

[torrayne]

The generated code asks for a int which prevents me from providing something like "10_" or "%10"

/* name: ListExtensions :many */
SELECT `id`,
    `student_id`,
    `length`,
    `created_at`
FROM `extensions`
WHERE `student_id` LIKE ?

Generated code

const listExtensions = `-- name: ListExtensions :many
select id, student_id, length, created_at from extensions where student_id like ? order by created_at desc limit 25
`

type ListExtensionsRow struct {
	ID        int       `json:"id"`
	StudentID int       `json:"student_id"`
	Length    int       `json:"length"`
	CreatedAt time.Time `json:"created_at"`
}

func (q *Queries) ListExtensions(ctx context.Context, student_id int) ([]ListExtensionsRow, error) {
	rows, err := q.query(ctx, q.listExtensionsStmt, listExtensions, student_id)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	items := []ListExtensionsRow{}
	for rows.Next() {
		var i ListExtensionsRow
		if err := rows.Scan(
			&i.ID,
			&i.StudentID,
			&i.Length,
			&i.CreatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

[torrayne]

Using the new mysql:beta engine LIKE just doesn't work at all.

[kyleconroy]

Reproduced the error here.