By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.23 |
Check constraint 'ip_v6_valid_ck' is violated.
Token 1 | Token 2 | IPv6: | Host: |
---|---|---|---|
2001 | 0db8 | 2001:0db8:0000:FFF0:0000:8a2e:0370:7334 | host_1 |
10 | 9 | 10:9:8:7:6:6:7:6 | host_2 |
4001 | 1111 | 4001:1111:2222:FFF0:0000:8a2e:0370:7334 | host_3 |
t_id | token_1 | token_2 |
---|---|---|
1 | 2001 | 9 |
2 | 2001 | 9 |
3 | 2001 | 1111 |
4 | 10 | 1111 |
5 | 4001 | 0db8 |
6 | 2001 | 9 |
t_id | token_1 | token_2 |
---|---|---|
1 | 2001 | 9 |
2 | 2001 | 9 |
6 | 2001 | 9 |
t_id | token_1 | token_2 |
---|---|---|
1 | 2001 | 123 |
2 | 2001 | 123 |
6 | 2001 | 123 |
ip_v6 | host | ip_v6_token_1 | ip_v6_token_2 |
---|---|---|---|
123:123::123 | host_2 | 123 | 123 |
2001:0db8:0000:FFF0:0000:8a2e:0370:7334 | host_1 | 2001 | 0db8 |
t_id | token_1 | token_2 |
---|---|---|
1 | 2001 | 123 |
2 | 2001 | 123 |
6 | 2001 | 123 |
7 | 2001 | 0db8 |
Cannot add or update a child row: a foreign key constraint fails (`db_1436509032`.`test_fk`, CONSTRAINT `test_fk_test_ip_v6_token_2_fk` FOREIGN KEY (`token_2`) REFERENCES `test` (`ip_v6_token_2`) ON DELETE CASCADE ON UPDATE CASCADE)