dbcli/litecli

In memory db causes '???' to show up instead of data

Alex-V69 opened this issue · 2 comments

I tried to use a database in memory and got a table that contains only: '???'

Output from PowerShell \

Creating a table and inserting first rows:

(none)> .open :memory:
You are now connected to database ":memory:"
:memory:> create table people(sex text);
:memory:> insert into people values('m');
:memory:> insert into people values('f');

After inserting like this for a while:

:memory:> select * from people;
??????????????┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼???┼?????
18 rows in set

I tried in Mac OSX and can confirm it works as expected. Here is the output

uv run litecli
LiteCli: 0.1.dev429+g5be771e (SQLite: 3.47.1)
GitHub: https://github.com/dbcli/litecli
(none)> .open :memory;
You are now connected to database ":memory"
Time: 0.003s
:memory> create people(sex text);
near "people": syntax error
:memory> create table people(sex text);
Query OK
Time: 0.002s
:memory> insert into people values('m');
Query OK, 1 row affected
Time: 0.001s
:memory> select * from people;
+-----+
| sex |
+-----+
| m   |
+-----+
1 row in set
Time: 0.006s
:memory>

Could you confirm if the problem persists in windows even in the latest version?

Indeed, litecli v1.14.4 doesn't seem to have this problem any longer.