Skip to content

Reduce simulate-query memory#20238

Open
MoonE wants to merge 2 commits intophpmyadmin:QA_5_2from
MoonE:simulate-query-memory
Open

Reduce simulate-query memory#20238
MoonE wants to merge 2 commits intophpmyadmin:QA_5_2from
MoonE:simulate-query-memory

Conversation

@MoonE
Copy link
Copy Markdown
Contributor

@MoonE MoonE commented Mar 15, 2026

Description

Fixes #18941

When the modal is opened it adds overflow: hidden style to body.
After clicking the Affected rows link, scrolling was disabled because the modal was not properly closed. Intrduced in #17065
image

  • Adds a separate query to count the affected rows to no longer load all rows from the db.
  • Allows paging for the changed-rows preview, this is done by wrapping the query with limit in another SELECT query.
image
  • Changes the name of the new-value column from x `new` to x *new* to circumvent a sql-parser error

MoonE added 2 commits March 15, 2026 21:05
Signed-off-by: Maximilian Krög <maxi_kroeg@web.de>
Use a separate query to count changed rows.
Wrap select query with limit with a select * query which enables paging for
the displayed rows.

Signed-off-by: Maximilian Krög <maxi_kroeg@web.de>
@codecov
Copy link
Copy Markdown

codecov bot commented Mar 15, 2026

Codecov Report

❌ Patch coverage is 0% with 31 lines in your changes missing coverage. Please review.
✅ Project coverage is 49.42%. Comparing base (0ade0ba) to head (827f371).
⚠️ Report is 189 commits behind head on QA_5_2.

Files with missing lines Patch % Lines
libraries/classes/Import/SimulateDml.php 0.00% 31 Missing ⚠️
Additional details and impacted files
@@             Coverage Diff              @@
##             QA_5_2   #20238      +/-   ##
============================================
+ Coverage     49.41%   49.42%   +0.01%     
+ Complexity    17188    16851     -337     
============================================
  Files           607      607              
  Lines         72549    69652    -2897     
============================================
- Hits          35850    34428    -1422     
+ Misses        36699    35224    -1475     
Flag Coverage Δ
recode-extension ?
unit-7.2-ubuntu-latest ?
unit-7.3-ubuntu-latest ?
unit-7.4-ubuntu-latest 49.31% <0.00%> (+<0.01%) ⬆️
unit-8.0-ubuntu-latest 49.35% <0.00%> (-0.02%) ⬇️
unit-8.1-ubuntu-latest 49.35% <0.00%> (-0.02%) ⬇️
unit-8.2-ubuntu-latest 49.29% <0.00%> (-0.03%) ⬇️
unit-8.3-ubuntu-latest ?
unit-8.4-ubuntu-latest ?

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

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.

1 participant