8.0.22 : Some CREATE TABLE .... SELECT Queries Using derived_condition_pushdown Optimizer Switch Silently Return Nothing And Don't Create Any Table
(Doc ID 2731358.1)
Last updated on DECEMBER 05, 2020
Applies to:MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
A query like: CREATE TABLE ...... SELECT ...... should always create the table even if the SELECT returns nothing. However this was not case for certain queries:
Server was recently upgraded to 8.0.22. This is a regression bug affecting 8.0.22.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document