another version of the fix.
Here i removed a loop that seems to be superfluous


mysql-test/r/derived.result:
  appropriate test result added
mysql-test/t/derived.test:
  test case for the bug 1727
sql/sql_lex.cc:
  we don't need loop here