#1256 Plain text output column width

[superuser]

Feature request #484 provides a nice toggle for text output. However, it looks like it is broken for slightly long values of text.

Eg.

select 'helloworld!' as str1;
str1  
------
hell  

[Gerd Wagner]

Sorry, I can't reproduce your problem. I executed your statement on Postgres and the output was:

str1

helloworld!

What version of SQuirreL and which database are you using?

[superuser]

Squirrel v 3.7. This is against Presto (https://prestodb.io/docs/0.147/installation/jdbc.html)

You're right, I'm also seeing the full string on Postgres.

select cast('hello world!' as varchar(100)) as str1
;
str1                                                
----------------------------------------------------
hello world!      

Shouldn't the output be database / driver independent?

[grinderX19]

Can we have a setting for the "Results as text" output?
It seems limited to 50 chars at the moment. F.e. running this

select "Lorem ipsum dolor sit amet, consectetur adipiscing elit" as test;

Will display the full string in "Results" tab but in "Results as text" it will be

test                                                
----------------------------------------------------
Lorem ipsum dolor sit amet, consectetur adipiscing  

[Gerd Wagner]

GrinderX19, your request is implemented and will be available in future snapshots and versions.
Excerpt from Changes list:
New preference to define the maximum column width for text outputs, see menu File --> Global Preferences --> tab SQL --> section General.
This was asked for in bug #1256.