Skip to content

Conversation

manticore-projects
Copy link
Contributor

@manticore-projects manticore-projects commented Nov 28, 2022

  1. Clickhouse global join

  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;
  3. Support SET statement with UserVariable

    set @Flag = 1
  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

Make `If... Else...` statements work with Blocks
Make `Statement()` production work with `Block()`
Rewrite the `Block()` related Unit Tests

fixes JSQLParser#1682
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
Replaces PR JSQLParser#1415, all credit goes to @s13o
Re-arranged some recently added Tokens in alphabetical order
Update Keywords
Make JSonExpression accept Expressions
Add Testcase
Expose Idents() and Operators()
Fixes JSQLParser#1696
@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
Labels
None yet
Projects
None yet
2 participants