Re: [SQL] Change in 9.1?

[Andreas Joseph Krogh]

På tirsdag 22. november 2011 kl 08:39:09 skrev Jasmin Dizdarevic <jasmin.dizdare...@gmail.com>:

Hi, 

 

we have a reporting tool, that sometimes uses this kind of condition.

...WHERE a.field = a.field 

 

To explain this: a.field can be filtered by the user. the user can choose some values. if he does, this condition will be build:

...WHERE a.field IN (1,2,3)

 

If the user doesn't choose any values the * = * condition is used.

 

Since 9.1 we're experiencing problems with this construction. Have there been any changes to the planner regarding this?

 

It would be far easier to give you an answer if you provided a query which worked before which now, in 9.1, gives you trouble.

--
Andreas Joseph Krogh <andr...@officenet.no> - mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc