dataalive commented on issue #8559: URL: https://github.com/apache/incubator-doris/issues/8559#issuecomment-1076035904
under version 0.15.9-rc09, it looks like: ``` mysql> select * from part A where A.p_name = "rose moccasin"; ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'p_partkey' in 'a' mysql> select * from part A where a.p_name = "rose moccasin"; ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'p_partkey' in 'a' mysql> select * from part a where a.p_name = "rose moccasin"; +-----------+---------------+--------+------------+-----------+------------+--------------------------+--------+-------------+ | p_partkey | p_name | p_mfgr | p_category | p_brand | p_color | p_type | p_size | p_container | +-----------+---------------+--------+------------+-----------+------------+--------------------------+--------+-------------+ | 94251 | rose moccasin | MFGR#1 | MFGR#15 | MFGR#1510 | forest | LARGE POLISHED COPPER | 22 | MED CAN | | 132258 | rose moccasin | MFGR#4 | MFGR#41 | MFGR#4123 | bisque | SMALL BURNISHED NICKEL | 46 | WRAP BAG | mysql> select * from part a where A.p_name = "rose moccasin"; +-----------+---------------+--------+------------+-----------+------------+--------------------------+--------+-------------+ | p_partkey | p_name | p_mfgr | p_category | p_brand | p_color | p_type | p_size | p_container | +-----------+---------------+--------+------------+-----------+------------+--------------------------+--------+-------------+ | 3187 | rose moccasin | MFGR#5 | MFGR#55 | MFGR#5529 | honeydew | SMALL POLISHED NICKEL | 1 | SM DRUM | | 10974 | rose moccasin | MFGR#1 | MFGR#12 | MFGR#1211 | steel | LARGE POLISHED BRASS | 29 | WRAP DRUM | | 55272 | rose moccasin | MFGR#3 | MFGR#33 | MFGR#3325 | seashell | MEDIUM PLATED COPPER | 32 | WRAP PKG | ``` And in 1.0.0-preview ``` mysql> select * from part C where c.p_name = "turquoise sandy"; +-----------+-----------------+--------+------------+-----------+------------+---------------------------+--------+-------------+ | p_partkey | p_name | p_mfgr | p_category | p_brand | p_color | p_type | p_size | p_container | +-----------+-----------------+--------+------------+-----------+------------+---------------------------+--------+-------------+ | 233418 | turquoise sandy | MFGR#1 | MFGR#14 | MFGR#1418 | lace | LARGE ANODIZED COPPER | 29 | LG PACK | ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
