Skip to content
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.

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

Handle function return type or argument type is array type #76

Closed
goldmedal opened this issue Aug 4, 2022 · 1 comment
Closed

Handle function return type or argument type is array type #76

goldmedal opened this issue Aug 4, 2022 · 1 comment
Labels

Comments

@goldmedal
Copy link
Contributor

No description provided.

@goldmedal
Copy link
Contributor Author

pg-wire is archived.

grieve54706 added a commit that referenced this issue Dec 13, 2024
* chore(trino): edit expression for timestamptz

* feat(rewriter): integrate

* feat(format): datetime to string with specify time zone

* feat(rewriter): rewrite timestamp literal with session time zone

* feat(rewriter): rewrite timestamp literal to cast as timestamp with time zone

Avoid sqlglot convert type incorrectly like
`TIMESTAMP '2024-01-01 00:00:00 America/Bahia_Banderas'` to
`CAST('2024-01-01 00:00:00 America/Bahia_Banderas' AS TIMESTAMP` from
Trino to Postgres.

If the statement is `CAST('2024-01-01 00:00:00 America/Bahia_Banderas'
AS TIMESTAMP WITH TIME ZONE`, sqlglot will convert it to
`CAST('2024-01-01 00:00:00 America/Bahia_Banderas' AS TIMESTAMP WITH
TIME ZONE)` correctly.

* feat(rewriter): rewrite cast as timestamp to timestamp with time zone

* chore(mssql): time zone should be a time, and update skip reason

* feat(mysql): use convert_tz instead of cast

* chore(mssql): time zone should be time and cast should with column name

* fix(clickhouse): rewrite by toDateTime

* chore(header-sql-dialect): move the http header about sql dialect in rewriter

* feat(v3): implement headers

* test(v3): implement should wait rust

* fix: data_source could be None

* fix(test): adjust expected

* test(duckdb): add test case

* test: align timestamp with time zone expression

* chore(rewriter): use WrenException instead of NoSuchElementException

* feat(rewriter): add test case and adjust datetime pattern

* chore(comment): fix comment

* chore(api): use StrEnum instead of string

* chore(comment): add comment
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant