[PHOENIX-3052] Cannot JOIN on comparing CHAR columns of differing length

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.7.0
• Labels: char join sql
• Assignee: Unassigned
• Reporter: Kevin Liew
• Created: 06/Jul/16 19:51
• Updated: 07/Jul/16 17:57

Description

create table testchar1 (pk char(10) primary key)
create table testchar2 (pk char(20) primary key)

upsert into testchar1 values('a')
upsert into testchar2 values('a')

upsert into testchar1 values('b')
upsert into testchar2 values('b')

select * from testchar1 INNER JOIN testchar2 ON testchar1.pk = testchar2.pk

`testchar1` and `testchar2` contain the same data so two rows should be returned.

Note that the following query works when testchar3.pk has the same column length as testchar1.pk:

select * from testchar1 INNER JOIN testchar3 ON testchar1.pk = testchar3.pk

Issue Links

• relates to: PHOENIX-3051 IN predicate cannot compare CHAR columns of differing length