Rails migrations that use :boolean as a data type fail. The odbc_adapter code uses 'bool' in the generated SQL for the symbol :boolean. "bool" is a Postgres alias for "boolean". Snowflake does not support that alias.
Solution
"boolean" must be used instead of "bool" in the generated SQL.
Testing/QA Notes
Create and test a migration.
Post Merge Notes
Will need PRs to springbuk, edison, and probably DM to update the adapter.
Source
https://springbuk-glass.atlassian.net/browse/MOJ-451
Problem
Rails migrations that use
:booleanas a data type fail. The odbc_adapter code uses 'bool' in the generated SQL for the symbol:boolean. "bool" is a Postgres alias for "boolean". Snowflake does not support that alias.Solution
"boolean" must be used instead of "bool" in the generated SQL.
Testing/QA Notes
Create and test a migration.
Post Merge Notes
Will need PRs to springbuk, edison, and probably DM to update the adapter.