summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_timezone.result
diff options
context:
space:
mode:
authordlenev@brandersnatch.localdomain <>2005-03-16 04:32:47 +0300
committerdlenev@brandersnatch.localdomain <>2005-03-16 04:32:47 +0300
commitf1691140421ecdb37e4706add568b88162a9ec37 (patch)
tree3fa8e5965f7758c8da8c6827d247549163f01785 /mysql-test/r/rpl_timezone.result
parent3f6fdabe4f5f8d5b2ce91e8842809a8e45e1ba87 (diff)
downloadmariadb-git-f1691140421ecdb37e4706add568b88162a9ec37.tar.gz
WL#874 "Extended LOAD DATA".
Now one can use user variables as target for data loaded from file (besides table's columns). Also LOAD DATA got new SET-clause in which one can specify values for table columns as expressions. For example the following is possible: LOAD DATA INFILE 'words.dat' INTO TABLE t1 (a, @b) SET c = @b + 1; This patch also implements new way of replicating LOAD DATA. Now we do it similarly to other queries. We store LOAD DATA query in new Execute_load_query event (which is last in the sequence of events representing LOAD DATA). When we are executing this event we simply rewrite part of query which holds name of file (we use name of temporary file) and then execute it as usual query. In the beggining of this sequence we use Begin_load_query event which is almost identical to Append_file event
Diffstat (limited to 'mysql-test/r/rpl_timezone.result')
-rw-r--r--mysql-test/r/rpl_timezone.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/rpl_timezone.result b/mysql-test/r/rpl_timezone.result
index d39b9f242bc..cd2c4d099be 100644
--- a/mysql-test/r/rpl_timezone.result
+++ b/mysql-test/r/rpl_timezone.result
@@ -32,13 +32,13 @@ t
2004-06-11 09:39:02
show binlog events;
Log_name Pos Event_type Server_id End_log_pos Info
-master-bin.000001 4 Format_desc 1 96 Server ver: VERSION, Binlog ver: 4
-master-bin.000001 96 Query 1 189 use `test`; create table t1 (t timestamp)
-master-bin.000001 189 Query 1 281 use `test`; create table t2 (t char(32))
-master-bin.000001 281 Query 1 373 use `test`; SET ONE_SHOT TIME_ZONE='UTC'
-master-bin.000001 373 Query 1 497 use `test`; insert into t1 values ('20040101000000'), ('20040611093902')
-master-bin.000001 497 Query 1 575 use `test`; delete from t1
-master-bin.000001 575 Query 1 699 use `test`; insert into t1 values ('20040101000000'), ('20040611093902')
+master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
+master-bin.000001 # Query 1 # use `test`; create table t1 (t timestamp)
+master-bin.000001 # Query 1 # use `test`; create table t2 (t char(32))
+master-bin.000001 # Query 1 # use `test`; SET ONE_SHOT TIME_ZONE='UTC'
+master-bin.000001 # Query 1 # use `test`; insert into t1 values ('20040101000000'), ('20040611093902')
+master-bin.000001 # Query 1 # use `test`; delete from t1
+master-bin.000001 # Query 1 # use `test`; insert into t1 values ('20040101000000'), ('20040611093902')
set time_zone='MET';
insert into t2 (select t from t1);
select * from t1;