mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
fb67cde237
- Force usage of () around complex DEFAULT expressions - Give error if DEFAULT expression contains invalid characters - Don't use const_charset_conversion for stored Item_func_sysconf expressions as the result is not constaint over different executions - Fixed Item_func_user() to not store calculated value in str_value
29 lines
693 B
Text
29 lines
693 B
Text
#
|
|
# Test of replicating default values
|
|
# As the table is using non deterministic functions, replication must
|
|
# switch to binlog format.
|
|
#
|
|
|
|
-- source include/have_binlog_format_mixed_or_row.inc
|
|
-- source include/master-slave.inc
|
|
|
|
connection master;
|
|
|
|
create table t1 (a int DEFAULT (1+1), b bigint default uuid_short(), u blob default user());
|
|
insert into t1 (a) values(1);
|
|
|
|
let $b=query_get_value(select * from t1, b, 1);
|
|
let $u=query_get_value(select * from t1, u, 1);
|
|
|
|
sync_slave_with_master;
|
|
connection slave;
|
|
|
|
show create table t1;
|
|
--disable_query_log
|
|
eval select a,"$b"=b as uuid,"$u"=u as user from t1;
|
|
--enable_query_log
|
|
connection master;
|
|
|
|
drop table t1;
|
|
|
|
--source include/rpl_end.inc
|