In any case it is pretty annoying gotcha which I hope MySQL will fix in next MySQL versions - the fact queries in this example behave differently is illogical and counter intuitive.

• 无论如何，这都是相当烦人的，因此希望MYSQL能在下一个版本中解决它 -- 本文的例子中的查询表现的如此不同其实是不合逻辑的只是大致的估算。