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.

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

[YSQL] Feature Support - CREATE/DROP AGGREGATE, CAST, OPERATOR, OPERATOR CLASS, RULE #1981

Closed
jaki opened this issue Aug 6, 2019 · 2 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL)
Projects
Milestone

Comments

@jaki
Copy link
Contributor

jaki commented Aug 6, 2019

CREATE AGGREGATE, CREATE CAST, CREATE OPERATOR, CREATE OPERATOR CLASS, and CREATE RULE statements are not yet supported. Same with DROP AGGREGATE, DROP CAST, DROP OPERATOR, DROP OPERATOR CLASS, and DROP RULE statements.

@jaki jaki added the area/ysql Yugabyte SQL (YSQL) label Aug 6, 2019
@jaki jaki added this to To do in YSQL via automation Aug 6, 2019
@jaki jaki changed the title [YSQL] Feature Support - CREATE CAST, CREATE OPERATOR, CREATE RULE [YSQL] Feature Support - CREATE AGGREGATE, CAST, OPERATOR, RULE Aug 6, 2019
@jaki jaki self-assigned this Aug 6, 2019
@jaki jaki changed the title [YSQL] Feature Support - CREATE AGGREGATE, CAST, OPERATOR, RULE [YSQL] Feature Support - CREATE AGGREGATE, CAST, OPERATOR, OPERATOR CLASS, RULE Aug 7, 2019
@jaki jaki moved this from To do to In progress in YSQL Aug 27, 2019
@jaki jaki changed the title [YSQL] Feature Support - CREATE AGGREGATE, CAST, OPERATOR, OPERATOR CLASS, RULE [YSQL] Feature Support - CREATE/DROP AGGREGATE, CAST, OPERATOR, OPERATOR CLASS, RULE Aug 27, 2019
@jaki
Copy link
Contributor Author

jaki commented Aug 27, 2019

Precedes issue #2172.

@jaki jaki moved this from In progress to To do in YSQL Aug 28, 2019
@jaki jaki moved this from To do to In progress in YSQL Sep 4, 2019
@jaki jaki added this to the v2.0 milestone Sep 11, 2019
jaki pushed a commit that referenced this issue Sep 12, 2019
…RULE

Summary:
Enable `CREATE AGGREGATE`, `CREATE CAST`, `CREATE OPERATOR`, `CREATE
RULE`, `DROP AGGREGATE`, `DROP CAST`, `DROP OPERATOR`, `DROP RULE` as
Postgres features.  Enable `CREATE OPERATOR CLASS`, `DROP OPERATOR
CLASS` as Postgres beta features.  Update some, but not all,
corresponding Postgres regress tests.  This revision closes issue #1981.

Test Plan:
* `yb_pg_create_aggregate`, `yb_pg_errors`, `yb_pg_privileges` regress
  tests for `CREATE/DROP AGGREGATE`
* `yb_pg_create_cast`, `yb_pg_plpgsql`, `yb_pg_privileges` regress tests
  for `CREATE/DROP CAST`
* `yb_pg_case`, `yb_pg_create_operator`, `yb_pg_drop_operator`,
  `yb_pg_errors`, `yb_pg_privileges` regress tests for `CREATE/DROP
  OPERATOR`
* `yb_feature_alter_table`, `yb_pg_copydml`, `yb_pg_errors`,
  `yb_pg_foreign_key`, `yb_pg_rules`, `yb_pg_triggers`, regress tests for
  `CREATE/DROP RULE`
* `TestPgForeignKey`, `TestPgRegressAuthorization`,
  `TestPgRegressBetaFeatures`, `TestPgRegressFeature`,
  `TestPgRegressPgMisc`, `TestPgRegressPgMiscIndependent`,
  `TestPgRegressRules` java tests for above regress tests

Unrelated, affected tests:

* `yb_pg_insert`, `yb_pg_int4` regress tests
* `TestPgRegressPLpgSQL` java test

Reviewers: neha, mihnea

Reviewed By: mihnea

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D7119
@jaki
Copy link
Contributor Author

jaki commented Sep 12, 2019

Closed by commit 1c95753.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL)
Projects
YSQL
  
Done
Development

No branches or pull requests

1 participant