Skip to content

Mysql: FROM_UNIXTIME() #655

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

Closed
markschmid opened this issue Aug 6, 2020 · 2 comments
Closed

Mysql: FROM_UNIXTIME() #655

markschmid opened this issue Aug 6, 2020 · 2 comments
Labels
📚 mysql enhancement New feature or request
Milestone

Comments

@markschmid
Copy link

The following should be supported:

Schema:

create table `test` (
  `ts` datetime
);

Query:

insert into test (
  ts
) values (
  from_unixtime(?)
);

Output new parser:
2020/08/06 14:23:32 unknown MySQL type: any

@kyleconroy kyleconroy added 📚 mysql enhancement New feature or request labels Aug 6, 2020
@kyleconroy
Copy link
Collaborator

While we can add one-off function definitions, the plan is to solve this via #657. I have working code (from #550) that generates function definitions for PostgreSQL.

@kyleconroy
Copy link
Collaborator

Closed in favor of #657

kyleconroy added a commit that referenced this issue Nov 19, 2020
kyleconroy added a commit that referenced this issue Nov 19, 2020
kyleconroy added a commit that referenced this issue Nov 21, 2020
kyleconroy added a commit that referenced this issue Nov 22, 2020
kyleconroy added a commit that referenced this issue Nov 22, 2020
* dolphin: Add a subset of math func signatures

* dolphin: Add FROM_UNIXTIME signature

Fixes #655

* dolphin: flow control function signatures

* dolphin: Add ISNULL function signature

Fixes #630

* dolphin: Add STRCMP function signature

* dolphin: Add aggregate function signatures

* dolphin: Add all JSON function signatures

* dolphin: Add signatures for mathematical functions

* dolphin: Add string function signatures

* dolphin: Add date and time function signatures

* dolphin: Add comparison operator function signatures

* dolphin: Add encryption function signatures

* dolphin: Add miscellaneous function signatures

* dolphin: Add information function signatures

* dolphin: Add window function signatures

* dolphin: Add performance schema function signatures

* dolphin: Add locking function signatures

* dolphin: Add regexp function signatures

* dolphin: Add XML function signatures

* dolphin: Add GTID function signatures

* dolphin: Add a few more function signatures

* dolphin: Add spatial analysis function signatures

* dolphin: Remove two unknown functions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
📚 mysql enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants