The Wayback Machine - https://web.archive.org/web/20220211070920/https://github.com/JSQLParser/JSqlParser/issues/1245
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

Jump to bottom

To Do List: Missing Oracle specific statements #1245

Open
manticore-projects opened this issue Jun 28, 2021 · 4 comments
Open

To Do List: Missing Oracle specific statements #1245

manticore-projects opened this issue Jun 28, 2021 · 4 comments
Assignees
@manticore-projects
Labels
improvement

Comments

@manticore-projects
Copy link
Contributor

@manticore-projects manticore-projects commented Jun 28, 2021 •
edited

This is just a reminder for myself, so far I found the following Oracle specific statements missing:

  • ALTER SYSTEM Fixed by PR #1288
  • RENAME table TO ... Fixed by PR #1286
  • PURGE ... Fixed by PR #1287
  • ALTER TABLE ... DROP for multiple columns fixed by PR #1379
  • ALTER TABLE ... ADD for multiple columns fixed, it is working in JSQLFormatter
  • INSERT for multiple values
  • ALTER TABLE ... MOVE TABLESPACE ... fixed by PR #1293

Please feel free to add to the list. I would want to implement these statements eventually.
@AnEmortalKid
Copy link
Contributor

@AnEmortalKid AnEmortalKid commented Jul 1, 2021

More oracle things missing as far as I remember: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm

@wumpz
Copy link
Member

@wumpz wumpz commented Jul 16, 2021

For sure. And from I think nearly 300 test sqls at the moment 172 are parsed successfully. Look into SelectOracleTest.

@manticore-projects
Copy link
Contributor Author

@manticore-projects manticore-projects commented Jul 25, 2021

More oracle things missing as far as I remember: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm

Greetings, please clarify because I think that Hierarchical Queries have been implemented yet and I also have added support for CONNECT_BY_ROOT via PR #1282. What is left open please?

@manticore-projects
Copy link
Contributor Author

@manticore-projects manticore-projects commented Jul 25, 2021

For sure. And from I think nearly 300 test sqls at the moment 172 are parsed successfully. Look into SelectOracleTest.

Good chunk from the failing tests is about Oracle's MultiInsert. How do you want me to approach this:
a) refactor and amend the existing Insert or
b) provide a new MultiInsert instead (including the standard compliant multiple VALUES syntax)

At the moment I tend to go route b) but am a kind of undecided. Please advise.

@manticore-projects manticore-projects self-assigned this Jul 26, 2021
@manticore-projects manticore-projects mentioned this issue Jul 26, 2021
Closed
@manticore-projects manticore-projects mentioned this issue Oct 11, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@manticore-projects manticore-projects

Labels
improvement
Projects
None yet
Milestone
No milestone
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
@wumpz @AnEmortalKid @manticore-projects