Skip to content

Conversation

@sapk
Copy link
Contributor

@sapk sapk commented Aug 31, 2023

I got in a case similar to #1503. This PR will fix #1503.

I found one discrepancy between column definition between create table and alter definition. I fix it by defining a common sub function.

On generic engine update part, it was missing to create enum on alter table statement compared to create. I added an argument to the func createEnum to override previous definition when needed.

I added two tests to cover the two ALTER case MODIFY and CHANGE.

I only know very few part of the codebase so let me know If I need to change anything to make this merged.

@kyleconroy kyleconroy merged commit b581867 into sqlc-dev:main Oct 13, 2023
kyleconroy added a commit that referenced this pull request Oct 13, 2023
Extends the work done in #2680 to support adding and dropping columns and tables.

Fixes #2475
@sapk sapk deleted the fix-1503 branch October 14, 2023 06:45
alfonsodev pushed a commit to ExponentiaTeam/sqlc that referenced this pull request Oct 13, 2025
I got in a case similar to sqlc-dev#1503. This PR will fix sqlc-dev#1503.

I found one discrepancy between column definition between create table and alter definition. I fix it by defining a common sub function.

On generic engine update part, it was missing to create enum on alter table statement compared to create. I added an argument to the func createEnum to override previous definition when needed.

I added two tests to cover the two ALTER case MODIFY and CHANGE.

I only know very few part of the codebase so let me know If I need to change anything to make this merged.
alfonsodev pushed a commit to ExponentiaTeam/sqlc that referenced this pull request Oct 13, 2025
Extends the work done in sqlc-dev#2680 to support adding and dropping columns and tables.

Fixes sqlc-dev#2475
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

ALTER TABLE MODIFY enum not respected

2 participants