DO NOT REPLY [Bug 8196] New: - misspelled SQL query in org.apache.catalina.session.JDBCStore.keys() method

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8196>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8196

misspelled SQL query in org.apache.catalina.session.JDBCStore.keys() method

           Summary: misspelled SQL query in
                    org.apache.catalina.session.JDBCStore.keys() method
           Product: Tomcat 4
           Version: Unknown
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Catalina
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: seweryn.sobieszek@e-point.pl


The query SELECT COUNT(s.session_id), s.session_id FROM tomcat_sessions s,
tomcat_session c GROUP BY c.session_id does not it is supposed to do (as I think).
As I figured out it should return count of sessions with their identifiers, but 
it doesn't works properly on MySQL, and doesn't work on SQL92-compliant database
at all - attribute s.session_id isn't grouped but it should be.
The query should say: SELECT COUNT(s.session_id), c.session_id FROM
tomcat_sessions s, tomcat_session c GROUP BY c.session_id;
The bug is present in current CVS version.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>