1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-30 19:23:07 +03:00
Commit Graph

1013 Commits

Author SHA1 Message Date
70f5c12279 Merge pull request #1010 from tntnatbry/MCOL-3680
MCOL-3680 mysqld will abort if Columnstore.xml is missing.
2020-01-28 15:26:05 +00:00
2c814bd3ed MCOL-3744 mcssystemready to work with SKIP_OAM_INIT 2020-01-24 12:33:03 -06:00
092994d00d Merge pull request #1006 from LinuxJedi/change-engine
MCOL-128 Support ALTER TABLE...ENGINE=Columnstore
2020-01-24 09:26:13 -06:00
4b86890cf7 MCOL-128 Support ALTER TABLE...ENGINE=Columnstore
Also implements:

* ALTER TABLE from Columnstore to another engine
* MCOL-3349 CREATE TABLE ... AS SELECT.
2020-01-23 21:12:33 +00:00
57bf5303f1 MCOL-3662 Restore error message for multi parameter aggregates save for UDAnF and GROUP_CONCAT 2020-01-23 14:10:15 -06:00
d0ffede135 MCOL-3680 mysqld will abort if Columnstore.xml is missing
Add try-catch blocks in the plugin code to prevent mysqld
from aborting if configcpp cannot access Columnstore.xml.
2020-01-23 17:41:02 +00:00
c6aaa3f227 This commit fixes MDB crash that happens when table lock timeout fires
with multiply DML run in separate transactions.

This commit also fixes GCC unused variable warning.
2020-01-21 16:48:15 -05:00
b6dfdd6e99 Merge pull request #1000 from drrtuy/MCOL-1734_2
MCOL-1734 CS now behaves similar to MDB in case of NOT IN + correlated subquery if the subquery returns empty set.
2020-01-21 16:45:24 -05:00
cd80b0ace5 Merge pull request #1003 from mariadb-corporation/fix-doUpdateDelete
This commit fixes MDB crash that happens when table lock timeout fires
2020-01-17 08:25:44 -08:00
f21998eff3 Merge pull request #1002 from LinuxJedi/10.5-compatible
MariaDB 10.5 Compatibility
2020-01-15 19:10:49 -08:00
f178f2c22f This commit fixes MDB crash that happens when table lock timeout fires
with multiply DML run in separate transactions.

This commit also fixes GCC unused variable warning.
2020-01-14 22:44:35 +00:00
a959aad92d MariaDB 10.5 Compatibility
Several changes have happened in MariaDB 10.5, most notably:

* Information Schema table definitions have changed
* More things use LEX_CSTRING

This fixes all the compile issues
2020-01-13 10:47:14 -08:00
8595fa0226 MCOL-1734 CS now behaves similar to MDB in case of
NOT IN + correlated subquery if the subquery returns empty set.
CS now returns full outer record set.

gcc 8.2 complains about unused variable in ha_mcs_impl.cc
2020-01-07 17:23:17 +03:00
de4ab3e294 MCOL-3702 Fix replication config file changes
log_bin is missing from columnstore.cnf. This causes a search for the
master log file to fail and replication doesn't apply.

This patch adds a commented out log_bin which is enabled as needed.

It also fixes an error message.
2020-01-03 10:08:52 +00:00
bd592aa714 Merge pull request #984 from LinuxJedi/fix-engineid
MCOL-3673 Fix legacy db type
2019-12-20 07:44:14 +02:00
bf944c4ce4 Merge pull request #991 from mariadb-corporation/MENT-513
fixes for MENT-513
2019-12-20 07:40:49 +02:00
b0248c665c Re-added commit 5eb050f3af with a one-char modification that fixes
an odd access denied error when running a select stmt.
2019-12-19 18:40:57 -05:00
dbc8cbaca9 Revert "Merge pull request #989 from LinuxJedi/set-maturity"
This reverts commit 5eb050f3af, reversing
changes made to 0be00a3a73.
2019-12-19 18:08:49 -05:00
96adf535ae don't create a ResourceManager to initialize a global variable
this is executed when ha_columnstore is loaded, at dlopen time
before any initialization code is run and crashes any dlopen
attemps.

