ef3a655f84
MCOL-406 More fixes to stored procs
...
* Fix infinite loop problem when there are no ColumnStore tables
* Make table_usage('schema', NULL) work
2016-12-07 09:12:51 +00:00
6efe906972
MCOL-406 add table_usage() schema input
...
table_usage() is now called using:
* table_usage(NULL, NULL) - all tables
* table_usage(NULL, 'table') - match tables with the name 'table' in all
schemas
* table_usage('schema', 'table') - match a specific schema and table
combination
2016-12-06 20:10:07 +00:00
d4a601b4fb
Merge pull request #68 from mariadb-corporation/MCOL-442
...
MCOL-442 Allow default zero date/datetime
2016-12-06 12:26:09 -06:00
fe381ab07c
MCOL-442 Allow default zero date/datetime
...
Remove the hard-coded restriction in the DDL code, it isn't needed any
more
2016-12-06 15:47:33 +00:00
e2771c246b
MCOL-406 Add schema to table_usage()
...
Schema name should be included in results
2016-12-06 12:59:43 +00:00
f586f3b46a
MCOL-423 Fixes to I_S tables
...
Fixes the following:
* Compression ratio calculation was incorrect
* Possible issues due to system catalog thread ID usage
* Compressed file size data count was leaking many FDs when the table
wasn't compressed
* Compressed file size data count was allocating random large amounts
of RAM and then leaking it when the table wasn't compressed
2016-11-29 10:45:38 +00:00
3b1de94cd8
MCOL-406 Improved Information Schema
...
* Add INFORMATION_SCHEMA.COLUMNSTORE_FILES which contains information
about files
* Remove file information from COLUMNSTORE_EXTENTS (due to above)
* Hide columns with Object ID < 3000 (internal columns)
* Fix bad calculation in data_size columns
* Fix minor memory leak
* Add compressedSize() function to IDBFileSystem to get the used file
size for a compressed file
* Add columnstore_info schema with utility stored procedures to access
the information_schema tables
2016-11-23 22:11:26 +00:00
874596c6cd
MCOL-309 Implement Information Schema tables
...
This patch does the following:
* Fix a year storage issue in the datestamp for the columnstore tables
metadata table (note that any previous tables will still have the
incorrect year stored).
* Expose the table creation date in CalpontSystemCatalog::getTables()
* Add an INFORMATION_SCHEMA table listing the tables in ColumnStore
(similar to systable)
* Add an INFORMATION_SCHEMA table listing the columns in ColumnStore
(similar to syscolumn)
* Add an INFORMATION_SCHEMA table listing the extents in ColumnStore
(similar to the editem tool but with additional file information)
* Modifies the build system and scripts to support the new tables
2016-11-14 15:44:20 +00:00
14a9581bb6
MCOL-385 Fix crash observed with 10.1.19 merge
...
Appears to be a regression introduced in MCOL-361 which was causing a
segault with bug3670.negative.sql
2016-11-07 21:04:26 +00:00
4fc7fa12cd
MCOL-129 INSERT/UPDATE strict mode support
...
This changes the warning for truncation to the correct MariaDB error
code (1264).
In addition it passes the strict mode up into the DML class to roll back
correctly.
It also sets the abort_on_warning flag for updates as this isn't set on
the rnd_init phase but is needed for strict mode to work.
2016-11-04 14:06:00 +00:00
059a158837
Merge pull request #49 from mariadb-corporation/MCOL-263
...
MCOL-263: throw different error message on load data infile if column…
2016-11-03 09:39:40 -05:00
39c3cabb7c
MCOL-263: throw different error message on load data infile if columnstore suspendDatabaseWrite is enabled
2016-11-02 17:34:46 -05:00
086a98794e
MCOL-361 String::c_ptr() can cause a realloc and break things. Remove all uses of c_ptr to String objects from the server.
2016-11-01 16:07:13 -05:00
ab5afda7c4
MCOL-121 reverse the disabling client progress reports.
2016-10-31 14:06:10 -05:00
0368dd487a
MCOL-153 Add UDF function calgetsqlcount() which will display the number of sql statements active and the number waiting.
2016-10-27 15:49:01 -05:00
6694bc3d16
Merge pull request #44 from mariadb-corporation/MCOL-344
...
Add better cache explanations to debug_walk. This is debug only.
2016-10-27 15:42:00 -05:00
331dfd3a4c
Add better cache explanations to debug_walk. This is debug only.
2016-10-27 15:39:50 -05:00
32c76825de
Merge pull request #43 from mariadb-corporation/MCOL-218
...
Mcol 218
2016-10-27 20:21:19 +01:00
b1a110b830
MCOL-121 client reports "stage 2 - enabling keys" for every query against a CS table.
...
Add progress_report_time=0 to default my.cnf to disable progress reports
2016-10-24 17:30:05 -05:00
fc4cb7ab71
Clean up unneeded objects created in fix.
2016-10-24 11:44:07 -05:00
87ac01c3d4
MCOL-218: Make drop database work in the columnstore engine.
2016-10-19 15:23:02 -05:00
e4f93ea2f2
MCOL-46 subquery sometimes causes unknown error
...
This was caused by Item_cache::val_str() sometimes causing a full exec of subquery before we're ready
2016-10-12 13:30:35 -05:00
d50721d65a
MCOL-343 Change references to String::ptr() into String::c_ptr()
2016-10-03 15:54:55 -05:00
5fad418309
MCOL-341 Fix DATETIME2 support in INSERT...SELECT
...
DATETIME2 has a variable pack length but we were using a constant length
of 8 if the value was NULL. This messed up the offset for the next
column.
2016-10-03 15:51:47 +01:00
52c0f79fcf
MCOL-330 Fix datetime to int conversion
...
Datetime has internal int value which is very different to MySQL's int
value. This patch differentiates between the two and also fixes a column
width issue which appeared once the datetime handling was fixed.
2016-09-29 17:27:52 +01:00
3d91ac193c
Merge branch 'develop' of git://github.com/mariadb-corporation/mariadb-columnstore-engine into MCOL-97
2016-09-22 18:50:59 -05:00
7d3cd26af9
MCOL-160 MCOL-262 CMake Build Fixes for out-of-tree builds and engine RPMS
2016-09-22 10:14:18 -04:00
b954001fba
Remove net-snmp and use the OS version
...
Also remove a few old binaries from build/
2016-09-13 17:42:57 +01:00
b5d4e02b21
MCOL-173 Fix null handling for bulk inserts
...
When infinidb_use_import_for_batchinsert is enabled the NULL handling
for the batch insert was incorrect. This is due to an off-by-one on the
NULL bitmap. This also affects INSERT...SELECT.
2016-09-09 16:09:47 +01:00
8364c9da52
MCOL-281 LDI using cpimport pads char column values with spaces
...
Use new logic to find actual data length
2016-09-07 12:13:22 -05:00
23cf2e3edc
Remove #define SKIP_AUTOI. This is no longer used
2016-09-06 12:04:28 -05:00
7e8262e0d2
Merge pull request #5 from LinuxJedi/MCOL-171
...
Add support for zero date separate to NULL
2016-09-02 09:14:48 -05:00
d9de4cfde0
MCOL-279 Debuging 279 revealed a weakness in processing when front end ond backend were out of sync. It could cause a mysqld crash. Added error code to check and report, rather than crash.
2016-09-01 13:01:33 -05:00
09276ff885
Comment debug lines. Change a debug line to be more useful.
2016-09-01 13:01:33 -05:00
25851df89d
Add support for zero date separate to NULL
...
NULL is now pushed through the MariaDB storage engine plugin down to the
insert processing. A '0000-00-00' date is now a separate value to NULL.
This is more in-line with MariaDB's handling.
2016-08-30 16:26:36 +01:00
0d2f496389
MCOL-05 Modify the DDL parser to not use (even more) global variables.
2016-08-16 18:25:09 -05:00
468a971517
name change
2016-08-15 13:39:00 -05:00
10e5ed83ce
MCOL-5 We've had problems with CREATE and DELETE crashing. Add some better error handling
2016-08-12 16:57:51 -05:00
392d6df495
Merge branch 'mcol-159' into develop
...
Conflicts:
1
Makefile.save
autom4te.cache/output.0
autom4te.cache/traces.0
autom4te.cache/traces.1
compile
config.guess
config.sub
configure.save
dbcon/Makefile.in
dbcon/ddlpackage/Makefile.in
dbcon/ddlpackage/ddl-scan.cpp
dbcon/ddlpackageproc/Makefile.in
dbcon/dmlpackage/Makefile.in
dbcon/dmlpackage/dml-scan.cpp
dbcon/dmlpackageproc/Makefile.in
dbcon/execplan/Makefile.in
dbcon/joblist/Makefile.in
dbcon/mysql/Makefile.in
ddlproc/Makefile.in
decomsvr/Makefile.in
depcomp
dmlproc/Makefile.in
exemgr/Makefile.in
install-sh
missing
net-snmp/Makefile.in
net-snmp/net-snmp-5.7.3/agent/mibgroup/mib_module_includes.h
net-snmp/net-snmp-5.7.3/configure-summary
net-snmp/net-snmp-5.7.3/dist/generation-scripts/gen-variables
net-snmp/net-snmp-5.7.3/include/net-snmp/agent/mib_module_config.h
net-snmp/net-snmp-5.7.3/mk/MODULE_LIST.mk
net-snmp/net-snmp-5.7.3/mk/mib_module_list_c.mk
net-snmp/net-snmp-5.7.3/mk/mib_module_list_code.mk
net-snmp/net-snmp-5.7.3/mk/mib_module_list_ft.mk
net-snmp/net-snmp-5.7.3/mk/mib_module_list_lo.mk
net-snmp/net-snmp-5.7.3/mk/mib_module_list_o.mk
net-snmp/net-snmp-5.7.3/mk/mibgroup_list_ft.mk
net-snmp/net-snmp-5.7.3/mk/mibgroup_list_lo.mk
net-snmp/net-snmp-5.7.3/mk/mibgroup_list_o.mk
net-snmp/net-snmp-5.7.3/mk/module_list_c.mk
net-snmp/net-snmp-5.7.3/mk/module_list_code.mk
net-snmp/net-snmp-5.7.3/mk/module_list_ft.mk
net-snmp/net-snmp-5.7.3/mk/module_list_lo.mk
net-snmp/net-snmp-5.7.3/mk/module_list_o.mk
oam/Makefile.in
oam/cloud/Makefile.in
oam/etc/Makefile.in
oam/oamcpp/Makefile.in
oam/post/Makefile.in
oamapps/Makefile.in
oamapps/calpontDB/Makefile.in
oamapps/calpontSupport/Makefile.in
oamapps/columnstoreDB/Makefile.in
oamapps/columnstoreSupport/Makefile.in
oamapps/mcsadmin/Makefile.in
oamapps/postConfigure/Makefile.in
oamapps/sendtrap/Makefile.in
oamapps/serverMonitor/Makefile.in
oamapps/sessionWalker/Makefile.in
oamapps/traphandler/Makefile.in
primitives/Makefile.in
primitives/blockcache/Makefile.in
primitives/linux-port/Makefile.in
primitives/primproc/Makefile.in
procmgr/Makefile.in
procmon/Makefile.in
snmpd/Makefile.in
snmpd/etc/Makefile.in
snmpd/snmpmanager/Makefile.in
tools/Makefile.in
tools/clearShm/Makefile.in
tools/cleartablelock/Makefile.in
tools/configMgt/Makefile.in
tools/cplogger/Makefile.in
tools/dbbuilder/Makefile.in
tools/dbloadxml/Makefile.in
tools/ddlcleanup/Makefile.in
tools/editem/Makefile.in
tools/getConfig/Makefile.in
tools/idbmeminfo/Makefile.in
tools/setConfig/Makefile.in
tools/viewtablelock/Makefile.in
utils/Makefile.in
utils/batchloader/Makefile.in
utils/boost_idb/Makefile.in
utils/cacheutils/Makefile.in
utils/common/Makefile.in
utils/compress/Makefile.in
utils/configcpp/Makefile.in
utils/dataconvert/Makefile.in
utils/ddlcleanup/Makefile.in
utils/funcexp/Makefile.in
utils/idbdatafile/Makefile.in
utils/idbhdfs/Makefile.in
utils/idbhdfs/hdfs-12/Makefile.in
utils/idbhdfs/hdfs-20/Makefile.in
utils/jemalloc/Makefile.in
utils/joiner/Makefile.in
utils/loggingcpp/Makefile.in
utils/messageqcpp/Makefile.in
utils/mysqlcl_idb/Makefile.in
utils/querystats/Makefile.in
utils/querytele/Makefile.in
utils/rowgroup/Makefile.in
utils/rwlock/Makefile.in
utils/startup/Makefile.in
utils/threadpool/Makefile.in
utils/thrift/Makefile.in
utils/udfsdk/Makefile.in
utils/windowfunction/Makefile.in
utils/winport/Makefile.in
versioning/BRM/Makefile.in
versioning/Makefile.in
writeengine/Makefile.in
writeengine/bulk/Makefile.in
writeengine/client/Makefile.in
writeengine/dictionary/Makefile.in
writeengine/index/Makefile.in
writeengine/redistribute/Makefile.in
writeengine/server/Makefile.in
writeengine/shared/Makefile.in
writeengine/splitter/Makefile.in
writeengine/wrapper/Makefile.in
2016-08-10 16:24:51 -05:00
8bc7e46905
MCOL-5 Don't send empty strings in cpimport command line. It confuses cpimport.
2016-08-09 11:35:45 -05:00
8de8666046
MCOL-5 fill the vector before taking the addresses of the strings.
2016-08-08 16:36:01 -05:00
7598e8bc75
MCOL-5 Building the cpimport command line for LDI relied on the addresses of the contents of a std:vector being static during re-allocation. This is an erroneous assumption. Recoded to build the vector completely, then use it.
2016-08-05 14:09:19 -05:00
4709c2bece
Add dependencies on netsnmp build
2016-07-27 16:00:28 -05:00
539e524ad4
name change from InfiniDB in comments
2016-07-26 09:24:46 -05:00
6527f191e1
merged mcol-5
2016-07-21 09:00:25 -05:00
6d11ce030d
MCOL-66 - Make the DDL and DML parsers re-entrant.
...
Serialize all DDL because the VVS can't handle modifying the same block simultaneously
Fix the CTRL+C logic in DML that caused COMMIT issues.
2016-07-20 11:47:51 -05:00
fe1a4c659e
Fix libcalmysql
2016-07-19 12:40:51 -05:00
edb55cf23a
mcol-5 save files
2016-07-19 10:46:58 -05:00
72ac8c5e90
CMake fixes for executable install and libclamysql
2016-07-15 16:23:26 -05:00
ba2a66f589
More cmakefile fixes
2016-07-15 15:07:35 -05:00
