zpa

zpa copied to clipboard

unable to analyze .trsl files

2

Hi, I used PLSQL to scan a folder which contains .trsl (sql) files. But ZPA PLSQL Quality profile is unable to scan the this file, but at the end it...

csrvsk

Better support for test and coverage reports generated by utPLSQL

1

Generating tests and coverage accurately with utPLSQL-cli can be quite challenging due to its mapping configuration, as illustrated in [this guide](https://github.com/felipebz/zpa/wiki/utPLSQL-integration#example-with-dedicated-folders-for-each-file-type). Achieving accurate results can be challenging due to certain...

felipebz

Unnecessary concatenation of string literals

1

It's not necessary concatenate two string literals at runtime. Noncompliant code: ``` var := 'a'||'b'; var2 := concat('a', 'b'); ``` Compliant code: ``` var := 'ab'; var2 := 'ab'; ```

felipebz

Simple SQL Injections not detected

3

The plugin does not detect easy to spot SQL Injections as the following: ``` CREATE OR REPLACE PROCEDURE putlineDesc ( vname IN VARCHAR2 ) AS TYPE rcursor IS REF CURSOR;...

isgroup-srl

Hi, I used ENABLE keyword in CREATE TABLE statement as below CREATE TABLE TPA_MASTER ( CONFIGID VARCHAR2(100 BYTE) PRIMARY KEY ENABLE, NO_OF_PWD_ATTEMPTS NUMBER, SESSION_TIME_DURATION NUMBER NOT NULL ENABLE, PWD_EXPIRY_PERIOD NUMBER,...

jagdish9

Why it get a error when parsing "create table tt as select * from t"

1

com.sonar.sslr.api.RecognitionException: Parse error at line 1 column 16: --> create table tt as select * from tEOF at org.sonar.sslr.internal.vm.Machine.parse(Machine.java:73) at com.sonar.sslr.impl.Parser.parse(Parser.java:84) at com.sonar.sslr.impl.Parser.parse(Parser.java:78) at org.sonar.sslr.internal.toolkit.SourceCodeModel.setSourceCode(SourceCodeModel.java:62) at org.sonar.sslr.internal.toolkit.ToolkitPresenter.onSourceCodeParseButtonClick(ToolkitPresenter.java:122) at org.sonar.sslr.internal.toolkit.ToolkitViewImpl$5.actionPerformed(ToolkitViewImpl.java:201) at...

gzll

https://stackoverflow.com/questions/7810108/sequence-and-case-in-a-select-in-oracle do not use sequence.nextval in decode or case when it may be return the result that you are expected

snoopyhzy

ALTER INDEX throws exception

3

SQL file: alter index test.test nologging; Exception: com.sonar.sslr.api.RecognitionException: Parse error at line 1 column 6: --> alter index test.test nologging; 2: /EOF at org.sonar.sslr.internal.vm.Machine.parse(Machine.java:73) at com.sonar.sslr.impl.Parser.parse(Parser.java:84) at com.sonar.sslr.impl.Parser.parse(Parser.java:78) at org.sonar.sslr.internal.toolkit.SourceCodeModel.setSourceCode(SourceCodeModel.java:62)...

styper

Currently to create new rules it's necessary to know the internals of the grammar and look at the generated AST using the zpa-toolkit. Ideally we should provide an easier API...

felipebz

"INSERT ALL" is not recognized by the parser. Source: https://github.com/utPLSQL/utPLSQL/blob/35dbe64739c0fe42c09cf9812ed946971ad04040/examples/remove_rooms_by_name/test_remove_rooms_by_name.pkg#L27 Reference: https://sonarcloud.io/project/issues?id=utPLSQL-zpa-demo&issues=AWrh9a36ezZPqKiffFMW&open=AWrh9a36ezZPqKiffFMW

felipebz