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

"Customly parsed" SQL functions #3

Closed
sbuberl opened this issue Aug 11, 2015 · 3 comments
Closed

"Customly parsed" SQL functions #3

sbuberl opened this issue Aug 11, 2015 · 3 comments
Assignees
Projects
Milestone

Comments

@sbuberl
Copy link
Owner

sbuberl commented Aug 11, 2015

Some SQL standard functions have special syntax to their parameters rather just comma separated. For example:

TRIM(LEADING 'x' FROM 'xxxbarxxx')
EXTRACT(YEAR_MONTH FROM '2009-07-02 01:02:03')

I did this before in the 1.4 rewrite branch. Just need to port them over.

@sbuberl
Copy link
Owner Author

sbuberl commented Aug 24, 2015

Ported over most of the ones I did before. Added extract, overlay, position, and trim. And changed substring() to use standard syntax.

Only one I added before that is not ported is CAST() which I treat as function to simplify parsing. Will add CAST and see if any more I should add.

@sbuberl sbuberl self-assigned this Aug 23, 2017
@sbuberl
Copy link
Owner Author

sbuberl commented Aug 25, 2017

Basic version of CAST added which will expand after more stuff is added in future. Started adding some unit tests for this which I will finish before I close this out.

@sbuberl
Copy link
Owner Author

sbuberl commented Aug 26, 2017

Done adding unit tests for all the functions. This is complete.

@sbuberl sbuberl closed this as completed Aug 26, 2017
@sbuberl sbuberl added this to the 1.4 milestone Aug 28, 2017
@sbuberl sbuberl added this to Done in 1.4 Sep 19, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
1.4
  
Done
Development

No branches or pull requests

1 participant