Doing an \sqldump on a database having a table containing triggers, with the -TF option enabled, displays the triggers twice. If setting the -TF option to false, the triggers are displayed once.
Shouldn't the triggers be displayed only once when the -TF option is enabled, and not displayed at all when the -TF option is set to false?
Tested using ADStudio 12 RC 23 with a MySQL server.
Scenario:
After looking into this closely, \sqldump should not support -TF|--table-script-full options. These options are removed and man page is updated.
In ADS, the Script Generator dialog only enables the 'Tables: Script full table (Indexes, Triggers)' check box if none of 'Indexes' and 'Triggers' objects to be scripted. In \sqldump, at the moment, it always scripts all of available objects; hence, 'script full table' should be set to 'false' all the time.
sqldump: -TF: Invalid option is now displayed if you use -TF option.
man page is updated, removed from command
Fixed in version 12.0.0
sqldump: -TF: Invalid option is now displayed if you use -TF option.
man page is updated, removed from command
Fixed in version 12.0.0
Issue #7773 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/29705 |
No time estimate |
After looking into this closely, \sqldump should not support -TF|--table-script-full options. These options are removed and man page is updated.
In ADS, the Script Generator dialog only enables the 'Tables: Script full table (Indexes, Triggers)' check box if none of 'Indexes' and 'Triggers' objects to be scripted. In \sqldump, at the moment, it always scripts all of available objects; hence, 'script full table' should be set to 'false' all the time.