Here’s the query:
select email,‘char’ from t_table_name;
runs fine. But when I add a space after email and before the following comma, the result set has 3 columns: email, ROWID, and ‘char’. the data in the ROWID column are of the “AAAIyWAAHAAAAU…” variety. I’m assuming its some sort of settings on SQL nav (Release 220.127.116.118) combined with the single quote following the “space comma”.
I’m pulling my hair out over this. The error happens on one of my coworkers machine, as well as mine, but not on others. Please Help!!!
Also on the two ‘offending’ machines, we don’t get any concatenation with this query:
SELECT substr(email,0,length(email)-8)||‘newdomain.com’ FROM t_users;