dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Support declare error code

Open max-hoffman opened this issue 1 year ago • 0 comments

Support declare error code:

	{
		Name: "create DECLARE HANDLERs",
		SetUpScript: []string{
			`DROP TABLE IF EXISTS t1;`,
			`CREATE TABLE t1 (pk BIGINT PRIMARY KEY);`,
                        `CREATE PROCEDURE proc_named_condition()
BEGIN
	DECLARE a, b INT DEFAULT 1;
    DECLARE cur1 CURSOR FOR SELECT * FROM t1;
    OPEN cur1;
    BEGIN
	DECLARE eof CONDITION FOR 1329;
	DECLARE EXIT HANDLER FOR eof SET a = 2;
		tloop: LOOP
			FETCH cur1 INTO b;
            IF a > 1 THEN
				LEAVE tloop;
            END IF;
		END LOOP;
    END;
    CLOSE cur1;
    SELECT a;
END;`,
		},
		Assertions: []ScriptTestAssertion{
			{
				Query:    "CALL proc_named_condition();",
				Expected: []sql.Row{{2}},
			},
		},
	},
unsupported syntax: declare eof condition for 1329

max-hoffman avatar Feb 05 '24 23:02 max-hoffman