[ http://issues.apache.org/jira/browse/DERBY-1587?page=all ]
Yip Ng updated DERBY-1587:
--------------------------
Attachment: derby1587trunkdiff1.txt
derby1587trunkstat1.txt
derby1587trunkstat1.txt contains the files change against the trunk codeline
and
derby1587trunkdiff1.txt contains the patch and testcase output corrections in
the lang suite for DERBY-1587. The fix is in the miscBuiltins() production in
JavaCC sqlgrammar.jj file where the SQL parser did not account for INT token;
thus, not recognizing INT().
Ran derbyall suite and no new regression is introduced by this patch.
Appreciate it if someone can review this. Thanks!
> INTEGER function cannot be abbreviated
> --------------------------------------
>
> Key: DERBY-1587
> URL: http://issues.apache.org/jira/browse/DERBY-1587
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.1.3.1
> Reporter: Christian d'Heureuse
> Assigned To: Yip Ng
> Priority: Minor
> Attachments: derby1587trunkdiff1.txt, derby1587trunkstat1.txt
>
>
> The reference manual
> (http://db.apache.org/derby/docs/10.1/ref/rrefbuiltinteger.html) states that
> the INTEGER function can be abbreviated by INT, but Derby 10.1.3.1 does not
> accept that.
> Example:
> VALUES INTEGER(1.5);
> -> OK
> VALUES INT(1.5);
> -> ERROR 42X80: VALUES clause must contain at least one element.
--
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