Description
In the current master branch, when users do not specify the database name in the `ALTER VIEW AS SELECT` command, we always try to alter the permanent view even if the temporary view exists.
The expected behavior of `ALTER VIEW AS SELECT` should be like: alters the temporary view if the temp view exists; otherwise, try to alter the permanent view. This order is consistent with another command `DROP VIEW`, since users are unable to specify the keyword TEMPORARY.