Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
None
-
None
-
nightly regression test
Description
I added in the working_tpch1_compareLogOnly into the nightly regression test run today, I didn't even have these set of scripts on my machine.
A number of failures in this folder : partitionOptimization
Need to be investigated. log isn't matching the ref log from InfiniDB.
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/aCreateViews.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/bug5848.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTest001.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch01.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch02.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch03.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch04.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch05.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch06.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch07.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch08.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch09.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch10.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch11.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch12.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch13.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch14.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch15.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch16.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch17.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch18.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch19.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch20.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch21.sql
Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch22.sql
here are some examples:
[root@srvregtest partitionOptimization]# cat aCreateViews.sql.log
ERROR 1303 (2F003) at line 32: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 44: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 63: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 74: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 86: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 94: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 104: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 111: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 117: Can't create a PROCEDURE from within another stored routine
[root@srvregtest partitionOptimization]# cat aCreateViews.sql.ref.log
lineitem_count
6001215
v_lineitem_count
6001215
orders_count
1500000
v_orders_count
1500000
part_count
200000
-----------------------------
cat vTpch22.sql.log
ERROR 1305 (42000) at line 19: PROCEDURE tpch1.customerColumnsTouched does not exist
ERROR 1305 (42000) at line 20: PROCEDURE tpch1.ordersColumnsTouched does not exist
ERROR 1305 (42000) at line 21: PROCEDURE tpch1.eliminatedBlocksGE does not exist
[root@srvregtest partitionOptimization]# cat vTpch22.sql.ref.log
calsettrace(1)