select * vs select this

[jangorecki]

What's up?

There seems to be some inconsistency

This one works

from invoices
select invoices.*

all the others all failing

from invoices
select *

from invoices
select this.*

from invoices
select this

Based on how this is being used in other places, I would suggest that all three other forms could work as well.

Alternatively this could be more strictly defined, as sometimes it is alias for * (count this) and sometimes for a table name (join this). This is documented now and seems fine, but then all three forms above could be working then.