insertion of BINARY(250) field fails
I'm getting nulls in my BINARY(250) record and I'm at my wit's end. make_flags() is non-null. Any thoughts appreciated ...
.
.
.
SET @convertedDigestCreateSqlString = CONCAT('CREATE TABLE ', converted_digest_table, ' (result DECIMAL(20, 5), correspondance BINARY (250))');
.
.
.
SET @digestInsertSqlString = CONCAT('INSERT INTO ', converted_digest_table, ' (result, correspondance) VALUES(?,?)');
SET @digestSqlString = CONCAT('CREATE VIEW digestView AS SELECT result, CONCAT(', concatColNamesStr, ') FROM ', digest_table);
SELECT @digestSqlString;
PREPARE digestStmt FROM @digestSqlString;
EXECUTE digestStmt;
DEALLOCATE PREPARE digestStmt;
set @debug_limit = 5; # TAKE ME OUT
set @debug_counter = 0;
OPEN digestCursor;
BEGIN
DECLARE dResult DOUBLE DEFAULT 0.;
DECLARE digestResultString TEXT(65535);
DECLARE binaryFlags BINARY(250);
DECLARE digestCursorDone INTEGER DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET digestCursorDone = 1;
set @result = 0.;
set @binFlags = CAST(0 AS BINARY(250));
PREPARE insertStmt FROM @digestInsertSqlString;
FETCH digestCursor INTO dResult, digestResultString;
WHILE digestCursorDone = 0 DO
SELECT dResult, digestResultString;
FETCH digestCursor INTO dResult, digestResultString;
# make_flags defined as:
#
# CREATE FUNCTION make_flags (digestResultString TEXT(65535),
# n0String TEXT(65535),
# n1String TEXT(65535),
# n2String TEXT(65535),
# v0String TEXT(65535),
# v1String TEXT(65535),
# v2String TEXT(65535),
# numberOfRegressionTerms INTEGER) RETURNS BINARY(250)
# DETERMINISTIC
#
SET @binFlags = make_flags(digestResultString, n0String, n1String, n2String,
v0String, v1String, v2String, termCount);
set @result = dResult;
set @binFlags = binaryFlags;
EXECUTE insertStmt USING @result, @binFlags;
SET @debug_counter = @debug_counter + 1;
IF @debug_counter = @debug_limit THEN
SET digestCursorDone = 1;
END IF;
END WHILE;
END;
CLOSE digestCursor;
DROP VIEW digestView;
DEALLOCATE PREPARE insertStmt;