Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.3.6
-
Fix Version/s: N/A
-
Component/s: Storage Engine - Federated
-
Labels: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.