MySQL Forums
Forum List  »  Stored Procedures

insertion of BINARY(250) field fails
Posted by: Paul Hubenig
Date: February 09, 2015 02:54PM

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
insertion of BINARY(250) field fails
2796
February 09, 2015 02:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.