marising edited a comment 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 test alter table add double key 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
