Wednesday, March 28, 2018

mariadb mysql stored udf wrong error message

i just wasted 12 hours chasing an error in stored function on mariadb
select sugarcrm.canstart('10.8.0.99') as "val";
ERROR 1054 (42S22): Unknown column 'fixedip' in 'field list'
the error " Unknown column 'fixedip' in 'field list" was not related to any table I was referencing in my udf. turns out it is referring to a parameter name in the udf
i am setting a user variable like this:
 SET @fixedip := fixedip; the error is that my parameter name is ipadr and not fixedip! I am pissed that I was mislead into thinking this was a column in a table i was querrying or inserting into  

very annoying😞!!!


1 comment: