View Full Version : Issue with IFNULL in JdbcConnectionRepository and Postgres 8.4
Jul 1st, 2011, 11:56 AM
Just wanted to point out that IFNULL isn't a supported function in Postgres 8.4. It's used in JdbcConnectionRepository:166. I'm fairly certain the COALESCE function should be able to replace it safely in all major DBs.
Jul 1st, 2011, 01:45 PM
Thanks. I see you've submitted a pull request to change this. I'll have a look and let you know.
Jul 1st, 2011, 02:21 PM
Okay, I've merged your pull request and it's now using coalesce instead of ifnull. That seems like a much more portable choice.
I've also just pushed another snapshot build to include this change. As Dolan pointed out, this should work with most any DB. But if you run into any trouble with it, let us know (and what DB you're using).
Thanks for the contribution!
Jul 19th, 2011, 12:12 PM
Thanks Craig for the quick turnaround!
Powered by vBulletin® Version 4.2.1 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.