wgip

As part of #501, we bring back Dynamic VE tests, however, some of them are failing (so ignored for now). This Issue is to track the work to fix these...

(using `testQuick` too) - [ ] should we run some jobs automatically every 8 hours or so so that the state of things is always validated? - [x] `Test /...

Projection/TPC issue: MatchError substring(input_1#6269, 1, 2) (Query 22)

16

``` Query 22 *** FAILED *** (Hide Details) Message: substring(input_1#6269, 1, 2) AS cntrycode#6518 (of class org.apache.spark.sql.catalyst.expressions.Alias) Exception: scala.MatchError com.nec.spark.agile.SparkExpressionToCExpression$.evalString(SparkExpressionToCExpression.scala:161) com.nec.spark.planning.VERewriteStrategy.$anonfun$apply$2(VERewriteStrategy.scala:134) ```

Due to the compression they provide

``` Query 15 *** FAILED *** (Hide Details) Message: List((8449,Supplier#000008449,Wp34zim9qYFbVctdW,20-469-856-8873,1772627.2087)) did not equal List((8449,Supplier#000008449,Wp34zim9qYFbVctdW,20-469-856-8873,1772627.2087000003)) ``` This is a quick-win, just in terms of knowing where we stand

``` Query 7 *** FAILED *** (Hide Details) Message: input_4#1910 AS supp_nation#2064 (of class org.apache.spark.sql.catalyst.expressions.Alias) Exception: scala.MatchError com.nec.spark.agile.SparkExpressionToCExpression$.evalString(SparkExpressionToCExpression.scala:161) ```

Reproduced in the Dynamic C test