[ICU] Add casts from Timestamp_* to TimestampTZ#9539
Merged
Mytherin merged 30 commits intoduckdb:mainfrom Feb 15, 2024
Merged
Conversation
hawkfish
reviewed
Nov 1, 2023
Contributor
hawkfish
left a comment
There was a problem hiding this comment.
Code looks great! Can we have some pure SQL tests that don't require pandas?
Contributor
Author
|
Of course it couldn't be this simple 🙃 Because the conversion to TIMESTAMP_TZ is transformative, it fails to verify because the stats are out of date //! Expression statistics (if any) - ONLY USED FOR VERIFICATION
unique_ptr<BaseStatistics> verification_stats;🙃 Fixed it by just disabling the verification for the test |
hawkfish
reviewed
Nov 1, 2023
Contributor
Author
|
Interesting behavior? D select make_timestamp(-9223372036854775806);
Error: Conversion Error: Date out of range in timestamp conversionReplacing every value with a 0 until it succeeds: ┌──────────────────────────────────────┐
│ make_timestamp(-9223372000000000000) │
│ timestamp │
├──────────────────────────────────────┤
│ 290309-12-22 (BC) 06:13:20 │
└──────────────────────────────────────┘I assume this is the minimum then? |
…it was super confusing
hawkfish
reviewed
Nov 2, 2023
hawkfish
reviewed
Nov 8, 2023
hawkfish
reviewed
Nov 10, 2023
Contributor
hawkfish
left a comment
There was a problem hiding this comment.
The Try... is a good addition. I still think the extra IsFinite calls are unnecessary, although the assert is a good idea.
hawkfish
approved these changes
Dec 12, 2023
Collaborator
|
Thanks! There seems to be some CI failures remaining - could you have a look? |
…p infinities between duckdb<->parquet
Closed
1 task
1 task
hawkfish
approved these changes
Feb 14, 2024
Collaborator
|
Thanks! LGTM |
krlmlr
added a commit
to duckdb/duckdb-r
that referenced
this pull request
Mar 15, 2024
Merge pull request duckdb/duckdb#10658 from hannes/csvpathlength Merge pull request duckdb/duckdb#10756 from Mytherin/preserveinsertionordermemory Merge pull request duckdb/duckdb#10746 from samansmink/enable-azure-autoload Merge pull request duckdb/duckdb#10747 from maiadegraaf/list_reverse_bug Merge pull request duckdb/duckdb#10748 from taniabogatsch/capi-tests Merge pull request duckdb/duckdb#10739 from peterboncz/pb/immmedate_mode_only_in_non_autocommit Merge pull request duckdb/duckdb#10688 from Tmonster/union_exclude Merge pull request duckdb/duckdb#10710 from samansmink/comment-on-column Merge pull request duckdb/duckdb#10725 from hawkfish/fuzzer-preceding-frame Merge pull request duckdb/duckdb#10723 from hawkfish/fuzzer-null-timestamp Merge pull request duckdb/duckdb#10436 from taniabogatsch/map-fixes Merge pull request duckdb/duckdb#10587 from kryonix/main Merge pull request duckdb/duckdb#10738 from TinyTinni/fix-assert-in-iscntrl Merge pull request duckdb/duckdb#10708 from carlopi/ci_fixes Merge pull request duckdb/duckdb#10726 from hawkfish/fuzzer-to-weeks Merge pull request duckdb/duckdb#10727 from hawkfish/fuzzer-window-bind Merge pull request duckdb/duckdb#10733 from TinyTinni/remove-static-string Merge pull request duckdb/duckdb#10715 from Tishj/python_tpch_regression_rework Merge pull request duckdb/duckdb#10728 from hawkfish/fuzzer-argminmax-decimal Merge pull request duckdb/duckdb#10717 from carlopi/fix_extension_deploy Merge pull request duckdb/duckdb#10694 from Mytherin/castquerylocation Merge pull request duckdb/duckdb#10448 from peteraisher/feature/use-assertThrows-for-jdbc-tests Merge pull request duckdb/duckdb#10691 from Mytherin/issue10685 Merge pull request duckdb/duckdb#10684 from Mytherin/distincton Merge pull request duckdb/duckdb#9539 from Tishj/timestamp_unit_to_tz Merge pull request duckdb/duckdb#10341 from Tmonster/tpch_ingestion_benchmark Merge pull request duckdb/duckdb#10689 from Mytherin/juliaversion Merge pull request duckdb/duckdb#10669 from Mytherin/skippedtests Merge pull request duckdb/duckdb#10679 from Tishj/reenable_window_rows_overflow Merge pull request duckdb/duckdb#10672 from carlopi/wasm_extensions_ci Merge pull request duckdb/duckdb#10660 from szarnyasg/update-storage-info-for-v0100 Merge pull request duckdb/duckdb#10643 from bleskes/duck_transaction_o11y Merge pull request duckdb/duckdb#10654 from carlopi/fix_10548 Merge pull request duckdb/duckdb#10650 from hannes/noprintf Merge pull request duckdb/duckdb#10649 from Mytherin/explicitenumnumbers
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
4 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
This PR fixes #9532
What we essentially do is just perform
value::TIMESTAMP::TIMESTAMP_TZwherevalue::TIMESTAMP_TZis requested.