mrzzzrm

Only in ../tpch-dbgen/: answers
Only in ../tpch-dbgen/: bcd2.c
Only in ../tpch-dbgen/: bcd2.h
Only in ../tpch-dbgen/: bcd2.o
diff -p third_party/tpch-dbgen/bm_utils.c ../tpch-dbgen/bm_utils.c
*** third_party/tpch-dbgen/bm_utils.c	2019-04-16 17:06:53.528759641 +0200
--- ../tpch-dbgen/bm_utils.c	2019-04-16 11:39:42.886691071 +0200
***************
*** 67,73 ****
  #endif            /* HP */

mrzzzrm

#include <iostream>

#include <chrono>

#include "types.hpp"
#include "expression/evaluation/expression_evaluator.hpp"
#include "expression/expression_functional.hpp"
#include "logical_query_plan/stored_table_node.hpp"
#include "storage/storage_manager.hpp"
#include "tpch/tpch_table_generator.hpp"

mrzzzrm

+-----------+-------------------+------+-------------------+------+--------+---------------------------------+
| Benchmark | prev. iter/s      | runs | new iter/s        | runs | change | p-value (significant if <0.001) |
+-----------+-------------------+------+-------------------+------+--------+---------------------------------+
| 10a       | 1.38898563385     | 4    | 1.3584805727      | 4    | -2%    |                                 |
| 10b       | 1.4033523798      | 4    | 1.41070389748     | 4    | +1%    |                                 |
| 10c       | 0.325197100639    | 4    | 0.315420240164    | 4    | -3%    |                                 |
| 11a       | 1.11681199074     | 4    | 1.0961265564      | 4    | -2%    |                                 |
| 11b       | 1.31984686852     | 4    | 1.32565557957     | 4    | +0%    |                                 |
| 11c       | 0.00119730341248  | 1    | 0.00136229034979  | 1    | +14%   |                                 |
| 11d       | 0.000487156

mrzzzrm

WARNING: ThreadSanitizer: data race (pid=14582)
  Write of size 8 at 0x7b2000000bb8 by thread T1 (mutexes: write M2287):
    #0 void std::vector<std::shared_ptr<opossum::Chunk>, std::allocator<std::shared_ptr<opossum::Chunk> > >::_M_realloc_insert<std::shared_ptr<opossum::Chunk> >(__gnu_cxx::__normal_iterator<std::shared_ptr<opossum::Chunk>*, std::vector<std::shared_ptr<opossum::Chunk>, std::allocator<std::shared_ptr<opossum::Chunk> > > >, std::shared_ptr<opossum::Chunk>&&) /usr/bin/../lib/gcc/x86_64-linux-gnu/8/../../../../include/c++/8/bits/vector.tcc:471:30 (hyrisePlayground+0x345eb2c)
    #1 std::shared_ptr<opossum::Chunk>& std::vector<std::shared_ptr<opossum::Chunk>, std::allocator<std::shared_ptr<opossum::Chunk> > >::emplace_back<std::shared_ptr<opossum::Chunk> >(std::shared_ptr<opossum::Chunk>&&) /usr/bin/../lib/gcc/x86_64-linux-gnu/8/../../../../include/c++/8/bits/vector.tcc:109:4 (hyrisePlayground+0x345bb31)
    #2 opossum::Table::append_chunk(std::vector<std::shared_ptr<opossum::BaseSegment>, boost:

mrzzzrm

  auto gt_customer = std::make_shared<opossum::GetTable>("CUSTOMER");
  auto validate = std::make_shared<opossum::Validate>(gt_customer);

  auto first_filter = std::make_shared<opossum::TableScan>(validate, opossum::ColumnID{5} /* "C_LAST" */,
                                                           opossum::ScanType::OpEquals, c_last);

  auto second_filter = std::make_shared<opossum::TableScan>(first_filter, opossum::ColumnID{1} /* "C_D_ID" */,
                                                            opossum::ScanType::OpEquals, c_d_id);

  auto third_filter = std::make_shared<opossum::TableScan>(second_filter, opossum::ColumnID{2} /* "C_W_ID" */,

mrzzzrm

SELECT c_balance, c_first, c_middle, c_id
FROM customer
WHERE c_last=? AND c_d_id=? AND c_w_id=?
ORDER BY c_first;

mrzzzrm

SELECT * FROM a INNER JOIN b ON a.id = b.id;

mrzzzrm

SELECT * FROM a, b WHERE a.id = b.id;

mrzzzrm

SELECT 
  InnerResult[0] 
FROM 
  (SELECT 
     T1[0], T2[2] 
   FROM 
     T1 JOIN T2 ON T1[0] = T2[2]
) AS InnerResult;

mrzzzrm

-- In the inner query
 --   * c needs to be resolved to ”T2”, but could also be referred by ”T2.c”
--    * T1.a needs to have the prefix, because ”T2” also contains a column ”a”
 --   * The first output column is nevertheless named “a” and not “T1.a”
 -- In the outer query, the ”InnerResult” prefix is, again, optional, but 
--   the subquery needs to have an alias
SELECT 
  InnerResult.a 
FROM 
  (SELECT