Skip to content

Schema Validations: Incorrect reports for boolean columns

Just tried bundle exec rails gitlab:db:schema_checker:run locally. I am seeing a lot of false positives, I think it’s for every boolean column we have, for example:

The table workspaces has a different column statement between structure.sql and database
Diff:
-CREATE TABLE workspaces (force_full_reconciliation boolean DEFAULT false NOT NULL, force_include_all_resources boolean DEFAULT false NOT NULL)
+CREATE TABLE workspaces (force_full_reconciliation boolean NOT NULL, force_include_all_resources boolean NOT NULL)

For the above table the columns are boolean DEFAULT false NOT NULL in all of struicture.sql, main, and ci databases.

Edited by Krasimir Angelov