Bug #14448 delimiter in 'prompt'
Submitted: 29 Oct 2005 1:16 Modified: 15 Aug 2006 5:34
Reporter: Jeff C
Status: Closed
Category:Server Severity:S4 (Feature request)
Version:5.0.15 OS:Linux (RHEL3)
Assigned to: Dean Ellis Target Version:
Triage: D5 (Feature request)

[29 Oct 2005 1:16] Jeff C 
Description:
I want to have the current delimiter in the prompt so that I can know at a glance which is
set.

For example, my prompt now:
(root@localhost) [test]> 

I would like to have the current delimiter setting in that prompt... example:
(root@localhost) (||) [test]>  <-- if the delimiter were ||
(root@localhost) (;) [test]>   <-- if the delimiter were ; 

I don't see a setting for the current delimiter in :
http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html

Perhaps someone can add a setting so I can change my prompt to reflect the current
delimiter.

Thanks,
Jeff

How to repeat:
n/a

Suggested fix:
n/a
[29 Oct 2005 1:39] Jeff C 
Therion pumped out a patch within a few minutes.. he's quite impressive to say the
least...

<Therion> +      case 'l':
<Therion> +      {
<Therion> +       processed_prompt.append(delimiter_str);
<Therion> +       break;
<Therion> +      }

Hopefully it gets committed for 5.0.16 and gets documented.

Thanks Therion.
[29 Oct 2005 1:47] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31641
[18 Jul 2006 22:18] Chad MILLER 
Docs team:  Take note of this change.
[19 Jul 2006 20:35] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/9346
[20 Jul 2006 0:02] Chad MILLER 
Pushed to 5.0-maint team tree.
[3 Aug 2006 18:45] Magnus Svensson 
Pushed to 5.0.25
[3 Aug 2006 19:59] Paul DuBois 
Noted in 5.0.25 changelog.

The mysql client now allows \l in the prompt command argument
to insert the current delimiter into the prompt.
[14 Aug 2006 22:59] Konstantin Osipov 
Merged into 5.1.12
[15 Aug 2006 5:34] Paul DuBois 
Noted in 5.1.12 changelog.