LineitemJoinAggregate

Continuous Benchmarking

LineitemJoinAggregate - [aggregate] Execute the query "SELECT l_returnflag, l_linestatus, sum(l_quantity) AS sum_qty, sum(l_extendedprice) AS sum_base_price, sum(l_extendedprice * (1 - l_discount)) AS sum_disc_price, sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS sum_charge, avg(l_quantity) AS avg_qty, avg(l_extendedprice) AS avg_price, avg(l_discount) AS avg_disc, count(*) AS count_order FROM lineitem, orders WHERE l_orderkey=o_orderkey GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus" on SF1
CommitDateResultLogsMessage
12b02020-05-061.03[Q/L/E]support builtin function right
71412020-05-061.03[Q/L/E]Merge pull request #631 from zz-jason/function/right support builtin function right
dd172020-05-061.02[Q/L/E]Merge pull request #621 from cwida/rigger10 Fixes for Rigger #10
c65b2020-05-051.03[Q/L/E]Merge pull request #620 from zz-jason/function/left add builtin function left
6aeb2020-05-051.04[Q/L/E]address comment
c8202020-05-051.02[Q/L/E]replace space with tab
9ccd2020-05-051.03[Q/L/E]remove irrelevant header files
52262020-05-051.01[Q/L/E]add builtin function left
0e4b2020-05-041.02[Q/L/E]r package version bump
eb2a2020-05-041.02[Q/L/E]Merge pull request #612 from cwida/altertable Additional Alter Table Support
16962020-05-041.04[Q/L/E]Merge pull request #616 from cwida/fastpandasscan Fast Pandas Scan
8b522020-05-031.01[Q/L/E]Merge branch 'master' into altertable
877b2020-05-031.03[Q/L/E]Merge branch 'master' into fastpandasscan
1a7e2020-05-031.03[Q/L/E]Merge pull request #615 from cwida/feckingpy2 mc for python2
c66c2020-05-031.05[Q/L/E]Fix for python 2 pkg
dbd72020-05-031.04[Q/L/E]Disable wheel and just run build and test locally
c5882020-05-031.03[Q/L/E]Try setting to Python 2.7.10
86a22020-05-031.04[Q/L/E]Try building only a specific version
5f092020-05-031.04[Q/L/E]Disable Python 2 wheel builds for now...
c8482020-05-031.03[Q/L/E]Add numpy/pandas to download
896a2020-05-031.03[Q/L/E]Try language:generic instead of language:python
6f012020-05-031.04[Q/L/E]Try latest cibuildwheel version
b1952020-05-031.03[Q/L/E]Other dist
f2872020-05-031.08[Q/L/E]Try different dist for Python 2 Travis
b7852020-05-031.06[Q/L/E]Merge pull request #614 from hawkfish/hawkfish-datefunc Hawkfish datefunc
767b2020-05-021.04[Q/L/E]Issue 193: DAYNAME Implement and test.
5c722020-05-021.01[Q/L/E]Issue 193: MONTHNAME Implement and test.
100c2020-05-021.03[Q/L/E]Issue 193: LAST_DAY Implement and test.
5b962020-05-021.03[Q/L/E]Issue 193: WEEKOFYEAR and YEARWEEK Implement and test.
8f542020-05-021.01[Q/L/E]Issue 193: DAYOFMONTH and WEEKDAY Implement and test alias functions.
c7cb2020-05-021.04[Q/L/E]Merge pull request #11 from cwida/master Merge as of 2020-05-02
8c242020-05-021.05[Q/L/E]Merge pull request #607 from cwida/pyrel2 Python API: added execute() and query() methods for relations
53da2020-05-021.05[Q/L/E]Merge pull request #608 from hawkfish/hawkfish-bitfunc Hawkfish bitfunc
4b722020-05-021.05[Q/L/E]Merge pull request #611 from hawkfish/hawkfish-issue610 Hawkfish Issue 610
11e52020-05-011.04[Q/L/E]Merge pull request #597 from hawkfish/hawkfish-stringfunc Implement more string functions
fa0e2020-05-011.04[Q/L/E]Issue 610: LPAD/RPAD argument type Make the count argument a 32 bit integer to prevent overflow.
fabd2020-05-011.03[Q/L/E]Issue 193: GetScalarIntegerUnaryFunctionFixedReturn Only used in one file.
926c2020-05-011.03[Q/L/E]Issue 193: Reformat BIT_AGG GetBitfieldUnaryAggregate is only used in one file.
32562020-05-011.01[Q/L/E]Issue 193: BIT_AND, BIT_OR, BIT_XOR Implement and test.
0e0d2020-05-011.05[Q/L/E]Merge pull request #606 from cwida/fixsourceid Fix recompile of all sources after commit
ec502020-05-011.03[Q/L/E]Issue 193: BIT_COUNT Implement and test.
52822020-05-011.01[Q/L/E]Issue 193: BIT_LENGTH Implement and test.
ff292020-05-011.04[Q/L/E]Merge pull request #10 from cwida/master Pull string functions
f2072020-04-301.06[Q/L/E]Avoid creating an adaptive filter when there are no filters
cfbe2020-04-301.04[Q/L/E]Only include DUCKDB_SOURCE_ID definition where necessary
a3822020-04-301.06[Q/L/E]Merge pull request #601 from cwida/rigger9 New Batch of Rigger Fixes
67362020-04-291.05[Q/L/E]Correctly call UTFVerify in execute_function: selection vector is already handled before this point, so don't apply it again (fixes #603)
22a52020-04-291.06[Q/L/E]Add optimization to collators: for collators that only affect order but not equality, we now have a flag that skips applying the collation function when equality is required (i.e. distinct, group by and equality comparisons/joins)
ef292020-04-291.05[Q/L/E]Support GROUP BY in collations (fixes #602)
9f452020-04-291.02[Q/L/E]Implement repalloc in Postgres parser, allowing the parser to correctly handle long string constants (found by Pedro)
50a92020-04-291.02[Q/L/E]Merge pull request #598 from cwida/pyrel Python wrappers for relational API
b6362020-04-291.03[Q/L/E]adding some attributes to inspect relations (alias, type, columns, types) and hopefully fixing test
4e7a2020-04-281.03[Q/L/E]added from_csv_auto support to python client
c8af2020-04-281.03[Q/L/E]Merge remote-tracking branch 'origin/master' into pyrel
c0fe2020-04-281.03[Q/L/E]Merge pull request #582 from tdoehmen/csv_sniffer csv sniffer for dialect, data type and header detection
ce2b2020-04-281.03[Q/L/E]merged with master
797c2020-04-281.05[Q/L/E]only activate auto_csv tests if STANDARD_VECTOR_SIZE>=16, removed unused fs variable
90e32020-04-281.04[Q/L/E]made strict casts available via parameter and dropped StrictCast operator, simplified isMoreGenericThan method, fixed enums in csv sniffer, catched parser exception while jumping, split up unittests
8b912020-04-271.01[Q/L/E]Merge pull request #594 from cwida/extension ICU Extension & Extension Support
2bb32020-04-271.01[Q/L/E]Add more tests for various collations taken from the unicode website
f4042020-04-271.01[Q/L/E]Remove printing from test
b7052020-04-271.01[Q/L/E]On Windows, link to static build of DuckDB
56912020-04-271.02[Q/L/E]Also ened to rename relation types for Windows
f05f2020-04-271.02[Q/L/E]Rename statement types because windows.h likes to #define simple words
22112020-04-261.02[Q/L/E]Or is the windows path like this?
1b8e2020-04-261.02[Q/L/E]Correct path for Travis Windows
a6502020-04-261.02[Q/L/E]Merge branch 'master' into extension
e3502020-04-261.03[Q/L/E]Format
044c2020-04-261.02[Q/L/E]Merge pull request #593 from cwida/rigger8 Rigger Test Fixes
96d52020-04-261.02[Q/L/E]Fix for #592
63f42020-04-261.03[Q/L/E]Fix for #590
0cb82020-04-261.03[Q/L/E]For FIRST aggregate, use int8_t for BOOLEAN type (fixes #581)
a7502020-04-261.02[Q/L/E]Correctly compute year length of large negative years in DATE -> VARCHAR cast (fixes #587 and #591)
0bfd2020-04-261.01[Q/L/E]Throw an error message when creating an index on the rowid column (fixes #589)
8a7c2020-04-261.02[Q/L/E]In Orrify, if we have a compressed vector inside a dictionary don't normalify inside the dictionary itself, because we might be decompressing only part of the vector. This can cause problems if another part of that vector is then required elsewhere. (Fixes #588)
77f32020-04-261.04[Q/L/E]In caseconvert, correctly handle the case where LOWER/UPPER results in a UTF character with a different byte-width than the original UTF character (Fixes #586)
e8ec2020-04-261.05[Q/L/E]Also disallow moving casts to other side of comparison in case of VARCHAR -> NUMERIC, as this can change the order (e.g. -1 < -2, but '-1' > '-2'). This fixes #584.
dc352020-04-251.02[Q/L/E]Fixing #585
bc962020-04-251.01[Q/L/E]Fixing #583
1d2e2020-04-251.04[Q/L/E]Merge branch 'rigger8' of https://github.com/cwida/duckdb into rigger8
f7752020-04-251.03[Q/L/E]Fix with upd_counter on selections for strings
184f2020-04-241.03[Q/L/E]Fix for ASCII substring with out of range offset
251c2020-04-241.04[Q/L/E]Fix typo
e9132020-04-241.04[Q/L/E]Skip comparison optimization on non-invertible casts (e.g. INT -> BOOL is not invertible, because -1 -> TRUE -> 1). This fixes #571.
ed922020-04-241.05[Q/L/E]Merge pull request #570 from cwida/utf8fix Use Grapheme Cluster Breakers in Reverse and Shell
2ea42020-04-231.05[Q/L/E]Fix typo
8cd22020-04-231.05[Q/L/E]More easy aliasing of scalar functions
eada2020-04-231.04[Q/L/E]Add support for COLLATE in expressions
bf302020-04-231.00[Q/L/E]Add support for default collation type. The collation can be set on database startup and changed through PRAGMA default_collation='x';
9ef02020-04-231.03[Q/L/E]Merge branch 'master' into utf8fix
0b7d2020-04-221.04[Q/L/E]Merge pull request #574 from cwida/zonemaps Using adaptive filters in table scans
b2a52020-04-211.04[Q/L/E]Merge branch 'master' of https://github.com/cwida/duckdb into zonemaps
c3892020-04-211.03[Q/L/E]Optimizing expressions on empty PREFIX/CONTAINS/SUFFIX needles (#573)
a09d2020-04-191.03[Q/L/E]Merge pull request #551 from cwida/zonemaps New batch of zonemap stuff
484a2020-04-181.02[Q/L/E]Fixing bug on all elements from the chunk were filtered
d7c72020-04-181.02[Q/L/E]Merge branch 'master' of https://github.com/cwida/duckdb into zonemaps
8e102020-04-181.03[Q/L/E]Fixing lock bug
c6642020-04-171.03[Q/L/E]Make scanning great again
4f1b2020-04-171.10[Q/L/E]Adding fetch on format
44fb2020-04-171.07[Q/L/E]Format
3a302020-04-171.07[Q/L/E]Myth changes
e1342020-04-171.03[Q/L/E]Format
09f42020-04-171.03[Q/L/E]Merge pull request #566 from cwida/buildsystemfix Build System Fixes
90c22020-04-171.03[Q/L/E]Try to fix path issue on windows
1f6f2020-04-171.03[Q/L/E]No longer call UncompressedSegment::Verify while writing; it breaks for overflow strings
184d2020-04-171.03[Q/L/E]Fix amalgamation build
c9e92020-04-171.04[Q/L/E]Fix GCC warning
481a2020-04-171.04[Q/L/E]Switch to bionic again in travis
6f452020-04-171.05[Q/L/E]Construct the free list based directly on the used blocks in the checkpoint, rather than on the blocks read
55902020-04-161.02[Q/L/E]Add missing file
68be2020-04-161.03[Q/L/E]Merge branch 'master' into buildsystemfix
43082020-04-161.03[Q/L/E]Try to switch dist
ad782020-04-161.04[Q/L/E]Try removing this ppa
cc5e2020-04-161.03[Q/L/E]Merge pull request #564 from cwida/rigger7 Rigger Test Fixes
3cea2020-04-161.02[Q/L/E]Merge pull request #563 from cwida/viewtfrelation Add ViewRelation and TableFunctionRelation
11792020-04-161.04[Q/L/E]Merge pull request #559 from tiagokepe/master Like optimization rules
e7582020-04-151.05[Q/L/E]Skip unity build entirely
ab492020-04-151.04[Q/L/E]Merge remote-tracking branch 'upstream/master'
b8d92020-04-151.03[Q/L/E]Added missing include.
1f352020-04-151.05[Q/L/E]Initial implementation of railroad diagrams for statements
80272020-04-151.05[Q/L/E]Merge pull request #558 from cwida/rigger6 Next Batch of Rigger fixes
8e9d2020-04-141.05[Q/L/E]Fix for sqlite api wrapper
50842020-04-141.05[Q/L/E]Fix for filter pushdown into left join: properly handle case where optimizer splits single expression into multiple expressions (fixes #552)
13c32020-04-141.02[Q/L/E]Handle dictionary vector in StringVector::AddHeapReference (fixes #549)
fda82020-04-141.03[Q/L/E]Sum all types (int32, int64) to DOUBLE to avoid overflow (fixes #543)
dae32020-04-141.05[Q/L/E]New rigger tests
05602020-04-141.03[Q/L/E]Prepared Statement support & Semi-official compliance tests for JDBC driver (#550)
4dcd2020-04-141.03[Q/L/E]Merge pull request #548 from cwida/namedwindowfix Named Window Fix & Rigger Fix
49062020-04-131.08[Q/L/E]Codefactor
09562020-04-131.04[Q/L/E]Remove null terminators produced by regex range filter (fixes #547)
de6b2020-04-131.04[Q/L/E]Better error message for errors in WINDOW clause, and add test case for duplicate window clause name
00a22020-04-131.06[Q/L/E]Correctly bind and scope named window parameters in transformer (fixes #546)
f3c72020-04-131.05[Q/L/E]Merge pull request #542 from cwida/rigger5 Rigger Test Fixes 5
72492020-04-131.04[Q/L/E]Don't plan empty ORDER nodes (fixes #544)
0f952020-04-131.03[Q/L/E]Fix bork of bork fix
ee092020-04-131.04[Q/L/E]Merge pull request #541 from cwida/nan Disallow NaN/INF in the system
b4aa2020-04-130.88[Q/L/E]Off by one
79452020-04-130.89[Q/L/E]Properly copy strings into vectors when scanning aggregates again (fixes #540)
faf42020-04-130.87[Q/L/E]Out of range shifts return 0; like SQLite (fixes #538)
504e2020-04-130.87[Q/L/E]Remove LogicalPrune and PhysicalPrune; instead add a projection node when ORDER BY columns need to be pruned (fixes #537)
0fe62020-04-130.89[Q/L/E]Add new bugs found by Rigger
1cc02020-04-131.04[Q/L/E]Ignore NULL values in float/double arithmetic
a1e92020-04-131.07[Q/L/E]Remove NaN handling in merge join: NaN's should never occur anymore in the system
2f852020-04-131.02[Q/L/E]Handle overflows in STRING -> REAL/DOUBLE casts
cba92020-04-131.03[Q/L/E]Prevent NAN/INF from entering the system through the Appender as well
05972020-04-131.05[Q/L/E]Test for INF and NaN produced by arithmetic as well
45a02020-04-130.88[Q/L/E]Throw error if SUM/AVG aggregates produce INF
7f982020-04-130.87[Q/L/E]Throw exception on out of range double -> float cast
946c2020-04-130.87[Q/L/E]For all numeric/trigo functions, if errno is set or the function returns NaN or inf we convert the value to NULL instead
6c8e2020-04-130.87[Q/L/E]Throw error on out of range double constants in parser
4ab32020-04-130.88[Q/L/E]Merge pull request #529 from cwida/rigger4 Fixes for new batch of bugs
f5122020-04-120.87[Q/L/E]Correctly clean up string aggregates for min/max
80ec2020-04-120.87[Q/L/E]Newlines for codefactor
75482020-04-120.88[Q/L/E]For min/max of strings, properly allocate for non-inlined strings
65ed2020-04-120.88[Q/L/E]Add an optional SQL type to values. This type is set for Value::DATE, Value::TIME and Value::TIMESTAMP. If the value is not provided the default mapping is assumed (e.g. INT32->INTEGER). This fixes a problem with preparing DATE/TIME/TIMESTAMP values.
3fd52020-04-120.88[Q/L/E]Remove test that depended on casting "1" to DATE
03ea2020-04-120.87[Q/L/E]Correctly call string.Finalize() in REVERSE function (fixes #535)
18662020-04-120.88[Q/L/E]When fetching a value from a string segment, correctly fetch the data from the base table if there is an update present but the update does not apply to the current row.
79052020-04-120.87[Q/L/E]Add REAL type to GetTypeId<> to make #533 throw the correct error message
409b2020-04-120.87[Q/L/E]In executing of a cast expression, only skip the cast if the SQL types match, not just if the internal types match (fixes #531)
f7912020-04-120.87[Q/L/E]Extra tests again
98ab2020-04-120.89[Q/L/E]Rework round again: perform old computation instead of manual loop, but simply return unrounded value if the result is nan or inf
c5be2020-04-120.87[Q/L/E]In Round, when the precision is too high return the value as-is rather than performing a crude rounding
eec82020-04-120.88[Q/L/E]Remove redundant blank lines
1db22020-04-120.90[Q/L/E]For now disable tests for NaN resulting from floating point computations
10352020-04-120.87[Q/L/E]The regex range filter can only be applied for full match regex matches; it is incorrect for partial regex matches
50d42020-04-120.88[Q/L/E]Fix test for #527
5c642020-04-120.90[Q/L/E]Disable query verification for #526
05a82020-04-120.87[Q/L/E]Correct answer for test 526
a5a82020-04-120.90[Q/L/E]Handle count = 0 case properly in expression executor
6aaf2020-04-120.88[Q/L/E]New tests!
0e5a2020-04-120.87[Q/L/E]For filters with a projection map, push the projection even if the filter has no expressions (fixes #525)
e3992020-04-120.88[Q/L/E]Fix for #521, prevent ROUND from creating NaN/inf values
d0f42020-04-120.89[Q/L/E]Next batch of bugs found by Rigger
3f0e2020-04-120.88[Q/L/E]Merge pull request #524 from cwida/riggerart Fix for the ART bug #495
06142020-04-120.88[Q/L/E]Merge pull request #519 from cwida/rigger3 Rigger Test Fixes 3
17a02020-04-120.87[Q/L/E]Prepared statement support for JDBC Client (#520)
97952020-04-110.87[Q/L/E]Merge pull request #512 from cwida/rigger2 Rigger Test Fixes 2
5c4c2020-04-110.88[Q/L/E]RIGHT JOIN and creating index on boolean is now supported
95ca2020-04-110.88[Q/L/E]Fix for join transformer after merge
70d22020-04-110.89[Q/L/E]Merge branch 'master' into rigger2
c52f2020-04-110.87[Q/L/E]Merge pull request #509 from cwida/relationapi Relation API
f5f02020-04-110.89[Q/L/E]Add more tests that trigger various exceptions
2d942020-04-100.89[Q/L/E]More tests for relation API
058f2020-04-100.87[Q/L/E]Add Explain relation and verify that result of relation does not change (because of e.g. catalog changes)
ca1d2020-04-100.87[Q/L/E]Format
87e12020-04-100.87[Q/L/E]Merge branch 'master' into relationapi
340d2020-04-100.89[Q/L/E]Merge pull request #499 from cwida/rigger A collection of fixes for issues found by Manuel Rigger
57c32020-04-100.88[Q/L/E]Probably fixed #500, only create java strings for non-null entries. doh.
2a482020-04-100.87[Q/L/E]maybe this fixes #500, having issues to reproduce
f9e42020-04-090.88[Q/L/E]Show tables test: change "NULL" to NULL
40322020-04-090.90[Q/L/E]Link DuckDB to pthread: this is necessary for RE2 on Linux
b8a62020-04-090.89[Q/L/E]Display result of PRAGMA statement in shell and add test
9f8b2020-04-090.89[Q/L/E]Merge branch 'master' into rigger
4ad62020-04-090.90[Q/L/E]Merge pull request #501 from cwida/queryschema Add Support for SHOW/DESCRIBE Tables
70672020-04-090.89[Q/L/E]Fix for views with aliases
65d82020-04-090.87[Q/L/E]Allow DESCRIBE as alias to SHOW
c6902020-04-090.88[Q/L/E]Add support for SHOW TABLES and SHOW integers
c17e2020-04-090.88[Q/L/E]Allow pragma_table_info to be used for views as well, and throw an exception if a view is used when the underlying types have changed
f11d2020-04-090.88[Q/L/E]Fix for bool index entries, #496
c2ce2020-04-080.88[Q/L/E]JDBC client (#492)
d7962020-04-070.89[Q/L/E]Merge pull request #488 from tiagokepe/master Contains Scalar Function
2b322020-04-070.90[Q/L/E]Merge remote-tracking branch 'upstream/master' Merge from CWI repository.
aecb2020-04-070.87[Q/L/E]Removed bind info structures of old contains functions.
0e452020-04-070.86[Q/L/E]Removed benchmark of other contains functions.
844e2020-04-070.93[Q/L/E]Removed tests of other contains functions.
4f8f2020-04-070.86[Q/L/E]Keep only the winner contains function, i.e., contains using STRSTR.
bc9f2020-04-070.88[Q/L/E]Merge pull request #487 from xhochy/patch-1 pybind11 is a build-time-only dependency. Once the package is built, `pybind11` is no longer needed.
bd782020-04-070.86[Q/L/E]Added benchmark for contains with LIKE.
d1812020-04-070.88[Q/L/E]Benchmarking contains STRSTR.
4ee12020-04-070.88[Q/L/E]Added test for contains functions.
67ba2020-04-070.87[Q/L/E]Added test for contains using STRSTR.
c0442020-04-070.88[Q/L/E]Implemented contains with strstr.
b47e2020-04-070.88[Q/L/E]Update setup.py
64dc2020-04-070.88[Q/L/E]pybind11 is a build-time-only dependency Once the package is built, `pybind11` is no longer needed.
23272020-04-050.87[Q/L/E]r package version bump for release
f3f82020-04-030.88[Q/L/E]Direct scan operator for R data.frames (#483) * added code to register r data frames as virtual tables using duckdb_register * using scan function for append in dbWriteTable
848a2020-04-020.86[Q/L/E]Merge pull request #482 from cwida/zonemaps Skipping Segments
e6b32020-04-020.88[Q/L/E]Making sure we dont kaput filter nodes by mistake
ec9a2020-04-020.88[Q/L/E]Potentially fixing vector size segfault
eca32020-04-020.87[Q/L/E]More Myth Comments
e2082020-04-020.88[Q/L/E]Addressing Myth Comments
f2e42020-04-010.87[Q/L/E]Windexing it
c3252020-04-010.88[Q/L/E]More tests on the optimizer
61802020-04-010.87[Q/L/E]Merge branch 'master' of https://github.com/cwida/duckdb into zonemaps
52502020-04-010.89[Q/L/E]Fixing tpc ds queries
ce042020-04-010.86[Q/L/E]Rewrite Python API with pybind11 (#481)
250a2020-03-310.87[Q/L/E]Merge pull request #480 from tiagokepe/master Suffix Scalar Function
3ee82020-03-310.86[Q/L/E]Run Formater.
15a52020-03-310.86[Q/L/E]Added brackets around if statements and tests for NULL.
182c2020-03-300.88[Q/L/E]Added TPC-H benchmark for the suffix function.
cd242020-03-300.86[Q/L/E]Added random string benchmark for the suffix function.
c1ae2020-03-300.87[Q/L/E]Added test for the suffix function.
255c2020-03-300.87[Q/L/E]Register suffix function.
f8cb2020-03-300.87[Q/L/E]Implemented suffix function.
9bd42020-03-290.88[Q/L/E]Merge remote-tracking branch 'upstream/master'
a99b2020-03-280.86[Q/L/E]Adding auto-create feature to R client: duckdb.read.csv/read_csv_duckdb (#479) * support for read_csv_duckdb (alias: duckdb.read.csv) to automagically create a schema from a CSV file and import said file
4fec2020-03-280.86[Q/L/E]UTF8 NFC Normalization with utf8proc (#478) Normalize UTF8 strings to NFC where they enter DuckDB using utf8proc
acb42020-03-280.88[Q/L/E]removed erroneous header
c8462020-03-280.86[Q/L/E]Merge pull request #477 from tiagokepe/master Prefix Scalar Function
b9dd2020-03-270.89[Q/L/E]Merge pull request #475 from cwida/minorbugfixes Fix Minor Bugs
1a212020-03-270.86[Q/L/E]Keep only the best prefix algorithm.
04cd2020-03-270.87[Q/L/E]Added one more prefix algorithm, i.e., prefix8.
dd762020-03-270.87[Q/L/E]Fix for passing in nullptr to sqlite::QueryDatabase
8ed12020-03-270.88[Q/L/E]On sqlite::QueryDatabase, return a result containing the error instead of a nullptr if query compilation fails (fixes #470)
d7e52020-03-270.86[Q/L/E]Properly invalidate open prepared statements in ClientContext::Invalidate
c4892020-03-270.87[Q/L/E]Properly allocate space for non-inlined strings that are passed into FIRST aggregates
17b12020-03-270.86[Q/L/E]Merge pull request #474 from cwida/removeselvector Selection Vector Rework
91ba2020-03-260.87[Q/L/E]Merge branch 'master' into removeselvector
07a72020-03-260.87[Q/L/E]Add new type hash_t, and use uintptr_t instead of uint64_t for pointer arithmetic
a7162020-03-260.87[Q/L/E]Fixes for single file compilation
21bd2020-03-260.90[Q/L/E]Adding read only flag to Python module. (#473) * Adding read only flag to Python module. Usage: duckdb.connect('/some/file', True)
baca2020-03-240.89[Q/L/E]Support for prepared statements in R client (#468) Switched the R client to use prepared statements as well. Now supporting dbBind() natively.
a5172020-03-230.89[Q/L/E]Merge pull request #467 from lepennec/cursor_description Add description field to Python cursor to increase compatibility
a1ca2020-03-230.91[Q/L/E]Add test for Python cursor description
a8362020-03-220.94[Q/L/E]Add description field to Python cursor
04852020-03-200.89[Q/L/E]Merge pull request #463 from edalmeida/instrfunction Add support for SQL `INSTR(X, Y)`, checks if Y is contained in X and returns the position of the first match. See https://www.sqlite.org/lang_corefunc.html#instr
bf792020-03-190.89[Q/L/E]Code formatting to pass CodeFactor check
5c5b2020-03-190.91[Q/L/E]Code source formatting
8f612020-03-190.90[Q/L/E]Included UTF-8 test cases and benchmark (also with Regex function)
151a2020-03-170.89[Q/L/E]fixing virtualbox tests
e4232020-03-170.89[Q/L/E]Merge pull request #462 from informagi/master Minor update to fix command sequence.
02262020-03-160.90[Q/L/E]Minor update to fix command sequence.
a5562020-03-140.88[Q/L/E]Support for nested lists in projections and selections. New UNNEST operator. (#457)
52fb2020-03-130.89[Q/L/E]Merge pull request #458 from lepennec/date DATE type support for Python API
58cb2020-03-130.89[Q/L/E]Test objects rather than types
20d52020-03-120.88[Q/L/E]Merge pull request #455 from tiagokepe/rename-table Rename table
69bc2020-03-120.93[Q/L/E]Added storage test for a renamed table.]
b8e12020-03-120.92[Q/L/E]Added extra tests: CHECK_COLUMN, constrains, and non exist table.
1de72020-03-120.91[Q/L/E]Testing whether the table to be rename renamed exists.
21d52020-03-120.91[Q/L/E]Format table_catalog_entry.cpp.
97922020-03-110.90[Q/L/E]Copying regular constraint in the Copy() method. Using Copy() in the AlterEntry.
52cc2020-03-110.92[Q/L/E]Use an assertion to check the catalog type.
d4822020-03-100.89[Q/L/E]Removed unsed attributes.
0fcf2020-03-100.90[Q/L/E]When there are no new values in DISTINCT aggregates skip the update step
6e602020-03-100.91[Q/L/E]Added unit test for RENAME TABLE.
519a2020-03-090.89[Q/L/E]Merge pull request #453 from cwida/aggregaterework Rework Aggregate Function Interface
d1c62020-03-090.89[Q/L/E]Fix for combine of SUM/MIN/MAX when the target is uninitialized (NULL)
c24e2020-03-090.91[Q/L/E]Fix includes for single file compilation
3b872020-03-090.90[Q/L/E]Merge branch 'master' into aggregaterework
35b02020-03-090.90[Q/L/E]Format
7e462020-03-090.90[Q/L/E]Workaround for GCC bug
92562020-03-090.89[Q/L/E]Remove now-unused scatter functions
48392020-03-090.89[Q/L/E]Fix for Combine, source state is not vector of pointers to states but rather vector of states
c6972020-03-090.89[Q/L/E]Add some extra STRING_AGG tests
b2c42020-03-090.90[Q/L/E]Rework aggregate function interface
1cfd2020-03-080.92[Q/L/E]Fixing datetime in fetchall()/fetchone() (#451) * fixing datetime in fetchall()/fetchone()
df222020-03-070.91[Q/L/E]Merge pull request #450 from cwida/pystringfix Fixing NumPy/Pandas String fetching and add test case based on #448
bc8a2020-03-070.91[Q/L/E]Fixing NumPy/Pandas String fetching and add test case based on #448
f1262020-03-040.91[Q/L/E]Merge pull request #444 from cwida/tablefunctionvarreturn Variable Return Types for Table-Producing Functions
c3852020-03-040.91[Q/L/E]Fix for programmatic querying
11582020-03-040.90[Q/L/E]Remove PhysicalTableFunctionOperatorState
b9982020-03-040.90[Q/L/E]Fixes for individual file compilation
59502020-03-040.91[Q/L/E]Format
db522020-03-040.90[Q/L/E]Add missing files
cdc12020-03-040.90[Q/L/E]Merge branch 'master' into tablefunctionvarreturn
43a82020-03-040.90[Q/L/E]Fix for the programmatic querying example
082a2020-03-040.90[Q/L/E]Simplify input parameters for table functions: pass in values, not a DataChunk
7b172020-03-040.91[Q/L/E]Add bind function to table functions that allows them to set their return types/return names based on input arguments
b0972020-03-040.89[Q/L/E]Merge pull request #443 from phillc73/patch-1 Updating R install instructions in Comments
ab262020-03-030.90[Q/L/E]Updating R install instructions in Comments As per details in [Issue 189](https://github.com/cwida/duckdb/issues/189) and [Issue 428](https://github.com/cwida/duckdb/issues/428)
35d22020-03-030.91[Q/L/E]Merge pull request #442 from cwida/fastcast Fast To String Casts
57e72020-03-030.91[Q/L/E]Extra test and cleanup of format function
cd782020-03-030.90[Q/L/E]also full-building tags otherwise the python binaries have incorrect versions
a0aa2020-03-030.91[Q/L/E]Add format benchmark
863b2020-03-030.91[Q/L/E]Add convenience Cast methods to std::string and clean up some duplicate code
bd052020-03-020.90[Q/L/E]Use correct count in format function
9b162020-03-020.91[Q/L/E]Use fmt library to provide printf and format functions
59032020-03-020.90[Q/L/E]Amalgamation fixes for fmt
48212020-03-020.90[Q/L/E]Add fmt library, and use fmt library for float/double formatting
c2b82020-03-020.92[Q/L/E]Fix for time/timestamp cast benchmarks
13642020-03-020.92[Q/L/E]Rework time -> string and timestamp -> string casts
8f112020-03-020.92[Q/L/E]Rework date to string casting, and format BC dates as "1000-01-01 (BC)" instead of "-1000-01-01" similar to how Postgres handles BC dates
6b922020-03-020.91[Q/L/E]More benchmark fixes
e54a2020-03-020.92[Q/L/E]Fix for new cast benchmarks
526e2020-03-020.95[Q/L/E]Merge branch 'master' into fastcast
93972020-03-020.91[Q/L/E]Add date/time/timestamp benchmarks
ce632020-03-020.90[Q/L/E]Add support for GetValue again
fb282020-03-020.91[Q/L/E]r package version bump
6e012020-03-020.92[Q/L/E]Builds on Solaris & OpenBSD (#440) Added tests for OpenBSD and Solaris using VirtualBox on Travis
6d6f2020-02-290.91[Q/L/E]Merge pull request #439 from cwida/temporarytablewithreadonly Catalog Cleanup & Support for Temporary Structures in Read Only Mode
fb5d2020-02-290.92[Q/L/E]Make this a normal library again
0f232020-02-290.91[Q/L/E]Properly call Normalify for IS NULL/IS NOT NULL
6fee2020-02-290.90[Q/L/E]Fix programmatic querying example
2e4b2020-02-290.91[Q/L/E]More fixes for unity builds
9bbd2020-02-290.90[Q/L/E]Add regular (non-unity) build to travis in Clang 6
78b02020-02-290.91[Q/L/E]Reduce number of client_context.hpp includes and fix individual file compilation
062c2020-02-290.92[Q/L/E]Several fixes for older compilers
4bac2020-02-280.90[Q/L/E]Allow creation of temporary sequences/views, and fix ALTER TABLE on temporary tables
56452020-02-270.91[Q/L/E]Make create function parse data also inherit from generic CreateInfo
2f2e2020-02-270.92[Q/L/E]Make all catalog entries that are part of a schema inherit from StandardEntry
86d92020-02-270.91[Q/L/E]Merge CreateStatements and BoundCreateStatements together into a single create statement to unify code
93812020-02-270.90[Q/L/E]Merge pull request #437 from tdoehmen/tmp_folder_windows_fix special treatment for :memory: dbdir argument
58f82020-02-260.90[Q/L/E]special treatment for :memory: dbdir argument
c26b2020-02-250.92[Q/L/E]Merge pull request #433 from cwida/idx_t2 Rename index_t to idx_t because Solaris
b0782020-02-250.90[Q/L/E]Merge remote-tracking branch 'origin/master' into idx_t2
4c082020-02-250.90[Q/L/E]Fix for quoted range var without schema in Catalog::ParseRangeVar + tests
62a52020-02-250.92[Q/L/E]Unify code to parse schema/table from sequences with R client appender, and add correct support for quotes to it. This fixes #430
31b42020-02-250.91[Q/L/E]Merge pull request #431 from cwida/stringrep Rework String Representation
d8c62020-02-240.90[Q/L/E]Format
dbd92020-02-240.91[Q/L/E]Fixes for R client and rest server
2a552020-02-240.90[Q/L/E]Revert "Remove string inlining (for benchmark reasons)" This reverts commit ca74946959d0449dc781ac23b910180a5201dcd8.
ca742020-02-241.28[Q/L/E]Remove string inlining (for benchmark reasons)
5b232020-02-240.92[Q/L/E]Merge branch 'master' into stringrep
b6932020-02-240.95[Q/L/E]Fix
4ee72020-02-240.94[Q/L/E]Add new set of micro benchmarks involving string operations
c13c2020-02-200.94[Q/L/E]Merge pull request #427 from Honeypot95/reverse_function2 Implement the reverse function.
15ea2020-02-200.93[Q/L/E]Merge pull request #426 from cwida/changevectorsize Fixes for support of different vector sizes
7d602020-02-200.94[Q/L/E]Test even fewer vector sizes to limit testing time and add extra string agg test case
bb292020-02-200.94[Q/L/E]Limit the amount of vector sizes tested to avoid the time limit on travis
bfa42020-02-200.95[Q/L/E]Remove -j from build for travis
7d3f2020-02-200.94[Q/L/E]Travis: try not explicitly setting the compiler
13d52020-02-190.93[Q/L/E]Add ubuntu toolchain to travis build
1a322020-02-190.94[Q/L/E]Add travis test for different vector sizes
52a52020-02-190.94[Q/L/E]Allow setting of vector size through cmake and add python script for testing different vector sizes
51982020-02-190.93[Q/L/E]Fix explain for VECTOR_SIZE=2
fa2d2020-02-190.95[Q/L/E]Vector_size=4 working
b92b2020-02-190.94[Q/L/E]Fixes for vector_size=8; fix for local storage when all values in a vector are deleted
d6602020-02-190.93[Q/L/E]Add test that throws an exception in the middle of an aggregate with destructor being constructed
d3022020-02-190.94[Q/L/E]Add destructor function for aggregates, and use it in STRING_AGG function to properly manage allocation of string aggregates
65622020-02-190.96[Q/L/E]Allow VECTOR_SIZE=16, fix off-by-one in assertion and fix for NLJ with NULL values
6ee22020-02-190.95[Q/L/E]Allow VECTOR_SIZE=32
ff852020-02-190.94[Q/L/E]Fixes for vector_size=64, including a fix to NLJ and a fix to properly set vector types in Gather::Set
ab062020-02-190.94[Q/L/E]Fixes for vector_size = 2048
4d5d2020-02-190.94[Q/L/E]Fixes for VECTOR_SIZE=512
8ca42020-02-180.94[Q/L/E]Add test for loading a non-database file in the shell-test
46bd2020-02-180.94[Q/L/E]Allow nullptr to be passed to sqlite3_open
fb3f2020-02-180.93[Q/L/E]Fix for printing profiling info related to prepared statements (this fixes profile info in shell)
edd32020-02-180.94[Q/L/E]Avoid crash in shell when opened with a non-db file
afbf2020-02-180.94[Q/L/E]Fix for NULL values in nextval function
89302020-02-180.94[Q/L/E]Merge pull request #423 from cwida/removedupinfofromvector Remove Individual Vector Cardinalities
70dc2020-02-180.97[Q/L/E]Fix assert restrict
19bc2020-02-170.93[Q/L/E]ASSERT_RESTRICT: report file and line number, and change to inclusive bounds
42d02020-02-170.94[Q/L/E]Fixes for embedded C and R package
23f12020-02-170.97[Q/L/E]Merge branch 'master' into removedupinfofromvector
1e552020-02-170.95[Q/L/E]Format
a5532020-02-170.93[Q/L/E]Fix incorrect cardinality setting in join cache
9e362020-02-170.98[Q/L/E]Fix for JoinOrderOptimizer with cross products
b4932020-02-170.92[Q/L/E]Fix for large aggregate hashtables
9ef72020-02-170.94[Q/L/E]Fix several other issues with setting incorrect cardinality
8bb62020-02-140.32[Q/L/E]Fix several issues with correctly setting cardinality, more fixes required
7aa42020-02-130.94[Q/L/E]WindowSegmentTree and Vector are no longer friends: now DataChunk is Vectors best friend
bca82020-02-130.95[Q/L/E]Remove DataChunk::owned_data, and now initialize data chunks normally
91b32020-02-120.90[Q/L/E]Remove unused DataChunk::Move method
9ab72020-02-120.89[Q/L/E]Rename Flatten to ClearSelectionVector
f8ed2020-02-120.87[Q/L/E]Merge pull request #421 from cwida/bsd OpenBSD build changes from @videlft
920b2020-02-110.87[Q/L/E]Merge pull request #419 from cwida/multilineshell Fixing multiline query pasting in shell
1b0c2020-02-110.86[Q/L/E]Merge pull request #418 from samansmink/date-truncate-function Date truncate function
0bbf2020-02-110.87[Q/L/E]refactor date_trunc to use date_part_specifier
a7042020-02-110.86[Q/L/E]fixed wrongly reformatted template
43802020-02-110.85[Q/L/E]fixed typo in variable name
966d2020-02-110.83[Q/L/E]ran make format on new date_trunc function code
ba2c2020-02-110.88[Q/L/E]added date_trunc function for timestamp and date types. interval type not yet supported.
fcc22020-02-100.87[Q/L/E]Merge pull request #416 from cwida/tablestar Support for select table.* from table, issue #415
1c762020-02-100.86[Q/L/E]support for select table.* from table, issue #415
e10d2020-02-080.91[Q/L/E]First part of nested types: STRUCTS (#414) We add a new type `STRUCT` that can hold a named ordered list of other types. For now, two functions are supported: `STRUCT_PACK()` to create structs, for example `STRUCT_PACK(a := 42, b := 43)` to create a `STRUCT` of two integers named `a` and `b`. Then, there is `STRUCT_EXTRACT()` that returns one of the entries of a struct again. For example, `SELECT STRUCT_EXTRACT(STRUCT_PACK(a := 42, b := 43), 'a')` returns `42`.
67942020-02-050.87[Q/L/E]Fix error message
73c22020-02-050.90[Q/L/E]Merge branch 'master' of github.com:cwida/duckdb
ce8c2020-02-050.88[Q/L/E]Disallow ORDER and FILTER for aggregates (#408)
874e2020-02-050.87[Q/L/E]Remove unused in-place binary operators
a5a42020-02-050.87[Q/L/E]Using `Depends` for DBI in R package (#411) * using depends for DBI
bd052020-02-040.87[Q/L/E]Enable ccache in CMakeList
3cfb2020-02-040.88[Q/L/E]Move NotNullSelVector to VectorOperations
2fbd2020-02-040.85[Q/L/E]Remove Vector::Move and replace its usage with Vector::Reference
1ded2020-02-040.87[Q/L/E]Disallow DISTINCT in Window Functions (Fixes #408)
fa482020-02-040.87[Q/L/E]Merge pull request #409 from cwida/vectortypes Vector Rework (Vector types, three buffer system, arrow compatible TypeIds)
bac12020-02-040.86[Q/L/E]Format
90ad2020-02-040.86[Q/L/E]Merge branch 'master' into vectortypes
33912020-02-040.84[Q/L/E]Merge pull request #404 from kryonix/master Support for Recursive Common Table Expressions
bdad2020-02-030.86[Q/L/E]version bump r package
59f82020-01-310.84[Q/L/E]Merge pull request #406 from cwida/adaptive-reordering Adaptive Expression Reordering
643b2020-01-270.83[Q/L/E]Added q1 benchmark with int group keys
c44f2020-01-250.85[Q/L/E]Merge pull request #402 from cwida/artstring Support for String/Compound Keys
f3372020-01-240.84[Q/L/E]Adding myth tests
faea2020-01-240.84[Q/L/E]Throwing exception when trying to create index on columns with duplicate data
00ed2020-01-230.83[Q/L/E]Indexes for temporary tables
a50d2020-01-220.83[Q/L/E]Formatter
fd2b2020-01-220.84[Q/L/E]Merge branch 'master' into artstring
4c8b2020-01-220.88[Q/L/E]Adding test on uniquness and prefix changes on enough data for all ART nodes
1efb2020-01-220.84[Q/L/E]Fixing issue on prefix copy
70c22020-01-210.83[Q/L/E]Have Travis generate the R repo metadata files `PACKAGES` and upload to DuckDB Download server
7b312020-01-200.84[Q/L/E]Using linenoise instead of readline for shell (#393) Also fixes a windows bug
7e852020-01-190.85[Q/L/E]Switching to stock SQLite shell (#388) We now build a statically linked command line interface `duckdb_cli` built from the stock SQLite shell.c sources.
2deb2020-01-140.85[Q/L/E]sub-second precision for timestamps in python api (#391) * sub-second precision for timestamps in python API
57b22020-01-110.83[Q/L/E]Merge pull request #390 from cwida/unusedcolumns Add Unused Column & Column Lifetime Optimizers
4e682020-01-110.84[Q/L/E]Format
e1942020-01-110.84[Q/L/E]Merge branch 'master' into unusedcolumns
a7232020-01-110.84[Q/L/E]Fix for unused column join test and add additional test
5d2b2020-01-110.83[Q/L/E]Perform IN clause optimizer before join ordering/unused column elimination/column lifetime optimizer
77fd2020-01-110.86[Q/L/E]Add extra tests for joins with unused columns
b8862020-01-110.85[Q/L/E]Add benchmarks for Q1 aggregate after join, one with a filter and one without a filter