>Description:
I needed more than 15 joins for one statement so I changed table_map type
to ulonglong. First everything worked fine for 3-5 hours. But later some
left joins sttopped working. With one particular table.
Since this is not an official way to go this may be considered not a bug.
But it obviously indicates the problem in the code. It's not type-clean
somewhere.
>How-To-Repeat:
Don't have the exact recipie. But set this variable to ulonglong and run
lots of complex statements. Some of them may stop working after a while.
>Fix:
N/A
>Submitter-Id: <submitter ID>
>Originator: Yuri Victorovich
>Organization:
Optima Inc.
>MySQL support: none
>Synopsis: option of 31 joins per statement doen't work cleanly
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (FreeBSD port: mysql-server-3.23.51)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.51, for portbld-freebsd4.5
>on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.51
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 50 min 6 sec
Threads: 3 Questions: 578 Slow queries: 0 Opens: 197 Flush tables: 1 Open tables:
64 Queries per second avg: 0.087
>Environment:
System: FreeBSD s1.optima-inc.us 4.6-STABLE FreeBSD 4.6-STABLE #1: Mon Jul 29 17:53:48
EDT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1219086 Jul 29 16:21 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Jul 29 16:21 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 575632 Jul 29 16:21 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.51'
--program-prefix= --enable-assembler --with-berkeley-db --with-innodb
--prefix=/usr/local i386-portbld-freebsd4.6 'CFLAGS=-O -pipe ' CXX=cc
host_alias=i386-portbld-freebsd4.6 build_alias=i386-portbld-freebsd4.6
target_alias=i386-portbld-freebsd4.6 CC=cc 'CXXFLAGS=-O -pipe -felide-constructors
-fno-rtti -fno-exceptions'
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
