I have a table that has a BIGINT UNSIGNED
primary key column.
I need to reference entries in this table using a stored procedure, with the value for the key column passed in as a parameter.
I also need to be able to support values greater than 9223372036854775807 (BIGINT(MAX)
), but when I attempt to pass a value to the stored procedure parameter that is greater, I get a value out-of-range error. Because the parameter is defined as BIGINT
not BIGINT UNSIGNED
.
If I manually recreate the stored procedure, using a Query tab, and specify BIGINT UNSIGNED
for the parameter, the procedure is created fine, and everything works.
However, HeidiSQL (10.2.0.5599) still shows the parameter, in the "Create Code" tab, as being just BIGINT
and not BIGINT UNSIGNED
(as it actually is in the database).
Worse, if I then use the "Export Database as SQL" command, the create code for the stored procedure, in the generated SQL script file, is also now using just BIGINT
and not BIGINT UNSIGNED
. So when the database is created by importing the generated SQL script, the parameter type is now incorrect, and value out-of-range errors begin appearing once again.
I'm really hoping that I'm missing something, or doing something wrong, as HeidiSQL has been my go-to database tool for a long time now. But this is a breaking issue for the project I'm currently working on. If anyone can help me out, it would be massively appreciated!