[wp-trac] [WordPress Trac] #44440: Case sensitive/insensitive bug

[WordPress Trac]

#44440: Case sensitive/insensitive bug
--------------------------+------------------------------
 Reporter:  dingdang      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.9.6
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+------------------------------

Comment (by pbiron):

 My envs:

 * windows 10 pro
    * WP 4.9.6
    * MySQL 5.7.10 (engine=InnoDB, db collation utf8mb4_unicode_520_ci)
    * PHP 5.6.36
 * linux (Kernel Version 2.6.32-673.26.1.lve1.4.29.el6.x86_64, I think it's
 centOS but not positive)
    * WP 4.9.6
    * MySQL 5.6.39 (engine=MyISAM, db collation utf8mb4_unicode_520_ci)
    * PHP 5.6.20

 I can confirm:

 1. in windows, I end up with table names like `prefix_xxx`; while in linux
 I end up with table names like `pReFiX_xxx`
 2. the values in the `option_name` and `meta_name` columns of the relevant
 rows of `$wpdb->options` and `$wpdb->usermeta` are `pReFiX_xxx` in both
 windows and linux

 However, I can **not** replicate the problem of "loses its role and access
 is forbidden" on linux.  I am able to access admin funcs (i.e., create
 posts, etc) in both windows & linux envs.

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