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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
