search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-17] Casting boolean as string and vice versa #853

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[reporter="jpham", created="Tue, 10 Jan 2006 12:18:02 -0500 (GMT-05:00)"] Would it be possible for us to support this?

create table s.b (c boolean primary key);
No rows affected (1.238 seconds)

select cast(c as varchar(256)) from s.b;
0: jdbc:farrago:> Error: Cast function cannot convert value of type BOOLEAN to type VARCHAR(256) (state=,code=0)

dynamobi-build commented 12 years ago

[author="angel", created="Mon, 16 Jan 2006 21:59:17 -0500 (GMT-05:00)"] Support added in Eigebase change 5083. "unknown" not handled in Fennel calculator. When casting to non-nullable boolean, "unknown" is treated as invalid.