No rows returned if a row contains unicode character

[frodeaa]

SQL queries returned empty row, found out that it was caused by unicode character.

create table my_table (val text);
insert into my_table (val) values ('a'), ('b'), ('unicode \u2013 is – here');

my-db> select * from my_table limit 2
+-------+
| val   |
|-------|
| a     |
| b     |
+-------+
SELECT 2
my-db> select * from my_table limit 3

my-db>

We get the expected rows if we use the row_to_json function

my-db> select row_to_json(row(val)) from my_table limit 3
+--------------------------------------------+
| row_to_json                                |
|--------------------------------------------|
| {u'f1': u'a'}                              |
| {u'f1': u'b'}                              |
| {u'f1': u'unicode \\u2013 is \u2013 here'} |
+--------------------------------------------+
SELECT 3
my-db>

[macobo]

This should be fixed in the latest version and I am not able to reproduce it either - what version of pgcli do you have installed?

[frodeaa]

$ pip list | grep pgcli
pgcli (0.10.0)

and I can confirm that it works correctly in 0.10.3, will close the issue.
The bug seems to be fixed in 0.10.1 by 4aaa117

[amjith]

@frodeaa Can you try upgrading pgcli?

pip install -U pgcli.

[frodeaa]

yes, upgrading fixes the problem @amjith