[GitHub] [incubator-shardingsphere] tristaZero commented on issue #2252: insert with generated keys,when the last column value is null，cause NullPointerException

[GitBox]

tristaZero commented on issue #2252: insert with generated keys,when the last 
column value is null，cause NullPointerException
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2252#issuecomment-486536874
 
 
   I did the following test, but no exception happened.
   **ShardingRule Configuration**
   ```
   shardingRule:
     tables:
       t_order:
         actualDataNodes: ds_${0..1}.t_order_${0..1}
         tableStrategy:
           inline:
             shardingColumn: order_id
             algorithmExpression: t_order_${order_id % 2}
         keyGenerator:
           type: SNOWFLAKE
           column: order_id
   ```
   **Table structure**
   ```
   CREATE TABLE `t_order_1` (
     `order_id` bigint(20) NOT NULL,
     `user_id` int(11) NOT NULL,
     `status` varchar(45) DEFAULT NULL,
     PRIMARY KEY (`order_id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   ```
   
   **SQL**
   ```
   insert into t_order values(1,null), (2,2);
   ```
   Do you think this example fits your scenario?
   
   By the way, can you set the props `sql.show=true`? So that we can view log 
to check the rewritten SQLs are correct or not.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services