>filter settings i dont have any.
>
>regarding non saved data, the select statement should behave exactly the same in both datasessions.
>
>this is the perplexing issue.
>
>if the select statement was wrong it would behave incorrectly in both data sessions private and default.

If you use some filter criteria in your select, then SET ANSI settings will come into play.