4 messages in com.mysql.lists.bugsSelf join queries on LOCKED TABLES| From | Sent On | Attachments |
|---|---|---|
| Hartmut Holzgraefe | 09 Jul 2002 08:07 | |
| Hartmut Holzgraefe | 09 Jul 2002 09:01 | |
| Michael Widenius | 28 Jul 2002 02:42 | |
| Hartmut Holzgraefe | 30 Jul 2002 05:32 |
| Subject: | Self join queries on LOCKED TABLES |
|---|---|
| From: | Hartmut Holzgraefe (hart...@hartmut.six.de) |
| Date: | 07/09/2002 08:07:12 AM |
| List: | com.mysql.lists.bugs |
Description:
an alias name for a locked table in a query is not recognized producing an
ERROR 1100: Table 'alias_name' was not locked with LOCK TABLES
error message
tested against 3.23.37 and 4.0.1
How-To-Repeat:
CREATE TABLE selfjoin(id int); LOCK TABLES selfjoin READ; SELECT t1.id, t2.id FROM selfjoin t1, selfjoin t2 WHERE t1.id=t2.id;
Fix:
Submitter-Id: <submitter ID> Originator: Organization: Six Offene Systeme GmbH
-- Hartmut Holzgraefe hart...@six.de http://www.six.de/ +49-711-99091-77
MySQL support: none
Synopsis: table alias names and locked tables
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-4.0.1-alpha-max (Official MySQL-max binary)
Server: /usr/local/mysql-max-4.0.1-alpha-pc-linux-gnu-i686/bin/mysqladmin Ver
8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686
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 4.0.1-alpha-max-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql4.sock Uptime: 7 days 6 hours 20 min 39 sec
Threads: 68 Questions: 88678 Slow queries: 22 Opens: 20210 Flush tables: 1
Open tables: 67 Queries per second avg: 0.141
Environment:
System: Linux hartmut 2.4.16 #8 Die Jan 15 14:57:44 CET 2002 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/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
-rwxr-xr-x 1 root root 1384168 Sep 20 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 25215580 Sep 20 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 20 2001 /usr/lib/libc.so
-rw-r--r-- 1 root root 856542 Sep 24 2001 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 20 Nov 12 2001 /usr/lib/libc-client.so
-> libc-client.so.2000c
-rwxr-xr-x 1 root root 718160 Sep 24 2001
/usr/lib/libc-client.so.2000c
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL-max binary' --with-extra-charsets=complex
--with-server-suffix=-max --enable-thread-safe-client --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared --with-berkeley-db --with-innodb