In the SQL Editor I’m trying to run a simple command (select * from table where uid=‘slnfdln320fjes’) however, this returns a success of 0 rows which doesn’t make sense because I ran (select * from table) and copied that uid from the result of 2000 rows.
I did the same commands with another table in my database and it worked.
The only difference is that the type of column may be different (dict encoded str v str) but I couldn’t check that because I’m not sure which command to use (tried NFORMATION_SCHEMA.COLUMNS and sys.columns).
So 2 questions I guess:
How do you check the attribute type using the SQL Editor?
Is there a reason my command won’t return a row? Does it have to do with it being a dict encoded str?