Re-execute the previous query

[Ben-Zvi]

Wish there was a way to re-run the previous query. Can be helpful with multi-line queries that cannot easily be cut-n-paste.
Even better - specify an offset, like running the query before the last, or before that, like:
!rerun (same as !rerun-1)
!rerun-2
!rerun-3

[julianhyde]

Have you tried up-arrow?

[marcprux]

I think the OP may be referring specifically to multi-line queries. jline (and thus sqlline) is not multi-line command-aware, so "SELECT \n CURRENT_TIMESTAMP;" followed by up-arrow will only re-populate "CURRENT_TIMESTAMP;" on the command line. It's been a long-time irritation for me, but I don't think sqlline can address it without a fix on the jline side.

…

On Apr 6, 2018, at 19:07, Julian Hyde ***@***.***> wrote: Have you tried up-arrow? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[Ben-Zvi]

Need to upgrade to a newer JLine (see jline/jline3#36 )

[vdiravka]

Looks like update of SQLine JLine 2.14.4 to 3.9.0 version is not trivial task and requires a good knowledge of SQLine and JLine.

[snuyanzin]

Currently from time to time I'm doing some activity on moving to use to jline3 and this and some other features seems to be working there [1]. However there are still several issues like support jline2 history files, non-working jline's less on Windows and etc. Also it requires moving to jdk 1.8.
Any help is appreciated.
I do not think it will be ready for 1.5.0 but as soon as the main issues will be resolved I will make a PR
[1] https://github.com/snuyanzin/sqlline/tree/JLINE3

[snuyanzin]

Added implementation of !rerun (also !/ is possible by analogy with Oracle sqlplus) in #115
Please have a look and review

[julianhyde]

Fixed in bf495f9, PR #155. Thanks @snuyanzin!