[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          |   Keywords:
  Focuses:                  |
----------------------------+-----------------------------
 $table_prefix = '7e1_';

 WordPress database error: [You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near '7e1_users ( ID bigint(20) unsigned NOT NULL auto_increment,
 user_login varch' at line 1]

 It seems that mysql is trying to parse 7e1_users in engineering notation
 (numeric value), instead of as an allowed table name. This requires the
 table name to always be quoted to force correct parsing. Unsure what the
 path forward is, i.e. detect and display a better error message, or auto
 quote the table name.

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