diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/distinct2.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/test/distinct2.test b/test/distinct2.test index 46eace6f0..958d9634f 100644 --- a/test/distinct2.test +++ b/test/distinct2.test @@ -301,4 +301,16 @@ do_execsql_test 3030 { {} 1 a } +#------------------------------------------------------------------------- +# +reset_db + +do_execsql_test 4010 { + CREATE TABLE t1(a, b COLLATE RTRIM); + INSERT INTO t1 VALUES(1, ''), (2, ' '), (3, ' '); +} +do_execsql_test 4020 { + SELECT b FROM t1 UNION SELECT 1; +} {1 { }} + finish_test |