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.

Sign up for GitHub

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

Jump to bottom

feat(expr): support hex / oct / bin when casting from string to integrals #17561

Open
xiangjinwu opened this issue Jul 4, 2024 · 0 comments
Open

feat(expr): support hex / oct / bin when casting from string to integrals #17561

xiangjinwu opened this issue Jul 4, 2024 · 0 comments
Assignees
@xiangjinwu
Labels
type/feature
Milestone
release-2.2

Comments

@xiangjinwu
Copy link
Contributor

To lift the restriction in #14262:

Only during sqlparsing but not execution (eg '0x20'::int / source ingestion / pgwire text protocol)

With this we won't need to use the internal PostgreSQL function int8recv #13069:

  • old: int8recv(decode(right(MD5('1234'), 16), 'hex'))
  • new: ('0x' || right(MD5('1234'), 16))::bigint
@xiangjinwu xiangjinwu self-assigned this Jul 4, 2024
@github-actions github-actions bot added this to the release-1.10 milestone Jul 4, 2024
@xiangjinwu xiangjinwu modified the milestones: release-1.10, release-1.11 Jul 10, 2024
@xiangjinwu xiangjinwu modified the milestones: release-2.1, release-2.2 Oct 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@xiangjinwu xiangjinwu

Labels
type/feature
Projects
None yet
Milestone
release-2.2
Development

No branches or pull requests
1 participant
@xiangjinwu