<h2 dir="auto">Question</h2>
<p dir="auto">I use interval algorithm by the properties like this</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
        props:
          path: .shardingsphere
      overwrite: true
    datasource:
      names: test-algorithm
      test-algorithm:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/test_algorithm?useUnicode=true&amp;characterEncoding=utf-8&amp;rewriteBatchedStatements=true&amp;serverTimezone=Asia/Shanghai
        username: test
        password: test
        maxPoolSize: 100
        minPoolSize: 5
    rules:
      sharding:
        tables:
          metic_text_record:
            actual-data-nodes: test-algorithm.metic_text_record$-&gt;{202201..203012}
            table-strategy:
              standard:
                sharding-column: create_time
                sharding-algorithm-name: myalgorithm
        sharding-algorithms:
          myalgorithm:
            type: INTERVAL
            props:
              datetime-pattern: 'yyyy-MM-dd HH:mm:ss'
              datetime-lower: '2022-01-01 00:00:00'
              datetime-upper: '2023-12-01 00:00:00'
              sharding-suffix-pattern: 'yyyyMM'
              datetime-interval-amount: 1
              datetime-interval-unit: 'months'"><pre class="notranslate"><code class="notranslate">spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
        props:
          path: .shardingsphere
      overwrite: true
    datasource:
      names: test-algorithm
      test-algorithm:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/test_algorithm?useUnicode=true&amp;characterEncoding=utf-8&amp;rewriteBatchedStatements=true&amp;serverTimezone=Asia/Shanghai
        username: test
        password: test
        maxPoolSize: 100
        minPoolSize: 5
    rules:
      sharding:
        tables:
          metic_text_record:
            actual-data-nodes: test-algorithm.metic_text_record$-&gt;{202201..203012}
            table-strategy:
              standard:
                sharding-column: create_time
                sharding-algorithm-name: myalgorithm
        sharding-algorithms:
          myalgorithm:
            type: INTERVAL
            props:
              datetime-pattern: 'yyyy-MM-dd HH:mm:ss'
              datetime-lower: '2022-01-01 00:00:00'
              datetime-upper: '2023-12-01 00:00:00'
              sharding-suffix-pattern: 'yyyyMM'
              datetime-interval-amount: 1
              datetime-interval-unit: 'months'
</code></pre></div>
<p dir="auto">when the program use current time to format, it throws an error that StringIndexOutOfBoundsException<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/5958344/171363357-86790633-40c0-4dcc-bdf9-8b6aa5de424d.png"><img src="https://user-images.githubusercontent.com/5958344/171363357-86790633-40c0-4dcc-bdf9-8b6aa5de424d.png" alt="image" style="max-width: 100%;"></a><br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/5958344/171363434-0e186ecf-f962-4dcd-aa4b-d45e309ab619.png"><img src="https://user-images.githubusercontent.com/5958344/171363434-0e186ecf-f962-4dcd-aa4b-d45e309ab619.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">why the current time's pattern like ‘2022-06-01’ but not '2022-06-01 16:00:00'</p>
<p dir="auto">I used the offical example of proxy, when i use navicat to access the proxy, it thrown the exception below, so the test cannot continue. since i don't very familer with the code ,so i just trace to that, datasource name of BackenConnection is null lead to this issue。<br>
Below is the excepiton， and the configure also be attached.<br>
And the proxy is comminucate with QUERY_COM ,and the query sql is "SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA"</p>
<p dir="auto">ava.lang.NullPointerException: null<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.createConnection(JDBCBackendDataSource.java:150)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCBackendDataSource.getConnections(JDBCBackendDataSource.java:123)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.connection.BackendConnection.getConnectionFromUnderlying(BackendConnection.java:189)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.connection.BackendConnection.getConnectionsWithoutTransaction(BackendConnection.java:172)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.connection.BackendConnection.getConnections(BackendConnection.java:141)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.callback.ProxyJDBCExecutePrepareCallback.getConnections(ProxyJDBCExecutePrepareCallback.java:56)<br>
at org.apache.shardingsphere.core.execute.sql.prepare.SQLExecutePrepareTemplate.getSQLExecuteGroups(SQLExecutePrepareTemplate.java:89)<br>
at org.apache.shardingsphere.core.execute.sql.prepare.SQLExecutePrepareTemplate.getSynchronizedExecuteUnitGroups(SQLExecutePrepareTemplate.java:67)<br>
at org.apache.shardingsphere.core.execute.sql.prepare.SQLExecutePrepareTemplate.getExecuteUnitGroups(SQLExecutePrepareTemplate.java:59)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:78)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:91)<br>
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:77)<br>
at org.apache.shardingsphere.shardingproxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:54)<br>
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:72)<br>
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:86)<br>
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:66)<br>
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<br>
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<br>
at java.lang.Thread.run(Thread.java:748)</p>
<p dir="auto"><a href="https://github.com/apache/incubator-shardingsphere/files/3495706/config-files.zip">config-files.zip</a></p>