Re: v13 planner ERROR: could not determine which collation to use for string comparison - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: v13 planner ERROR: could not determine which collation to use for string comparison
Date
Msg-id 20200721195757.GM5748@telsasoft.com
Whole thread Raw
In response to Re: v13 planner ERROR: could not determine which collation to use for string comparison  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Reproducer:

postgres=# CREATE TABLE t AS SELECT ''a FROM generate_series(1,99); CREATE TABLE u AS SELECT ''a FROM
generate_series(1,99); VACUUM ANALYZE t,u;
 
postgres=# explain SELECT * FROM t JOIN u ON t.a!=u.a;
ERROR:  could not determine which collation to use for string comparison
HINT:  Use the COLLATE clause to set the collation explicitly.



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: OpenSSL randomness seeding
Next
From: David Steele
Date:
Subject: Re: OpenSSL randomness seeding