[ http://issues.apache.org/jira/browse/DERBY-1587?page=comments#action_12423388 ] Yip Ng commented on DERBY-1587: -------------------------------
I ran into this problem when I was writing grant/revoke testcases this morning, so I fixed it. The derbyall suite is still running, I will post the patch when it ran successful. I noticed that lang/cast.out has a testcase for this but the expected result is wrong in the master. values CHAR(INT(67890)); ERROR 42X01: Syntax error: Encountered "INT" at line 2, column 13. > 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 > > 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
