Skip to content

Conversation

@sgrebnov
Copy link

@sgrebnov sgrebnov commented Jul 19, 2024

Which issue does this PR close?

PR addresses Int64 unparser issue producing invalid CAST(col AS BigInt) SQL for MySQL.

MySQL cast function does not support BigInt and requires SIGNED for CAST

SIGNED [INTEGER]
Produces a signed BIGINT value.

Note: INTEGER does not work, requires SIGNED

sqlparser crate does not have Signed type so we construct ast::DataType::Custom

@sgrebnov sgrebnov self-assigned this Jul 19, 2024
@sgrebnov sgrebnov merged commit 790f9c6 into spiceai-40 Jul 19, 2024
@sgrebnov sgrebnov deleted the sgrebnov/fix-int64-cast-mysql branch July 19, 2024 17:40
y-f-u pushed a commit that referenced this pull request Jul 29, 2024
* Configurable date field extraction style for unparsing (#21)

* Add support for IntervalStyle::MySQL (#18)

* Support alternate format for Int64 unparsing (SIGNED for MySQL) (#22)

* Alternate format support for Timestamp casting (DATETIME for MySQL) (#23)

* Improve

* Fix clippy and docs
phillipleblanc pushed a commit that referenced this pull request Apr 22, 2025
… them (apache#15566)

* ExecutionPlan: add APIs for filter pushdown & optimizer rule to apply them

* wip

* fix tests

* fix

* fix

* fix doc

* fix doc

* Improve doc comments of `filter-pushdown-apis` (#22)

* Improve doc comments

* Apply suggestions from code review

---------

Co-authored-by: Adrian Garcia Badaracco <1755071+adriangb@users.noreply.github.com>

* Apply suggestions from code review

Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>

* simplify according to pr feedback

* Add missing file

* Add tests

* pipe config in

* docstrings

* Update datafusion/physical-plan/src/filter_pushdown.rs

* fix

* fix

* fmt

* fix doc

* add example usage of config

* fix test

* convert exec API and optimizer rule

* re-add docs

* dbg

* dbg 2

* avoid clones

* part 3

* fix lint

* tests pass

* Update filter.rs

* update projection tests

* update slt files

* fix

* fix references

* improve impls and update tests

* apply stop logic

* update slt's

* update other tests

* minor

* rename modules to match logical optimizer, tweak docs

---------

Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Co-authored-by: berkaysynnada <berkay.sahin@synnada.ai>
Co-authored-by: Berkay Şahin <124376117+berkaysynnada@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants