Opened 5 years ago
Closed 5 years ago
#2207 closed defect (wontfix)
Case evaluation model for div and mod.
Reported by: | apercov | Owned by: | apercov |
---|---|---|---|
Priority: | major | Milestone: | 10.0 |
Component: | qlparser | Version: | 9.8 |
Keywords: | Cc: | ||
Complexity: | Medium |
Description
The case evaluation model was updated with the ticket 2190. However, queries containing div and mod operators are getting evaluated with old model, which is drastically slower.
Also old model fails when it contains arrays that do not adhere to the same tiling scheme.
E.g. these queries in the systemtest:
---------------------------------------------------------------------- induction_all_operations_int_divide.rasql select (case when test_grey2 = 0 then 0c else div(test_grey, test_grey2) end) from test_grey, test_grey2 ---------------------------------------------------------------------- induction_all_operations_modulo.rasql select (case when test_grey2 = 0 then 0c else mod(test_grey, test_grey2) end) from test_grey, test_grey2.. fail when test_grey and test_grey2 (mr collections basically) are
inserted with different tiling schemes:
rasql --user rasadmin --passwd rasadmin -q 'create collection test_grey GreySet' rasql --user rasadmin --passwd rasadmin -q 'create collection test_grey2 GreySet' rasql --user rasadmin --passwd rasadmin -q 'insert into test_grey values decode($1 ) tiling aligned [0:49,0:29] tile size 1500' -f $RMANSRC/src/systemtest/testcases_mandatory/test_select/testdata/mr_1.png rasql --user rasadmin --passwd rasadmin -q 'insert into test_grey2 values decode($1 ) tiling aligned [0:29,0:59] tile size 1800' -f $RMANSRC/src/systemtest/testcases_mandatory/test_select/testdata/mr_1.png
Change History (2)
comment:1 by , 5 years ago
Owner: | set to |
---|---|
Status: | new → accepted |
comment:2 by , 5 years ago
Resolution: | → wontfix |
---|---|
Status: | accepted → closed |
Note:
See TracTickets
for help on using tickets.