Bug #14448 delimiter in 'prompt'

• Submitted: 28 Oct 2005 23:16
• Modified: 15 Aug 2006 3:34
• Reporter: Jeff C
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.0.15
• OS: Linux (RHEL3)
• Assigned to: Dean Ellis
• CPU Architecture: Any

[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.