In an exists query select * is harmless, select 1 and select * result in the same execution plan at least in MS SQL.
In a query than returns result rows it could break the query as soon as you add columns with names that already exist in other tables you joined in the query.
In a query than returns result rows it could break the query as soon as you add columns with names that already exist in other tables you joined in the query.