[
https://issues.apache.org/jira/browse/IGNITE-17121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Lapin updated IGNITE-17121:
-------------------------------------
Description:
Let's say there's a table created with
{code:java}
CREATE TABLE t ... WITH A=X, B=Y;{code}
It's suggested to introduce predefined DEFAULT key word as a specific
with-property value in order to reset such property to default. PostgeSQL use
same [approach|https://www.postgresql.org/docs/current/sql-altersystem.html]
So in order to reset B in example above following should be used:
{code:java}
ALTER TABLE t WITH B=DEFAULT;{code}
> Expand sql WITH syntax with abitliy of resetting specific values to deault
> --------------------------------------------------------------------------
>
> Key: IGNITE-17121
> URL: https://issues.apache.org/jira/browse/IGNITE-17121
> Project: Ignite
> Issue Type: Task
> Reporter: Alexander Lapin
> Priority: Major
> Labels: ignite-3
>
> Let's say there's a table created with
> {code:java}
> CREATE TABLE t ... WITH A=X, B=Y;{code}
> It's suggested to introduce predefined DEFAULT key word as a specific
> with-property value in order to reset such property to default. PostgeSQL use
> same [approach|https://www.postgresql.org/docs/current/sql-altersystem.html]
> So in order to reset B in example above following should be used:
> {code:java}
> ALTER TABLE t WITH B=DEFAULT;{code}
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
