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

    lead function error

    Fábio Guilherme Newbie

      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.