After upgraded to version 6.0.1 some of my queries response incorrect result.
The first issue is: select count( fieldId) response incorrect result.
select count(agentCode) as total from agent where typekey = “AgentProfile” --> get ‘total’ value is 0, expected result is 6391.
The previous version is response correct result.
Field id and meta().id have the same value.
When I join this table with other table using field id response data is blank . However, when using field meta.id() to join table the response data is correct