Skip to content

ISSUES-117 support temporary table management#1824

Merged
alexey-milovidov merged 11 commits intoClickHouse:masterfrom
zhang2014:fix/ISSUES-117
Feb 8, 2018
Merged

ISSUES-117 support temporary table management#1824
alexey-milovidov merged 11 commits intoClickHouse:masterfrom
zhang2014:fix/ISSUES-117

Conversation

@zhang2014
Copy link
Copy Markdown
Contributor

@zhang2014 zhang2014 changed the title [WIP]ISSUES-117 support temporary table management [WIP] ISSUES-117 support temporary table management Jan 25, 2018
@zhang2014 zhang2014 force-pushed the fix/ISSUES-117 branch 3 times, most recently from b9340f0 to 1070e46 Compare January 27, 2018 16:03
@zhang2014 zhang2014 changed the title [WIP] ISSUES-117 support temporary table management ISSUES-117 support temporary table management Jan 31, 2018
Copy link
Copy Markdown
Contributor

@ludv1x ludv1x Feb 2, 2018

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Style:

}
else
{
    ...
}

Copy link
Copy Markdown
Contributor

@ludv1x ludv1x Feb 2, 2018

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Just column->insertDefault() `column->insert(String{})

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Is the new syntax backwards-compatible with the previous one?

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Camel case (externalTables) is used only for function names.

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

You could also put column temporary into the block.
It allows excluding the temporary database in case of WHERE temporary != 0

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Style

@zhang2014 zhang2014 force-pushed the fix/ISSUES-117 branch 3 times, most recently from 3c4987f to 02afa74 Compare February 2, 2018 13:26
Copy link
Copy Markdown
Contributor

@ludv1x ludv1x Feb 2, 2018

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Could you add an error code?
I would suggest ErrorCodes::SYNTAX_ERROR, but I am not sure it is a syntax error, it is some kind of user error, and the check should be done in the interpreter.

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Could you add the full syntax with NOT LIKE ...

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

IMHO it is better to use for-range loop

@zhang2014 zhang2014 force-pushed the fix/ISSUES-117 branch 2 times, most recently from a9d6e66 to 2c3451b Compare February 2, 2018 14:53
@alexey-milovidov alexey-milovidov merged commit d6b7233 into ClickHouse:master Feb 8, 2018
alexey-milovidov added a commit that referenced this pull request Feb 8, 2018
@zhang2014 zhang2014 deleted the fix/ISSUES-117 branch February 14, 2018 04:01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Temporary table management

3 participants