Skip to content

Support enum_code() function #5408

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
Merged
merged 2 commits into from
Nov 21, 2022
Merged

Support enum_code() function #5408

merged 2 commits into from
Nov 21, 2022
+90 −0

Conversation

lokax
Copy link
Contributor

@lokax lokax commented Nov 18, 2022

Closes #5395

@Tishj
Copy link
Contributor

Tishj commented Nov 18, 2022

Could we add a test that uses this function in a prepared statement?

@Tishj
Copy link
Contributor

Tishj commented Nov 19, 2022

I suspected

statement ok
PREPARE p1 as SELECT enum_code(?) FROM test

query I
EXECUTE p1('sad'::mood)
----
0
0
0
0

wouldn't work, but I stand corrected 👍

@Mytherin Mytherin changed the base branch from master to feature November 19, 2022 15:45
@Mytherin Mytherin merged commit 170eef9 into duckdb:feature Nov 21, 2022
@Mytherin
Copy link
Collaborator

Thanks for the PR! LGTM

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Feature request: retrieve integer index values from an ENUM column using SQL
3 participants
@lokax @Tishj @Mytherin