Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.8.4
-
None
-
None
-
None
Description
To be hostnest i developed my own function to generate DIGEST_TEXT, the problem with mariadb there is bug too : (that is had to reproduce ...)
SELECT id FROM mysql_server WHERE id = 1; |
-- Not the same query than : (and not the same digest)
|
SELECT `id` FROM `mysql_server` WHERE `id` = 1; |
SELECT id FROM mysql_server WHERE id = 1; |
--will give
|
SELECT ID FROM mysql_server WHERE ID = ? -- id without ` , it's the same problem for KEYS WORDS |
|
|
SELECT `id` FROM `mysql_server` WHERE `id` = 1; |
-- will give
|
SELECT `id` FROM `mysql_server` WHERE `id` = ?
|
These 2 query are equal by not give the same DIGEST_TEXT and of course not the same DIGEST too.
MySQL fixed it already !