medillcmip / Radregator

A Context Management System
GNU General Public License v3.0
7 stars 1 forks source link

CountIfConcur SQL causes error with PostgreSQL databasse #99

Closed ghing closed 14 years ago

ghing commented 14 years ago

This was working in SQLite3 on my netbook when I pushed to master. With PostgreSQL 8.4, a number of unit tests fail with error messages like this:

...
File "/home/ghing/.virtualenvs/radregator/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
    return self.cursor.execute(query, args)
DatabaseError: column "concur" does not exist
LINE 1: ...", COUNT (CASE "core_commentresponse"."type" WHEN "concur" T...

I'm guessing there's just something weird with the CASE syntax and I may have to check the database backend setting and do something different depending on which one is used.

ghing commented 14 years ago

Fixed in commit 2e26dc200d4c0836a35e91eb338e1e38c662fef4