[ http://issues.apache.org/jira/browse/DERBY-1763?page=comments#action_12430525 ] Christopher Schick commented on DERBY-1763: -------------------------------------------
true. However, it's not limited to count(*) actually. count(1) and count(c1) show the same behavior. Haven't checked on a sane build though, if the error message changes in that case. > Using RTRIM(LTRIM(col)) and group by col gives NPE > -------------------------------------------------- > > Key: DERBY-1763 > URL: http://issues.apache.org/jira/browse/DERBY-1763 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.1.3.1 > Environment: Windows 2000, Sun JDK 1.4.2_10 > Reporter: Christopher Schick > > When trying to execute a simple SQL Statement that includes both the RTRIM() > and LTRIM() functions on a column in the SELECT clause and contains a GROUP > BY clause on that column, the following Nullpointer Exception is thrown: > ERROR XJ001: Java exception: ': java.lang.NullPointerException'. > This does NOT happen, if only RTRIM() OR LTRIM() is used, or if no GROUP BY > clause is specified. > This issue is quite urgent for us, as we don't see a workaround to achieve > the desired results. > Attached an example table schema and the affected SELECT Statement. > -------------------------------------------- > CREATE TABLE t1 ( > c1 VARCHAR(10), > c2 VARCHAR(10) > ); > INSERT INTO t1 VALUES('a', 'b'); > INSERT INTO t1 VALUES('c', 'd'); > SELECT RTRIM(LTRIM(c1)), > COUNT(*) > FROM t1 > GROUP BY c1; -- 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