Crashes - because a missing config file is a crashing offence,
but it's an issue for another day
2019-12-19 19:42:38 +01:00
9cc92fda91 compilation failure
#define likely clashes with

static bool likely(const string_type& str)

in /usr/include/boost/date_time/special_values_parser.hpp
2019-12-19 18:15:16 +01:00
76f25045d9 Make plugin maturity definable at compile time. 2019-12-19 07:30:22 +02:00
d8e763655c MCOL-3654: Fix row-based repl detection
if 0'd the row-based repl checks for now to prevent ruling out
stmts we should be able to process.
2019-12-17 13:26:18 -05:00
e02302908b MCOL-3674: Fix row-based replication detection
Changed the row-based repl detection mechanism so stmt-based repl works
again, however, the detection mechanism is still wrong somehow.  What it
should be is currently unknown.
2019-12-17 13:15:58 -05:00
d0f51f6526 MCOL-3673 Fix legacy db type
We were auto-assigned a DB type which could cause issues during major
upgrades. Setting to autoassign gives us a DB type of 0 which solves
these issues.
2019-12-17 15:32:32 +02:00
451284aeee Merge pull request #982 from LinuxJedi/MCOL-3669a
MCOL-3669 Add real versioning to plugin
2019-12-13 22:07:37 +01:00
ff96140949 Merge pull request #983 from drrtuy/fixing-debug-build_1
Refactored MDB relation names decoding in DDL code.
2019-12-13 19:24:57 +00:00
114c5be935 MCOL-3669 Add real versioning to plugin
Make the version in information_schema.all_plugins reflect the real
version of ColumnStore.
2019-12-13 19:19:16 +00:00
7acfddddb7 Refactored MDB relation names decoding in DDL code.
SH now takes all or nothing thus we need to change if conditions that rules our GBH.

Small warning fixes for GCC8.2

Disabled GBH.
2019-12-13 11:38:19 -06:00
fb07a02696 Merge pull request #981 from LinuxJedi/MCOL-3672
MCOL-3672 Fix regression in deletes
2019-12-13 08:41:48 +00:00
b7396129c7 MCOL-3672 Fix regression in deletes
Deletes appear to only use the direct delete path. This allows that to
happen.
2019-12-13 07:33:29 +00:00
7cda5cd179 Merge pull request #980 from LinuxJedi/MCOL-3672
MCOL-3672 Fix double-DML execution
2019-12-13 00:18:10 +01:00
9734a25a35 MCOL-3672 Fix double-DML execution
Direct update/delete executed doUpdateDelete as well as the regular
execution route for doUpdateDelete.

This patch only executes doUpdateDelete the first time and direct
update/delete collects the counts.
2019-12-12 22:58:20 +00:00
4f03c8ac44 MCOL-3666 Cleanup columnstore.cnf
Options need to be loaded after the plugin is installed or they aren't
valid. Also remove a lot of junk from the file.
2019-12-12 13:28:17 +00:00
19b4702a24 This patch fllows the change introduced in the direct_update/delete API
in 10.4.11 to fix MDEV-18973 in Spider.
2019-12-11 08:05:49 -06:00
a119da7e54 Merge pull request #968 from LinuxJedi/MCOL-3650
MCOL-3650 delete bad UDF entries
2019-12-10 17:24:17 +01:00
3f5e1fd0c8 Merge pull request #964 from mariadb-corporation/MCOL-3529
MCOL-3529 This patch implements direct_update and direct_delete features
2019-12-09 09:40:33 +00:00
850984f590 MCOL-3650 delete bad UDF entries
In 1.4.1 and below UDFs were stored in libcalmysql.so. These have been
move to ha_columnstore.so. Unfortunately the install script ignores the
previous entries. This patch removes any left over entries before adding
the new ones.
2019-12-06 11:58:12 +00:00
7489d0bfd0 MCOL-3625 Rename packages
Rename packages to MariaDB-columnstore-engine, MariaDB-columnstore-libs
and MariaDB-columnstore-platform.

Also add the "columnstore-" prefix the the components so that MariaDB's
packaging system understands then and add a line to include them in
MariaDB's packaging.

