Both of these give an error at ORDER BY. Am I doing something wrong, or is this a missing part of the ROW_NUMBER() feature?
I think you might be seeing DERBY-3634: http://issues.apache.org/jira/browse/DERBY-3634
I think there is some renewed work on the ROW_NUMBER feature for Derby 10.5, so hopefully some of these problems will be addressed soon. bryan
