[ERROR][db-async-netty-thread-3][2016-01-28 02:57:26,715] Error with message -> ErrorMessage(fields=Map(Line -> 104, File -> numutils.c, SQLSTATE -> 22P02, Routine -> pg_atoi, Message -> invalid input syntax for integer: "123.123", Severity -> ERROR))
[ERROR][db-async-netty-thread-3][2016-01-28 02:57:26,715] Error on connectioncom.github.mauricio.async.db.postgresql.exceptions.GenericDatabaseException: ErrorMessage(fields=Map(Line -> 104, File -> numutils.c, SQLSTATE -> 22P02, Routine -> pg_atoi, Message -> invalid input syntax for integer: "123.123", Severity -> ERROR))
    at com.github.mauricio.async.db.postgresql.PostgreSQLConnection.onError(PostgreSQLConnection.scala:172)
    at com.github.mauricio.async.db.postgresql.codec.PostgreSQLConnectionHandler.channelRead0(PostgreSQLConnectionHandler.scala:151)
    at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294)
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:244)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:308)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:294)
    at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846)
    at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
    at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
    at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
    at java.lang.Thread.run(Thread.java:745)

[ERROR][db-async-netty-thread-3][2016-01-28 02:57:26,716] Setting error on future scala.concurrent.impl.Promise$DefaultPromise@12d25586

-- using no type and pass number works
joern=# PREPARE update_numcol AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol (123);
UPDATE 1
joern=# EXECUTE update_numcol (123.123);
UPDATE 1
joern=# DEALLOCATE update_numcol;
DEALLOCATE

-- using numeric type and pass number works
joern=# PREPARE update_numcol (NUMERIC) AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol (123);
UPDATE 1
joern=# EXECUTE update_numcol (123.123);
UPDATE 1
joern=# DEALLOCATE update_numcol;
DEALLOCATE

-- using integer type and pass number works
joern=# PREPARE update_numcol (INTEGER) AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol (123);
UPDATE 1
joern=# EXECUTE update_numcol (123.123);
UPDATE 1
joern=# DEALLOCATE update_numcol;
DEALLOCATE

-- using no type and pass string works
joern=# PREPARE update_numcol AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol ('123');
UPDATE 1
joern=# EXECUTE update_numcol ('123.123');
UPDATE 1
joern=# DEALLOCATE update_numcol;
DEALLOCATE

-- using numeric type and pass string works
joern=# PREPARE update_numcol (NUMERIC) AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol ('123');
UPDATE 1
joern=# EXECUTE update_numcol ('123.123');
UPDATE 1
joern=# DEALLOCATE update_numcol;
DEALLOCATE

-- using integer type and pass string does not work
joern=# PREPARE update_numcol (INTEGER) AS UPDATE test_table SET numcol = $1 WHERE id = 1;
PREPARE
joern=# EXECUTE update_numcol ('123');
UPDATE 1
joern=# EXECUTE update_numcol ('123.123');
ERROR:  invalid input syntax for integer: "123.123"
LINE 1: EXECUTE update_numcol ('123.123');
                               ^
joern=# DEALLOCATE update_numcol;
DEALLOCATE