alaisi / postgres.async

Asynchronous PostgreSQL client for Clojure
Eclipse Public License 1.0
137 stars 9 forks source link

Multidimensional arrays don't seem to work #23

Open theasp opened 8 years ago

theasp commented 8 years ago

This is the result of trying to insert [[6 6]] into a column of INTEGER[][].

                                                      java.lang.Thread.run                         Thread.java: 745
io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run           DefaultThreadFactory.java: 137  
                  io.netty.util.concurrent.SingleThreadEventExecutor$2.run      SingleThreadEventExecutor.java: 112
                                     io.netty.channel.nio.NioEventLoop.run                   NioEventLoop.java: 371  
                     io.netty.channel.nio.NioEventLoop.processSelectedKeys                   NioEventLoop.java: 399
            io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized                   NioEventLoop.java: 485
                      io.netty.channel.nio.NioEventLoop.processSelectedKey                   NioEventLoop.java: 528
            io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read         AbstractNioByteChannel.java: 131
                   io.netty.channel.DefaultChannelPipeline.fireChannelRead         DefaultChannelPipeline.java: 962
            io.netty.channel.AbstractChannelHandlerContext.fireChannelRead  AbstractChannelHandlerContext.java: 278
          io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead  AbstractChannelHandlerContext.java: 292  
                   io.netty.handler.codec.ByteToMessageDecoder.channelRead           ByteToMessageDecoder.java: 264
               io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead           ByteToMessageDecoder.java: 277
            io.netty.channel.AbstractChannelHandlerContext.fireChannelRead  AbstractChannelHandlerContext.java: 278
          io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead  AbstractChannelHandlerContext.java: 292
                   io.netty.handler.codec.ByteToMessageDecoder.channelRead           ByteToMessageDecoder.java: 264
               io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead           ByteToMessageDecoder.java: 277
            io.netty.channel.AbstractChannelHandlerContext.fireChannelRead  AbstractChannelHandlerContext.java: 278
          io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead  AbstractChannelHandlerContext.java: 292
         com.github.pgasync.impl.netty.NettyPgProtocolStream$5.channelRead          NettyPgProtocolStream.java: 304
              com.github.pgasync.impl.netty.NettyPgProtocolStream$1.onNext          NettyPgProtocolStream.java: 197
            com.github.pgasync.impl.netty.NettyPgProtocolStream.access$300          NettyPgProtocolStream.java:  46
        com.github.pgasync.impl.netty.NettyPgProtocolStream.toSqlException          NettyPgProtocolStream.java: 223
com.github.pgasync.SqlException: ERROR: SQLSTATE=22P02, MESSAGE=malformed array literal: "[[6,6]]"
    code: "22P02"
alaisi commented 8 years ago

Hi,

can you provide a test case for this? Are you trying to use a vector as a parameter (requires extending IPgParameter) or trying to run a constant string sql insert?

Thanks, Antti