5.0.92: USING table alias - fals
Hi everyone.
Right now i'm using MySQL 5.0.92 (Because of replication from 4.0 version. I can't change that version, so I can't update this one).
Here is test-case:
yavin# jexec 32 mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 430
Server version: 5.0.92 FreeBSD port: mysql-server-5.0.92
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> USE test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> CREATE TABLE test (
-> id int(14)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM test USING test t WHERE 1=1;
ERROR 1109 (42S02): Unknown table 'test' in MULTI DELETE
mysql> DELETE FROM test USING test WHERE 1=1;
Query OK, 0 rows affected (0.00 sec)
mysql>
In 4.0 version this case success. Could someone hive me link or smth to solve this error?
Subject
Views
Written By
Posted
5.0.92: USING table alias - fals
3454
October 04, 2011 06:52AM
1239
October 04, 2011 10:38PM
1377
November 10, 2011 09:45PM
1648
November 11, 2011 02:39AM
1118
November 17, 2011 08:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.