[OSM-dev] Potlatch update

[Richard Fairhurst]

Frederik Ramm wrote:

> [big hairy SQL query snipped]
> That might work?

That's loads better. Thanks a lot. I'll see how that affects the  
possibility of doing some POI stuff for Potlatch...

> Someone once told me that Mysql is too dumb to use an index inside  
> an OR condition and that one would therefore be better off with  
> UNIONs.

Looking at http://bugs.mysql.com/bug.php?id=11989, it looks like  
you're right - at least for MySQL 4, which is what I'm using. It's  
been fixed in MySQL 5.

What version of MySQL are we using on the db server?

cheers
Richard