SQLite columns not showing up - 'Unknown datatype "uint". Fall back to UNKNOWN.'

[jgwinner]

Preconditions

• HeidiSQL version: 11.3.0.6341
• Database type and version: SQLite version 3.
• OS: Windows 10

Describe the bug

Opening a valid SQLite database results in no data being displayed and an error in the bottom window:
/* Unknown datatype "uint". Fall back to UNKNOWN. */

To Reproduce

1. Add a local SQlite database (test.sqlite)
2. Open it with HeidiSQL, via a new connection:
3. Connection type: "SQLite"
4. Library: sqlite3.dll
5. Database filename: valid file on the disk.
6. Click on any table. No data will display and the data type shows as "unknown"
   

Note if I open this with the sqlite3 CLI program, it works fine.

Screenshots or Crash reports

[ansgarbecker]

According to your comment, only UINT columns are affected, or?
I can confirm that UINT is not yet supported by Heidi in SQLite mode.

[jgwinner]

Most of our SQlIte database is indeed unit, so it would be hard to tell, but I believe so, yes.

Ok, thanks for confirming.

In fact, just had a major bug where a -1 was handled wrong. In any event, instead of 'unknown' could it be possible to try to interpret the column as a signed int? It'll be wrong for 0xFFFFFFFF, but right most of the time.

Failing that, is it in the road map?

Back to the CLI :)

[jgwinner]

Oh - and what info do you need? Yes, it's UINT's so far (32 bit unsigned int)

[ansgarbecker]

Should be fixed in the next build: