New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot convert IS TRUE or IS FALSE from Redshift to Trino #1740

Closed

pangyifish opened this issue Jun 7, 2023 · 0 comments

Assignees

pangyifish commented Jun 7, 2023

sql = """SELECT a from (select true as a) where a is true"""
converted_sql = sqlglot.transpile(sql, read="redshift", write="trino")[0]
print(converted_sql)

SELECT a FROM (SELECT TRUE AS a) WHERE a IS TRUE
Trino error: mismatched input 'TRUE'. Expecting: 'DISTINCT', 'NOT', 'NULL'

a fix could be: replacing "is true" with ""; "is false" with "not"

The text was updated successfully, but these errors were encountered:

tobymao self-assigned this

tobymao closed this as completed in

0cc09cf

adrianisk pushed a commit to adrianisk/sqlglot that referenced this issue


          Fix: is true for presto closes tobymao#1740

20e50b6

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment