| Bug #13395 | Can't create table with partial foreign key | ||
|---|---|---|---|
| Submitted: | 22 Sep 2005 3:03 | Modified: | 15 Sep 2006 16:10 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
| Version: | 1.1.14 | OS: | Windows (WinXP SP2) |
| Assigned to: | Vladimir Kolesnikov | CPU Architecture: | Any |
| Tags: | Object Editors | ||
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[22 Sep 2005 3:04]
[ name withheld ]
[22 Sep 2005 3:05]
[ name withheld ]
Define table bar with foreign key referencing partial foo's index
Attachment: edit-bar.gif (image/gif, text), 28.97 KiB.
[22 Sep 2005 3:06]
[ name withheld ]
Generated SQL for bar table creation, with syntax errors
Attachment: create-table-bar.gif (image/gif, text), 10.22 KiB.
[22 Sep 2005 3:07]
[ name withheld ]
Error message: key not found
Attachment: key-not-found.gif (image/gif, text), 9.81 KiB.
[22 Sep 2005 3:14]
[ name withheld ]
Empty column lines should not be taken account
Attachment: empty-keys.gif (image/gif, text), 9.68 KiB.
