Dylan0222

It appears that the default value handling differs between the two systems. Since column c2 has a NOT NULL constraint, one would theoretically expect it not to return NULL. However,...

> It appears that the default value handling differs between the two systems. Since column c2 has a NOT NULL constraint, one would theoretically expect it not to return NULL....

> Thanks for your patience. We have confirmed it is a bug, and also notified the DEV team. Thanks a lot. Best wishes to you~

Hi Has there been any progress? I would like to clarify my concern further. According to the documentation, the default behavior of operator precedence should follow the exact rules outlined...

Thank you for your response. MySQL has previously acknowledged the presence of this bug in the optimizer for version 8.0 and above. BTW, It’s intriguing to consider the criteria OceanBase...