AW: JOIN on FIXED

Fabio Pinotti wrote
> 
> 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?

Which version are you using?
How does the explain for the select look like?
How does the select look like?
Please provide the table definitions of all tables concerned plus the
index-definitions to see which part of primary/secondary key was formed
by this column.
Did you add that column after the first creation of the table or was it
part of the table creation?
Please provide the installation parameter values (if I knew the version
you are using, I could tell you what I am really interested in).
Did you change some kernel-settings after contact with one of my
colleagues, especially some join/optimize-settings?

Elke
SAP Labs Berlin

> 
> Best regards
> Fabio

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx