Forum OpenACS Q&A: order by upper(bar) bug in PG 7.1. Still revelant?

Hi,

Some time ago I received a big patch from Ola Hansson that corrects a bunch of stuff in many modules so they can work with PG 7.1. Then Chris Hardy patched his patch for intranet and corrected some things, but only for intranet.

I am not familiar with what the bug was, so if someone would please explain them to me, it'd be nice. I've been going through the patch and changing some things that needed to be changed. However, in my tests with PG 7.1 RC4 I don't see any problem with order by:

test=# select * from bar;
  name  |   last_name    
--------+-------------
 fulano | da silva
 jose   | maria
 Zeca   | austrogildo
(3 rows)

test=# select * from bar order by upper(last_name);
  name  |   last_name    
--------+-------------
 Zeca   | austrogildo
 fulano | da silva
 jose   | maria
(3 rows)

I am up to line 250 of the patch now, out of > 600. Most of the patch needs to be changed, so if the bug is no longer relevant in 7.1 final (or RC4 since it's the same as final) then I can just delete a big chunck of the patch.

If somebody knows details of the bug, I can create a test case asd see if it's still relevant. It doesn't look like it.

Check this out:

https://openacs.org/forums/message-view?message_id=17672

It describes the case that failed, which involves UNION as well as ORDER BY.  Sorry I didn't get back to your e-mail earlier...

Try Dan's example with and without the explicit name...