In addition
* Fix S3 building for dist source build
* Fix Debian 10 dependency issue
* Fix git handling for dist builds
* Add support for MariaDB's RPM building
* Use MariaDB's PCRE and readline
* Removes a few dead files
* Fix Boost noncopyable includes
2019-12-04 11:04:39 +00:00
a8cd34f86d Add support for building from server 2019-12-03 21:21:28 +00:00
27ec629ace Remove I_S plugins from my.cnf 2019-12-03 21:21:28 +00:00
e072bf9e9b MCOL-3628 Move I_S tables into main handler lib
The I_S tables are all now in ha_columnstore.so
2019-12-03 21:21:28 +00:00
9f89ab0559 MCOL-3627 Fix library name
The ColumnStore library is now called ha_columnstore.so to be inline
with other storage engines.
2019-12-03 21:21:28 +00:00
5cedeb110b MCOL-3529 This patch implements direct_update and direct_delete features
to properly report the number of rows affected by UPDATE|DELETE.
2019-11-27 09:33:21 -06:00
57724e5515 Merge pull request #953 from drrtuy/MCOL-3602_MCOL-3593_3
Selected optimizer rewrites addition.
2019-11-25 21:50:38 +00:00
aff40f0dbc Merge pull request #949 from tntnatbry/fix-bitcount
Implement bit_count() distributed function and handle hexadecimal string literals in buildReturnedColumn().
2019-11-25 21:51:44 +03:00
3fabf01e93 MCOL-3593 Disabled full optimizer run and enabled copy-pasted simplify_joins.
Disabled 4th if block in buildOuterJoin to handle non-optimized MDB query
    structures.

    Broke getSelectPlan into pieces: processFrom, processWhere.

MCOL-3593 UNION processing depends on two flags isUnion that comes as
arg of getSelectPlan and unionSel that is a local variable in
getSelectPlan. Modularization of getSelectPlan broke the mechanizm.
This patch is supposed to partially fix it.

MCOL-3593 Removed unused if condition from buildOuterJoin that allows
unsupported construct subquery in ON expression.
Fixed an improper if condition that ignors tableMap entries w/o condition
in external_lock thus external_lock doesn't clean up when the query
finishes.
Fixed wrong logging for queries processed in tableMode. Now rnd_init
properly sends queryText down to ExeMgr to be logged.

MCOL-3593 Unused attribute FromSubQuery::fFromSub was removed.
 getSelectPlan has been modularized into: setExecutionParams,
 processFrom, processWhere. SELECT, HAVING, GROUP BY, ORDER BY
 still lives in getSelectPlan.
Copied optimization function simplify_joins_ into our pushdown
 code to provide the plugin code with some rewrites from MDB it
 expects.
The columnstore_processing_handlers_fallback session variable
 has been removed thus CS can't fallback from SH to partial
 execution paths, e.g. DH, GBH or plugin API.

MCOL-3602 Moved MDB optimizer rewrites into a separate file.

Add SELECT_LEX::optimize_unflattened_subqueries() call to fix IN
 into EXISTS rewrite for semi-JOINs with subqueries.

disable_indices_for_CEJ() add index related hints to disable
 index access methods in Cross Engine Joins.

create_SH() now flattens JOIN that has both physical tables and
 views. This fixes most of views related tests in the regression.
2019-11-25 10:03:32 -06:00
2e16fe674c 1. Implement bit_count() distributed function.
2. Handle hexadecimal string literals in buildReturnedColumn().
2019-11-22 18:02:47 -05:00
a76ceb5aa0 Get the associated string values for charset()/collation() functions applied to a field. 2019-11-22 01:34:29 +00:00
d4d1f4d578 Merge pull request #942 from LinuxJedi/MCOL-3527-2
MCOL-3527 (attempt 2) Fix proc security settings
2019-11-20 20:46:41 +01:00
a079cb8d59 MCOL-3527 (attempt 2) Fix proc security settings
Setting the definer didn't work and gave errors. This is because I
forgot to set the definer for the function too. This patch instead sets
the security level to INVOKER which is probably a better way of handling
this anyway.
2019-11-18 09:01:49 +00:00