Hi guys, hope this is ok to ask here.
Been trying to figure out if is possible to access mysql internals from ideally, a udf, or
a procedure. My specific goal is to provide a grouping() like function simliar to oracle
that prints a 1 if a NULL was placed by the ROLLUP operation, or 0 if otherwise.
However to start I'd be happy just printing, say all the fields used in the select
statement.
Any pointers on where to start?
the UDF implementation seems to hide internals, so I've pretty much given up on that. The
procedure code looks promising but it seems to be executed after the query has executed so
you are only provided with the results and my ultimate goal, accessing specifics regarding
a rollup would of already been processed and likely not available to me.
That leaves me to believe that my last option is to somehow write plugin, or t patch the
mysql source code directly. Both of which are not trivial for someone not familiar to
the code.
Cheers,
Shane
