If you set Admin->Views->Condition 1 to highlight
<> '' (that is two single quotes)
Then when you try and edit this view it lists the
condition as ' (just one single quote)
If you hit Update, it then generates a syntax error.
I think this is two bugs, the first that turns two
quotes into one, and the second that refuses to accept
a single quote in that field (IA single quote is an
error, but it shouldn't be a SQL error when updating
the view.
Either way, the condition doesn't seem to actually
work - but I think these bugs are valid even if I have
the syntax wrong.