ExtRegExp.h File Reference

Go to the source code of this file.

Functions
FENNEL_BEGIN_NAMESPACE void	strLikeEscapeA (RegisterRef< bool > *result, RegisterRef< char * > *matchValue, RegisterRef< char * > *pattern, RegisterRef< char * > *escape)
	StrLike.
void	strLikeA (RegisterRef< bool > *result, RegisterRef< char * > *matchValue, RegisterRef< char * > *pattern)
	StrLike.
void	strSimilarEscapeA (RegisterRef< bool > *result, RegisterRef< char * > *matchValue, RegisterRef< char * > *pattern, RegisterRef< char * > *escape)
	StrSimilar.
void	strSimilarA (RegisterRef< bool > *result, RegisterRef< char * > *matchValue, RegisterRef< char * > *pattern)
	StrSimilar.
void	ExtRegExpRegister (ExtendedInstructionTable *eit)

---

Function Documentation

void ExtRegExpRegister

(

ExtendedInstructionTable *

eit

)

Definition at line 180 of file ExtRegExp.cpp.

References ExtendedInstructionTable::add(), STANDARD_TYPE_BOOL, STANDARD_TYPE_CHAR, STANDARD_TYPE_VARCHAR, strLikeA(), strLikeEscapeA(), strSimilarA(), and strSimilarEscapeA().

Referenced by CalcInit::instance().

{
    assert(eit != NULL);

    // JK 2004/5/27: Are all of these combinations really needed?
    int i;
    for (i = 0; i < 8; i++) {
        vector<StandardTypeDescriptorOrdinal> params;

        params.push_back(STANDARD_TYPE_BOOL);

        if (i & 0x01) {
            params.push_back(STANDARD_TYPE_CHAR);
        } else {
            params.push_back(STANDARD_TYPE_VARCHAR);
        }
        if (i & 0x02) {
            params.push_back(STANDARD_TYPE_CHAR);
        } else {
            params.push_back(STANDARD_TYPE_VARCHAR);
        }

        eit->add(
            "strLikeA3", params,
            (ExtendedInstruction3Context<bool, char*, char*>*) NULL,
            &strLikeA);
        eit->add(
            "strSimilarA3", params,
            (ExtendedInstruction3Context<bool, char*, char*>*) NULL,
            &strSimilarA);

        // tack on escape parameter
        if (i & 0x04) {
            params.push_back(STANDARD_TYPE_CHAR);
        } else {
            params.push_back(STANDARD_TYPE_VARCHAR);
        }

        eit->add(
            "strLikeA4", params,
            (ExtendedInstruction4Context<bool, char*, char*, char*>*) NULL,
            &strLikeEscapeA);
        eit->add(
            "strSimilarA4", params,
            (ExtendedInstruction4Context<bool, char*, char*, char*>*) NULL,
            &strSimilarEscapeA);
    }
}

void strLikeA	(	RegisterRef< bool > *	result,
		RegisterRef< char * > *	matchValue,
		RegisterRef< char * > *	pattern
	)

StrLike.

Ascii. Reuses pattern. ESCAPE clause not defined.

FENNEL_BEGIN_NAMESPACE void strLikeEscapeA	(	RegisterRef< bool > *	result,
		RegisterRef< char * > *	matchValue,
		RegisterRef< char * > *	pattern,
		RegisterRef< char * > *	escape
	)

StrLike.

Ascii. Reuses pattern. Pass a zero length string into escape if not defined Passing a null into escape will result in null, per SQL99.

void strSimilarA	(	RegisterRef< bool > *	result,
		RegisterRef< char * > *	matchValue,
		RegisterRef< char * > *	pattern
	)

StrSimilar.

Ascii. Reuses pattern. ESCAPE clause not defined.

void strSimilarEscapeA	(	RegisterRef< bool > *	result,
		RegisterRef< char * > *	matchValue,
		RegisterRef< char * > *	pattern,
		RegisterRef< char * > *	escape
	)

StrSimilar.

Ascii. Reuses pattern. Pass a zero length string into escape if not defined Passing a null into escape will result in null, per SQL99 & SQL2003

---