Re: Re: CAST() no longer working with OOO 330m16

Hi Alex,

On 09.12.2010 10:35, Alex Thurgood wrote:
> Hi Ocke,
>
>
> ----- "Ocke Janssen"<[email protected]>  a écrit :
>
>>> As I mentioned, CAST works for me with OOo 3.2.1. It also works for
>> me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
>> is based on).
>> One more interesting thing
>> when executing
>> select CAST('2001-01-01' as DATE)
>> works, but when executing
>> select CAST('2001-01-01' as DATE) from ´testdb´.´i115436´
>> an error is thrown.
>
>
> You need to create an alias for the CASTed field. If you use this statement instead, it should work :
>
> SELECT CAST('2001-01-01' as DATE) as 'MyDate' from 'testdb'.'i115436'
Thanks. I found the issue and it can be fixed. Look at the issue for the 
case.

- oj

PS: A space can make a big difference.
>
>>
>> Could you please add some sample data to the issue?
>>
>
> If I get a bit of time today, I'll add some sample data to the issue.
>
>
> Alex
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>