Inconsistencies around casting booleans

2012-08-09 Thread Philip Tromans
Hi all, We've been using boolean types in partition values (not the best idea, I know), and we've noticed a few inconsistencies around casting: select cast('true' as boolean), cast('false' as boolean), cast(true as string), cast(false as string), cast(cast(false as string) as boolean) from test

Inconsistencies around casting booleans

2012-08-09 Thread Philip Tromans
Hi all, We've been using boolean types in partition values (not the best idea, I know), and we've noticed a few inconsistencies around casting: SELECT cast('true' as boolean), cast('false' as boolean), cast(true as string), cast(false as string), cast(cast(false as string) as boolean) FROM test