sql - RasberryPi python error - sqlite3.OperationalError: near "(": syntax error - but not in Windows

Question

I have a problem in python code with sqlite3.

This is my code.

conn = sqlite3.connect("test.db", isolation_level=None)
c = conn.cursor()
c.execute("WITH T AS (
    SELECT dense_rank() over(partition by code order by win desc, profit desc, ma asc) as rank, * 
    FROM ENV_ANALYZE WHERE LOSE = 0
    )
    SELECT code, name, ma, percent, cutLength, profit, win, lose FROM T where rank = 1")

In windows, It works!! There is no problem.

So,I copied this code to RasberryPi. But It occurs error like this

Traceback (most recent call last):
  File "/home/pi/python/test.py", line 27, in <module>
    SELECT code, name, ma, percent, cutLength, profit, win, lose FROM T where rank = 1")
sqlite3.OperationalError: near "(": syntax error

So I fixed like this for a test, It works in RasberryPi anyway. Removed dense_rank option.

c.execute("WITH T AS (
    SELECT 1 as rank, * 
    FROM ENV_ANALYZE WHERE LOSE = 0
    )
SELECT code, name, ma, percent, cutLength, profit, win, lose FROM T where rank = 1")

But I need that dense_rank option. So I need the first code and I want to Run in RasberryPi.

Do you have any idea about this?

question from:https://stackoverflow.com/questions/66066025/rasberrypi-python-error-sqlite3-operationalerror-near-syntax-error-but

Answer 1

Waitting for answers