>Description:
        When selecting from multiple recently added tables, mysql returned a "table 
does not exist error".
        table blatantly exists, i recently added it.

        nb: output from mysql (and mysqlbug) sanitized to protect IP.
>How-To-Repeat:
mysql> show tables;
+---------------+
| Tables_in_dba |
+---------------+
| co_info       |
| doc_user_info |
+---------------+
15 rows in set (0.00 sec)

mysql> select doc_user_info.id as did, co_info.id as cid, co_info.name as cname, 
doc_user_info.username from doc_user_info du,co_info co where co.id=du.id and du.id > 
150 and du.id < 200 order by du.id;
ERROR 1109: Unknown table 'doc_user_info' in field list
mysql> 

>Fix:
        no idea.

>Submitter-Id:  <submitter ID>
>Originator:    root
>Organization:
 Wherewithal inc
>MySQL support: none - yet
>Synopsis:      mysql fails to recognise tables
>Severity:      critical
>Priority:      high
>Category:      mysql
>Class:         sw-bug
>Release:       mysql-4.0.1-alpha (Official MySQL binary)

>Environment:
System: Linux <host sanitized> 2.4.8-26mdkenterprise #1 SMP Sun Sep 23 16:36:00 CEST 
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/i586-mandrake-linux-gnu/2.96/specs
gcc version 2.96 20000731 (Mandrake Linux 8.1 2.96-0.62mdk)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentium '  CXX='gcc'  CXXFLAGS='-O3 
-mpentium  -felide-constructors'  LDFLAGS='-static'
LIBC: 
lrwxrwxrwx    1 root     root           13 Feb 21 20:07 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x    1 root     root      1285480 Sep  9 19:57 /lib/libc-2.2.4.so
-rw-r--r--    1 root     root     27487418 Sep  9 19:30 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 Sep  9 19:30 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL binary' --with-extra-charsets=complex --with-server-suffix= 
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --disable-shared

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

Reply via email to