<h2 dir="auto">Question</h2>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="&lt;sharding-jdbc.version&gt;4.1.0&lt;/sharding-jdbc.version&gt;

&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;${sharding-jdbc.version}&lt;/version&gt;
&lt;/dependency&gt;"><pre class="notranslate"><code class="notranslate">&lt;sharding-jdbc.version&gt;4.1.0&lt;/sharding-jdbc.version&gt;

&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;${sharding-jdbc.version}&lt;/version&gt;
&lt;/dependency&gt;
</code></pre></div>
<h3 dir="auto">mysql version</h3>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="show variables like '%version%';
INSERT INTO MY_TABLE(Variable_name, Value) VALUES ('version', '8.0.18');"><pre class="notranslate">show variables <span class="pl-k">like</span> <span class="pl-s"><span class="pl-pds">'</span>%version%<span class="pl-pds">'</span></span>;
<span class="pl-k">INSERT INTO</span> MY_TABLE(Variable_name, Value) <span class="pl-k">VALUES</span> (<span class="pl-s"><span class="pl-pds">'</span>version<span class="pl-pds">'</span></span>, <span class="pl-s"><span class="pl-pds">'</span>8.0.18<span class="pl-pds">'</span></span>);</pre></div>
<h3 dir="auto">question</h3>
<p dir="auto">I use mybatis and shardingsphere in my project.<br>
This is my sql</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="select *
from (select user_id as userId, rank_value as rankValue, row_number() over (order by rank_value desc) as seq
      from t_stat_rank_day
      where rank_type = 1
        and rank_day = '2020-10-16'
      order by rank_value desc, update_time
      limit 50) as go
where go.userId = 1594371406316000000;"><pre class="notranslate"><span class="pl-k">select</span> <span class="pl-k">*</span>
<span class="pl-k">from</span> (<span class="pl-k">select</span> user_id <span class="pl-k">as</span> userId, rank_value <span class="pl-k">as</span> rankValue, row_number() over (<span class="pl-k">order by</span> rank_value <span class="pl-k">desc</span>) <span class="pl-k">as</span> seq
      <span class="pl-k">from</span> t_stat_rank_day
      <span class="pl-k">where</span> rank_type <span class="pl-k">=</span> <span class="pl-c1">1</span>
        <span class="pl-k">and</span> rank_day <span class="pl-k">=</span> <span class="pl-s"><span class="pl-pds">'</span>2020-10-16<span class="pl-pds">'</span></span>
      <span class="pl-k">order by</span> rank_value <span class="pl-k">desc</span>, update_time
      <span class="pl-k">limit</span> <span class="pl-c1">50</span>) <span class="pl-k">as</span> go
