Skip to content
CI - dbLinter checks and SQL-based tests

add link to SonarQube Cloud Issues in README.md #53

Sign in to view logs

add link to SonarQube Cloud Issues in README.md

add link to SonarQube Cloud Issues in README.md #53

Triggered via push March 1, 2026 16:59
@PhilippSalvisbergPhilippSalvisberg
pushed dc335f0
main
Status Success
Total duration 3m 17s
Artifacts 2

ci.yml

on: push
ci
3m 14s
ci
Fit to window
Zoom out
Zoom in

Annotations

10 errors, 131 warnings, and 3 notices
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1250.sql#L11
Missing DEFAULT ON NULL for child_id.
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1250.sql#L5
Missing DEFAULT ON NULL for parent_id.
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1240.sql#L10
Missing DEFAULT ON NULL for child_id.
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1240.sql#L4
Missing DEFAULT ON NULL for parent_id.
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1230.sql#L10
Missing DEFAULT ON NULL for child_id.
Core G-3170: Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.: examples/Core-G-1230.sql#L4
Missing DEFAULT ON NULL for parent_id.
Core G-3145: Avoid using SELECT * directly from a table or view.: examples/Core-G-1110.sql#L5
Using SELECT * without subquery.
Core G-1080: Avoid using the same expression on both sides of a relational comparison operator or a logical operator.: examples/Core-G-1080.sql#L9
Expression 'emp.salary > 3000' used on both sides of the condition.
Core G-2190: Avoid using ROWID or UROWID.: examples/Core-G-1060.sql#L13
Avoid using rowid.
Core G-1060: Avoid storing ROWIDs or UROWIDs in database tables.: examples/Core-G-1060.sql#L13
Storing ROWID in employees_log.
Core G-1250 DBL_OWNER.CHILD (core.g1250) failed: core.g1250#L0
results/test.junit.xml [took 1s]
Core G-1250 DBL_OWNER.EMPLOYEES (core.g1250) failed: core.g1250#L0
results/test.junit.xml [took 0s]
Core G-1250 DBL_OWNER.NULL_TEST (core.g1250) failed: core.g1250#L0
results/test.junit.xml [took 0s]
Core G-1250 DBL_OWNER.ORDER_ITEMS (core.g1250) failed: core.g1250#L0
results/test.junit.xml [took 0s]
Core G-1250 DBL_OWNER.PARENT (core.g1250) failed: core.g1250#L0
results/test.junit.xml [took 0s]
Core G-9218 DBL_OWNER.DEPT_OT.DÉPARTEMENT_ID (core.g9218) failed: core.g9218#L0
results/test.junit.xml [took 0s]
Core G-1150 DBL_OWNER.SELECT ANY TABLE (core.g1150) failed: core.g1150#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.CHILD.CHILD_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.CHILD.CHILD_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.CHILD.PARENT_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_DBMS.DBMS_DESCRIPTION (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_DBMS.DBMS_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_DBMS.DBMS_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_DBMS.DBMS_NAME_LOWER (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_SEVERITY_LEVELS.SEVL_DESCRIPTION (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_SEVERITY_LEVELS.SEVL_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_SEVERITY_LEVELS.SEVL_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_SEVERITY_LEVELS.SEVL_NAME_LOWER (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DBL_SEVERITY_LEVELS.SEVL_PRIORITY (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DEPARTEMENTS.NUMÉRO_DE_DÉPARTEMENT (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.DÉPARTEMENT_TMP.ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMP.EMPNO (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.COMMISSION_PCT (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.DEPARTMENT_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.EMAIL (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.EMPLOYEE_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.FIRST_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.HIRE_DATE (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.JOB_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.LAST_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.MANAGER_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.PHONE_NUMBER (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.SALARY (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.EMPLOYEES.TOTAL_SALARY (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.NULL_TEST.COLUMN_DEFAULTED (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.NULL_TEST.TEST_CASE (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.ORDERS.ORDER_NO (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.ORDERS.OTHER_ORDER_ATTRS (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.ORDER_ITEMS.ORDER_ITEM_NO (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.ORDER_ITEMS.ORDER_NO (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.ORDER_ITEMS.OTHER_ORDER_ITEM_ATTRS (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.PARENT.PARENT_ID (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.PARENT.PARENT_NAME (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-1270 DBL_OWNER.T.C1 (core.g1270) failed: core.g1270#L0
results/test.junit.xml [took 0s]
Core G-9216 DBL_OWNER.PACKAGE.DEPARTMENT_API.FERMER_DÉPARTEMENT (core.g9216) failed: core.g9216#L0
results/test.junit.xml [took 0s]
Core G-1210 DBL_OWNER.DEPARTEMENTS (core.g1210) failed: core.g1210#L0
results/test.junit.xml [took 0s]
Core G-1210 DBL_OWNER.EMPLOYEES (core.g1210) failed: core.g1210#L0
results/test.junit.xml [took 0s]
Core G-1210 DBL_OWNER.NULL_TEST (core.g1210) failed: core.g1210#L0
results/test.junit.xml [took 0s]
Core G-1210 DBL_OWNER.T (core.g1210) failed: core.g1210#L0
results/test.junit.xml [took 0s]
Core G-1110 DBL_BACKEND.TABLE.T1 (core.g1110) failed: core.g1110#L0
results/test.junit.xml [took 0s]
Core G-1110 DBL_BACKEND.VIEW.V1 (core.g1110) failed: core.g1110#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.DBL_DBMS (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 3s]
Core G-1230 DBL_OWNER.DBL_SEVERITY_LEVELS (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.DEPARTEMENTS (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.EMP (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.EMPLOYEES (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.NULL_TEST (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1230 DBL_OWNER.T (core.g1230) failed: core.g1230#L0
results/test.junit.xml [took 0s]
Core G-1130 DBL_BACKEND.DBL_OWNER.DBL_DBMS.READ (core.g1130) failed: core.g1130#L0
results/test.junit.xml [took 0s]
Core G-1130 DBL_BACKEND.DBL_OWNER.DBL_SEVERITY_LEVELS.READ (core.g1130) failed: core.g1130#L0
results/test.junit.xml [took 0s]
Core G-1130 DBL_BACKEND.DBL_OWNER.T.READ (core.g1130) failed: core.g1130#L0
results/test.junit.xml [took 0s]
Core G-1130 DBL_BACKEND.DBL_OWNER.T.UPDATE (core.g1130) failed: core.g1130#L0
results/test.junit.xml [took 0s]
Core G-9211 DBL_OWNER.EMPS (core.g9211) failed: core.g9211#L0
results/test.junit.xml [took 0s]
Core G-1310 DBL_OWNER.P (core.g1310) failed: core.g1310#L0
results/test.junit.xml [took 0s]
Core G-3160 DBL_OWNER.EMPLOYEES.TOTAL_SALARY (core.g3160) failed: core.g3160#L0
results/test.junit.xml [took 0s]
Core G-1140 DBL_BACKEND.DBL_OWNER.DBL_CONFIGS_V.READ (core.g1140) failed: core.g1140#L0
results/test.junit.xml [took 0s]
Core G-1140 DBL_BACKEND.DBL_OWNER.DBL_CONFIG_RULES_V.READ (core.g1140) failed: core.g1140#L0
results/test.junit.xml [took 0s]
Core G-1140 DBL_BACKEND.DBL_OWNER.DBL_SEVERITY_LEVELS.READ (core.g1140) failed: core.g1140#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.CHILD (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.DBL_DBMS (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.DBL_SEVERITY_LEVELS (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.DEPARTEMENTS (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.DÉPARTEMENT_TMP (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.EMP (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.EMPLOYEES (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.NULL_TEST (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.ORDERS (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.ORDER_ITEMS (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.PARENT (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1260 DBL_OWNER.T (core.g1260) failed: core.g1260#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.CHILD.CHILD_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.CHILD.CHILD_NAME (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.CHILD.PARENT_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.DEPARTEMENTS.NUMÉRO_DE_DÉPARTEMENT (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.DÉPARTEMENT_TMP.ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMP.EMPNO (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.COMMISSION_PCT (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.DEPARTMENT_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.EMAIL (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.EMPLOYEE_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.FIRST_NAME (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.HIRE_DATE (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.JOB_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.LAST_NAME (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.MANAGER_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.PHONE_NUMBER (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.EMPLOYEES.SALARY (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.NULL_TEST.COLUMN_DEFAULTED (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.NULL_TEST.TEST_CASE (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.ORDERS.ORDER_NO (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.ORDERS.OTHER_ORDER_ATTRS (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.ORDER_ITEMS.ORDER_ITEM_NO (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.ORDER_ITEMS.ORDER_NO (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.ORDER_ITEMS.OTHER_ORDER_ITEM_ATTRS (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.PARENT.PARENT_ID (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.PARENT.PARENT_NAME (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-1280 DBL_OWNER.T.C1 (core.g1280) failed: core.g1280#L0
results/test.junit.xml [took 0s]
Core G-9204 DBL_OWNER.EMP#PRIMARY#KEY (core.g9204) failed: core.g9204#L0
results/test.junit.xml [took 1s]
Core G-9204 DBL_OWNER.SYS_C008608 (core.g9204) failed: core.g9204#L0
results/test.junit.xml [took 0s]
Core G-9203 DBL_OWNER.EMP#PRIMARY#KEY (core.g9203) failed: core.g9203#L0
results/test.junit.xml [took 0s]
Core G-9203 DBL_OWNER.EMPLOYEES_FIRST_NAME (core.g9203) failed: core.g9203#L0
results/test.junit.xml [took 0s]
Core G-9203 DBL_OWNER.SYS_C008608 (core.g9203) failed: core.g9203#L0
results/test.junit.xml [took 0s]
Core G-1220 DBL_OWNER.ORDER_ITEMS (core.g1220) failed: core.g1220#L0
results/test.junit.xml [took 0s]
Core G-8510 DBL_OWNER (core.g8510) failed: core.g8510#L0
results/test.junit.xml [took 0s]
Core G-9202 DBL_OWNER.DEPARTEMENTS.NUMÉRO_DE_DÉPARTEMENT (core.g9202) failed: core.g9202#L0
results/test.junit.xml [took 0s]
Core G-1120 DBL_BACKEND.SELECT ANY TABLE (core.g1120) failed: core.g1120#L0
results/test.junit.xml [took 0s]
Core G-1120 DBL_BACKEND.SET CONTAINER (core.g1120) failed: core.g1120#L0
results/test.junit.xml [took 0s]
Core G-1240 DBL_OWNER.CHILD_PARENT_FK.PARENT_ID (core.g1240) failed: core.g1240#L0
results/test.junit.xml [took 1s]
Core G-9209 DBL_OWNER.DÉPARTEMENT_TMP (core.g9209) failed: core.g9209#L0
results/test.junit.xml [took 0s]
Core G-3170 DBL_OWNER.CHILD.CHILD_ID (core.g3170) failed: core.g3170#L0
results/test.junit.xml [took 0s]
Core G-3170 DBL_OWNER.PARENT.PARENT_ID (core.g3170) failed: core.g3170#L0
results/test.junit.xml [took 0s]
Core G-5010: Try to use a error/logging framework for your application.: examples/Core-G-1020.sql#L24
Use a logging framework instead of DBMS_OUTPUT.
Core G-4395: Avoid hard-coded upper or lower bound values with FOR loops.: examples/Core-G-1020.sql#L23
Hard-coded upper bound value 10 in FOR loop.
Core G-1020: Always have a matching loop or block label.: examples/Core-G-1020.sql#L25
End label 'for_loop' does not match start label 'process_with_for_loop'.
Core G-1020: Always have a matching loop or block label.: examples/Core-G-1020.sql#L20
End label 'basic_loop' does not match start label 'process_with_basic_loop'.
Core G-1020: Always have a matching loop or block label.: examples/Core-G-1020.sql#L15
End label 'while_loop' does not match start label 'process_with_while_loop'.
Core G-1020: Always have a matching loop or block label.: examples/Core-G-1020.sql#L9
End label 'data_preparation' does not match start label 'prepare_data'.
Core G-1010: Try to label your sub blocks.: examples/Core-G-1010.sql#L10
Missing end label in sub block.
Core G-1010: Try to label your sub blocks.: examples/Core-G-1010.sql#L8
Missing start label in sub block.
Core G-1010: Try to label your sub blocks.: examples/Core-G-1010.sql#L6
Missing end label in sub block.
Core G-1010: Try to label your sub blocks.: examples/Core-G-1010.sql#L4
Missing start label in sub block.
133 tests found
There are 133 tests, see "Raw output" for the full list of tests.
Core G-1940: Avoid long checking times.: examples/Core-G-3150.sql#L3
Checking time of 1.628 sec exceeded threshold of 1.500 sec.
Core G-1910: Avoid using the NOSONAR marker.: examples/Core-G-1910.sql#L4
NOSONAR marker.

Artifacts

Produced during runtime
Name Size Digest
github-pages Expired
332 KB
sha256:36cc4ebbfa4c2950f9cc4ada836c45ffda685a20fa580767b4a976cbc5c36f3d
results
332 KB
sha256:7467ad24015a52f1cb8b6e7893ad7997baad4000c363f0872c40acb4609f0390