Hi Guys,

I am a DBA in the process of migrating a Django application database from Postgres to MS SQL Server.

This application is using sql_server.pyodbc and Microsoft SQL Server ODBC driver for Linux/Ubuntu. Everything works except for queries that have a CASE WHEN and GROUP BY added to them.

From running traces I see that the SQL is actually passed to the SQL Server via the sp_prepexec procedure with MANY parameters. The parameters are variables and are different in the select vs group by, causing the error on SQL Server side.

This is just an example, the actual query is more complex:

select case when col1=@p1 then @p2 end as new_col1, sum(col2) from table group by case when col1=@p3 then @p4 end

In reality, @p1 and @p3 are the same values. So are @p2 and @p4. But SQL Server doesn't know that. This also fails if I run the same query on Postgres - so I assume this has to do with the sql_server.pyodbc package.

Has anyone come across this? What are my options? Am I doing something wrong with the configuration?


Thanks & Regards
Camillelola