5 Replies Latest reply on Nov 23, 2010 1:14 PM by jalen

Cast from null to timestamp problem

jalen Nov 18, 2010 4:43 AM

We have a table which contains a column of type "timestamp", but we don't want to let user query the value of this column now.

If I can write "select null as creation_date from T as t", it would be perfect. But Teiid Designer doesn't support it.

We write the script in Designer like that:

select cast(null as timestamp) as creation_date from T as t

When executing the VDB, error prompt:

Error Code:0 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:0 Message:Error Code:0 Message:Unexpected exception while translating results: 不支持从 int 到 TIMESTAMP 的转换。

The above Asia characters here means: do not support convert from int to TIMESTAMP.

Could anybody help me for this issue?

Thanks!

1. Re: Cast from null to timestamp problem

rareddy Nov 18, 2010 11:25 AM (in response to jalen)

Is this error you are seeing when executing from Designer? I executed following from SquirreL fine against 7.2 Final Teiid.

select cast(null as timestamp) as t from pm1.g1
select convert(null, timestamp) as t from pm1.g1

Ramesh..
Actions
2. Re: Cast from null to timestamp problem

shawkins Nov 18, 2010 12:56 PM (in response to rareddy)

Jalen,

What query are you executing in Designer, or is this just from a preview? As Ramesh is getting at the error you are seeing is more than likely not directly related to the converion of a null to timestamp. Perhaps there is something in the definition of T where are a source column of type int has been given a runtime type of timestamp.

Steve
Actions
3. Re: Cast from null to timestamp problem

jalen Nov 19, 2010 1:08 AM (in response to shawkins)

This sql is written in the Designer.
We use it deploy the VDB to JBoss and execute it.
Actions
4. Re: Cast from null to timestamp problem

rareddy Nov 21, 2010 8:44 PM (in response to jalen)

You can give us a sample test VDB with your issue, we will check this out.
Actions
5. Re: Cast from null to timestamp problem

jalen Nov 23, 2010 1:14 PM (in response to rareddy)

Do you only need the VDB file? Is that enough?

Thanks for your patience.
Actions

Go to original post