[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-internals
Subject:    bk commit into 4.1 tree (1.1541)
From:       sanja () mysql ! com
Date:       2003-06-28 10:34:14
[Download RAW message or body]

Below is the list of changes that have just been committed into a local
4.1 repository of bell. When bell does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1541 03/06/28 13:34:07 bell@sanja.is.com.ua +2 -0
  merging
  test moved to other bug 

  mysql-test/t/subselect.test
    1.67 03/06/28 13:34:01 bell@sanja.is.com.ua +0 -1
    merging
    test moved to other bug 

  mysql-test/r/subselect.result
    1.76 03/06/28 13:34:00 bell@sanja.is.com.ua +3 -4
    merging
    test moved to other bug 

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	bell
# Host:	sanja.is.com.ua
# Root:	/home/bell/mysql/bk/work-name-4.1

--- 1.75/mysql-test/r/subselect.result	Fri Jun 27 23:14:19 2003
+++ 1.76/mysql-test/r/subselect.result	Sat Jun 28 13:34:00 2003
@@ -608,7 +608,9 @@
 3
 3
 INSERT INTO t1 (x) select (SELECT SUM(x)+2 FROM t1) FROM t2;
-Unknown column 'x' in 'field list'
+ERROR HY000: You can't specify target table 't1' for update in FROM clause
+INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(x) FROM t2));
+ERROR 42S22: Unknown column 'x' in 'field list'
 INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(a) FROM t2));
 select * from t1;
 x
@@ -1151,9 +1153,6 @@
 SELECT DISTINCT REF_ID FROM t1 WHERE ID= (SELECT DISTINCT REF_ID FROM t1 WHERE ID=2);
 REF_ID
 DROP TABLE t1;
-(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0);
-a
-1
 CREATE TABLE `t1` (
 `id` mediumint(8) unsigned NOT NULL auto_increment,
 `pseudo` varchar(35) NOT NULL default '',

--- 1.66/mysql-test/t/subselect.test	Fri Jun 27 23:14:19 2003
+++ 1.67/mysql-test/t/subselect.test	Sat Jun 28 13:34:01 2003
@@ -741,7 +741,6 @@
 #
 # reduced subselect in ORDER BY & GROUP BY clauses
 #
-(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0);
 
 CREATE TABLE `t1` (
   `id` mediumint(8) unsigned NOT NULL auto_increment,

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals?unsub=mysql-internals@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]