Below is the list of changes that have just been committed into a local
4.0 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.1274 02/08/30 21:32:59 bell@stripped +29 -0
fixed tests to be independed from environment
mysql-test/t/warnings.test
1.4 02/08/30 21:32:55 bell@stripped +1 -1
fixed test to be independed from environment
mysql-test/t/varbinary.test
1.6 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/type_year.test
1.4 02/08/30 21:32:55 bell@stripped +1 -1
fixed test to be independed from environment
mysql-test/t/type_timestamp.test
1.5 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/type_time.test
1.4 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/type_set.test
1.2 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/odbc.test
1.4 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/lock_multi.test
1.3 02/08/30 21:32:55 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/key_primary.test
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/func_in.test
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/func_group.test
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/fulltext_left_join.test
1.6 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/flush_table.test
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/delayed.test
1.6 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/t/binary.test
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/warnings.result
1.3 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/varbinary.result
1.7 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/type_year.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/type_timestamp.result
1.6 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/type_time.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/type_set.result
1.3 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/odbc.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/lock_multi.result
1.4 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/key_primary.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/func_in.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/func_group.result
1.6 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/fulltext_left_join.result
1.8 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/delayed.result
1.6 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
mysql-test/r/binary.result
1.5 02/08/30 21:32:54 bell@stripped +1 -0
fixed test to be independed from environment
# 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/work-test-4.0
--- 1.4/mysql-test/r/binary.result Thu Oct 11 03:59:43 2001
+++ 1.5/mysql-test/r/binary.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1,t2;
create table t1 (name char(20) not null, primary key (name));
create table t2 (name char(20) binary not null, primary key (name));
--- 1.5/mysql-test/r/delayed.result Thu Oct 11 03:59:43 2001
+++ 1.6/mysql-test/r/delayed.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (a char(10), tmsp timestamp);
insert into t1 set a = 1;
insert delayed into t1 set a = 2;
--- 1.5/mysql-test/r/func_group.result Thu Nov 22 13:50:50 2001
+++ 1.6/mysql-test/r/func_group.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1,t2;
create table t1 (grp int, a bigint unsigned, c char(10) not null);
insert into t1 values (1,1,"a");
insert into t1 values (2,2,"b");
--- 1.4/mysql-test/r/func_in.result Thu Oct 11 03:59:43 2001
+++ 1.5/mysql-test/r/func_in.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
CREATE TABLE t1 (field char(1));
INSERT INTO t1 VALUES ('A'),(NULL);
SELECT * from t1 WHERE field IN (NULL);
--- 1.4/mysql-test/r/key_primary.result Thu Oct 11 03:59:44 2001
+++ 1.5/mysql-test/r/key_primary.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (t1 char(3) primary key);
insert into t1 values("ABC");
insert into t1 values("ABA");
--- 1.4/mysql-test/r/odbc.result Thu Oct 11 03:59:44 2001
+++ 1.5/mysql-test/r/odbc.result Fri Aug 30 21:32:54 2002
@@ -1,6 +1,7 @@
select {fn length("hello")}, { date "1997-10-20" };
{fn length("hello")} 1997-10-20
5 1997-10-20
+drop table if exists t1;
create table t1 (a int not null auto_increment,b int not null,primary key (a,b));
insert into t1 SET A=NULL,B=1;
insert into t1 SET a=null,b=2;
--- 1.4/mysql-test/r/type_time.result Thu Oct 11 03:59:45 2001
+++ 1.5/mysql-test/r/type_time.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (t time);
insert into t1 values("10:22:33"),("12:34:56.78"),(10),(1234),(123456.78),(1234559.99),("1"),("1:23"),("1:23:45"), ("10.22"), ("-10 1:22:33.45"),("20 10:22:33"),("1999-02-03 20:33:34");
insert t1 values (30),(1230),("1230"),("12:30"),("12:30:35"),("1 12:30:31.32");
--- 1.5/mysql-test/r/type_timestamp.result Thu Oct 11 03:59:45 2001
+++ 1.6/mysql-test/r/type_timestamp.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
CREATE TABLE t1 ( t timestamp);
SET TIMESTAMP=1234;
insert into t1 values(NULL);
--- 1.4/mysql-test/r/type_year.result Thu Oct 11 03:59:45 2001
+++ 1.5/mysql-test/r/type_year.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (y year,y2 year(2));
insert into t1 values (0,0),(1999,1999),(2000,2000),(2001,2001),(70,70),(69,69);
select * from t1;
--- 1.6/mysql-test/r/varbinary.result Tue Jan 29 18:32:14 2002
+++ 1.7/mysql-test/r/varbinary.result Fri Aug 30 21:32:54 2002
@@ -7,6 +7,7 @@
select x'31',X'ffff'+0;
x'31' X'ffff'+0
1 65535
+drop table if exists t1;
create table t1 (ID int(8) unsigned zerofill not null auto_increment,UNIQ bigint(21) unsigned zerofill not null,primary key (ID),unique (UNIQ) );
insert into t1 set UNIQ=0x38afba1d73e6a18a;
insert into t1 set UNIQ=123;
--- 1.3/mysql-test/t/binary.test Thu Oct 11 03:59:41 2001
+++ 1.4/mysql-test/t/binary.test Fri Aug 30 21:32:54 2002
@@ -2,6 +2,7 @@
# test sort,min and max on binary fields
#
+drop table if exists t1,t2;
create table t1 (name char(20) not null, primary key (name));
create table t2 (name char(20) binary not null, primary key (name));
--- 1.5/mysql-test/t/delayed.test Thu Oct 11 03:59:41 2001
+++ 1.6/mysql-test/t/delayed.test Fri Aug 30 21:32:54 2002
@@ -3,6 +3,7 @@
# (Can't be tested with purify :( )
#
+drop table if exists t1;
create table t1 (a char(10), tmsp timestamp);
insert into t1 set a = 1;
insert delayed into t1 set a = 2;
--- 1.3/mysql-test/t/flush_table.test Thu Oct 11 03:59:42 2001
+++ 1.4/mysql-test/t/flush_table.test Fri Aug 30 21:32:54 2002
@@ -4,6 +4,7 @@
# Test of flush table
#
+#drop table if exists t1;
#create table t1 (a int not null auto_increment primary key);
#insert into t1 values(0);
#lock table t1 read;
--- 1.3/mysql-test/t/func_group.test Thu Oct 11 03:59:42 2001
+++ 1.4/mysql-test/t/func_group.test Fri Aug 30 21:32:54 2002
@@ -2,6 +2,7 @@
# simple test of all group functions
#
+drop table if exists t1,t2;
create table t1 (grp int, a bigint unsigned, c char(10) not null);
insert into t1 values (1,1,"a");
insert into t1 values (2,2,"b");
--- 1.3/mysql-test/t/func_in.test Thu Oct 11 03:59:42 2001
+++ 1.4/mysql-test/t/func_in.test Fri Aug 30 21:32:54 2002
@@ -2,6 +2,7 @@
# test of IN (NULL)
#
+drop table if exists t1;
CREATE TABLE t1 (field char(1));
INSERT INTO t1 VALUES ('A'),(NULL);
SELECT * from t1 WHERE field IN (NULL);
--- 1.3/mysql-test/t/key_primary.test Thu Oct 11 03:59:42 2001
+++ 1.4/mysql-test/t/key_primary.test Fri Aug 30 21:32:54 2002
@@ -2,6 +2,7 @@
# test of primary key conversions
#
+drop table if exists t1;
create table t1 (t1 char(3) primary key);
insert into t1 values("ABC");
insert into t1 values("ABA");
--- 1.3/mysql-test/t/odbc.test Thu Oct 11 03:59:42 2001
+++ 1.4/mysql-test/t/odbc.test Fri Aug 30 21:32:55 2002
@@ -8,6 +8,7 @@
# Test retreiving row with last insert_id value.
#
+drop table if exists t1;
create table t1 (a int not null auto_increment,b int not null,primary key (a,b));
insert into t1 SET A=NULL,B=1;
insert into t1 SET a=null,b=2;
--- 1.3/mysql-test/t/type_time.test Thu Oct 11 03:59:43 2001
+++ 1.4/mysql-test/t/type_time.test Fri Aug 30 21:32:55 2002
@@ -1,6 +1,7 @@
#
# testing of the TIME column type
#
+drop table if exists t1;
create table t1 (t time);
insert into t1 values("10:22:33"),("12:34:56.78"),(10),(1234),(123456.78),(1234559.99),("1"),("1:23"),("1:23:45"), ("10.22"), ("-10 1:22:33.45"),("20 10:22:33"),("1999-02-03 20:33:34");
insert t1 values (30),(1230),("1230"),("12:30"),("12:30:35"),("1 12:30:31.32");
--- 1.4/mysql-test/t/type_timestamp.test Thu Oct 11 03:59:43 2001
+++ 1.5/mysql-test/t/type_timestamp.test Fri Aug 30 21:32:55 2002
@@ -2,6 +2,7 @@
# Test timestamp
#
+drop table if exists t1;
CREATE TABLE t1 ( t timestamp);
SET TIMESTAMP=1234;
insert into t1 values(NULL);
--- 1.3/mysql-test/t/type_year.test Thu Oct 11 03:59:43 2001
+++ 1.4/mysql-test/t/type_year.test Fri Aug 30 21:32:55 2002
@@ -1,7 +1,7 @@
#
# Test year
#
-
+drop table if exists t1;
create table t1 (y year,y2 year(2));
insert into t1 values (0,0),(1999,1999),(2000,2000),(2001,2001),(70,70),(69,69);
select * from t1;
--- 1.5/mysql-test/t/varbinary.test Thu Oct 11 03:59:43 2001
+++ 1.6/mysql-test/t/varbinary.test Fri Aug 30 21:32:55 2002
@@ -10,6 +10,7 @@
# Test of hex constants in WHERE:
#
+drop table if exists t1;
create table t1 (ID int(8) unsigned zerofill not null auto_increment,UNIQ bigint(21) unsigned zerofill not null,primary key (ID),unique (UNIQ) );
insert into t1 set UNIQ=0x38afba1d73e6a18a;
insert into t1 set UNIQ=123;
--- 1.3/mysql-test/t/warnings.test Thu Oct 11 03:59:43 2001
+++ 1.4/mysql-test/t/warnings.test Fri Aug 30 21:32:55 2002
@@ -1,7 +1,7 @@
#
# Test some warnings
#
-
+drop table if exists t1;
create table t1 (a int);
insert into t1 values (1);
insert into t1 values ("hej");
--- 1.3/mysql-test/r/lock_multi.result Thu Oct 11 03:59:44 2001
+++ 1.4/mysql-test/r/lock_multi.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1(n int);
insert into t1 values (1);
lock tables t1 write;
--- 1.2/mysql-test/r/type_set.result Tue May 28 10:21:54 2002
+++ 1.3/mysql-test/r/type_set.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (a set (' ','a','b') not null);
show create table t1;
Table Create Table
--- 1.2/mysql-test/t/lock_multi.test Thu Oct 11 03:59:42 2001
+++ 1.3/mysql-test/t/lock_multi.test Fri Aug 30 21:32:55 2002
@@ -6,6 +6,7 @@
#
-- source include/not_embedded.inc
+drop table if exists t1;
#test to see if select will get the lock ahead of low priority update
connect (locker,localhost,root,,);
--- 1.1/mysql-test/t/type_set.test Mon May 27 23:21:47 2002
+++ 1.2/mysql-test/t/type_set.test Fri Aug 30 21:32:55 2002
@@ -2,6 +2,7 @@
# Test of SET with space
#
+drop table if exists t1;
create table t1 (a set (' ','a','b') not null);
show create table t1;
drop table t1;
--- 1.2/mysql-test/r/warnings.result Thu Oct 11 03:59:45 2001
+++ 1.3/mysql-test/r/warnings.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1;
create table t1 (a int);
insert into t1 values (1);
insert into t1 values ("hej");
--- 1.7/mysql-test/r/fulltext_left_join.result Tue Nov 20 18:22:31 2001
+++ 1.8/mysql-test/r/fulltext_left_join.result Fri Aug 30 21:32:54 2002
@@ -1,3 +1,4 @@
+drop table if exists t1, t2;
CREATE TABLE t1 (
id VARCHAR(255) NOT NULL PRIMARY KEY,
sujet VARCHAR(255),
--- 1.5/mysql-test/t/fulltext_left_join.test Tue Nov 20 18:22:43 2001
+++ 1.6/mysql-test/t/fulltext_left_join.test Fri Aug 30 21:32:54 2002
@@ -2,6 +2,7 @@
#
+drop table if exists t1, t2;
CREATE TABLE t1 (
id VARCHAR(255) NOT NULL PRIMARY KEY,
sujet VARCHAR(255),
| Thread |
|---|
| • bk commit into 4.0 tree | bell | 30 Aug |
