× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
aquaclusters.josekibold reported 2012-10-11T20:04:50Z  · tariqrahiman last modified 2012-10-23T00:10:29Z

\sqldump -TF (--table-script-full) option


Dev
Fun Fun
funfun
QA
Niels Gron
NielsGron
Priority Low
Complexity Unknown
Component App - FluidShell - Command
Version 12.0

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:

 

$ DROP DATABASE IF EXISTS tmp_fs_sqldump_db /
$ CREATE DATABASE tmp_fs_sqldump_db /
$ CREATE TABLE IF NOT EXISTS tmp_fs_sqldump_db.table1 (`col one` VARCHAR(10)) ENGINE = InnoDB /
$ INSERT INTO tmp_fs_sqldump_db.table1 (`col one`) VALUES ("val1") /
$ DROP TRIGGER IF EXISTS trigger1 /
$ CREATE TRIGGER trigger1 BEFORE INSERT ON table1
$ FOR EACH ROW BEGIN
$ END /
$ sqldump -TF true | grep -c "DROP TRIGGER trigger1"
2<---Shouldn't it be 1?
sqldump -TF false | grep -c "DROP TRIGGER trigger1"
1<---Shouldn't it be 0?
sqldump -TF true | grep -c "CREATE TRIGGER trigger1"
2<---Shouldn't it be 1?
sqldump -TF false | grep -c "CREATE TRIGGER trigger1"
1
<---Shouldn't it be 0?

 

Issue #7773

Closed
Fixed
Resolved 2012-10-11T22:28:32Z
 
 
Completion
No due date
Fixed Build trunk/29705
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017