Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 265 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 229 Portuguese
New version 18.2, new format bugs :-(
I've uploaded the fresh new version of sqlcl 18.2 and tried to format very simple SQL that was formatted without problems in 18.1
I used a copy of rules file that I used for 18.1 (attached)
When I run the following script on the second format buffer I got a sqlcl crash
spool bug18_2
SELECT ROWID AS RD FROM MIGR_BATCH_HISTORIES WHERE BATCH_BATCH_ID = :B1 AND START_DATE <= SYSDATE AND END_DATE >= SYSDATE;
format buffer
format rules format_rules_18_2_1.xml
format buffer
spool off
Exception in thread "main" Syntax Error at line 347, column 32
| [node) from_clause & [node^+8 < node^)
^^^Expected: ')','^','-','+',
at oracle.dbtools.parser.plsql.SyntaxError.checkSyntax(SyntaxError.java:164)
at oracle.dbtools.parser.plsql.SyntaxError.checkSyntax(SyntaxError.java:101)
at oracle.dbtools.parser.Parsed.getRoot(Parsed.java:111)
at oracle.dbtools.parser.Parsed.getSyntaxError(Parsed.java:120)
at oracle.dbtools.arbori.Program.compile(Program.java:254)
at oracle.dbtools.arbori.SqlProgram.<init>(SqlProgram.java:26)
at oracle.dbtools.app.Format$3.<init>(Format.java:258)
at oracle.dbtools.app.Format.format(Format.java:258)
at oracle.dbtools.raptor.newscriptrunner.commands.FormatSQLPlusCommand.handleEvent(FormatSQLPlusCommand.java:65) at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:427)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:224)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:341)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:224)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runFile(SqlCli.java:786)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.handleAtFiles(SqlCli.java:764)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:486)
Have you any regression tests for formatting?
Answers
-
Hi,
I am also trying to get a format for a file using
>format file input_file output_file
SQLcl works for correct syntax of the input_file
for incorrect syntax of the input_file it just says "parser error" and outputs the usuage of the format command.
Is there a way to get the actual linenumber where the error was found,
Please let me know
Thanks
-
The culprit is the folowing:
<formatProgramURL>/C:/Users/smosin/AppData/Roaming/SQL Developer/system17.4.0.355.2349/o.sqldeveloper/format.arbori</formatProgramURL>
Removing it should fix the error message (the default custom formatting program would be fetched, but the advanced format options would be taken from your modified xml file).