Sinisa Milivojevic wrote:
>
> Greg Cope writes:
> > >Description:
> > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> > a nice list of blanks - no of blank lines
> > equals number of databases / tables)
> >
> > >How-To-Repeat:
> > Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
> >
> > >Fix:
> >
> > >Submitter-Id: <submitter ID>
> > >Originator: Greg Cope
> > >Organization:
> > <organization of PR author (multiple lines)>
> > >MySQL support: none
> > >Synopsis: SHOW command possiblxky broken in 3.23.33
> > >Severity: non-critical
> > >Priority: low
> > >Category: mysql
> > >Class: sw-bug
> > >Release: mysql-3.23.33 (Source distribution)
> >
> > >Environment:
> > <machine, os, target, libraries (multiple lines)>
> > System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50
> > EST 2001 i686 unknown
> > Architecture: i686
> >
> > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> > /usr/bin/cc
> > GCC: Reading specs from
> > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> > Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math
> > -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro
> > -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double
> > -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions
> > -march=pentiumpro -fomit-frame-pointer' LDFLAGS=''
> > LIBC:
> > lrwxrwxrwx 1 root root 13 Feb 13 10:46 /lib/libc.so.6
> > -> libc-2.1.3.so
> > -rwxr-xr-x 1 root root 4101836 Jan 15 15:49
> > /lib/libc-2.1.3.so
> > -rw-r--r-- 1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
> > -rw-r--r-- 1 root root 178 Jan 15 15:49 /usr/lib/libc.so
> > Configure command: ./configure --prefix=/usr/local/mysql-3.23.33
> > --enable-assembler --with-mysqld-ldflags=-all-static
> > --with-mysqld-user=mysql --localstatedir=/var/lib/mysql
> > --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql
> > --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man
> > --without-debug --without-bench
> > Perl: This is perl, version 5.005_03 built for i386-linux
> >
>
> Hi!
>
> As there are so many reports, we shall investigate a problem.
>
> Regards,
>
> Sinisa
Thanks for the reply.
I've narrowed this down to a possible issue with the mysqld binary - as
I've two versions of mysql on my machine - 3.23.32 and .33.
If I fire up .32 everything is fine.
If I fire up .33 everthing appears fine until you do a "SHOW" command.
Both binaries are setup with the same configure line and hence share the
same data dirs (althought not at the same time ;-)
Thanks again.
Greg
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
