lead function error

[fabio_guilherme89]

Hey,

I´m trying go get the timestamp from the next row, but i get this error "TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504: 22003 Unexpected exception while translating results: Bad value for type int : 2017-01-01 04:30:27".

The function i used:

select

lead(timestampvalue) over ( order by id)

from changestb;

But if i use bigint value type, i don´t get any error, for example:

select

lead(id) over ( order by id)

from changestb;

I dont understand why this happen.

[shawkins]

I am not able to reproduce this error.  Can you provide some additional details about this scenario - what is the query plan?  How many rows are processing? What Teiid version?

[fabio_guilherme89]

Thanks for your reply.
I have table with movement and the idea is to get the timestamp of the next movement. With both timestamp i can calculate the time passed between the two movements.

I forgot to mention the teiid version that i'm using, that is 9.3.

[shawkins]

I need to see query plan, or the ddl that describes changestb and what source(s) are involved.