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,