create_tmp_table() code is unaware of row_format=dynamic

Bug #1269529 reported by Chris Calender
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Invalid
Wishlist
Unassigned

Bug Description

 create_tmp_table() code is unaware of row_format=dynamic, and thus on-disk temp tables can be created in scenarios when it should not be.

I suspect this is more likely a feature request.

There are some more details about the issue, and reproducing it here, if interested (see last 5-ish comments):

https://mariadb.atlassian.net/browse/MDEV-4793

Revision history for this message
Chris Calender (chriscalender) wrote :

This is so there can be heap temporary table with a dynamic row format.

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

This feature request is tracked at https://blueprints.launchpad.net/percona-server/+spec/memory-temp-tables. Currently there are no short-term plans to implement it.

I had an alpha branch for Percona Server 5.5 (.15 or thereabouts) that mostly implemented this, but I haven't finish debugging of all the corner cases (such as, IIRC, temp tables for GEOMETRY).

Since there is a blueprint, I am going to close this bug report as Invalid. Please track the blueprint. Thanks!

Changed in percona-server:
importance: Undecided → Wishlist
status: New → Triaged
status: Triaged → Invalid
tags: added: rdba
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2441

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers