Hello.
The last week I opened a new post in this forum talking about an issue relationated with this same subject, but today I've found out that the problem affects to all my many to many relationships of my project.
I have a number of tables connected between them to a many-to-many relationship.
Let's say an example.
T_A -> T_B -> T_C -> T_D -> T_E -> T_F -> T_A
T_E and T_F are many_to_many relationships.
If I try to read rows in all my tables in the order T_A -> T_B -> T_C -> T_D -> T_E, just read them, ir produces a delete in T_F where the ID_TA in T_F = ID_TA from the first register I obtained.
I've been trying other combinations with different tables and all them produces sometimes the same effect in many-to-many relationships (sometimes reading, sometimes updating, other inserting or maybe a combination of all them).
Reading documentation about this issue I couldn't find so much... only the suggestion about not create a relationship many-to-many directly with the table, exporting it outside, is it true?
Somebody knows what's going on?, is this a bug?.
Thank you.
|