[wp-trac] [WordPress Trac] #36649: Right-hand CAST in a MySQL query produces DB error

[WordPress Trac]

#36649: Right-hand CAST in a MySQL query produces DB error
------------------------------------------------------+------------------
 Reporter:  ericlewis                                 |       Owner:
     Type:  defect (bug)                              |      Status:  new
 Priority:  normal                                    |   Milestone:  4.6
Component:  Database                                  |     Version:  2.8
 Severity:  normal                                    |  Resolution:
 Keywords:  has-patch needs-testing needs-unit-tests  |     Focuses:
------------------------------------------------------+------------------
Changes (by pento):

 * keywords:  has-patch needs-testing dev-feedback => has-patch needs-
     testing needs-unit-tests
 * milestone:  Awaiting Review => 4.6


Comment:

 Fun times.

 This looks like a relatively sane solution to the problem, we'll need it
 for #32405, too. We probably haven't seen any historical reports of this,
 because the default MySQL collation almost always matched the connection
 collation, prior to [31349].

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36649#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform