Yizhou-Yang opened a new issue, #8653:
URL: https://github.com/apache/inlong/issues/8653

   ### What happened
   
   We have client reports that pg-pg multiple table scenerios would fail on 
certain versions of postgres cdc (namely cdwpg 2.0), since .
   
       private static final String QUERY_PRIMARY_KEY_SQL = "SELECT\n" +
               "\tstring_agg (DISTINCT t3.attname, ',') AS " + 
PRIMARY_KEY_COLUMN + ",\n" +
               "    \tt4.tablename AS tableName\n" +
               "FROM\n" +
               "\tpg_constraint t1\n" +
               "INNER JOIN pg_class t2 ON t1.conrelid = t2.oid\n" +
               "INNER JOIN pg_attribute t3 ON t3.attrelid = t2.oid\n" +
               "AND array_position (t1.conkey, t3.attnum) is not null\n" +
               "INNER JOIN pg_tables t4 on t4.tablename = t2.relname\n" +
               "INNER JOIN pg_index t5 ON t5.indrelid = t2.oid\n" +
               "AND t3.attnum = ANY (t5.indkey)\n" +
               "LEFT JOIN pg_description t6 on t6.objoid = t3.attrelid\n" +
               "and t6.objsubid = t3.attnum\n" +
               "WHERE\n" +
               "\tt1.contype = 'p'\n" +
               "AND length (t3.attname) > 0\n" +
               "AND t2.oid = ?::regclass\n" +
               "group by\n" +
               "\tt4.tablename";
   
   <img width="1463" alt="企业微信截图_a78c27f6-f7d2-4158-a46c-dc5d524b9bbd" 
src="https://github.com/apache/inlong/assets/32808678/52553cee-8848-4a78-8032-5527cee1c6cf";>
   
   ### What you expected to happen
   
   the query sql should be compatible with most versions of postgres cdc.
   
   
   ### How to reproduce
   
   the problem is specific to some version of postgres. My edited sql should be 
strictly MORE compatible than the old one. It is tested in the production 
environment by the client via a hotfix (many hotfixes, actually). So it should 
not product any errors.
   
   ### Environment
   
   _No response_
   
   ### InLong version
   
   master
   
   ### InLong Component
   
   InLong Sort
   
   ### Are you willing to submit PR?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: dev-unsubscr...@inlong.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to