Bug #79691 Block Memcached from modifying tables that contain indexed virtual columns

• Submitted: 17 Dec 2015 13:19
• Modified: 8 Jan 2016 18:19
• Reporter: Thirunarayanan Balathandayuthapani
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.7
• OS: Any
• CPU Architecture: Any

[17 Dec 2015 13:19] Thirunarayanan Balathandayuthapani

Description:
Accessing/updating the virtual index for the table involves callback to server code.
Memcached doesn't access to server code. So block the memcached from modifying the table
contains virtual index.

How to repeat:
Try to access virtual index column via memcached connection.

Suggested fix:
Block the memcached from modifying the table contains virtual index

[8 Jan 2016 18:19] Daniel Price

Posted by developer:
 
Fixed as of the upcoming 5.7.11, 5.8.0 release, and here's the changelog entry:

memcached connections are blocked from accessing tables that contain an
indexed virtual column. Accessing a an indexed virtual column requires a
callback to the server, but a memcached connection does not have access to
the server code.