Use qualify row_number() ... not support select *

[wmtbnbo]

When I execute the following SQL statement.

select a.* from tablea a qualify row_number() over (partition by a.id order by a.date desc) = 1;

I will receive an exception message.

ERROR 1064 (HY000): Getting syntax error. Detail message: Can't support result other than column..

Adjust the statement to
select a.id,a.name from tablea a qualify row_number() over (partition by a.id order by a.date desc) = 1;

The statement can run normally.

[wangsimo0]

good enhancement