Is it possible to make an integer literal using RexBuilder?

[James]

Hi all,

I want to make an integer literal to feed to the string POSITION
function(POSITION(string1 IN string2)) for unittesting, but I can't find
the right function to do this. The best try I ever had is:

    rexBuilder.makeLiteral(1,
typeFactory.createSqlType(SqlTypeName.INTEGER), false)

But it returns a DECIMAL literal.

My question is: is it possible to make an integer literal using RexBuilder?
If yes, then how? If not, then what's the reason?

Thanks in advance.
James