MySQL Bugs: #3616: Up arrow should scroll through statements, not lines

Bug #3616	Up arrow should scroll through statements, not lines
Submitted:	30 Apr 2004 19:07	Modified:	30 Apr 2004 22:25
Reporter:	Nick Sullivan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	all	OS:	Any (all)
Assigned to:		CPU Architecture:	Any

Description:
When using the command line interface for mysql, the history is great. But it's a pain if you are using multi line sql statements. It makes sense to me that if you hit up arrow, you should see get the entire previous statement, not just the previous line.

How to repeat:
1) mysql -h yourhost -D yourdatabase
2) Input a mutiline sql statement.
3) Hit "up arrow". You will only get the last line from your previous statement, making reissuing the previous statement or editing the previous statement impossible.

Suggested fix:
History entries should be recorded by statement, not by line, so when you hit up arrow, you get the entire previous sql statement.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

done already (will be in 4.1.2)