× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
aquaclusters.josekibold reported 2012-10-30T15:15:16Z  · last modified 2012-11-06T14:54:13Z

\sqlexport with multiple (invalid and valid) tables


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

 

If calling the \sqlexport command with multiple tables, both invalid (inexistent) tables and valid tables, (1) when an invalid table is reached imediatley a Standard Error message is printed (Table 'X' not found.), (2) when a valid table is reached it's content is printed on the screen. (3) When the \sqlexport cmd finished, a Shell Exception message is printed (SQL export failed).
 
(1) & (2) behaviors are as expected, however (3), the fail message at the end, could be misleading.
 
For instance having the command \sqlexport invalid_table valid_table will end up with the data from valid_table printed on the screen and after that with the export failed message. This could suggest that getting all the data from the last table has failed.
 
My proposed modification would be not to display the failed message at the end, and consequently not to generate an Exception in case an export from multiple tables fails. (However the Exception should be kept in case of an invalid SQL from the \sqlbuffer, see #7855.)
 
The non-Exception behavior would be similar with the behavior, for instance, from the \cat cmd. Specifying multiple files, both inexistent and existent files, \cat inexistent_file valid_file, won't print an Exception message at the end.

Issue #7881

Closed
Fixed
Resolved 2012-11-03T04:39:54Z
 
 
Completion
No due date
Fixed Build trunk/30024
No time estimate

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