[GitHub] [incubator-doris] wubiaoi commented on issue #1864: Fix NPE error when creating table with bool column

[GitBox <gi...@apache.org>]

wubiaoi commented on issue #1864: Fix NPE error when creating table with bool column
URL: https://github.com/apache/incubator-doris/pull/1864#issuecomment-534866547
 
 
   @imay thanks for the comments.
   > For old version storage, we don't support boolean type.
   > What will happen if you patch is applied when creating boolean type.
   
   Now, creating boolean type will thrown NPE instead of a syntax error. 
   `ERROR 1064 (HY000): Unexpected exception: null`
   
   After applying this patch, the bool type will be supported similar to  mysql.
   eg.
   ```
   create table booltest
   (
   id boolean null, 
   value double sum null
   )
   engine=olap aggregate key(id) distributed by hash(id) buckets 6 properties("storage_type"="COLUMN","replication_num"="1");
   insert into booltest values(false,1.3);
   insert into booltest values(false,2.3);
   insert into booltest values(true,0.3);
   select * from booltest;
   ```
   id   | value 
   --- | ---
     1 | 0.3 
    0 | 3.6 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org