[MCOL-95] working_tpch1_compareLogOnly/partitionOptimization - store procedure errors Created: 2016-06-01  Updated: 2016-06-01  Resolved: 2016-06-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: None
Fix Version/s: 1.0.0

Type: Bug Priority: Minor
Reporter: David Hill (Inactive) Assignee: David Hall (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

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)



 Comments   
Comment by David Hill (Inactive) [ 2016-06-01 ]

looks like same in the storedProcedures folder

at sp.sql.log
ERROR 1303 (2F003) at line 19: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 25: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 31: Can't create a PROCEDURE from within another stored routine
ERROR 1303 (2F003) at line 37: 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

Comment by David Hill (Inactive) [ 2016-06-01 ]

duplicate of MCOL-45

Generated at Thu Feb 08 02:18:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.