sqlglot
sqlglot copied to clipboard
[bug] execute error when postgres to mysql
Before you file an issue
- Make sure you specify the "read" dialect eg.
parse_one(sql, read="spark") - Make sure you specify the "write" dialect eg.
ast.sql(dialect="duckdb") - Check if the issue still exists on main
Fully reproducible code snippet Please include a fully reproducible code snippet or the input sql, dialect, and expected output.
Official Documentation Please include links to official SQL documentation related to your issue.
this is sql:select string_to_array('dd,ee', ',') <@array['dd','ee','ff','gg','hh'];
this is sql: select ext_info::jsonb ->> 'orphan_unbind_type' from edw_ods.ods_xmt_invite_record;