I got an error (no error message) in a view that is based on a nested view but the data in the columns was in the wrong place. This problem suddenly occured in a system that has been running for several years.
I have not come across this error before and therefore I am a little lost.
I have a general fact view (view_base) containing common general fields och a view (view_special) that contains specialvalues for one type of data. These two views is then joined to a new view (view_all) containing all fields from both views.
the view was created according to below:
CREATE VIEW [view_all]
SELECT f., r.
FROM view_special AS r
JOIN view_base AS f
ON r.s_id = f.id
The acute solution was to recreate the top view (view_all) and everything was fine again, but I need to reassure that this problem does not pop up again!