test action #5
RainbowDashysql-review.yml
on: pull_request
check-release-on-test
6s
check-release-on-prod
8s
Annotations
4 errors and 15 warnings
|
check-release-on-test
Release checks find ERROR or WARNING violations
|
|
table.require-pk (601):
migrations/202504171526_2.sql#L2
Table "public"."oijoir" requires PRIMARY KEY, related statement: "CREATE TABLE IF NOT EXISTS oijoir (\n id int\n);". Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#601
|
|
table.require-pk (601):
migrations/202504171429_1.sql#L2
Table "public"."wer" requires PRIMARY KEY, related statement: "CREATE TABLE IF NOT EXISTS wer (\n id int\n);". Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#601
|
|
table.require-pk (601):
migrations/202503071616_create_ticket_table.sql#L3
Table "public"."ticket" requires PRIMARY KEY, related statement: "CREATE TABLE IF NOT EXISTS ticket (\n id int,\n name text\n);". Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#601
|
|
statement.check-set-role-variable (217):
migrations/202503181018_ticket_table_add_date_column.sql#L1
No SET ROLE statement found.. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#217
|
|
statement.check-set-role-variable (217):
migrations/202503141135_sleep.sql#L1
No SET ROLE statement found.. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#217
|
|
column.require-default (420):
migrations/202503071616_create_ticket_table.sql#L2
Column "ticket"."name" in schema "public" doesn't have DEFAULT. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#420
|
|
column.require-default (420):
migrations/202503071616_create_ticket_table.sql#L1
Column "ticket"."id" in schema "public" doesn't have DEFAULT. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#420
|
|
column.no-null (402):
migrations/202503071616_create_ticket_table.sql#L2
Column "name" in "public"."ticket" cannot have NULL value. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.no-null (402):
migrations/202503071616_create_ticket_table.sql#L1
Column "id" in "public"."ticket" cannot have NULL value. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.required (401):
migrations/202503071616_create_ticket_table.sql#L3
Table "ticket" requires columns: created_ts, creator_id, updated_ts, updater_id. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#401
|
|
naming.fully-qualified (310):
migrations/202503071616_create_ticket_table.sql#L3
unqualified object name: 'ticket'. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#310
|
|
statement.check-set-role-variable (217):
migrations/202503071616_create_ticket_table.sql#L1
No SET ROLE statement found.. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#217
|
|
statement.create-specify-schema (216):
migrations/202503071616_create_ticket_table.sql#L3
Table schema should be specified.. Targets: instances/test-sample-instance/databases/hr_test https://www.bytebase.com/docs/reference/error-code/advisor#216
|
|
column.no-null (402):
migrations/202504171526_2.sql#L1
Column "id" in "public"."oijoir" cannot have NULL value. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.no-null (402):
migrations/202504171429_1.sql#L1
Column "id" in "public"."wer" cannot have NULL value. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.no-null (402):
migrations/202503181018_ticket_table_add_date_column.sql#L0
Column "release_date" in "public"."ticket" cannot have NULL value. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.no-null (402):
migrations/202503071616_create_ticket_table.sql#L2
Column "name" in "public"."ticket" cannot have NULL value. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#402
|
|
column.no-null (402):
migrations/202503071616_create_ticket_table.sql#L1
Column "id" in "public"."ticket" cannot have NULL value. Targets: instances/prod-sample-instance/databases/hr_prod https://www.bytebase.com/docs/reference/error-code/advisor#402
|