SimpleDB NullPointerException when inserting null value ------------------------------------------------------- Key: TEIID-3819 URL: https://issues.jboss.org/browse/TEIID-3819 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1.6_2 Reporter: Jan Stastny Assignee: Steven Hawkins Fix For: 8.12.2, 8.13 Attachments: simpledb-vdb.xml, simpledb.cli When performing INSERT query, where one of the values is null, NullPointerException is thrown. Example query: {code:sql} INSERT INTO SMallA(ItemName,doublenum) VALUES ('nullRow',null) {code} Stack trace in teiid's console: {code:plain} 13:59:57,789 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue35) TEIID30019 Unexpected exception for request dypFs9C3QJ3B.14: java.lang.NullPointerException at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.addAttribute(SimpleDBConnectionImpl.java:255) at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performInsert(SimpleDBConnectionImpl.java:223) at org.teiid.translator.simpledb.SimpleDBInsertExecute.execute(SimpleDBInsertExecute.java:52) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:363) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] {code}