Subject | IBO / Firebird 3 - problems with inserting rows |
---|---|
Author | Marcin Bury |
Post date | 2016-06-16T07:31:25Z |
Hello All
I'm facing a strange problem with IBO working with Firebird 3 database.
When the query contains subselect and tables aliases are in use, IBO
apparently has problem obtaing proper keyrelation that leads to false
result of CanInsert function.
Having query like this
SELECT A.FIELD_1, A.FIELD_2, (SELECT B.FIELD_3 FROM TABLE_B B WHERE
B.KEY_FIELD = A.FIELD_2) B_FIELD
FROM TABLE_A A
When executed on FB3 - IBO findes two aliases, then FRelAliasList
contains two items and SysKeyRelations is always <empty_string>
Funny thing is that same query executed on FB 2.5 works properly.
Any ideas?
Thanks,
Marcin
I'm facing a strange problem with IBO working with Firebird 3 database.
When the query contains subselect and tables aliases are in use, IBO
apparently has problem obtaing proper keyrelation that leads to false
result of CanInsert function.
Having query like this
SELECT A.FIELD_1, A.FIELD_2, (SELECT B.FIELD_3 FROM TABLE_B B WHERE
B.KEY_FIELD = A.FIELD_2) B_FIELD
FROM TABLE_A A
When executed on FB3 - IBO findes two aliases, then FRelAliasList
contains two items and SysKeyRelations is always <empty_string>
Funny thing is that same query executed on FB 2.5 works properly.
Any ideas?
Thanks,
Marcin