This problem also arises with views. If you do "select * from" within a view, you will get the column mismatching as well.

The select will fail if you have cut a column off your table, but inserted columns will offset data as shown.