Bug #14448 delimiter in 'prompt'
Submitted: 28 Oct 2005 23:16 Modified: 15 Aug 2006 3:34
Reporter: Jeff C Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.15 OS:Linux (RHEL3)
Assigned to: Dean Ellis CPU Architecture:Any
Triage: D5 (Feature request)

[28 Oct 2005 23: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
[28 Oct 2005 23: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.
[28 Oct 2005 23: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 20:18] Chad MILLER
Docs team:  Take note of this change.
[19 Jul 2006 18: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
[19 Jul 2006 22:02] Chad MILLER
Pushed to 5.0-maint team tree.
[3 Aug 2006 16:45] Magnus BlÄudd
Pushed to 5.0.25
[3 Aug 2006 17: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 20:59] Konstantin Osipov
Merged into 5.1.12
[15 Aug 2006 3:34] Paul Dubois
Noted in 5.1.12 changelog.