Bug: Errors when Handling Self-Referencing Tables

[MZaFaRM]

1. Description:

   • "The tool encounters errors when attempting to populate self-referencing tables. This seems to occur when a table contains a foreign key that references its own primary key."

2. Steps to Reproduce:

   • "1. Create a self-referencing table in the database schema (e.g., an 'Employees' table where each employee has a 'manager_id' that references the 'employee_id' in the same table).
   • 2. Use the tool to populate this table with data.
   • 3. Observe the error that occurs during this process."

3. Expected Behavior:

   • "The tool should be able to handle self-referencing tables correctly, allowing for proper data insertion without errors."

4. Actual Behavior:

   • "When trying to populate self-referencing tables, the tool throws an error, preventing the successful insertion of data."

5. Impact:

   • "This issue limits the tool's usability for database schemas with self-referencing tables, which are common in various use cases like organizational hierarchies."