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] Add more regress tests for update optimizations #23733

Open
1 task done
karthik-ramanathan-3006 opened this issue Aug 29, 2024 · 0 comments
Open
1 task done

[YSQL] Add more regress tests for update optimizations #23733

karthik-ramanathan-3006 opened this issue Aug 29, 2024 · 0 comments
Assignees
@karthik-ramanathan-3006
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage

Comments

@karthik-ramanathan-3006
Copy link
Contributor

karthik-ramanathan-3006 commented Aug 29, 2024 •
edited by jira bot
Loading

Jira Link: DB-12637

Description

#18822 introduced optimizations to UPDATE queries skip redundant secondary index updates and foreign key checks.
This is a placeholder task to add more regress tests for the optimizations.

Issue Type

kind/enhancement

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@karthik-ramanathan-3006 karthik-ramanathan-3006 added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Aug 29, 2024
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue labels Aug 29, 2024
karthik-ramanathan-3006 added a commit that referenced this issue Sep 27, 2024
@karthik-ramanathan-3006
[#23733] YSQL: Add conditional trigger tests for update optimization
2e25b7d 
Summary:
This revision expands test coverage for conditional triggers for UPDATE queries in the context of D34040.
Jira: DB-12637

Test Plan:
Run the following tests:
```
./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressUpdateOptimized#schedule'
```

Reviewers: smishra

Reviewed By: smishra

Subscribers: yql

Tags: #jenkins-ready

Differential Revision: https://phorge.dev.yugabyte.com/D37691
timothy-e pushed a commit that referenced this issue Sep 30, 2024
@yugabyte-ci @timothy-e
[BACKPORT pg15-cherrypicks] all: Bulk port from master - 113
ca6c530 
Summary:
 a6d2802 [docs] Voyager left nav changes  (#24141)
 c629cfa [docs] added a missed alias (#24175)
 ef91421 [PLAT-15493] Failover fails post switchover in a replication setup
 2e25b7d [#23733] YSQL: Add conditional trigger tests for update optimization
 aca129f Fix lag metric name (#24178)
 c41a282 [#24164] xClusterDDLRepl: Skip CreateSequencesDataTable for AlterUniverseReplication
 fe84bfe [PLAT-13469] Health check to ensure systemd files have ExecPreStart
 81f0dfd [PLAT-15495] [UI] Add error column in node agent hidden page
 71ccee9 [PLAT-15358] Fix replication not existing logging message
 85e67fe [PLAT-15338] Improve formatting for very long universe names in DR participant cards
 8a71db3 [#24176] YSQL: Fix flaky test PgDdlAtomicitySanityTest.DdlRollbackMasterRestart
 b0d4d63 [#24145]: DocDB: Remove cdc specific yb_client from PgClientServiceImpl
 4bd9bd7 [PLAT-9803] Allow AWS universe to use any AWS instance type if runtime conf is set
 Excluded: 59b3636 [#24179] YSQL: INSERT ON CONFLICT batching
 Excluded: b9b57c6 [#24123] YSQL: Make a new ANN Access Method that redirects to the base table
 d8e4d30 [PLAT-15430]fix support bundle prometheus metrics query
 68d47f3 [PLAT-14030]Enable imdsv2 by default
 7fb93f2 [#24171] YSQL: Adapt of the PgCatalogPerfTest.ResponseCacheMemoryLimit unit test for pg15
 c18fd1c [#24190] CDCSDK: Enable tablet splitting on tables under CDCSDK stream by default
 8fade9b [PLAT-14966] [PLAT-14968] Edit KMS config reverts to default name in hashicorp vault
 347f14a [PLAT-15500][PLAT-15485]Fix read-replica edits for serviceEndpoint validations, move service-scope runtime config to Provider level
 fba6c68 [PLAT-15440] [PLAT][Metrics]IO write bytes are not calculated correctly for perprocess metrics
 247bed6 [PLAT-15534][YBA CLI]"yb-db-version list -o pretty" output is not a valid JSON
 99c5646 [PLAT-15437][PLAT-15445][YBA CLI] Changes to backup restore set of commands

Test Plan: Jenkins: rebase: pg15-cherrypicks

Reviewers: tfoucher, fizaa, telgersma

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

@karthik-ramanathan-3006 karthik-ramanathan-3006

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yugabyte-ci @karthik-ramanathan-3006