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 — Assorted Fixes #4 by manticore-projects · Pull Request #1676 · JSQLParser/JSqlParser

Conversation

@manticore-projects

@manticore-projects manticore-projects commented Nov 28, 2022 •
edited
Loading

Uh oh!

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

Copy link
Copy Markdown
Contributor
  1. Clickhouse global join

    • Replaces PR support clickhouse global keyword in join #1615
    • Fixes I use it to analyze clickhouse sql,But there is a problem,Can you show me #1535
    • All credits to @julianzlzhang, I just fixed the code style.
  2. Support IF... ELSE... statements with Block()

    if (a=b) begin
    update table1 set a = 'xx' where b = 'condition1';
    update table1 set a = 'xx' where b = 'condition2';
    end;
    else begin
    update table1 set a = 'xx' where b = 'condition1';
    update table1 set a = 'xx' where b = 'condition2';
    end;
    • Fixes Some SQL server syntax does not support parsing #1682 / 1
  3. Support SET statement with UserVariable

    set @Flag = 1
    • Fixes Some SQL server syntax does not support parsing #1682 / 2
    • Fixes Parsing "@@" throws exception #1237
  4. Google Spanner Support
    Replaces PR Google Spanner support #1415, all credit goes to @s13o
    Re-arranged some recently added Tokens in alphabetical order
    Update Keywords

  5. Amend JSONExpression and make it accept Expression beyond Column only

    SELECT '{"key": "value"}'::json -> 'key' AS X
    • Fixes PostgreSQL JSON arrow operators #1696

Sorry, something went wrong.

Uh oh!

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

All reactions
Zhang Zhongliang and others added 9 commits August 16, 2022 16:43
Zhang Zhongliang
support clickhouse global keyword in join
35ebbc5
@manticore-projects
fix: add missing public Getter
09c2fb7
Add public Getter for `updateSets`
Fixes JSQLParser#1630
@manticore-projects
Merge branch 'master' of github.com:JSQLParser/JSqlParser
5ecd039
@manticore-projects
Merge branch 'master' of github.com:JSQLParser/JSqlParser
05a02eb
@manticore-projects
Merge github.com:JSQLParser/JSqlParser
d5d6e3a
@manticore-projects
Merge github.com:JSQLParser/JSqlParser
9dfd527
@manticore-projects
Merge https://github.com/JSQLParser/JSqlParser
065a2f4
@manticore-projects
Merge branch 'clickhouse_globaljoin' of github.com:julianzlzhang/JSql…
29435de
…Parser into ClickhouseGlobalJoin
@manticore-projects
feat: Clickhouse GLOBAL JOIN
7086f18
All credits to @julianzlzhang

fixes JSQLParser#1615
fixes JSQLParser#1535
@manticore-projects manticore-projects mentioned this pull request Nov 28, 2022
support clickhouse global keyword in join #1615
Closed
manticore-projects added 3 commits December 9, 2022 13:42
@manticore-projects
feat: IF/ELSE statements supports Block
f9eee97
Make `If... Else...` statements work with Blocks
Make `Statement()` production work with `Block()`
Rewrite the `Block()` related Unit Tests

fixes JSQLParser#1682
@manticore-projects
fix: Revert unintended changes to the Special Oracle Tests
c125fbf
@manticore-projects
fix: SET statement supports UserVariable
42b429f
Make `SetStatement` parse Objects instead of Names only
Add Grammar to accept `UserVariable` (e.g. "set @Flag = 1")
Add Test Case for `UserVariable`

fixes JSQLParser#1682
@manticore-projects manticore-projects changed the title Clickhouse global join Assorted Fixes #4 Dec 9, 2022
@manticore-projects
feat: Google Spanner Support
b4eb8d8
Replaces PR JSQLParser#1415, all credit goes to @s13o
Re-arranged some recently added Tokens in alphabetical order
Update Keywords
@manticore-projects manticore-projects mentioned this pull request Dec 9, 2022
Google Spanner support #1415
Closed
@manticore-projects
fix: fix JSonExpression, accept Expressions
1ce014a
Make JSonExpression accept Expressions
Add Testcase
Expose Idents() and Operators()
Fixes JSQLParser#1696
@manticore-projects manticore-projects mentioned this pull request Dec 16, 2022
PostgreSQL JSON arrow operators #1696
Closed
@manticore-projects
test: add Test for Issue JSQLParser#1237
19572da
@wumpz
wumpz merged commit 8d9db70 into JSQLParser:master Dec 22, 2022
@manticore-projects
manticore-projects deleted the ClickhouseGlobalJoin branch March 7, 2023 00:40
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

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.

PostgreSQL JSON arrow operators Some SQL server syntax does not support parsing I use it to analyze clickhouse sql,But there is a problem,Can you show me Parsing "@@" throws exception

Uh oh!

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

2 participants

@manticore-projects @wumpz
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.