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] fix "could not identify an ordering operator for type hstore" #10441

Open
jaki opened this issue Oct 29, 2021 · 1 comment
Open

[YSQL] fix "could not identify an ordering operator for type hstore" #10441

jaki opened this issue Oct 29, 2021 · 1 comment
Assignees
@m-iancu
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@jaki
Copy link
Contributor

jaki commented Oct 29, 2021 •
edited by yugabyte-ci
Loading

Jira Link: DB-1281

Description

The following fails in YB but not PG:

CREATE EXTENSION hstore;
CREATE TEMP TABLE testhstore (h hstore);
select count(distinct h) from testhstore;

YB shows

ERROR:  could not identify an ordering operator for type hstore
LINE 1: select count(distinct h) from testhstore;

PG succeeds and return 0 rows.

This example is taken from src/postgres/contrib/hstore/sql/yb_pg_hstore.sql. Adding a gin index doesn't make a difference.
@jaki jaki added kind/bug This issue is a bug area/ysql Yugabyte SQL (YSQL) labels Oct 29, 2021
@jaki
Copy link
Contributor Author

jaki commented Oct 29, 2021

possibly related to issue #3628

@m-iancu m-iancu added this to YQL-beta Dec 3, 2021
jasonyb pushed a commit that referenced this issue Dec 4, 2021
@jaki
[#9956] ysql: support ybgin index in hstore extension
0130ddc 
Summary:
Add an update script to the hstore extension to support it on ybgin
indexes.  Name the version 1.5-yb-1.0 following this format:
<previous_pg_version>-yb-<yb_version>.sql.

Port the rest of the GIN section of the hstore regress test to
yb_pg_hstore.  Note some differences:

- ERROR on scan that uses more than one required scan entry
- ERROR on ordering operator (issue #10441)

Close: #9956

Test Plan:
    ./yb_build.sh --java-test TestPgRegressContribHstore

Reviewers: rskannan, mihnea

Reviewed By: mihnea

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D12576
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@m-iancu m-iancu

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
YQL-beta
Status: No status
Milestone
No milestone
Development

No branches or pull requests
4 participants
@m-iancu @sushantrmishra @jaki @yugabyte-ci