Reference
Error Code for SQL Review
General
0 - OK
Success1 - Internal error
Something unexpected happened, you can open a GitHub issue or contact us.2 - Schema review policy not found
Cannot find the schema review policy in a specific environment. Please follow the doc to create the policy.Compatibility
101 - DROP DATABASE
Applications usually specifies database in their connection string. Dropping the database will definitely break those applications.102 - RENAME TABLE
Renaming the table will break the code referring that table.103 - DROP TABLE
Dropping the table will break the code referring that table.104 - RENAME COLUMN
Renaming the column will break the code referring that column.105 - DROP COLUMN
Dropping the column will break the code referring that column.106 - ADD PRIMARY KEY
Primary key requires the candidate key set has unique value and the chosen candidate key set might not meet this requirement.107 - ADD UNIQUE KEY
Unique key requires the candidate key set has unique value and the chosen candidate key set might not meet this requirement.108 - ADD FOREIGN KEY
The existing values on the candidate foreign key and the referenced key might not meet the referential requirements.109 - ADD CHECK
The existing value might not meet the check requirement.110 - ALTER CHECK
The existing value might not meet the check requirement.111 - ALTER COLUMN
Some ALTER COLUMN change is backward incompatible such as changing the data type from VARCHAR to INT. On the other hand, some change is backward compatible such as changing the database type from INT to BIGINT, or adding a comment and etc. User should review the actual statement.Statement
201 - Statement syntax error
A syntax error in your SQL statement.202 - Statement missing where
The SQL has no WHERE clause. Check Require WHERE clause for details.203 - Statement not select all
The SQL hasSELECT *. Check Disallow SELECT * for details.
204 - Statement not allow leading wildcard like
The SQL has leading wildcard LIKE. Check Disallow leading % in LIKE for details.206 - Statement disallow COMMIT
The SQL hasCOMMIT. Check Disallow COMMIT for details.
207 - Statement redundant ALTER TABLE
The SQL has redundantALTER TABLE. Check Merge ALTER TABLE for details.
208 - Statement dry run failed
The SQL dry-run failed. Check Dry run DML statements for details.209 - Statement affected rows exceed limit
The SQL affected rows exceed the limit. Check Limit affected rows for details.210 - Statement add column with default
The SQL adds column with default value. Check Disallow add column with default for details.211 - Statement add check with validation
The SQL adds check with validation. Check Add CHECK constraints with NOT VALID option for details.212 - Statement add NOT NULL
The SQL adds NOT NULL. Check Disallow add NOT NULL constraints to an existing column for details.Naming
301 - Table naming convention mismatch
Mismatch the table naming convention in your schema review policy. Check Table naming convention for details.302 - Column naming convention mismatch
Mismatch the column naming convention in your schema review policy. Check Column naming convention for details.303 - Index naming convention mismatch
Mismatch the index naming convention in your schema review policy. Check Index naming convention for details.304 - Unique key naming convention mismatch
Mismatch the unique key naming convention in your schema review policy. Check Unique key naming convention for details.305 - Foreign key naming convention mismatch
Mismatch the foreign key naming convention in your schema review policy. Check Foreign key naming convention for details.306 - Primary key naming convention mismatch
Mismatch the primary key naming convention in your schema review policy. Check Primary key naming convention for details.307 - Auto-increment column naming convention mismatch
Mismatch the auto-increment column naming convention in your schema review policy. Check Auto-increment column naming convention for details.Column
401 - Missing required columns
Cannot find the required columns defined in your schema review policy. Check Enforce the required columns in each table for details.402 - Column cannot be null
The column cannot beNULL. Check Columns no NULL value for details.
403 - Change column type
The column type is changed. Check Disallow change column type for details.404 - NOT NULL column with no default
The NOT NULL column has no default value. Check Set DEFAULT value for NOT NULL columns for details.405 - Column not exists
The column does not exist. Found in Bytebase’s pre-execution checks, please confirm if there is a problem with the SQL.406 - Use CHANGE COLUMN statement
The column is changed withCHANGE COLUMN. Check Disallow ALTER TABLE CHANGE COLUMN statements for details.