loserwang1024 commented on PR #3950:
URL: https://github.com/apache/flink-cdc/pull/3950#issuecomment-2826726826

   This test have too much sleep logical which is unstable, thus I adjust this 
test. Please rebase and add it.
   ```java
    @Test
       public void testStartupFromCommittedOffset() throws Exception {
           setup(true);
           initializePostgresTable(POSTGRES_CONTAINER, "inventory");
           try (Connection connection = getJdbcConnection(POSTGRES_CONTAINER);
                Statement statement = connection.createStatement()) {
               statement.execute(
                       "INSERT INTO inventory.products VALUES 
(default,'first','first description',0.1);");
               statement.execute(
                       "INSERT INTO inventory.products VALUES 
(default,'second','second description',0.2);");
           }
   
           // newly create slot's confirmed lsn is latest. We will test whether 
committed mode starts from here.
           String slotName = getSlotName();
           try (Connection connection = getJdbcConnection(POSTGRES_CONTAINER); 
Statement statement = connection.createStatement()) {
               // TODO: Remove it after adding publication to an existing 
replication slot.
               statement.execute("CREATE PUBLICATION dbz_publication FOR TABLE 
inventory.products");
               statement.execute(String.format("select 
pg_create_logical_replication_slot('%s','pgoutput');", slotName));
           }
   
           try (Connection connection = getJdbcConnection(POSTGRES_CONTAINER); 
Statement statement = connection.createStatement()) {
               statement.execute(
                       "INSERT INTO inventory.products VALUES 
(default,'thirth','thirth description',0.1);");
               statement.execute(
                       "INSERT INTO inventory.products VALUES 
(default,'forth','forth description',0.2);");
           }
   
   
           String sourceDDL =
                   String.format(
                           "CREATE TABLE debezium_source ("
                                   + " id INT NOT NULL,"
                                   + " name STRING,"
                                   + " description STRING,"
                                   + " weight DECIMAL(10,3),"
                                   + " PRIMARY KEY (id) NOT ENFORCED"
                                   + ") WITH ("
                                   + " 'connector' = 'postgres-cdc',"
                                   + " 'hostname' = '%s',"
                                   + " 'port' = '%s',"
                                   + " 'username' = '%s',"
                                   + " 'password' = '%s',"
                                   + " 'database-name' = '%s',"
                                   + " 'schema-name' = '%s',"
                                   + " 'table-name' = '%s',"
                                   + " 'scan.incremental.snapshot.enabled' = 
'true',"
                                   + " 'decoding.plugin.name' = 'pgoutput', "
                                   + " 'slot.name' = '%s',"
                                   + " 'scan.lsn-commit.checkpoints-num-delay' 
= '0',"
                                   + " 'scan.startup.mode' = 'committed-offset'"
                                   + ")",
                           POSTGRES_CONTAINER.getHost(),
                           POSTGRES_CONTAINER.getMappedPort(POSTGRESQL_PORT),
                           POSTGRES_CONTAINER.getUsername(),
                           POSTGRES_CONTAINER.getPassword(),
                           POSTGRES_CONTAINER.getDatabaseName(),
                           "inventory",
                           "products",
                           slotName);
           String sinkDDL =
                   "CREATE TABLE sink "
                           + " WITH ("
                           + " 'connector' = 'values',"
                           + " 'sink-insert-only' = 'false'"
                           + ") LIKE debezium_source (EXCLUDING OPTIONS)";
           tEnv.executeSql(sourceDDL);
           tEnv.executeSql(sinkDDL);
   
           TableResult result =
                   tEnv.executeSql("INSERT INTO sink SELECT * FROM 
debezium_source");
           waitForSinkSize("sink", 2);
   
           String[] expected =
                   new String[] {
                           "112,thirth,thirth description,0.100", 
"113,forth,forth description,0.200"
                   };
   
           List<String> actual = 
TestValuesTableFactory.getResultsAsStrings("sink");
           Assertions.assertThat(actual).containsExactlyInAnyOrder(expected);
           result.getJobClient().get().cancel().get();
       }
   
   ```


-- 
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: issues-unsubscr...@flink.apache.org

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

Reply via email to