Oracle's discussion about null

Today, I want to go into something meaningless: many people know that it is meaningless to use null values for comparison. But have you ever actually tried it?
Try to see if there are some strange phenomena. Let's take a look at the following two results (tested on 10 Gb): www.2cto.com
Is it strange? I just used a different sequence to compare and filter with null, but different results are displayed. It is reasonable to say that no data can be found. Now let's look at their execution plan: Obviously, the two statements go through different execution paths. One is filtered, and the other is not. This is a bug of 10 Gb. This discussion was intense in the QQ group. After a colleague tested it on the 11g, neither of the two writing methods was returned:
Www.2cto.com apparently fixed this bug in 11g.