Subject | Re: [firebird-support] join and columns with the same name on diferent tables |
---|---|
Author | Daniel Rail |
Post date | 2004-04-06T17:41:19Z |
Hi,
At April 6, 2004, 12:54, Alexandre Benson Smith wrote:
ambiguous fields. I think you've proven that ISQL does a check where
it shouldn't(on dialect 1 databases), and the bug is more likely in
ISQL. The ambiguous fields check isn't performed on a dialect 1
database, but on a dialect 3 database. The reason why it is this way
is so that old applications(using dialect 1) wouldn't be broken.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At April 6, 2004, 12:54, Alexandre Benson Smith wrote:
> Forgot to metion Dialect 1 database.....This is why IBConsole, IBOConsole and Marathon didn't complain about
ambiguous fields. I think you've proven that ISQL does a check where
it shouldn't(on dialect 1 databases), and the bug is more likely in
ISQL. The ambiguous fields check isn't performed on a dialect 1
database, but on a dialect 3 database. The reason why it is this way
is so that old applications(using dialect 1) wouldn't be broken.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)