GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Oracle Alternative Quoting by manticore-projects · Pull Request #1722 · JSQLParser/JSqlParser

Conversation

@manticore-projects

@manticore-projects manticore-projects commented Jan 29, 2023 •
edited
Loading

Uh oh!

There was an error while loading. Please reload this page.

Copy link
Copy Markdown
Contributor
  1. feat: Oracle Alternative Quoting
  • add support for Oracle Alternative Quoting e.g. q'(...)'
  • fixes Oracle - Alternative Quoting Mechanism (''Q'') for String Literals - parsing error #1718
  • add a Logo and FavIcon to the Website
  • document recent changes on Quoting/Escaping
  • add an example on building SQL from Java
  • rework the README.md, promote the Website
  • add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)

Please preview https://manticore-projects.github.io/JSqlParser/index.html and https://github.com/manticore-projects/JSqlParser#readme

  1. Merge PR Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH #1691, all credits to @zaza
  • remove the unnecessary Reserved Keywords, which would break some standard tests
  1. Add alternative Statement Separators GO, Slash / and 2 Empty New Lines

    SELECT * FROM dual
    
    SELECT * FROM dual
    /
    
    SELECT * FROM dual
    go

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

All reactions
zaza and others added 20 commits December 11, 2022 21:03
@zaza
Fixes JSQLParser#1684: Support CREATE MATERIALIZED VIEW with AUTO REF…
747152a
…RESH

Support parsing create view statements in Redshift with AUTO REFRESH
option.
@zaza
Merge branch 'master' into 1684-create-mv-auto-refresh
9e09005
@zaza
Reduce cyclomatic complexity in CreateView.toString
ea4477b
Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.
@manticore-projects
Enhanced Keywords
b5321d6
Add Keywords and document, which keywords are allowed for what purpose
@manticore-projects
Fix incorrect tests
5fae2f5
@manticore-projects
Define Reserved Keywords explicitly
f49e828
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
@manticore-projects
Fix test resources
86f337d
@manticore-projects
Adjust Gradle to JUnit 5
2d51a82
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
@manticore-projects
Do not mark SpeedTest for concurrent execution
232aff6
@manticore-projects
Remove unused imports
3ba5410
@manticore-projects
Adjust Gradle to JUnit 5
e960a35
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
@manticore-projects
Do not mark SpeedTest for concurrent execution
67f7951
@manticore-projects
Remove unused imports
a016be0
@manticore-projects
Sphinx Documentation
2ef6637
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
@manticore-projects
doc: request for Conventional Commit messages
57193b8
@manticore-projects
feat: make important Classes Serializable
b94b2cc
Implement Serializable for persisting via ObjectOutputStream
@manticore-projects
chore: Make Serializable
02202c5
@manticore-projects
doc: Better integration of the RR diagrams
a3ca325
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
@manticore-projects
Merge
fcb5ab1
@manticore-projects
feat: Oracle Alternative Quoting
c57c427
- add support for Oracle Alternative Quoting e.g. `q'(...)'`
- fixes JSQLParser#1718
- add a Logo and FavIcon to the Website
- document recent changes on Quoting/Escaping
- add an example on building SQL from Java
- rework the README.md, promote the Website
- add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)
@manticore-projects manticore-projects mentioned this pull request Jan 29, 2023
Oracle - Alternative Quoting Mechanism (''Q'') for String Literals - parsing error #1718
Closed
@manticore-projects
style: Appease PMD/Codacy
2aec1f6
@manticore-projects
manticore-projects force-pushed the master branch from 86ec07c to 2aec1f6 Compare January 29, 2023 07:11
@manticore-projects

manticore-projects commented Jan 29, 2023

Copy link
Copy Markdown
Contributor Author

Please also update the "Project About" part and link to the Website (instead to the Wiki).

image

All reactions

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

@manticore-projects
feat: CREATE VIEW ... REFRESH AUTO...
1c8d8da
- Merge PR JSQLParser#1691, fixes JSQLParser#1684
    all credits go to @zaza
@manticore-projects manticore-projects mentioned this pull request Jan 30, 2023
Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH #1691
Closed
wumpz
wumpz reviewed Jan 31, 2023
View reviewed changes
Comment thread pom.xml Resolved

Uh oh!

There was an error while loading. Please reload this page.

manticore-projects added 3 commits February 1, 2023 08:11
@manticore-projects
doc: fix the issue template
b707b23
- fix the issue template
- fix the -SNAPSHOT version number
@manticore-projects
Update issue templates
46314c4
@manticore-projects
Update issue templates
4aeafbc
@manticore-projects
feat: Support more Statement Separators
b081484
- `GO`
- Slash `/`
- Two empty lines
@wumpz
wumpz merged commit e71e57d into JSQLParser:master Feb 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@wumpz wumpz wumpz left review comments

Uh oh!

There was an error while loading. Please reload this page.

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Oracle - Alternative Quoting Mechanism (''Q'') for String Literals - parsing error

Uh oh!

There was an error while loading. Please reload this page.

3 participants

@manticore-projects @wumpz @zaza
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.