[
http://issues.apache.org/jira/browse/DERBY-1220?page=comments#action_12376459 ]
Myrna van Lunteren commented on DERBY-1220:
-------------------------------------------
This must be some kind of resource limit issue - with the full script for
floattypes.sql and altertable.sql the problems - syntax errors in completely
fine statements - occur consistently, but I've tried to bring back the
floattypes.sql script to a smaller test case and have not succeeded. At some
point the failure becomes harder to reproduce, until any more lines stripped
away apparently do not reproduce the problem at all.
It only occurs with the combination 10.2 and ibm15, not ibm14 or 10.1. And only
on zOS.
The build number for the jvm is:
--------------------------------------
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pmz31dev-20060420 (SR2))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 z/OS s390-31 j9vmmz3123-20060420 (JI
T enabled)
J9VM - 20060419_06266_bHdSMr
JIT - 20060418_1800_r8
GC - 20060412_AA)
JCL - 20060420
--------------------------------------
At the instance of the failure, derby.log contains this:
--------------------------------------
2006-04-26 10:46:18.895 GMT Thread[main,5,main] (XID = 873), (SESSIONID = 0), (D
ATABASE = wombat), (DRDAID = null), Failed Statement is: -- fail
insert into fake values 5e-37/1e1
ERROR 42X01: Syntax error: Encountered "il" at line 1, column 6.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
at
org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java:154)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:310)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java:713)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:560)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:507)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:313)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:204)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:170)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
at org.apache.derby.tools.ij.main(ij.java:60)
Cleanup action completed
2006-04-26 10:46:19.146 GMT:
--------------------------------------
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
> Attachments: floatman102.out, floattypess3.sql
>
> The following tests fail with unexpected syntax errors that do not occur with
> ibm14 on zOS:
> derbylang/derbylang.fail:lang/altertable.sql
> derbylang/derbylang.fail:lang/floattypes.sql
> This may still be a test issue, or a jvm issue, further research is needed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
