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

[SQL] Support MySQL CAST_DATETIME function. #568

Closed
Tracked by #454
dongzl opened this issue Dec 7, 2022 · 0 comments
Closed
Tracked by #454

[SQL] Support MySQL CAST_DATETIME function. #568

dongzl opened this issue Dec 7, 2022 · 0 comments
Assignees
@csynineyang
Labels
SQL SQL support
Milestone
0.2.0

Comments

@dongzl
Copy link
Contributor

dongzl commented Dec 7, 2022 •
edited
Loading

What would you like to be added:

Why is this needed:

ref #459

official document:
https://dev.mysql.com/doc/refman/5.6/en/cast-functions.html#function_cast

reference code:

https://github.com/arana-db/arana/tree/master/pkg/runtime/function2/abs.go
@dongzl dongzl mentioned this issue Dec 7, 2022
Closed
43 tasks
@dongzl dongzl changed the title CAST_DATETIME [SQL] Support MySQL CAST_DATETIME function. Dec 7, 2022
@dongzl dongzl added the SQL SQL support label Dec 7, 2022
@dongzl dongzl added this to the 0.2.0 milestone Dec 7, 2022
@dongzl dongzl mentioned this issue Dec 31, 2022
Closed
@dongzl dongzl mentioned this issue Jan 17, 2023
Merged
jjeffcaii pushed a commit that referenced this issue Feb 9, 2023
@csynineyang
feat: support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function (#606)
ac942f6 
* add node config support (#464)

* Support MySQL CAST_CHAR function.

* format style

* Support MySQL CAST_TIME function. (#570)

* Support MySQL CAST_DATE function. (#569)

* Support MySQL CAST_DATETIME function. (#568)

* Support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function

* Resolve Conversation
@dongzl dongzl closed this as completed Feb 11, 2023
GavinLam164 pushed a commit to GavinLam164/arana that referenced this issue Feb 25, 2023
@csynineyang
feat: support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function (arana…
7876dbe 
…-db#606)

* add node config support (arana-db#464)

* Support MySQL CAST_CHAR function.

* format style

* Support MySQL CAST_TIME function. (arana-db#570)

* Support MySQL CAST_DATE function. (arana-db#569)

* Support MySQL CAST_DATETIME function. (arana-db#568)

* Support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function

* Resolve Conversation
AlexStocks pushed a commit that referenced this issue Apr 18, 2023
@csynineyang
Support create table SQL statement (#424) (#653)
a00866f 
* add node config support (#464)

* Support MySQL CAST_CHAR function.

* format style

* Support MySQL CAST_TIME function. (#570)

* Support MySQL CAST_DATE function. (#569)

* Support MySQL CAST_DATETIME function. (#568)

* Support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function

* Resolve Conversation

* Support CREATE TABLE

* add: IfNotExists

* fix: reformat imports

* Resolve Conversation
AlexStocks pushed a commit that referenced this issue Jun 18, 2023
@csynineyang
[SQL] Support MySQL window function. (#688)
c696476 
* add node config support (#464)

* Support MySQL CAST_CHAR function.

* format style

* Support MySQL CAST_TIME function. (#570)

* Support MySQL CAST_DATE function. (#569)

* Support MySQL CAST_DATETIME function. (#568)

* Support MySQL CAST_TIME/CAST_DATE/CAST_DATETIME function

* Resolve Conversation

* Support CREATE TABLE

* add: IfNotExists

* fix: reformat imports

* Resolve Conversation

* Support window function: CUME_DIST

* Support window function: PERCENT_RANK

* Support window function: RANK

* Support window function: DENSE_RANK

* Support window function: FIRST_VALUE/LAST_VALUE/LAG/LEAD

* Support window function: NTH_VALUE/NTILE/ROW_NUMBER

* support argument(n) in LAG/LEAD

* convert Int64 to Float64 in test case
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@csynineyang csynineyang

Labels
SQL SQL support
Projects
None yet
Milestone
0.2.0
Development

No branches or pull requests
2 participants
@dongzl @csynineyang