<span class="pl-k">where</span> <span class="pl-c1">go</span>.<span class="pl-c1">userId</span> <span class="pl-k">=</span> <span class="pl-c1">1594371406316000000</span>;</pre></div>
<p dir="auto">But something error happens:</p>
<div class="highlight highlight-source-java notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="line 2:14 no viable alternative at input '(selectrow_number()over'
line 2:14 no viable alternative at input '(selectrow_number()over'
line 2:11 extraneous input '(' expecting ')'
line 2:14 mismatched input 'over' expecting {TRUNCATE, POSITION, VIEW, AS, ANY, OFFSET, BEGIN, COMMIT, ROLLBACK, SAVEPOINT, BOOLEAN, DATE, TIME, TIMESTAMP, YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, MICROSECOND, MAX, MIN, SUM, COUNT, AVG, CURRENT, ENABLE, DISABLE, INSTANCE, DO, DEFINER, CASCADED, LOCAL, CLOSE, OPEN, NEXT, NAME, TYPE, TABLES, TABLESPACE, COLUMNS, FIELDS, INDEXES, STATUS, MODIFY, VALUE, DUPLICATE, FIRST, LAST, AFTER, OJ, ACCOUNT, USER, ROLE, START, TRANSACTION, WITHOUT, ESCAPE, SUBPARTITION, STORAGE, SUPER, TEMPORARY, THAN, UNBOUNDED, SIGNED, UPGRADE, VALIDATION, ROLLUP, SOUNDS, UNKNOWN, OFF, ALWAYS, COMMITTED, LEVEL, NO, PASSWORD, PRIVILEGES, ACTION, ALGORITHM, AUTOCOMMIT, BTREE, CHAIN, CHARSET, CHECKSUM, CIPHER, CLIENT, COALESCE, COMMENT, COMPACT, COMPRESSED, COMPRESSION, CONNECTION, CONSISTENT, DATA, DISCARD, DISK, ENCRYPTION, END, ENGINE, EVENT, EXCHANGE, EXECUTE, FILE, FIXED, FOLLOWING, GLOBAL, HASH, IMPORT_, LESS, MEMORY, NONE, PARSER, PARTIAL, PARTITIONING, PERSIST, PRECEDING, PROCESS, PROXY, QUICK, REBUILD, REDUNDANT, RELOAD, REMOVE, REORGANIZE, REPAIR, REVERSE, SESSION, SHUTDOWN, SIMPLE, SLAVE, VISIBLE, INVISIBLE, ENFORCED, AGAINST, LANGUAGE, MODE, QUERY, EXTENDED, EXPANSION, VARIANCE, MAX_ROWS, MIN_ROWS, SQL_BIG_RESULT, SQL_BUFFER_RESULT, SQL_CACHE, SQL_NO_CACHE, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES, ROW_FORMAT, WEIGHT_STRING, COLUMN_FORMAT, INSERT_METHOD, KEY_BLOCK_SIZE, PACK_KEYS, PERSIST_ONLY, BIT_AND, BIT_OR, BIT_XOR, GROUP_CONCAT, JSON_ARRAYAGG, JSON_OBJECTAGG, STD, STDDEV, STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, AUTO_INCREMENT, AVG_ROW_LENGTH, DELAY_KEY_WRITE, ROTATE, MASTER, BINLOG, ERROR, SCHEDULE, COMPLETION, EVERY, HOST, SOCKET, PORT, SERVER, WRAPPER, OPTIONS, OWNER, RETURNS, CONTAINS, SECURITY, INVOKER, TEMPTABLE, MERGE, UNDEFINED, DATAFILE, FILE_BLOCK_SIZE, EXTENT_SIZE, INITIAL_SIZE, AUTOEXTEND_SIZE, MAX_SIZE, NODEGROUP, WAIT, LOGFILE, UNDOFILE, UNDO_BUFFER_SIZE, REDO_BUFFER_SIZE, HANDLER, PREV, ORGANIZATION, DEFINITION, DESCRIPTION, REFERENCE, FOLLOWS, PRECEDES, IMPORT, CONCURRENT, XML, DUMPFILE, SHARE, CODE, CONTEXT, SOURCE, CHANNEL, CLONE, AGGREGATE, INSTALL, COMPONENT, UNINSTALL, RESOURCE, EXPIRE, NEVER, HISTORY, OPTIONAL, REUSE, MAX_QUERIES_PER_HOUR, MAX_UPDATES_PER_HOUR, MAX_CONNECTIONS_PER_HOUR, MAX_USER_CONNECTIONS, RETAIN, RANDOM, OLD, ISSUER, SUBJECT, CACHE, GENERAL, SLOW, USER_RESOURCES, EXPORT, RELAY, HOSTS, FLUSH, RESET, RESTART, IO_THREAD, SQL_THREAD, SQL_BEFORE_GTIDS, SQL_AFTER_GTIDS, MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE, RELAY_LOG_POS, SQL_AFTER_MTS_GAPS, UNTIL, DEFAULT_AUTH, PLUGIN_DIR, STOP, IDENTIFIER_, STRING_}"><pre class="notranslate"><span class="pl-s1">line</span> <span class="pl-c1">2</span>:<span class="pl-c1">14</span> <span class="pl-s1">no</span> <span class="pl-smi">viable</span> <span class="pl-s1">alternative</span> <span class="pl-smi">at</span> <span class="pl-s1">input</span> <span class="pl-s">'(selectrow_number()over'</span>
<span class="pl-s1">line</span> <span class="pl-c1">2</span>:<span class="pl-c1">14</span> <span class="pl-s1">no</span> <span class="pl-s1">viable</span> <span class="pl-s1">alternative</span> <span class="pl-s1">at</span> <span class="pl-s1">input</span> <span class="pl-s">'(selectrow_number()over'</span>
<span class="pl-s1">line</span> <span class="pl-c1">2</span>:<span class="pl-c1">11</span> <span class="pl-s1">extraneous</span> <span class="pl-s1">input</span> <span class="pl-s">'('</span> <span class="pl-s1">expecting</span> <span class="pl-s">')'</span>
<span class="pl-s1">line</span> <span class="pl-c1">2</span>:<span class="pl-c1">14</span> <span class="pl-s1">mismatched</span> <span class="pl-s1">input</span> <span class="pl-s">'over'</span> <span class="pl-s1">expecting</span> {<span class="pl-c1">TRUNCATE</span>, <span class="pl-c1">POSITION</span>, <span class="pl-c1">VIEW</span>, <span class="pl-c1">AS</span>, <span class="pl-c1">ANY</span>, <span class="pl-c1">OFFSET</span>, <span class="pl-c1">BEGIN</span>, <span class="pl-c1">COMMIT</span>, <span class="pl-c1">ROLLBACK</span>, <span class="pl-c1">SAVEPOINT</span>, <span class="pl-c1">BOOLEAN</span>, <span class="pl-c1">DATE</span>, <span class="pl-c1">TIME</span>, <span class="pl-c1">TIMESTAMP</span>, <span class="pl-c1">YEAR</span>, <span class="pl-c1">QUARTER</span>, <span class="pl-c1">MONTH</span>, <span class="pl-c1">WEEK</span>, <span class="pl-c1">DAY</span>, <span class="pl-c1">HOUR</span>, <span class="pl-c1">MINUTE</span>, <span class="pl-c1">SECOND</span>, <span class="pl-c1">MICROSECOND</span>, <span class="pl-c1">MAX</span>, <span class="pl-c1">MIN</span>, <span class="pl-c1">SUM</span>, <span class="pl-c1">COUNT</span>, <span class="pl-c1">AVG</span>, <span class="pl-c1">CURRENT</span>, <span class="pl-c1">ENABLE</span>, <span class="pl-c1">DISABLE</span>, <span class="pl-c1">INSTANCE</span>, <span class="pl-c1">DO</span>, <span class="pl-c1">DEFINER</span>, <span class="pl-c1">CASCADED</span>, <span class="pl-c1">LOCAL</span>, <span class="pl-c1">CLOSE</span>, <span class="pl-c1">OPEN</span>, <span class="pl-c1">NEXT</span>, <span class="pl-c1">NAME</span>, <span class="pl-c1">TYPE</span>, <span class="pl-c1">TABLES</span>, <span class="pl-c1">TABLESPACE</span>, <span class="pl-c1">COLUMNS</span>, <span class="pl-c1">FIELDS</span>, <span class="pl-c1">INDEXES</span>, <span class="pl-c1">STATUS</span>, <span class="pl-c1">MODIFY</span>, <span class="pl-c1">VALUE</span>, <span class="pl-c1">DUPLICATE</span>, <span class="pl-c1">FIRST</span>, <span class="pl-c1">LAST</span>, <span class="pl-c1">AFTER</span>, <span class="pl-c1">OJ</span>, <span class="pl-c1">ACCOUNT</span>, <span class="pl-c1">USER</span>, <span class="pl-c1">ROLE</span>, <span class="pl-c1">START</span>, <span class="pl-c1">TRANSACTION</span>, <span class="pl-c1">WITHOUT</span>, <span class="pl-c1">ESCAPE</span>, <span class="pl-c1">SUBPARTITION</span>, <span class="pl-c1">STORAGE</span>, <span class="pl-c1">SUPER</span>, <span class="pl-c1">TEMPORARY</span>, <span class="pl-c1">THAN</span>, <span class="pl-c1">UNBOUNDED</span>, <span class="pl-c1">SIGNED</span>, <span class="pl-c1">UPGRADE</span>, <span class="pl-c1">VALIDATION</span>, <span class="pl-c1">ROLLUP</span>, <span class="pl-c1">SOUNDS</span>, <span class="pl-c1">UNKNOWN</span>, <span class="pl-c1">OFF</span>, <span class="pl-c1">ALWAYS</span>, <span class="pl-c1">COMMITTED</span>, <span class="pl-c1">LEVEL</span>, <span class="pl-c1">NO</span>, <span class="pl-c1">PASSWORD</span>, <span class="pl-c1">PRIVILEGES</span>, <span class="pl-c1">ACTION</span>, <span class="pl-c1">ALGORITHM</span>, <span class="pl-c1">AUTOCOMMIT</span>, <span class="pl-c1">BTREE</span>, <span class="pl-c1">CHAIN</span>, <span class="pl-c1">CHARSET</span>, <span class="pl-c1">CHECKSUM</span>, <span class="pl-c1">CIPHER</span>, <span class="pl-c1">CLIENT</span>, <span class="pl-c1">COALESCE</span>, <span class="pl-c1">COMMENT</span>, <span class="pl-c1">COMPACT</span>, <span class="pl-c1">COMPRESSED</span>, <span class="pl-c1">COMPRESSION</span>, <span class="pl-c1">CONNECTION</span>, <span class="pl-c1">CONSISTENT</span>, <span class="pl-c1">DATA</span>, <span class="pl-c1">DISCARD</span>, <span class="pl-c1">DISK</span>, <span class="pl-c1">ENCRYPTION</span>, <span class="pl-c1">END</span>, <span class="pl-c1">ENGINE</span>, <span class="pl-c1">EVENT</span>, <span class="pl-c1">EXCHANGE</span>, <span class="pl-c1">EXECUTE</span>, <span class="pl-c1">FILE</span>, <span class="pl-c1">FIXED</span>, <span class="pl-c1">FOLLOWING</span>, <span class="pl-c1">GLOBAL</span>, <span class="pl-c1">HASH</span>, <span class="pl-c1">IMPORT_</span>, <span class="pl-c1">LESS</span>, <span class="pl-c1">MEMORY</span>, <span class="pl-c1">NONE</span>, <span class="pl-c1">PARSER</span>, <span class="pl-c1">PARTIAL</span>, <span class="pl-c1">PARTITIONING</span>, <span class="pl-c1">PERSIST</span>, <span class="pl-c1">PRECEDING</span>, <span class="pl-c1">PROCESS</span>, <span class="pl-c1">PROXY</span>, <span class="pl-c1">QUICK</span>, <span class="pl-c1">REBUILD</span>, <span class="pl-c1">REDUNDANT</span>, <span class="pl-c1">RELOAD</span>, <span class="pl-c1">REMOVE</span>, <span class="pl-c1">REORGANIZE</span>, <span class="pl-c1">REPAIR</span>, <span class="pl-c1">REVERSE</span>, <span class="pl-c1">SESSION</span>, <span class="pl-c1">SHUTDOWN</span>, <span class="pl-c1">SIMPLE</span>, <span class="pl-c1">SLAVE</span>, <span class="pl-c1">VISIBLE</span>, <span class="pl-c1">INVISIBLE</span>, <span class="pl-c1">ENFORCED</span>, <span class="pl-c1">AGAINST</span>, <span class="pl-c1">LANGUAGE</span>, <span class="pl-c1">MODE</span>, <span class="pl-c1">QUERY</span>, <span class="pl-c1">EXTENDED</span>, <span class="pl-c1">EXPANSION</span>, <span class="pl-c1">VARIANCE</span>, <span class="pl-c1">MAX_ROWS</span>, <span class="pl-c1">MIN_ROWS</span>, <span class="pl-c1">SQL_BIG_RESULT</span>, <span class="pl-c1">SQL_BUFFER_RESULT</span>, <span class="pl-c1">SQL_CACHE</span>, <span class="pl-c1">SQL_NO_CACHE</span>, <span class="pl-c1">STATS_AUTO_RECALC</span>, <span class="pl-c1">STATS_PERSISTENT</span>, <span class="pl-c1">STATS_SAMPLE_PAGES</span>, <span class="pl-c1">ROW_FORMAT</span>, <span class="pl-c1">WEIGHT_STRING</span>, <span class="pl-c1">COLUMN_FORMAT</span>, <span class="pl-c1">INSERT_METHOD</span>, <span class="pl-c1">KEY_BLOCK_SIZE</span>, <span class="pl-c1">PACK_KEYS</span>, <span class="pl-c1">PERSIST_ONLY</span>, <span class="pl-c1">BIT_AND</span>, <span class="pl-c1">BIT_OR</span>, <span class="pl-c1">BIT_XOR</span>, <span class="pl-c1">GROUP_CONCAT</span>, <span class="pl-c1">JSON_ARRAYAGG</span>, <span class="pl-c1">JSON_OBJECTAGG</span>, <span class="pl-c1">STD</span>, <span class="pl-c1">STDDEV</span>, <span class="pl-c1">STDDEV_POP</span>, <span class="pl-c1">STDDEV_SAMP</span>, <span class="pl-c1">VAR_POP</span>, <span class="pl-c1">VAR_SAMP</span>, <span class="pl-c1">AUTO_INCREMENT</span>, <span class="pl-c1">AVG_ROW_LENGTH</span>, <span class="pl-c1">DELAY_KEY_WRITE</span>, <span class="pl-c1">ROTATE</span>, <span class="pl-c1">MASTER</span>, <span class="pl-c1">BINLOG</span>, <span class="pl-c1">ERROR</span>, <span class="pl-c1">SCHEDULE</span>, <span class="pl-c1">COMPLETION</span>, <span class="pl-c1">EVERY</span>, <span class="pl-c1">HOST</span>, <span class="pl-c1">SOCKET</span>, <span class="pl-c1">PORT</span>, <span class="pl-c1">SERVER</span>, <span class="pl-c1">WRAPPER</span>, <span class="pl-c1">OPTIONS</span>, <span class="pl-c1">OWNER</span>, <span class="pl-c1">RETURNS</span>, <span class="pl-c1">CONTAINS</span>, <span class="pl-c1">SECURITY</span>, <span class="pl-c1">INVOKER</span>, <span class="pl-c1">TEMPTABLE</span>, <span class="pl-c1">MERGE</span>, <span class="pl-c1">UNDEFINED</span>, <span class="pl-c1">DATAFILE</span>, <span class="pl-c1">FILE_BLOCK_SIZE</span>, <span class="pl-c1">EXTENT_SIZE</span>, <span class="pl-c1">INITIAL_SIZE</span>, <span class="pl-c1">AUTOEXTEND_SIZE</span>, <span class="pl-c1">MAX_SIZE</span>, <span class="pl-c1">NODEGROUP</span>, <span class="pl-c1">WAIT</span>, <span class="pl-c1">LOGFILE</span>, <span class="pl-c1">UNDOFILE</span>, <span class="pl-c1">UNDO_BUFFER_SIZE</span>, <span class="pl-c1">REDO_BUFFER_SIZE</span>, <span class="pl-c1">HANDLER</span>, <span class="pl-c1">PREV</span>, <span class="pl-c1">ORGANIZATION</span>, <span class="pl-c1">DEFINITION</span>, <span class="pl-c1">DESCRIPTION</span>, <span class="pl-c1">REFERENCE</span>, <span class="pl-c1">FOLLOWS</span>, <span class="pl-c1">PRECEDES</span>, <span class="pl-c1">IMPORT</span>, <span class="pl-c1">CONCURRENT</span>, <span class="pl-c1">XML</span>, <span class="pl-c1">DUMPFILE</span>, <span class="pl-c1">SHARE</span>, <span class="pl-c1">CODE</span>, <span class="pl-c1">CONTEXT</span>, <span class="pl-c1">SOURCE</span>, <span class="pl-c1">CHANNEL</span>, <span class="pl-c1">CLONE</span>, <span class="pl-c1">AGGREGATE</span>, <span class="pl-c1">INSTALL</span>, <span class="pl-c1">COMPONENT</span>, <span class="pl-c1">UNINSTALL</span>, <span class="pl-c1">RESOURCE</span>, <span class="pl-c1">EXPIRE</span>, <span class="pl-c1">NEVER</span>, <span class="pl-c1">HISTORY</span>, <span class="pl-c1">OPTIONAL</span>, <span class="pl-c1">REUSE</span>, <span class="pl-c1">MAX_QUERIES_PER_HOUR</span>, <span class="pl-c1">MAX_UPDATES_PER_HOUR</span>, <span class="pl-c1">MAX_CONNECTIONS_PER_HOUR</span>, <span class="pl-c1">MAX_USER_CONNECTIONS</span>, <span class="pl-c1">RETAIN</span>, <span class="pl-c1">RANDOM</span>, <span class="pl-c1">OLD</span>, <span class="pl-c1">ISSUER</span>, <span class="pl-c1">SUBJECT</span>, <span class="pl-c1">CACHE</span>, <span class="pl-c1">GENERAL</span>, <span class="pl-c1">SLOW</span>, <span class="pl-c1">USER_RESOURCES</span>, <span class="pl-c1">EXPORT</span>, <span class="pl-c1">RELAY</span>, <span class="pl-c1">HOSTS</span>, <span class="pl-c1">FLUSH</span>, <span class="pl-c1">RESET</span>, <span class="pl-c1">RESTART</span>, <span class="pl-c1">IO_THREAD</span>, <span class="pl-c1">SQL_THREAD</span>, <span class="pl-c1">SQL_BEFORE_GTIDS</span>, <span class="pl-c1">SQL_AFTER_GTIDS</span>, <span class="pl-c1">MASTER_LOG_FILE</span>, <span class="pl-c1">MASTER_LOG_POS</span>, <span class="pl-c1">RELAY_LOG_FILE</span>, <span class="pl-c1">RELAY_LOG_POS</span>, <span class="pl-c1">SQL_AFTER_MTS_GAPS</span>, <span class="pl-c1">UNTIL</span>, <span class="pl-c1">DEFAULT_AUTH</span>, <span class="pl-c1">PLUGIN_DIR</span>, <span class="pl-c1">STOP</span>, <span class="pl-c1">IDENTIFIER_</span>, <span class="pl-c1">STRING_</span>}</pre></div>
<p dir="auto">I want to get the rank by using <code class="notranslate">row_number</code>, even if I use another way for example</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="
select *
from (select a.*, @rank := @rank + 1 As seq
      from (select @rank := 0, user_id, rank_value as rankValue
            from hoho_trade.t_stat_rank_day
            where rank_type = 1
              and rank_day = '2020-10-15'
            order by rank_value desc, update_time
            limit 50) as a
     ) b
