<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">4.0.0-RC1 error<br>
3.1.0 normal</p>
<h3 dir="auto">Which project did you use? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">sharding-jdbc</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">rewrite sql contains schema,so can right run.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">rewrite sql doesn't contain schema.</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<p dir="auto">I have three schemas: ds0, ds1, test<br>
test also default datasource</p>
<p dir="auto">at ds0 create table test_a:<br>
CREATE TABLE <code class="notranslate">test_a</code> (<br>
<code class="notranslate">name</code> varchar(20) DEFAULT NULL COMMENT '名称',<br>
<code class="notranslate">code</code> varchar(20) DEFAULT NULL COMMENT '编码',<br>
<code class="notranslate">id</code> varchar(36) NOT NULL DEFAULT '',<br>
PRIMARY KEY (<code class="notranslate">id</code>)<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8;</p>
<p dir="auto">at ds1 create table test_b:<br>
CREATE TABLE <code class="notranslate">test_b</code> (<br>
<code class="notranslate">name</code> varchar(20) DEFAULT NULL COMMENT '名称',<br>
<code class="notranslate">code</code> varchar(20) DEFAULT NULL COMMENT '编码',<br>
<code class="notranslate">id</code> varchar(36) NOT NULL DEFAULT '',<br>
PRIMARY KEY (<code class="notranslate">id</code>)<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8;</p>
<p dir="auto">at test execute sql (test_a, test_b all not sharding tables):<br>
select e.* from (<br>
SELECT<br>
c.<code class="notranslate">id</code> AS idStr,<br>
c.<code class="notranslate">code</code> AS <code class="notranslate">code</code>,<br>
c.<code class="notranslate">name</code> AS <code class="notranslate">name</code><br>
FROM<br>
<code class="notranslate">ds0</code>.<code class="notranslate">test_a</code> c<br>
UNION ALL<br>
SELECT<br>
<code class="notranslate">a</code>.<code class="notranslate">id</code> AS idStr,<br>
<code class="notranslate">a</code>.<code class="notranslate">code</code> AS <code class="notranslate">code</code>,<br>
<code class="notranslate">a</code>.<code class="notranslate">name</code> AS <code class="notranslate">name</code><br>
FROM<br>
<code class="notranslate">ds1</code>.<code class="notranslate">test_b</code> a<br>
) e</p>
<p dir="auto">error info as bellow:<br>
2019-10-31 09:25:36.838  INFO 9720 --- [nio-8084-exec-1] ShardingSphere-SQL                       : Actual SQL: test :::<br>
select e.* from (<br>
SELECT<br>
c.<code class="notranslate">id</code> AS idStr,<br>
c.<code class="notranslate">code</code> AS <code class="notranslate">code</code>,<br>
c.<code class="notranslate">name</code> AS <code class="notranslate">name</code><br>
FROM<br>
<code class="notranslate">test_a</code> c<br>
UNION ALL<br>
SELECT<br>
<code class="notranslate">a</code>.<code class="notranslate">id</code> AS idStr,<br>
<code class="notranslate">a</code>.<code class="notranslate">code</code> AS <code class="notranslate">code</code>,<br>
<code class="notranslate">a</code>.<code class="notranslate">name</code> AS <code class="notranslate">name</code><br>
FROM<br>
<code class="notranslate">test_b</code> a<br>
) e<br>
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.test_a' doesn't exist</p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<h2 dir="auto">Use version</h2>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="    &lt;dependency&gt;
        &lt;groupId&gt;org.apache.shardingsphere&lt;/groupId&gt;
        &lt;artifactId&gt;sharding-jdbc-spring-boot-starter&lt;/artifactId&gt;
        &lt;version&gt;4.0.0-RC3&lt;/version&gt;
    &lt;/dependency&gt;"><pre class="notranslate"><code class="notranslate">    &lt;dependency&gt;
        &lt;groupId&gt;org.apache.shardingsphere&lt;/groupId&gt;
        &lt;artifactId&gt;sharding-jdbc-spring-boot-starter&lt;/artifactId&gt;
        &lt;version&gt;4.0.0-RC3&lt;/version&gt;
    &lt;/dependency&gt;
</code></pre></div>
<hr>
<h2 dir="auto">Meeting problems</h2>
<h2 dir="auto">2019-12-01 23:08:28.800 ERROR 25132 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'create_time' from result set.  Cause: java.sql.SQLFeatureNotSupportedException: getObject with type</h2>
<h2 dir="auto">Object property is localdatetime ，Only date type is supported after testing，The time types of jdk8 are not supported .</h2>
<p dir="auto">LocalDate  type<br>
LocalTime type<br>
LocalDateTime type</p>
<p dir="auto">Throw exception when returning encapsulation as object from database</p>
<hr>
<h2 dir="auto">Hope to solve the bug</h2>