[jira] [Commented] (GUACAMOLE-1526) Error on connection history search

["Mike Jumper (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GUACAMOLE-1526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17484916#comment-17484916 ] 

Mike Jumper commented on GUACAMOLE-1526:
----------------------------------------

I haven't tested for this behavior with MySQL/MariaDB and SQL Server, but for PostgreSQL the issue is that a year with 7+ digits is outside the allowed range for a timestamp:

{quote}
org.postgresql.util.PSQLException: ERROR: timestamp out of range: "1234567-01-01 00:00:00.000000 +00:00:00"
{quote}

If this occurs for MySQL/MariaDB and SQL Server, it's probably for the same reason. In each of these cases, database-specific implementations should avoid querying the history based on the date for values that cannot exist due to the inherent size restrictions on timestamps.

> Error on connection history search
> ----------------------------------
>
>                 Key: GUACAMOLE-1526
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-1526
>             Project: Guacamole
>          Issue Type: Bug
>          Components: guacamole-auth-jdbc
>    Affects Versions: 1.3.0, 1.4.0
>            Reporter: Roldao G Rego Jr
>            Priority: Minor
>
> An error occurs when I try to search the connection history page after typing a number with more than 6 digits



--
This message was sent by Atlassian Jira
(v8.20.1#820001)