[BUG-3.12.99-210209]Sort columns broken :(

[sky5walk]

Details for the issue

What did you do?

Clicked a column header within the data browser.

What did you expect to see?

Sorted data below the column headers.

What did you see instead?

No columns are visible.

Useful extra information

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

• Windows: ( version: latest 10 Pro___ )
• Linux: ( distro: ___ )
• macOS: ( version: ___ )
• Other: ___

What is your DB4S version?

• 3.12.1
• 3.12.0
• 3.11.x
• Other: ___DB Browser for SQLite Version 3.12.99 (Feb 9 2021)

Did you also

• Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
• Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

[sky5walk]

Ok, installed in reverse order till the bug is gone. :(
DB.Browser.for.SQLite-2021-01-27-win64 <-- Works.

[chrisjlocke]

Any chance of a screenshot? I can't reproduce this (on Windows 10) and my version is from 6 Feb.

[sky5walk]

I have dark theme enabled. There is nothing to screenshot. I only see the headers. The rest is blank screen.

[MKleusberg]

Sounds like we generate a broken SQL query. Can you paste the last one or two lines from the "SQL Log" window's "Application" section in here, @sky5walk? Also a copy of the CREATE TABLE statement of your table could be helpful.

[sky5walk]

I can try this with the next nightly that would make the fix.
Right now I'm frozen at 210127.

Side note: My real reason for upgrading and stumbling onto this bug, was a floating point error with my queries using nightly, 3.12.99 200603.
Ex. Inequalities failed with simple 2 <= 2.05. !!
This is fixed with 210127.

[justinclift]

@sky5walk Ahhh. Sounds more like @MKleusberg was asking if you'd be ok to try running one of the broken builds (eg last night's?) in order to cut-n-paste the SQL log from that. eg so he can diagnose and fix the problem

Maybe just grab the .zip version to keep things easy? That one doesn't need any installation. 😄

[sky5walk]

Ok, this is latest nightly run from zip, not installed.
Easy fix 😌
You can see below, there is an error when I click on the TTp(s) column.
The SQL must put double quotes or backticks around a complex column name: TTp(s)

SQL Log - APP

PRAGMA foreign_keys = '1';
PRAGMA database_list;
SELECT type,name,sql,tbl_name FROM "main".sqlite_master;
PRAGMA encoding;
SELECT "_rowid_",* FROM "main"."DOC" LIMIT 0, 49999;
SELECT "_rowid_",* FROM "main"."DOC" LIMIT 0, 49999;
SELECT "_rowid_",* FROM "main"."TD" LIMIT 0, 49999;
SELECT COUNT(*) FROM "main"."TD"
SELECT "_rowid_",* FROM "main"."TD"  ORDER BY TTp(s) ASC LIMIT 0, 49999;

SQL Log - ERROR
(1) no such column: s in "SELECT "_rowid_",* FROM "main"."TD" ORDER BY TTp(s) ASC LIMIT 0, 49999;"

[justinclift]

Perfect, thanks. 😄

[sky5walk]

Can someone mark this as BUG?

[justinclift]

Oops, good point. Done. 😄

[justinclift]

That being said, we could just add you to the developers group @sky5walk, so you'd have the ability to do stuff like that yourself, if you want?

[sky5walk]

Ok, yes. Please add me. 😄

[justinclift]

@sky5walk Team invite sent. 😄