Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
JOIN on FIXED
From: Fabio Pinotti (fabio.pinottiicteam.it)
Date: Tue Feb 22 2005 - 09:10:54 CST
Hi, I've encountered a strange behaviour with join on columns of different data type.
I had a Fixed(9,0) column in table A and a Fixed(6,0) column in table B, with the same numerical value. But the join between the tables returned no result.
Only upgrading the fixed(6,0) column in table B to data type fixed(9,0), solved the problem.
Is this a known bug?