[GitHub] [incubator-doris] marising commented on pull request #3738: [Bug]fix the crash of checksum task #3735

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

marising commented on pull request #3738:
URL: https://github.com/apache/incubator-doris/pull/3738#issuecomment-636877119


   It's very confusing for me，doris does not support the key column as double or float，but I've met twice. 
   
   1. I create table and alter table add column
   MySQL [checksum]> alter table catalog_sales modify column `cs_sales_price` double KEY null after `cs_item_sk`;
   ERROR 1064 (HY000): Float or double can not used as a key, use decimal instead.
   
   2. The table of customer
   alter table add column xxx double key null after xxx，but no error message and execute success!
   
   MySQL [search]> desc  xxx_sku_AB;
   +--------------+-------------+------+-------+---------+-----------+
   | Field        | Type        | Null | Key   | Default | Extra     |
   +--------------+-------------+------+-------+---------+-----------+
   ...
   | price        | DOUBLE      | Yes  | true  | N/A     |           |
   ....
   +--------------+-------------+------+-------+---------+-----------
   


----------------------------------------------------------------
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



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