Bug #119413 Intersection order

• Submitted: 17 Nov 23:52
• Reporter: wenwen wen
• Status: Open
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: mysql Ver 9.4.
• OS: Any
• CPU Architecture: Any

[17 Nov 23:52] wenwen wen

Description:
SELECT NULL INTERSECT SELECT 1 returns empty but SELECT 1 INTERSECT SELECT NULL gives the result 1. The order of the intersection changes then the results are different.

How to repeat:
You could change the order of INTERSECT but must have NULL at one side.