Skip to content

sql: add indnullsnotdistinct column to pg_catalog.pg_index#93933

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
e-mbrown:eb/pgindex
Dec 20, 2022
Merged

sql: add indnullsnotdistinct column to pg_catalog.pg_index#93933
craig[bot] merged 1 commit intocockroachdb:masterfrom
e-mbrown:eb/pgindex

Conversation

@e-mbrown
Copy link
Copy Markdown
Contributor

@e-mbrown e-mbrown commented Dec 19, 2022

Epic: CRDB-23454
Fixes: #92583

This commit indnullsnotdistinct column to pg_index. Since we do not support NULLS [ NOT ] DISTINCT on CREATE INDEX the column is also false.

Release note: None

@e-mbrown e-mbrown requested a review from a team December 19, 2022 19:52
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Collaborator

@rafiss rafiss left a comment

Choose a reason for hiding this comment

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

lgtm, once CI is passing

Copy link
Copy Markdown
Collaborator

@rafiss rafiss left a comment

Choose a reason for hiding this comment

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

Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @e-mbrown)


pkg/sql/pg_catalog.go line 1918 at r1 (raw file):

						tree.NewDInt(tree.DInt(indnatts)),            // indnatts
						tree.MakeDBool(tree.DBool(index.IsUnique())), // indisunique
						tree.DBoolFalse,                              //indnullsnotdistinct

nit: add a space after //

This commit `indnullsnotdistinct` column to pg_index.
Since we do not support `NULLS [ NOT ] DISTINCT` on
`CREATE INDEX` the column is also false.

Release note: None
@e-mbrown
Copy link
Copy Markdown
Contributor Author

TFTR!

bors r=rafiss

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Dec 20, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Dec 20, 2022

Build succeeded:

@craig craig bot merged commit 8cca165 into cockroachdb:master Dec 20, 2022
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.

sql: support indnullsnotdistinct column in pg_catalog.pg_index

3 participants