sqlglot icon indicating copy to clipboard operation
sqlglot copied to clipboard

[bug] execute error when postgres to mysql

Open Toms1999 opened this issue 1 year ago • 2 comments

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.

Toms1999 avatar May 17 '24 08:05 Toms1999

this is sql:select string_to_array('dd,ee', ',') <@array['dd','ee','ff','gg','hh'];

Toms1999 avatar May 17 '24 08:05 Toms1999

this is sql: select ext_info::jsonb ->> 'orphan_unbind_type' from edw_ods.ods_xmt_invite_record;

Toms1999 avatar May 17 '24 09:05 Toms1999