Wrong column length - Githubissues

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

Wrong column length #153

Closed ilvetz closed 6 years ago

ilvetz commented 6 years ago

Issue Type

[ ] Feature Request
[x] Bugfix/Errors
[ ] Questions
[ ] Other

Prerequisites (For bugfixes)

[x] Are you running the latest version?
[ ] Did you check the logs?
[x] Did you check the Setup?

Description

Executing a SELECT statement (trying with SQLite, I don't know others) output columns have the size of the first element.

Steps to Reproduce (For bugfixes)

Run a SELECT statement on a table where any string is longer than the first element for the same column

Expected behavior: Column has the size of the longest element or a "max_column_size" attribute can be configured.

Actual behavior: Elements longer than the first element for the same column are truncated.

Versions

Version: v0.9.6
OS: Windows 7
RDBMS: (SQLite)

ilvetz commented 6 years ago

Closing. This is a feature of SQLite itself, when using column mode for output.