type CastFunc struct {
	Expr     *Expression `parser:" \"CAST\" \"(\" @@ "`
	CastType string      `parser:" \"AS\" @(\"BOOL\" | \"INT\" | \"INTEGER\" | \"STRING\" | \"FLOAT\" | \"DECIMAL\" | \"NUMERIC\" | \"TIMESTAMP\") \")\" "`
}

// SubstringFunc represents SUBSTRING sql function
type SubstringFunc struct {
	Expr *PrimaryTerm `parser:" \"SUBSTRING\" \"(\" @@ "`
	From *Operand     `parser:" ( \"FROM\" @@ "`

    }

    @Test
    @DisplayName("Constants: values match Windows error codes")
    void constants_have_expected_values() {
        // Ensure each public constant has its documented numeric value (happy path)
        assertAll(() -> assertEquals(0, WinError.ERROR_SUCCESS), () -> assertEquals(5, WinError.ERROR_ACCESS_DENIED),

     * <ul>
     * <li>Invalid directive formats</li>
     * <li>Unknown directives</li>
     * <li>Invalid crawl-delay values (non-numeric, negative)</li>
     * <li>Directives before any User-agent declaration (ignored)</li>
     * <li>Empty values for directives</li>
     * </ul>
     *

        int LIST_ITEM = 2;
        int COMBINATION_ITEM = 5;

        int compareTo(Item item);

        int getType();

        boolean isNull();
    }

    /**
     * Represents a numeric item in the version item list that can be represented with an int.
     */
    private static class IntItem implements Item {
        private final int value;

        public static final IntItem ZERO = new IntItem();

	if v1.IsNull() || v2.IsNull() {
		return v1, nil
	}

	err = inferTypesForCmp(v1, v2)
	if err != nil {
		return nil, err
	}

	atleastOneNumeric := v1.isNumeric() || v2.isNumeric()
	bothNumeric := v1.isNumeric() && v2.isNumeric()
	if atleastOneNumeric || !bothNumeric {
		return v1, nil
	}

	if v1.SameTypeAs(*v2) {
		return v1, nil
	}

	cmpResult, cmpErr := v1.compareOp(opEq, v2)

	// is used when autogenerating new credentials.
	// There is no max length enforcement for secret keys
	secretKeyMaxLen = 40

	// Alpha numeric table used for generating access keys.
	alphaNumericTable = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"

	// Total length of the alpha numeric table.
	alphaNumericTableLen = byte(len(alphaNumericTable))

	reservedChars = "=,"
)

	lval, lerr := e.Left.evalNode(r, tableAlias)
	if lerr != nil || len(e.Right) == 0 {
		return lval, lerr
	}

	// Process remaining child nodes - result must be
	// numeric. This AST node is for terms separated by + or -
	// symbols.
	for _, rightTerm := range e.Right {
		op := rightTerm.Op
		rval, rerr := rightTerm.Right.evalNode(r, tableAlias)
		if rerr != nil {
			return nil, rerr

        assertEquals(8, serverData.encryptionKey.length);
        assertEquals(16, serverData.guid.length);
    }

    /**
     * Test edge cases for numeric fields
     */
    @Test
    @DisplayName("Test edge cases for numeric fields")
    public void testNumericFieldsEdgeCases() {
        // Test maximum values for int fields
        serverData.sflags2 = Integer.MAX_VALUE;

        void testNamesByType() {
            byte[] ident = new byte[] { 0, 0, 0, 0, 0, 5 };
            // Unknown: domainName derived from numeric SID, accountName = RID
            SID unknown = new SID(buildSidT((byte) 1, ident, 10, 20, 30), jcifs.SID.SID_TYPE_UNKNOWN, null, null, false);
            assertEquals("S-1-5-10-20", unknown.getDomainName());

     */
    public void setMemorySize(final int memorySize) {
        this.memorySize = memorySize;
    }

    /**
     * Sets the maximum size of an alpha-numeric term.
     * @param maxAlphanumTermSize The max size of an alpha-numeric term.
     */
    public void setMaxAlphanumTermSize(final int maxAlphanumTermSize) {
        this.maxAlphanumTermSize = maxAlphanumTermSize;
    }

    /**