columns with same name in 2 different tables about aidb HOT 4 CLOSED

I think all columns are referred to by their fully qualified names "table.column". If not, we should probably do that everywhere.

from aidb.

https://github.com/ddkang/aidb-new/blob/f8e1521958e07381dd182a3a67174489191dafea/aidb/config/config.py#L185

I think, maybe here they are not

from aidb.

Yes, all columns are referred to by their fully qualified names "table.column".
To make the output can be deterministically generated, we need to make sure any primary key column in the output table with a foreign key relationship must exist in the primary key columns of the input tables. For example, suppose table A, table B are input tables, table C is a output table, C has a composite primary key (key1, key2, key3). If key1, key2 are foreign keys, they must refer to column in table A or table B. If key1 refer to another table D, we should raise an exception. However, a foreign key can only refer to one column in parent table. For multi input table situation, we make an assumption. Column with same name in different tables represent same thing. Suppose table A, table B are input tables, they have same column Frame. Table A can join Table B on Table A.Frame = Table B.Frame. Then the output table C should contain column Frame, and it only need to refer to one of Table A.Frame and Table B.Frame.

from aidb.

Perfect, makes sense.

from aidb.