skewness_samp.c File Reference

Sample moment coefficient of skewness. More...

#include "sqlstat.h"

Include dependency graph for skewness_samp.c:

Go to the source code of this file.

Classes
struct	skewness_samp_storage
	Storage for sample moment coefficient of skewness. More...

Functions
my_bool	skewness_samp_init (UDF_INIT *initid, UDF_ARGS *args, char *message)
	Called before first usage of function. More...
void	skewness_samp_reset (UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error)
	Reset function and add first group member Calls clear and add. More...
void	skewness_samp_clear (UDF_INIT *initid, char *is_null, char *error)
	Called at start of group. More...
void	skewness_samp_add (UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error)
	Add a member of the group. More...
double	skewness_samp (UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error)
	Retrieve sample moment coefficient of skewness. Called at end of group. More...
void	skewness_samp_deinit (UDF_INIT *initid)
	Called after last access to function. More...

Detailed Description

Sample moment coefficient of skewness.

CREATE AGGREGATE FUNCTION skewness_samp RETURNS REAL SONAME 'libsqlstat.so';
SELECT skewness_samp(x) FROM mytab;
DROP FUNCTION skewness_samp;

Definition in file skewness_samp.c.

Function Documentation

double skewness_samp	(	UDF_INIT *	initid,
		UDF_ARGS *	args,
		char *	is_null,
		char *	error
	)

Retrieve sample moment coefficient of skewness. Called at end of group.

Parameters

initid	function description
args	argument values
is_null	result is NULL
error	error message

Returns

sample moment coefficient of skewness

Definition at line 164 of file skewness_samp.c.

void skewness_samp_add	(	UDF_INIT *	initid,
		UDF_ARGS *	args,
		char *	is_null,
		char *	error
	)

Add a member of the group.

The counter and sums are updated

Parameters

initid	function description
args	argument values
is_null
error	error message

Definition at line 130 of file skewness_samp.c.

Here is the caller graph for this function:

void skewness_samp_clear	(	UDF_INIT *	initid,
		char *	is_null,
		char *	error
	)

Called at start of group.

void skewness_samp_clear(UDF_INIT *initid, char *is_null, char *error) The counter and sums are cleared.

Parameters

initid	function description
is_null
error	error message

Definition at line 111 of file skewness_samp.c.

Here is the caller graph for this function:

void skewness_samp_deinit

(

UDF_INIT *

initid

)

Called after last access to function.

Deallocate memory for counter and sums.

Parameters

initid

Definition at line 201 of file skewness_samp.c.

my_bool skewness_samp_init	(	UDF_INIT *	initid,
		UDF_ARGS *	args,
		char *	message
	)

Called before first usage of function.

Check parameters.
Indicate type of return value.
Allocate memory for counter and sums.

Parameters

initid	function description
args	parameters
message	error message

Returns

success = 0

Definition at line 58 of file skewness_samp.c.

void skewness_samp_reset	(	UDF_INIT *	initid,
		UDF_ARGS *	args,
		char *	is_null,
		char *	error
	)

Reset function and add first group member Calls clear and add.

Parameters

initid	function description
args	argument values
is_null
error	error message

Deprecated:

Reset is only called by MySQL 4.0 and below. It is implemented for backwards compatibility.

Definition at line 97 of file skewness_samp.c.

Here is the call graph for this function: