Last updated: 2020-05-11 14:32:54

If you want to view or download the full set of development documents, please see Development Guide for TDSQL.

TDSQL currently only supports derived tables with shardkey.

    mysql> select a from (select * from test1) as t;
    ERROR 7012 (HY000): Proxy ERROR:sql should has one shardkey
    mysql> select a from (select * from test1 where a=1) as t;
    | a |
    | 1 |
    1 row in set (0.00 sec)

Was this page helpful?

Was this page helpful?

  • Not at all
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful
Send Feedback