I expect an id and a lastname to be returned from the query, However only an id is returned.
It seems that the fieldresult annotation does not work.
If I use a different query: select id, lastname from employee, I get the lastname returned.
Below is the complete entity.
Does anyone have an idea what could be wrong?
It is just an example to try out the @field_result annotation.
I'm trying out all annotations, originally the mapping was as in your suggestion.
I deliberately changed the mapping/the query to be able to test the field_result annotation.
But I don't understand why it doesn't work.
I haven't tried this myself (may be later I'll try). But I think persistence provider has no idea of the field being a persistent field. You can verify this perhaps by persisting an entity of this with this code?