Fix Engine Syntax in SHOW CREATE DATABASE for Memory Engine

Fix wrong engine syntax in result of SHOW CREATE DATABASE query for databases with engine Memory. This closes #34335. #34345 (alexey-milovidov).