MySQL [hireez_sharding_db]> CREATE SHARDING TABLE RULE emailcampaign(
TABLE_STRATEGY(TYPE=standard,SHARDING_COLUMN="email_campaign_team_id",SHARDING_ALGORITHM="eamil_campaign_table_sharding_strategy"),KEY_GENERATE_STRATEGY(COLUMN="email_campaign_id",KEY_GENERATOR="snowflake"));
ERROR 1235 (42000): This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
算法已经定义过:
MySQL [hireez_sharding_db]> SHOW SHARDING ALGORITHMS\G;
*************************** 1. row ***************************
name: email_campaign_table_sharding_strategy
type: CLASS_BASED
props: algorithmClassName=com.hireez.EmailCampaignTableSharding,teamTableMapping=a::a$b::b$c::c$d::d$e::e,strategy=standard
1 row in set (0.002 sec)