HSQLDB 2.5.1 issue

Michael Dever via Hsqldb-user <[email protected]> Wed, 29 Jul 2020 14:44:54 -0400
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <[email protected]>
Hi All,

I've come across an issue of a General Exception 2.5.1, that worked in 2.5.0:
As you can see, trying to pull the page.ext 
and Group by, with counts.

Like I said it worked in 2.5,
and is now throwing a General Exception in 2.5.1


SELECT  
  CASE  
  WHEN  POSITION ( '.' IN ( RIGHT ( cs_uristem, 2 ) ) ) = 1 THEN RIGHT ( cs_uristem, 2 )  
  WHEN  POSITION ( '.' IN ( RIGHT ( cs_uristem, 3 ) ) ) = 1 THEN RIGHT ( cs_uristem, 3 )  
  WHEN  POSITION ( '.' IN ( RIGHT ( cs_uristem, 4 ) ) ) = 1 THEN RIGHT ( cs_uristem, 4 )  
  WHEN  POSITION ( '.' IN ( RIGHT ( cs_uristem, 5 ) ) ) = 1 THEN RIGHT ( cs_uristem, 5 )  
  WHEN  POSITION ( '.' IN ( RIGHT ( cs_uristem, 6 ) ) ) = 1 THEN RIGHT ( cs_uristem, 6 )  
  ELSE NULL  
   END AS extension, count(*) as ExtCount
  FROM iislogs  
 WHERE cs_uristem NOT LIKE '%.'  
   AND cs_uristem LIKE '%.%'  
 GROUP BY Extension
 ORDER BY EXTCOUNT DESC


Respectfully,