daichirata / hammer

🛠 hammer is a command-line tool to schema management for Google Cloud Spanner.
MIT License
83 stars 24 forks source link

Differences between the case of table and column names are treated as differences #62

Closed uji closed 2 months ago

uji commented 3 months ago

Spanner does not distinguish between uppercase and lowercase in table and column names. However, in the case of hammer, it does, which leads to the generation of ALTER TABLE statements for renaming when differences are detected. I would like to avoid outputting differences in this case.

When applying an ALTER TABLE statement that changes only the case of letters, the following error occurs.

Column names in table SampleTable differ only in case: SampleColumn, SAMPLECOLUMN.
Failed to execute migration, Column names in table SampleTable differ only in case: SampleColumn, SAMPLECOLUMN.