chore: test sql review #12
RainbowDashysql-review-action.yml
on: pull_request
check-release-on-prod
9s
Annotations
10 errors and 10 warnings
|
column.comment (Ј):
migrations-semver/1.13.0_phone.sql#L1
Comment is required for column `users.phone`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
statement.dml-dry-run (Ð):
migrations-semver/1.13.0_phone.sql#L3
"INSERT INTO users VALUES (1);" dry runs failed: ERROR: relation "users" does not exist (SQLSTATE 42P01). Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ð
|
|
statement.insert.must-specify-column (ѓ):
migrations-semver/1.13.0_phone.sql#L3
The INSERT statement must specify columns but "INSERT INTO users VALUES (1);" does not. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#ѓ
|
|
column.comment (Ј):
migrations-semver/1.3.5_nickname.sql#L1
Comment is required for column `users.nickname`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
column.comment (Ј):
migrations-semver/1.1.1_comment.sql#L1
Comment is required for column `users.comment`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
statement.dml-dry-run (Ð):
migrations-semver/1.0.1_init_data_dml.sql#L5
"INSERT INTO users (
|
|
column.comment (Ј):
migrations-semver/1.0.0_init.sql#L5
Comment is required for column `users.email`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
column.comment (Ј):
migrations-semver/1.0.0_init.sql#L5
Comment is required for column `users.name`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
column.comment (Ј):
migrations-semver/1.0.0_init.sql#L5
Comment is required for column `users.id`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
table.comment (Ј):
migrations-semver/1.0.0_init.sql#L5
Comment is required for table `users`. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ј
|
|
statement.check-set-role-variable (Ù):
migrations-semver/1.1.1_comment.sql#L1
No SET ROLE statement found.. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ù
|
|
statement.disallow-add-column-with-default (Ò):
migrations-semver/1.1.1_comment.sql#L1
Adding column with DEFAULT will locked the whole table and rewriting each rows. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ò
|
|
naming.fully-qualified (Ķ):
migrations-semver/1.0.1_init_data_dml.sql#L5
unqualified object name: 'users'. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ķ
|
|
statement.check-set-role-variable (Ù):
migrations-semver/1.0.1_init_data_dml.sql#L1
No SET ROLE statement found.. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ù
|
|
column.require-default (Ƥ):
migrations-semver/1.0.0_init.sql#L4
Column "users"."email" in schema "public" doesn't have DEFAULT. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ƥ
|
|
column.require-default (Ƥ):
migrations-semver/1.0.0_init.sql#L3
Column "users"."name" in schema "public" doesn't have DEFAULT. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ƥ
|
|
column.required (Ƒ):
migrations-semver/1.0.0_init.sql#L5
Table "users" requires columns: created_ts, creator_id, updated_ts, updater_id. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ƒ
|
|
naming.fully-qualified (Ķ):
migrations-semver/1.0.0_init.sql#L5
unqualified object name: 'users'. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ķ
|
|
statement.check-set-role-variable (Ù):
migrations-semver/1.0.0_init.sql#L1
No SET ROLE statement found.. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ù
|
|
statement.create-specify-schema (Ø):
migrations-semver/1.0.0_init.sql#L5
Table schema should be specified.. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#Ø
|