Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
Description
I have two tables
CREATE TABLE parent ( |
`cod_cta` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', |
`des_cta` VARCHAR(100), |
PRIMARY KEY (`cod_neg`,`cod_cta`), |
) ENGINE=INNODB;
|
 |
CREATE TABLE child ( |
`cod_asi` INT(11) NOT NULL DEFAULT 0, |
`num_lin` INT(11) NOT NULL DEFAULT 0, |
`cod_cta` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', |
PRIMARY KEY (`cod_asi`,`num_lin`), |
CONSTRAINT `fk_child_cta` FOREIGN KEY (`cod_cta`) REFERENCES parent ( `cod_cta`) ENGINE=INNODB; |
when I insert a new row in child table, FK OK data with trailing spaces, but when I join both tables in a select data dont retrieve any data.
thanks!
Attachments
Issue Links
- relates to
-
MDEV-22361 Cross-engine foreign keys support
- Open