Add a test for the boolean printing.

1 files changed, 12 insertions, 0 deletions

diff --git a/tests/test_pgexecute.py b/tests/test_pgexecute.py
index d8a8a5c0..e9c97e36 100644
--- a/tests/test_pgexecute.py
+++ b/tests/test_pgexecute.py
@@ -18,6 +18,18 @@ def test_conn(executor):
         SELECT 1""")
 
 @dbtest
+def test_bools_are_treated_as_strings(executor):
+    run(executor, '''create table test(a boolean)''')
+    run(executor, '''insert into test values(True)''')
+    assert run(executor, '''select * from test''', join=True) == dedent("""\
+        +------+
+        | a    |
+        |------|
+        | True |
+        +------+
+        SELECT 1""")
+
+@dbtest
 def test_schemata_table_and_columns_query(executor):
     run(executor, "create table a(x text, y text)")
     run(executor, "create table b(z text)")