Important Announcement
This forum will be discontinued.
The creation of new topics is disabled.
Please open GitHub issues for the corresponding topics/products in the following Trivadis repositories:
- PL/SQL & SQL Coding Guidelines
- PL/SQL Cop Command Line
- PL/SQL Cop for SonarQube
- PL/SQL Cop for SQL Developer
- PL/SQL Cop Validators
- PL/SQL Analyzer
- PL/SQL Unwrapper
A lot of users have already a GitHub account and the management of the issues is better than in this forum. For example, closing a forum topic is never related to a product change. Closing a GitHub issue for an accepted bug means that the bug is fixed. This should simplify the work for all involved parties.
See this blog post for more information.
Thank you for your understanding.
Yes, you're right. That's another parser bug. I've opened a ticket (PLSQLCOP-269). Parse error when using expressions in offset/rowcount in row_limiti...
using an alias works as well. In fact it is required also for the subquery variant. updated post.
opened ticket PLSQLCOP-268
Hmm, this looks like a parser bug. Thanks for reporting this. I'll open a ticket. However, It usually does not make sense to use the row_limiting_clau...
Can you please provide a full example? Thx
No, this is not known. I can reproduce it. I use some utPLSQL templates. I've done the following: 1) typed "ut", crtl-tab, selected a template 2) righ...
In the meantime I wrote the blog post I mentioned before. See . This makes clear that declaring constants in a package specification is okay. The Gui...
I've opened a GitHub issue for the first part of the question and will answer it there. My second question is regarding the license. It says no commer...
Regarding G-1050 there was a related discussion on GitHub where the guidelines are maintained. Regarding G-7230: If you define constants or variables...
This is really slow. I've changed to the sample directory of tvdcc and run "tvdcc.sh path=.". The result was: Summary:- Total files: 93- Total bytes:...
This is related to the other issue. The NPE occurs after reaching the timeout. Something goes wrong during cancelling of the task. That's strange, but...
Could you please post the result without using the validator parameter? You are currently using TrivadisGuidelines3Plus validator. I do not see if thi...
So our question is: is it currently possible create a custom validator on a Create or Alter Table statement? No, not with the PL/SQL validator. There ...
You set the timeout to 10 seconds per file. If you process 10 files and every file gets a timeout then the process is terminated after 1:40 minutes wi...
I agree the the naming of the rule is not optimal. However the reason and the example onmakes it clear. The mode should be set explicitly. See parame...