Query 15 of chbenchmark is incorrect for Oracle

[ai86-64]

Hi

Query 15 of chbenchmark is incorrect for Oracle db. Sequence create view - execute query - drop view does not work in multisession teset run.
There is 100% probability q15 failure becase of "this vew already exists" database error.

It is necessary fix dialect-oracle.xml like this way:

    <procedure name="Q15">
        <statement name="createview_stmt">
            select 1 from dual
        </statement>
        <statement name="query_stmt">
           WITH revenue0 (supplier_no, total_revenue) AS (
             SELECT  mod((s_w_id * s_i_id),10000) as supplier_no, sum(ol_amount) as total_revenue
             FROM  order_line, stock
             WHERE
                ol_i_id = s_i_id 
                AND ol_supply_w_id = s_w_id 
                AND ol_delivery_d >= to_date('2007-01-02 00:00:00','yyyy-mm-dd hh24:mi:ss')
             GROUP BY mod((s_w_id * s_i_id),10000))
           SELECT su_suppkey, su_name,  su_address, su_phone, total_revenue
           FROM supplier, revenue0 
           WHERE su_suppkey = supplier_no 
              AND total_revenue = (select max(total_revenue) from revenue0)
           ORDER BY su_suppkey
        </statement>
        <statement name="dropview_stmt">
            select 1 from dual
        </statement>
    </procedure>

Best reagrds,
Andrey.