Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Customer runs a query with a “not exists” clause, if he adds 1 extra column it produces different results?

April 26, 2017adds clause column customer extra produces query

0

Posted

Customer runs a query with a “not exists” clause, if he adds 1 extra column it produces different results?

1 Answer

0

Posted

This is a hard to pinpoint optimizer bug, could not get test case to reproduce out of original environment. However there have been other reports of similar problems. Customer changed query from “NOT EXISTS” to “NOT IN”, problem did not recur.