9.0rc1 - query of view produces unexpected results
От | Nathan Grange |
---|---|
Тема | 9.0rc1 - query of view produces unexpected results |
Дата | |
Msg-id | 4C8C2D58.5090308@actarg.com обсуждение исходный текст |
Ответы |
Re: 9.0rc1 - query of view produces unexpected results
Re: 9.0rc1 - query of view produces unexpected results |
Список | pgsql-sql |
Hello list, <br /><br /> I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpectedresults when i query a specific view. <br /><br /> I can only reproduce the unexpected results with a very specificset of tables, views, and relationships.<br /> The bad results are only manifest in 9.0 (beta and rc1). Version 8.4.4produces the expected results.<br /><br /> To sum up the issue ...<br /> 1. View register_orders_view contains only1 row of data ...<br /><br /><font color="#009900"><i>ttype | ropnum | shop_name <br /> -------+--------+-----------<br/> or | 30129 | District1</i></font><br /><br /> 2. The query ...<br /><i><br /><fontcolor="#009900">select * from register_orders_view where ttype='z'</font></i><br /><br /> ... should returnno rows, however all rows are returned. <br /><br /><br /> Included are a buildDemo.sql file that will create the necessarytables and views, and a runDemo.sql to demonstrate the query from #2 above. <br /><br /> If this is a valid result,can someone please help me understand why?<br /> If this is a case of "not the best" architecture a explanation wouldbe greatly apprecitated.<br /> Or if this is a bug with 9.0, what actions do I take to make the PostgreSQL team awares?<br/><br /> nate<br /><br />
В списке pgsql-sql по дате отправления: