Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ysql: support gin index on temp table #8386

Closed
jaki opened this issue May 10, 2021 · 0 comments
Closed

ysql: support gin index on temp table #8386

jaki opened this issue May 10, 2021 · 0 comments
Assignees
@jaki
Labels
area/ysql Yugabyte SQL (YSQL) kind/new-feature This is a request for a completely new feature

Comments

@jaki
Copy link
Contributor

jaki commented May 10, 2021

Support

CREATE TEMP TABLE t (a int[]);
CREATE INDEX ON t USING gin (a);

and other variants. This should be easy since it uses postgres storage.

Related: #7850
@jaki jaki added kind/new-feature This is a request for a completely new feature area/ysql Yugabyte SQL (YSQL) labels May 10, 2021
@jaki jaki self-assigned this May 10, 2021
@jaki jaki closed this as completed in 3111014 May 12, 2021
YintongMa pushed a commit to YintongMa/yugabyte-db that referenced this issue May 26, 2021
@jaki @YintongMa
[yugabyte#8386] ysql: support GIN on temp tables
8018b97 
Summary:
To unblock temporary gin index scan, remove error on comparing ctid.
The error was likely added for safety purposes in the early days of
YSQL.  Since the error message doesn't show up in GitHub issues, it
likely never really gets hit, so it's probably safe to remove it.

Close: yugabyte#8386

Test Plan:
    ./yb_build.sh --java-test org.yb.pgsql.TestPgRegressGin

Reviewers: mihnea

Reviewed By: mihnea

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D11221
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jaki jaki

Labels
area/ysql Yugabyte SQL (YSQL) kind/new-feature This is a request for a completely new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jaki