1# verify that values(x) works in update expression 2 3source include/have_tokudb.inc; 4 5source ../include/setup_fast_update_upsert.inc; 6set tokudb_enable_fast_upsert=1; 7 8create table t (id int primary key, x int not null) engine = tokudb; 9 10insert into t values (1,1); 11insert into t values (1,1) on duplicate key update x=x+1; 12select * from t; 13 14replace_regex /MariaDB/XYZ/ /MySQL/XYZ/; 15error ER_UNSUPPORTED_EXTENSION; 16insert into t values (1,10) on duplicate key update x=values(x)+1; 17select * from t; 18 19insert into t values (1,10) on duplicate key update x=x+values(x); 20select * from t; 21 22insert into t values (1,100) on duplicate key update x=x+values(x); 23select * from t; 24 25drop table t; 26 27 28