I face a very strange problem, I have a function that executes a SQL statement, this SQL statement has a string variable exists 3 times in the statment that passed by the function's arguments. So simple till now but what actually happens seems to be a bug. consider I pass one of two values 'IATA' or 'ICAO' so when i pass the 'IATA' to the statement it works, but when I pass the 'ICAO' it displays 'NULLs' in the first two places and work in the 3rd place!!!.
e.g.
In case of IATA:
ID - CODE X - CODE Y - CODE Z
-----------------------------
1 - IATA1 - IATA2 - IATA3
In case of ICAO:
-----------------------------
1 - NULL - NULL - ICAO3
!! Knowing that CODE Y and code Z are from same table
and if i place static 'ICAO' in the statement, it works fine!!
I wish it's not a bug.
e.g.
In case of IATA:
ID - CODE X - CODE Y - CODE Z
-----------------------------
1 - IATA1 - IATA2 - IATA3
In case of ICAO:
-----------------------------
1 - NULL - NULL - ICAO3
!! Knowing that CODE Y and code Z are from same table
and if i place static 'ICAO' in the statement, it works fine!!
I wish it's not a bug.