MySQL: only the first RENAME COLUMN in a multi-column ALTER is applied when parsing goose migrations #4493

Version

1.31.1

What happened?

Description

When goose migrations rename multiple columns in a single ALTER TABLE using MySQL RENAME COLUMN, sqlc applies only the first rename. Queries that reference subsequently renamed columns fail code generation.

Environment

• Engine: MySQL
• Migration tool: goose (-- +goose Up / -- +goose Down)
• sqlc config: schema: "migrations" (directory of migration files)

Relevant log output

sqlc generate
# queries/users.sql:2:26: column "display_label" does not exist

Database schema

-- ./migrations/001_create_users.sql

-- +goose Up
CREATE TABLE users (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    label VARCHAR(255) NOT NULL
);

-- +goose Down
DROP TABLE users;

-- ./migrations/002_rename_columns.sql

-- +goose Up
ALTER TABLE users
    RENAME COLUMN name TO display_name,
    RENAME COLUMN label TO display_label;

-- +goose Down
ALTER TABLE users
    RENAME COLUMN display_name TO name,
    RENAME COLUMN display_label TO label;

SQL queries

-- name: GetUserByID :one
SELECT id, display_name, display_label
FROM users
WHERE id = ?;

Configuration

version: "2"
sql:
  - schema: "migrations"
    queries: "queries"
    engine: "mysql"
    gen:
      go:
        out: "gen"

Playground URL

Also reproducible in the playground: https://play.sqlc.dev/p/0c6c6ca61c5a84c31e28e4c943056e6da218ccb4a8ad925589ce736d9850d400

What operating system are you using?

macOS

What database engines are you using?

MySQL

What type of code are you generating?

Go