Announcement Announcement Module
Collapse
No announcement yet.
Issue with IFNULL in JdbcConnectionRepository and Postgres 8.4 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Issue with IFNULL in JdbcConnectionRepository and Postgres 8.4

    Hi all,

    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.

  • #2
    Thanks. I see you've submitted a pull request to change this. I'll have a look and let you know.

    Comment


    • #3
      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!

      Comment


      • #4
        Thanks Craig for the quick turnaround!

        Comment

        Working...
        X