Hi, Seems select statement without sharding key in the where clause will return all records from the tables from all sharded databases. Please have your help.
For example, if two sharded database has the same table and records, selecting from that table without sharding key in the where clause, all records from the two databases are returned which are duplicated. Is there some settings I need to put into the configuration? If it's a boardcast route because not hitting sharding key, the table is not sharded or any reason, is there some way I can return unique records without using "unique" in the original source query? Regards, Eric Poon
