mike-jumper commented on PR #902:
URL: https://github.com/apache/guacamole-client/pull/902#issuecomment-1646339534
I'm referring to comparisons against the `guacamole_entity` table. There
does seem to be a difference in how basic string comparisons are performed
between the databases, probably due to differing defaults in collation.
When I try things against PostgreSQL, `guacadmin` and `GUACADMIN` are
different:
```
guacamole_db=# SELECT * FROM guacamole_entity WHERE type = 'USER' AND name =
'guacadmin';
entity_id | name | type
-----------+-----------+------
1 | guacadmin | USER
(1 row)
guacamole_db=# SELECT * FROM guacamole_entity WHERE type = 'USER' AND name =
'GUACADMIN';
entity_id | name | type
-----------+------+------
(0 rows)
```
When I try against MySQL, they're the same:
```
MariaDB [guacamole_db]> SELECT * FROM guacamole_entity WHERE type = 'USER'
AND name = 'guacadmin';
+-----------+-----------+------+
| entity_id | name | type |
+-----------+-----------+------+
| 1 | guacadmin | USER |
+-----------+-----------+------+
1 row in set (0.000 sec)
MariaDB [guacamole_db]> SELECT * FROM guacamole_entity WHERE type = 'USER'
AND name = 'GUACADMIN';
+-----------+-----------+------+
| entity_id | name | type |
+-----------+-----------+------+
| 1 | guacadmin | USER |
+-----------+-----------+------+
1 row in set (0.001 sec)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@guacamole.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
