Re: [BUGS] Bug #795: null resulting from left join corrupts select

2002-10-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > select > * > from > test1 left join test2 on (test1.test1_id = test2.test1_id) > where > test1.test1_id = test2.test1_id; > test1_id | test2_id | test1_id > --+--+-- > 1 |1 |1 > 2 | | This is fixed fo

Re: [BUGS] Bug #796: Problem after upgrading to v. 723

2002-10-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > After upgrading from v. 721 to 723 some of regression tests failed. > BEGIN; >CREATE SEQUENCE s_ASeq; >SELECT nextval('s_ASeq') ; >DROP SEQUENCE s_ASeq ; >/* some sql statement might be here */ > COMMIT; > 1) Problem occurs when attempt is made to drop

[BUGS] Bug #796: Problem after upgrading to v. 723

2002-10-12 Thread pgsql-bugs
Michael Brusser ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problem after upgrading to v. 723 Long Description After upgrading from v. 721 to 723 some of regression tests failed. (We're running on Solaris) Looking into pro