Sql Compiler: Add escape after IN operator

rldhont · rldhont · commit 904d26abd2a8 · 2017-01-02T16:25:32.000+01:00
diff --git a/src/core/qgssqlexpressioncompiler.cpp b/src/core/qgssqlexpressioncompiler.cpp
@@ -314,7 +314,7 @@ QgsSqlExpressionCompiler::Result QgsSqlExpressionCompiler::compileNode( const Qg
       if ( rn != Complete && rn != Partial )
         return rn;
 
-      result = QStringLiteral( "%1 %2IN(%3)" ).arg( nd, n->isNotIn() ? "NOT " : "", list.join( QStringLiteral( "," ) ) );
+      result = QStringLiteral( "%1 %2IN (%3)" ).arg( nd, n->isNotIn() ? "NOT " : "", list.join( QStringLiteral( "," ) ) );
       return ( inResult == Partial || rn == Partial ) ? Partial : Complete;
     }
 

Original file line number	Diff line number	Diff line change
`@@ -314,7 +314,7 @@ QgsSqlExpressionCompiler::Result QgsSqlExpressionCompiler::compileNode( const Qg`
`314`	`314`	`if ( rn != Complete && rn != Partial )`
`315`	`315`	`return rn;`
`316`	`316`
`317`		`- result = QStringLiteral( "%1 %2IN(%3)" ).arg( nd, n->isNotIn() ? "NOT " : "", list.join( QStringLiteral( "," ) ) );`
	`317`	`+ result = QStringLiteral( "%1 %2IN (%3)" ).arg( nd, n->isNotIn() ? "NOT " : "", list.join( QStringLiteral( "," ) ) );`
`318`	`318`	`return ( inResult == Partial \|\| rn == Partial ) ? Partial : Complete;`
`319`	`319`	`}`
`320`	`320`