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

fix: EXPOSED-464 CurrentTimestampWithTimeZone expression does not work as a default #2180

Merged
merged 2 commits into from
Aug 5, 2024

Conversation

joc-a
Copy link
Collaborator

@joc-a joc-a commented Jul 30, 2024

Description

Summary of the change:
When the value of a timestampWithTimeZone column is set from CURRENT_TIMESTAMP, the format of the value is different than when a different value is set as a default or a value is set during insertion, and the column type was not handling that case before for SQLite and Oracle.

Detailed description:

  • What:
    Make timestampWithTimeZone column work when CurrentTimestampWithTimeZone expression is used as a default in SQLite and Oracle.
  • Why:
    Error was being thrown before.
  • How:
    Modify formatters to handle when timestampWithTimeZone column is set from CURRENT_TIMESTAMP.

Type of Change

Please mark the relevant options with an "X":

  • Bug fix
  • New feature
  • Documentation update

Updates/remove existing public API methods:

  • Is breaking change

Affected databases:

  • MariaDB
  • Mysql5
  • Mysql8
  • Oracle
  • Postgres
  • SqlServer
  • H2
  • SQLight

Checklist

  • Unit tests are in place
  • The build is green (including the Detekt check)
  • All public methods affected by my PR has up to date API docs
  • Documentation for my change is up to date

Related Issues

@joc-a joc-a force-pushed the joc/exposed-464 branch 2 times, most recently from bffca11 to 00750b0 Compare July 30, 2024 15:32
…ork as a default

When the value of a `timestampWithTimeZone` column is set from CURRENT_TIMESTAMP, the format of the value is different than when an explicit value is set, and the column type was not handling that case before.
@joc-a joc-a marked this pull request as ready for review July 31, 2024 13:25
@joc-a joc-a requested a review from obabichevjb July 31, 2024 13:26
@joc-a joc-a merged commit a2285b5 into main Aug 5, 2024
5 checks passed
@joc-a joc-a deleted the joc/exposed-464 branch August 5, 2024 13:41
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