[DERBY-4748] StringIndexOutOfBoundsException on syntax error (invalid COMMIT)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.2.1, 10.5.3.1, 10.6.1.0, 10.7.1.1
• Fix Version/s: 10.4.2.1, 10.5.3.1, 10.6.2.1, 10.7.1.1
• Component/s: Network Client, SQL
• Environment: Windows XP
• Urgency: Normal
• Bug behavior facts: Regression
• Assignee: Kristian Waagan
• Reporter: Stephen Felts
• Created: 19/Jul/10 23:13
• Updated: 17/Jun/13 09:19
• Resolved: 10/Aug/10 15:20

Description

Start the network server on port 1527 on localhost.

Run ant on the following:

<project default="all">
<property environment="env" />
<path id="derby.classpath.id">
<fileset dir="${env.DERBY_LIB">
<include name="derbynet.jar" />
<include name="derbyclient.jar" />
</fileset>
</path>

<target name="all">
<sql driver="org.apache.derby.jdbc.ClientDriver"

url="jdbc:derby://localhost:1527/derbyDB;create=true;user=derbyuser;passsword=derbypwd"
userid="derbyuser"
password="derbypwd"
classpathref="derby.classpath.id"
onerror="continue">
create table mytable1 (mycol varchar(255));
commit;
</sql>
</target>
</project>

On 10.5.3, I get
[sql] Executing commands
[sql] Failed to execute: commit
[sql] java.sql.SQLSyntaxErrorException: Syntax error: Encountered
"commit"
at line 1, column 1.
[sql] 1 of 2 SQL statements executed successfully

but on 10.6.1, I get
[sql] Executing commands

BUILD FAILED
java.lang.StringIndexOutOfBoundsException: String index out of range: 6
at java.lang.String.charAt(String.java:686)
at org.apache.derby.client.am.Statement.isolateAnyInitialIdentifier(Unknown Source)
at org.apache.derby.client.am.Statement.getStatementToken(Unknown Source)
at org.apache.derby.client.am.Statement.parseSqlAndSetSqlModes(Unknown Source)
....