SQL returns wrong result when the table order is swapped
I noticed a strange behavior—a SQL statement, which used to return no rows in the past, started returning rows in an environment where the test data set has not changed. I performed a code comparison and observed a difference in the order of a table in FROM clause. After looking through, I found a bug entry on MOS …
SQL returns wrong result when the table order is swapped Read More »