where user_id = 1594371406316000000;"><pre class="notranslate"><span class="pl-k">select</span> <span class="pl-k">*</span>
<span class="pl-k">from</span> (<span class="pl-k">select</span> a.<span class="pl-k">*</span>, @rank :<span class="pl-k">=</span> @rank <span class="pl-k">+</span> <span class="pl-c1">1</span> <span class="pl-k">As</span> seq
      <span class="pl-k">from</span> (<span class="pl-k">select</span> @rank :<span class="pl-k">=</span> <span class="pl-c1">0</span>, user_id, rank_value <span class="pl-k">as</span> rankValue
            <span class="pl-k">from</span> <span class="pl-c1">hoho_trade</span>.<span class="pl-c1">t_stat_rank_day</span>
            <span class="pl-k">where</span> rank_type <span class="pl-k">=</span> <span class="pl-c1">1</span>
              <span class="pl-k">and</span> rank_day <span class="pl-k">=</span> <span class="pl-s"><span class="pl-pds">'</span>2020-10-15<span class="pl-pds">'</span></span>
            <span class="pl-k">order by</span> rank_value <span class="pl-k">desc</span>, update_time
            <span class="pl-k">limit</span> <span class="pl-c1">50</span>) <span class="pl-k">as</span> a
     ) b
<span class="pl-k">where</span> user_id <span class="pl-k">=</span> <span class="pl-c1">1594371406316000000</span>;</pre></div>
<p dir="auto">That appears the same mismatch error.<br>
What can I do?<br>
Thanks sincerely!</p>
<h2 dir="auto">Bug Report</h2>
<blockquote>
<p dir="auto">ERROR Maxwell - SQLException: No database selected</p>
</blockquote>
<p dir="auto">When I use shardingproxy connect maxwell , It throw this error ,and maxwell could not start<br>
When I use proxysql or mysql cli connect maxwell, It run OK.</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">Mysql version: 5.7.21<br>
Maxwell version: 1.26.4<br>
Shardingproxy version: 4.1.1</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">step as below</h3>
<p dir="auto"><code class="notranslate"> ./maxwell --client_id="maxwell" --user='maxwell' --host='xx.xx.xx.11' --password="xxxxxxx" --port='23306' --log_level=DEBUG --producer=stdout --filter=exclude:*.*,include:db1.tb1.*</code></p>
<blockquote>
<p dir="auto">Using kafka version: 1.0.0<br>
11:11:45,421 ERROR Maxwell - SQLException: No database selecte</p>
</blockquote>