search

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3
https://code.mteixeira.dev/SublimeText-SQLTools/
GNU General Public License v3.0
177 stars 40 forks source link

Sqlite output clipped #196

Closed klonuo closed 6 years ago

klonuo commented 6 years ago

Hi,

I use latest version with ST 3161 on Windows 10 with sqlite 3.23.0.

It seems that for some reason output is clipped in ST, while in sqlite interpreter it is as expected:

image

Any ideas?

tkopets commented 6 years ago

For readability purposes (if you select more than one column) SQLTools uses column mode in sqlite3: sqlite3 -column ... (same as .mode column in the interactive session). This however has some limitations, namely citing the docs: https://www.sqlite.org/cli.html

By default, each column is between 1 and 10 characters wide, depending on the column header name and the width of the first column of data. Data that is too wide to fit in a column is truncated. Use the ".width" dot-command to adjust column widths ...

klonuo commented 6 years ago

Basically removing -column from sqlite execute options setting, should not clip result to the length of the first output record

Thanks @tkopets