sqlitestudio icon indicating copy to clipboard operation
sqlitestudio copied to clipboard

Concated columns show wrong values, after another column is sorted

Open JP95Git opened this issue 2 years ago • 0 comments

Details

Concated columns show wrong values, after another column is sorted.

Steps to reproduce

Create a sample table with these data:

--
-- File generated with SQLiteStudio v3.3.3 on Sa Mrz 12 10:39:21 2022
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: test
DROP TABLE IF EXISTS test;

CREATE TABLE test (
    id     INTEGER PRIMARY KEY AUTOINCREMENT,
    name1  VARCHAR,
    name2  VARCHAR,
    number INTEGER
);

INSERT INTO test (id, name1, name2, number) VALUES (1, 'namenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamename31', 'name32', 3);
INSERT INTO test (id, name1, name2, number) VALUES (2, 'namenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamename21', 'name22', 2);
INSERT INTO test (id, name1, name2, number) VALUES (3, 'namenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamenamename11', 'name12', 1);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;

Then run this query: select ID, name1 || name2 as names, name2, number from test

Click on the arrows "Load remaining part of the value". Everything looks fine.

Sort for column name2.

Click on the arrows "Load remaining part of the value". The column names now shows the wrong values.

Operating system

Windows 10

SQLiteStudio version

3.3.3

JP95Git avatar Mar 12 '22 09:03 JP95Git