1362227089 commented on issue #12267: URL: https://github.com/apache/seatunnel/issues/12267#issuecomment-5746821444
## Full query results ### 1. `SELECT datname FROM pg_database ORDER BY datname;` | datname | |-----------| | cflag | | highgo | | template0 | | template1 | ### 2. Connected to database `highgo`, query `information_schema.tables` for `testdb.test_a` | table_catalog | table_schema | table_name | table_type | |---------------|--------------|------------|------------| | highgo | testdb | test_a | BASE TABLE | | highgo | testdb | test_a | BASE TABLE | | highgo | testdb | test_a | BASE TABLE | | highgo | testdb | test_a | BASE TABLE | | highgo | testdb | test_a | BASE TABLE | | highgo | testdb | test_a | BASE TABLE | ### 3. Connected to database `cflag`, run the same `information_schema.tables` query | table_catalog | table_schema | table_name | table_type | |---------------|--------------|------------|------------| *(empty result)* ### Connector logs ```log 2026-09-20 09:34:32,189 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - list of available databases is: [highgo, template1, template0, cflag] 2026-09-20 09:34:32,723 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing 2026-09-20 09:34:32,723 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing 2026-09-20 09:34:32,723 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing 2026-09-20 09:34:32,723 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing 2026-09-20 09:34:32,744 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing 2026-09-20 09:34:32,744 INFO [.c.s.c.p.u.TableDiscoveryUtils] [main] - including 'highgo.testdb.test_a' for further processing Additional notes: We verified against underlying system catalogs `pg_class` and `pg_namespace`. Only one physical table entry exists for `testdb.test_a`, no duplicate table objects at storage layer. - `template0` and `template1` cannot be connected by regular user on HighGo, connector skips them with cross‑database reference error as we saw in early warnings. - The log shows six identical `highgo.testdb.test_a` entries are emitted from table discovery, which exactly matches the 6 duplicate rows returned by `information_schema.tables`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
