maria-developers team mailing list archive

Thread
Date

WL#215 New (by Monty): Add functional indexes

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: worklog-noreply@xxxxxxxxxxxx
Date: Thu, 30 Jun 2011 16:17:05 +0000 (UTC)

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Add functional indexes
CREATION DATE..: Thu, 30 Jun 2011, 16:17
SUPERVISOR.....: Monty
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-Sprint
TASK ID........: 215 (http://askmonty.org/worklog/?tid=215)
VERSION........: Server-5.6
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 200 (hours remain)
ORIG. ESTIMATE.: 200

PROGRESS NOTES:



DESCRIPTION:

Add support for functional indexes.

This is needed for MWL#34 Dynamic columns.

The idea would be to extend the handler interface with a callback function that
provides the handler with a key in normal key-read format of the index entry.

In addition we need to enhance the optimizer to recognize the function used for
the functional index parts so that it can use the index.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)