Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0, 10.1, 10.3.6, 10.2, 10.3
-
None
Description
Reproduce
install soname 'ha_federatedx'; |
|
create or replace table t1 (x int); |
--replace_result $MASTER_MYPORT MASTER_MYPORT
|
eval create or replace table tf engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'; |
create or replace table t1 (x varchar(255)); |
insert into tf values ("hello"); |
|
drop database test; |
create database test; |
uninstall soname 'ha_federatedx'; |
Result
mysqltest: At line 7: query 'insert into tf values ("hello")' failed: 1366: Incorrect integer value: 'hello' for column 'x' at row 1
|
Expected
No error.
Reproduce 2
then
insert into t1 values ("hello"); |
select * from tf; |
Result 2
+------+
|
| x |
|
+------+
|
| 0 |
|
+------+
|
Expected 2.
"hello" returned.
Notes
FRM discrepancy is allowed between server and client.