liaoweisharp opened a new issue, #36450:
URL: https://github.com/apache/shardingsphere/issues/36450
**Known Conditions: **
Using ShardingSphere-Proxy version 5.5.2.
Created the sharding rule with the following statement:
CREATE SHARDING TABLE RULE UserScoreIncome(
STORAGE_UNITS(cpx_content_new),
SHARDING_COLUMN=BookID,
TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="3","null-handling-strategy"="NULL_IGNORED"))
);
When executing the following SQL statement, an error occurs:
mysql> insert into UserScoreIncome(ID, BookID) values('2', null);
ERROR 20020 (44000): Sharding value can not be null in SQL statement.
**My question is:**
How should I configure the sharding rule to ensure successful insertion
even when the sharding column (BookID) is null? I've heard that by default,
such records should be inserted into the first shard, but I don't know the
specific sharding rule configuration to achieve this.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
