I have this test, and MySQL node does give the same query
I just test this query, it gives 2 different data when the node is the same
- It run alone
- It run with other node before connected
If run these 2 same copy nodes which connect them together, the same issue happened!
It seems alone node and connected node has issues with some of query syntax:
- Alone: right data of query
- Connected: wrong data, with so many other duplicated rows