--disable_query_log

--disable_result_log

--source ../../t/test_init.inc

--enable_result_log

--enable_query_log

--source include/have_innodb.inc

set spider_same_server_link= 1;

evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql

OPTIONS (SOCKET "$MASTER_1_MYSOCK", DATABASE 'test',user 'root');

CREATE TABLE t1 (c6 decimal(6,0)) ENGINE=InnoDB;

CREATE TABLE t1_s (c6 decimal(6,0))

ENGINE=SPIDER COMMENT='wrapper "mariadb", srv "srv", table "t1"' ;

CREATE TABLE t2 (c8 decimal(8,0), c6 decimal(6,0)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (123456), (654321);

# fail with ER_WARN_DATA_OUT_OF_RANGE (1264): Out of range value for

# column c6 at row 1

# success when selecting from t1 or when

# set statement spider_use_handler=1 for

INSERT INTO t2 (c8, c6) SELECT 12345678, c6 FROM t1_s GROUP BY c6;

drop table t2, t1_s, t1;

drop server srv;

--disable_query_log

--disable_result_log

--source ../../t/test_deinit.inc

--enable_result_log

--enable_query_log