[SPARK-22413] Type coercion for IN is not coherent between Literals and subquery - ASF JIRA

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Incomplete
Affects Version/s: 2.3.0
Fix Version/s: None
Component/s: SQL
Labels:
- bulk-closed

Description

The IN statement can have a different behavior according to whether there is a list of literals or a subquery, because the type coercion works differently in the two cases.

This means, that these two equivalent queries return different results:

select 1 from (select 1) a where 1 in ('01'); // this returns an empty dataset
select 1 from (select 1) a where 1 in (select '01' from (select 1)); // returns 1 row