Re: HSQLDB 2.5.1 issue

Please report in the Help forum and provide the table definition for the iislogs table.

Fred

On Wed, Jul 29, 2020, at 19:44, Michael Dever via Hsqldb-user wrote:
> 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,
> 
> 
> 
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>