3 Replies Latest reply on Jul 25, 2017 1:59 PM by Steven Hawkins

    lead function error

    Fábio Guilherme Newbie




      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:


      lead(timestampvalue) over ( order by id)

      from changestb;


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


      lead(id) over ( order by id)

      from changestb;


      I dont understand why this happen.