We are trying to upgrade hsqldb and sqltool dependencies from 2.4.1 to 2.7.1.
Below is the command which gets executed. It takes multiple sql files in a single command :
**java -cp /local/lib/hsqldb-2.7.1.jar.jar:/local/lib/sqltool-2.7.1.jar
org.hsqldb.cmdline.SqlTool --inlineRc=URL=jdbc:hsqldb:mem:x,USER=SA,PASSWORD= m1.sql z2.sql a3.sql **
But after upgrade, this command get stuck while executing. The 1st one gets executed and then it gets stuck. The same command used to run successfully with version 2.4.1. So what could be the reason here of getting stuck?
Also one more observation here is that while executing it takes the last sql file as the 1st one to be executed.
Root cause found. With commit 5862 when enhancing to support URLs generally (as opposed to local file paths), I somehow lost the ++ postfix operator in increment an index, and there happens to be no unit test to cover multiple SQL files in a single invocation. Fix is to just insert the two + characters and I'll do that now.
Fix applied with revision 6632.