[wp-trac] [WordPress Trac] #36422: Specific table prefixes causes sql errors

[WordPress Trac]

#36422: Specific table prefixes causes sql errors
----------------------------+------------------------------
 Reporter:  voldemortensen  |       Owner:
     Type:  defect (bug)    |      Status:  new
 Priority:  normal          |   Milestone:  Awaiting Review
Component:  Database        |     Version:
 Severity:  normal          |  Resolution:
 Keywords:                  |     Focuses:
----------------------------+------------------------------

Comment (by dd32):

 The correct thing to do would be to always quote the table names, but
 realistically that's not an option here (plugins, etc).

 Maybe we can preflight the prefix name during the DB credentials checks
 somehow? just check that the DB interprets an unquoted prefix the same as
 it would a quoted one?
 I assume we'd just say it's an invalid prefix if it failed, I'd err on the
 side of not trying to explain why it's invalid though.

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