Skip to content

Conversation

@AbhishekASLK
Copy link
Contributor

This PR fixes the parsing error for USING keyword in oracle dialect

SQL:

SELECT CHR(187 USING NCHAR_CS)

Documentation

@AbhishekASLK AbhishekASLK changed the title fix(oracle)!: using keyword in chr fix(oracle)!: USING keyword in chr Dec 28, 2025
Copy link
Collaborator

@VaggelisD VaggelisD left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Hey @AbhishekASLK, looks like MySQL also supports this function and SQLGlot already has support for it.

Check out mysql.py for how exp.Chr is handled in FUNCTION_PARSERS and chr_sql, we can probably move both of these to the base dialect to solve Oracle too.

@AbhishekASLK
Copy link
Contributor Author

Hey @AbhishekASLK, looks like MySQL also supports this function and SQLGlot already has support for it.

Check out mysql.py for how exp.Chr is handled in FUNCTION_PARSERS and chr_sql, we can probably move both of these to the base dialect to solve Oracle too.

Sure, will look into this shortly.

@VaggelisD VaggelisD merged commit 2bf9405 into tobymao:main Dec 30, 2025
9 checks passed
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