[MDEV-3251] LP:615752 - Subquery caching is not visible in EXPLAIN Created: 2010-08-10  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug615752.xml    

 Description   

As discussed on the dev meeting, it is imperative that all optimizations are visible one way or another. Subquery caching is currently only detectable via SHOW STATUS LIKE 'Subquery_cache_hit' which does not scale well for automatic testing.

Instead "Using subquery cache" must be present in the Notes section of EXPLAIN , or alternatively some indication must be given in EXPLAIN EXTENDED.

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-07-29 ]

Launchpad bug id: 615752

Generated at Thu Feb 08 06:47:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.