Re: Multiple SQLi buffers? (Emacs 24.0, sql-mode 2.5)

[mmaug]

On Aug 19, 6:30 pm, Tim X <t...@nospam.dev.null> wrote:
> Wayne S <wstew...@marchex.com> writes:
> > WS> I upgraded emacs 20.3 to 20.4 (from emacs.orebokech.com).  I then
> > WS> ...
>
> > Whoops!  Make that emacs 23.x -> 24.0.
>
> Note that there has been a number of changes in thesql-mode bundled
> with emacs 24. In particular, MySQL connections can now use a port and
> hyou can define multiple connection 'names'.
>
> My guess would be that these changes have affected that old behavior. It
> could well be a bug or it could be that a different procedure is now
> required to do what you want. One way to work around the problem could
> be to define different connection names for connecting to the same
> database and see if that works.
>

There was, in fact, a bug introduced by an earlier patch -- the use of
sql-buffer had changed and caused these problems.   I restored the
previous usage but things got  awkward if you were using multiple sql-
product's so I had to check sql-product in situations it wasn't
necessary before.  The result is that the old sql-mysql/sql-rename-
buffer/sql-mysql will no longer create the second MySQL instance.
This is not properly documented in the code or in NEWS; I need to do
that soon.

You now may C-u M-x sql-mysql to guarantee a new buffer; without the C-
u it will try to locate an existing SQLi buffer running MySQL (if it
can't find one, it creates a new one).

Please let me know if you see any other odd behavior.  I am trying to
take sql-mode to another level with inspection capabilities but need
to be sure the base is solid.

Thanks