INCLUDING COMPRESSION

Started by Fujii Masaoabout 5 years ago6 messageshackersdocs
Jump to latest
#1Fujii Masao
masao.fujii@gmail.com
hackersdocs

The syntax for like_option in CREATE TABLE docs seems to forget to mention
INCLUDING COMPRESSION option. I think the following fix is necessary.
Patch attached.

-{ INCLUDING | EXCLUDING } { COMMENTS | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }
+{ INCLUDING | EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Attachments:

fix_create_table_doc.patchtext/plain; charset=UTF-8; name=fix_create_table_doc.patch; x-mac-creator=0; x-mac-type=0Download+1-1
#2Michael Paquier
michael@paquier.xyz
In reply to: Fujii Masao (#1)
hackersdocs
Re: INCLUDING COMPRESSION

On Wed, Apr 14, 2021 at 11:46:58PM +0900, Fujii Masao wrote:

The syntax for like_option in CREATE TABLE docs seems to forget to mention
INCLUDING COMPRESSION option. I think the following fix is necessary.
Patch attached.

-{ INCLUDING | EXCLUDING } { COMMENTS | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }
+{ INCLUDING | EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }

Indeed. May I ask at the same time why gram.y (TableLikeOption) and
parsenodes.h (CREATE_TABLE_LIKE_COMPRESSION) don't classify this new
option in alphabetical order with the rest? Ordering them makes
easier a review of them.
--
Michael

#3Fujii Masao
masao.fujii@gmail.com
In reply to: Michael Paquier (#2)
hackersdocs
Re: INCLUDING COMPRESSION

On 2021/04/15 11:54, Michael Paquier wrote:

On Wed, Apr 14, 2021 at 11:46:58PM +0900, Fujii Masao wrote:

The syntax for like_option in CREATE TABLE docs seems to forget to mention
INCLUDING COMPRESSION option. I think the following fix is necessary.
Patch attached.

-{ INCLUDING | EXCLUDING } { COMMENTS | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }
+{ INCLUDING | EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }

Indeed.

Thanks! Pushed.

May I ask at the same time why gram.y (TableLikeOption) and
parsenodes.h (CREATE_TABLE_LIKE_COMPRESSION) don't classify this new
option in alphabetical order with the rest? Ordering them makes
easier a review of them.

I'm not sure why. But +1 to make them in alphabetical order.
Patch attached.

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Attachments:

including_compression_order.patchtext/plain; charset=UTF-8; name=including_compression_order.patch; x-mac-creator=0; x-mac-type=0Download+9-9
#4Michael Paquier
michael@paquier.xyz
In reply to: Fujii Masao (#3)
hackersdocs
Re: INCLUDING COMPRESSION

On Thu, Apr 15, 2021 at 11:24:07PM +0900, Fujii Masao wrote:

I'm not sure why. But +1 to make them in alphabetical order.
Patch attached.

LGTM.
--
Michael

#5Justin Pryzby
pryzby@telsasoft.com
In reply to: Fujii Masao (#3)
hackersdocs
Re: INCLUDING COMPRESSION (sort enum fields)

(moved to -hackers)

/messages/by-id/54d30e66-dbd6-5485-aaf6-a291ed55919d@oss.nttdata.com

On Thu, Apr 15, 2021 at 11:24:07PM +0900, Fujii Masao wrote:

On 2021/04/15 11:54, Michael Paquier wrote:

May I ask at the same time why gram.y (TableLikeOption) and
parsenodes.h (CREATE_TABLE_LIKE_COMPRESSION) don't classify this new
option in alphabetical order with the rest? Ordering them makes
easier a review of them.

I'm not sure why. But +1 to make them in alphabetical order.
Patch attached.

+1 to your patch

--
Justin

Attachments:

including_compression_order.patchtext/x-diff; charset=us-asciiDownload+9-9
#6Fujii Masao
masao.fujii@gmail.com
In reply to: Michael Paquier (#4)
hackersdocs
Re: INCLUDING COMPRESSION

On 2021/04/16 10:20, Michael Paquier wrote:

On Thu, Apr 15, 2021 at 11:24:07PM +0900, Fujii Masao wrote:

I'm not sure why. But +1 to make them in alphabetical order.
Patch attached.

LGTM.

Pushed. Thanks!

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION