• Also, can you explain what some of the unexpected results might be?

    Hi Gary,

    I've often experienced unexpected result. A typical issue, for example, occurs when you change the order of the columns on underlying views/tables of a view that use "SELECT *" (but not only with *! Also with explicit columns list!). For example if you add a new column on the underlying tables/views, expecially if you add that column in the middle and not at the end of the column list.

    This is what happens to me more often.

    I don't know if ther are other kind of issues... perhaps Cameron can describe to us other cases.

    Bye!

    Flavio.