数据库做分区后,使用union或union all 查询结果比预期的少
oracle11g 有一张台站表按地区字段做了分区,现有如下问题
1.查询两个地区时
结果错误,缺少p12的数据:select guid from station partition(p11) union all select guid from station(p12)
结果正确:select guid from station partition(p11) union select guid from station(p12)
2.查询更多地区时
结果错误,缺少p13的数据:select guid from station partition(p11) union select guid from station(p12) union select guid from station partition(p13)
结果正确:select guid from station partition(p11) union select guid from station(p12) union all select guid from station partition(p13)
请问这个问题是不是由分区引起的?这个问题怎么改?