LOVEGISER commented on issue #9544:
URL:
https://github.com/apache/incubator-doris/issues/9544#issuecomment-1125774002
1. i am run this sql command in Doris version 1.0.0-rc03-8b9a70c , the
result is correct,try to update to this version.
mysql> select count(left_table.device_id), rt.device_name from left_table
left join right_table rt
on left_table.device_id = rt.device_id where rt.device_name is null group by
rt.device_name order by rt.device_name ;
+---------------------------------+-------------+
| count(`left_table`.`device_id`) | device_name |
+---------------------------------+-------------+
| 3 | NULL |
+---------------------------------+-------------+
1 row in set (0.03 sec)
--
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]
