#589 CLI - Increase String Display Limit (mimic SQuirreL UI)

[Kevin Rodriguez]

Good Afternoon devs,

Related Ticket:

412 Command-Line Version https://sourceforge.net/p/squirrel-sql/feature-requests/412/

First and foremost, thank you for the implementation of the CMI for SQuirreL. I have been able to successfully run it through windows command prompt and output the needed data. However, when I'm pulling string fields, they only display the first 50 characters (tested using RIGHT function).

Additionally, when pulling the same data through the SQuirreL 4.0 interface, the strings appear in full as they should.

Devs, could you please expand the string character display limit for the CMI to the same specifications used in the SQuirreL UI?

Best, RK

(PS: The output to text looks great, but when we output it to CSV, the fields are all aggregated to a single cell and not spaced out as they should be. That's for another ticket of course, I'm currently developing a python scrypt to format it, but would be nice to output cleanly!)

[Gerd Wagner]

Sorry, I can't reproduce your length problem.
I tried batch mode and JShell mode on Linux and Windows.

As to your request about output formats: My idea is to let users decide for "formatted" output. If he does the settings for the output will be taken from the 'Store result of SQL to file' dialog. This would be analogous to the implementation of feature request 438, see
https://sourceforge.net/p/squirrel-sql/feature-requests/438/

[Gerd Wagner]

On the output formats again:

Here's an excerpt from change log (http://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/doc/changes.txt):

Command line interface (CLI):
  The command line interface (CLI) allows to create formatted files according to the settings in SQuirreL's 'Store result of SQL to file' dialog.
  CLI help commands will inform about details.
  For information on the command line interface see Readme.txt in subdirectory squirrelcli of your SQuirreL installation.

The feature is committed to our GIT repository and will be availabel in future snapshots and versions.

[Gerd Wagner]

I now was able to reproduce the text length problem. But instead of 50 chars I found the limit to be 100 chars.

It is fixed and will be available in future snapshots and versions.

Here's the excerpt from our change log:
589 CLI (command line): Increase string display limit
The column width of CLI output as well as of text outputs was limited to 100 characters.
The limit is now 1000000 characters.