Skip to content
CodeQL

RODARS pipeline #2154

Sign in to view logs

RODARS pipeline

RODARS pipeline #2154

Triggered via pull request December 20, 2024 21:58
@gabrielwolgabrielwol
synchronize #1103
1088-explore-new-rodars-data
Status Success
Total duration 1m 12s
Artifacts –

codeql.yml

on: pull_request
Matrix: Analyze
Fit to window
Zoom out
Zoom in

Annotations

63 errors, 1 warning, and 6 notices
SQLFluff: events/construction/sql/create-function-delete_old_rodars_issue_locations.sql#L2
CP05: Datatypes must be lower case.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L6
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L6
LT02: Expected line break and no indent before ')'.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L7
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L8
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L9
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L10
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L11
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L12
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L13
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L14
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L15
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L16
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L17
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L18
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L19
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L20
LT02: Line should not be indented.
SQLFluff: events/construction/sql/create-function-get_lanesaffected_sum.sql#L46
CP02: Unquoted identifiers must be consistently lower case.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L80
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L81
LT02: Expected indent of 8 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L82
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L83
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L84
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L85
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L86
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L87
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L88
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L89
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L90
LT02: Expected indent of 8 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L91
LT02: Expected indent of 8 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L92
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L93
LT02: Expected indent of 12 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L94
LT02: Expected indent of 8 spaces.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L95
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L1
LT02: First line should not be indented.
SQLFluff: events/construction/sql/division_explore.sql#L2
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L3
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L4
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L4
RF02: Unqualified reference 'issueid' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L5
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L5
RF02: Unqualified reference 'timestamputc' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L6
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L6
RF02: Unqualified reference 'issuetype' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L7
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L8
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L8
RF02: Unqualified reference 'priority' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L9
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L9
RF02: Unqualified reference 'proposedstarttimestamputc' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L10
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L10
RF02: Unqualified reference 'proposedendtimestamputc' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L11
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L11
RF02: Unqualified reference 'earlyendtimestamputc' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L12
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L12
RF02: Unqualified reference 'status' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L13
LT02: Expected indent of 4 spaces.
SQLFluff: events/construction/sql/division_explore.sql#L13
RF02: Unqualified reference 'timeoption' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L22
AM03: Ambiguous order by clause. Order by clauses should specify order direction for ALL columns or NO columns.
SQLFluff: events/construction/sql/division_explore.sql#L22
RF02: Unqualified reference 'timestamputc' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/division_explore.sql#L22
RF02: Unqualified reference 'issueid' found in select with more than one referenced table/view.
SQLFluff: events/construction/sql/insert-rodars_issue_locations.sql#L10
PRS: Line 10, Position 5: Found unparsable section: 'VALUES %s'
SQLFluff: events/construction/sql/select-rodars_issue_locations.sql#L17
LT02: Expected line break and indent of 4 spaces before '>'.
SQLFluff: events/construction/sql/select-rodars_issues.sql#L21
LT02: Expected line break and indent of 4 spaces before '>'.
SQLFluff: events/construction/sql/update-rodars_issues_geometry.sql#L2
PRS: Line 2, Position 5: Found unparsable section: 'VALUES %s'
Analyze (python)
ubuntu-latest pipelines will use ubuntu-24.04 soon. For more details, see https://github.com/actions/runner-images/issues/10636
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L80
LT01: Expected single whitespace between 'LATERAL' keyword and start bracket '('.
SQLFluff: events/construction/sql/create-view-rodars_locations.sql#L91
LT01: Expected single whitespace between naked identifier and start bracket '('.
SQLFluff: events/construction/sql/division_explore.sql#L1
LT01: Expected only single space before 'SELECT' keyword. Found ' '.
SQLFluff: events/construction/sql/select-rodars_issues.sql#L34
LT05: Line is too long (111 > 100).
SQLFluff: events/construction/sql/select-rodars_issues.sql#L35
LT05: Line is too long (107 > 100).
SQLFluff: events/construction/sql/select-rodars_issues.sql#L36
LT05: Line is too long (101 > 100).