MC and VSQL shows different query results
Weird thing...I have a table with 3 rows.when I tried to insert into the table the rows through MC I got :Cannot insert into or update IDENTITY/AUTO_INCREMENT column "id". So I followed this ;
and I went to vsql and typed: SELECT set_optimizer_directives('AllowIdentityInsert=True');
after that I was able to insert to my table the 3 rows.
when I query vsql with select * from mytable I get all 3 rows but when I am in the MC and querying the same table I get 0 rows.I tried to refresh the MC but I have no idea why it shows me different query result.