[SOLR-2141] NullPointerException when using escapeSql function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.1, 4.0
• Fix Version/s: 4.1, 6.0
• Component/s: contrib - DataImportHandler

Environment

openjdk 1.6.0 b12

• Assignee: James Dyer
• Reporter: Edward Rudd
• Created: 05/Oct/10 01:37
• Updated: 09/May/16 18:56
• Resolved: 27/Nov/12 16:51

Description

I have two entities defined, nested in each other..

<entity name="article" query="select category, subcategory from articles">
<entity name="other" query="select other from othertable where category='${dataimporter.functions.escapeSql(article.category)}'
AND subcategory='${dataimporter.functions.escapeSql(article.subcategory)}'">
</entity>
</entity>

Now, when I run that it bombs on any article where subcategory = '' (it's a NOT NULL column so empty string is there) If i do where subcategory!='' in the article query it works fine (aside from not pulling in all of the articles).

org.apache.solr.handler.dataimport.DataImportHandlerException: java.lang.NullPointerException
at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:424)
at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:383)
at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
Caused by: java.lang.NullPointerException
at org.apache.solr.handler.dataimport.EvaluatorBag$1.evaluate(EvaluatorBag.java:75)
at org.apache.solr.handler.dataimport.EvaluatorBag$5.get(EvaluatorBag.java:216)
at org.apache.solr.handler.dataimport.EvaluatorBag$5.get(EvaluatorBag.java:204)
at org.apache.solr.handler.dataimport.VariableResolverImpl.resolve(VariableResolverImpl.java:107)
at org.apache.solr.handler.dataimport.TemplateString.fillTokens(TemplateString.java:81)
at org.apache.solr.handler.dataimport.TemplateString.replaceTokens(TemplateString.java:75)
at org.apache.solr.handler.dataimport.VariableResolverImpl.replaceTokens(VariableResolverImpl.java:87)
at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71)
at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
... 6 more

Issue Links

• is related to: SOLR-4047 dataimporter.functions.encodeUrl throughs Unable to encode expression: field.name with value: null
• relates to: SOLR-3842 DataImportHandler: When attempting to use column values as field names, multivalued fields only retain the first result