summaryrefslogtreecommitdiff
path: root/sql/item_create.cc
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.4 into 10.5Marko Mäkelä2021-03-311-1/+1
|\
| * Merge 10.3 into 10.4Marko Mäkelä2021-03-311-3/+35
| |\
| | * Merge 10.2 into 10.3Marko Mäkelä2021-03-311-3/+35
| | |\
| | | * MDEV-13467: Feature request: Support for ST_Distance_Sphere()Anel Husakovic2021-03-271-2/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Cherry-pick 51e48b9f8981 - vscode gitignore - Thanks Robin Dupret for the review. Reviewed by:daniel@mariadb.org holyfoot@mariadb.com
* | | | Merge 10.4 into 10.5Marko Mäkelä2020-08-011-1/+1
|\ \ \ \ | |/ / /
| * | | Merge 10.3 into 10.4Marko Mäkelä2020-07-311-1/+1
| |\ \ \ | | |/ /
| | * | Merge 10.2 into 10.3Marko Mäkelä2020-07-311-1/+1
| | |\ \ | | | |/
| | | * MDEV-18042 Server crashes upon adding a non-null date column under ↵Nikita Malyavin2020-07-311-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | NO_ZERO_DATE with ALGORITHM=INPLACE accept table_name and db_name instead of table_share in make_truncated_value_warning
* | | | cleanup: PSI key is *always* the first argumentSergei Golubchik2020-03-101-8/+3
| | | |
* | | | perfschema memory related instrumentation changesSergei Golubchik2020-03-101-1/+1
| | | |
* | | | MDEV-20632: Recursive CTE cycle detection using CYCLE clause (nonstandard)Oleksandr Byelkin2020-03-101-7/+7
| | | | | | | | | | | | | | | | Added CYCLE ... RESTRICT (nonstandard) clause to recursive CTE.
* | | | MDEV-10569: Add RELEASE_ALL_LOCKS function. Implementing the SQLDaniel-Solo2020-02-271-0/+22
| | | | | | | | | | | | | | | | function to release all named locks
* | | | Part2: MDEV-20837 Add MariaDB_FUNCTION_PLUGINAlexander Barkov2019-10-161-94/+34
| | | | | | | | | | | | | | | | Removing MariaDB_FUNCTION_COLLECTION_PLUGIN
* | | | Part1: MDEV-20837 Add MariaDB_FUNCTION_PLUGINAlexander Barkov2019-10-161-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | - Defining MariaDB_FUNCTION_PLUGIN - Changing the code in /plugins/type_inet/ and /plugins/type_test/ to use MariaDB_FUNCTION_PLUGIN instead of MariaDB_FUNCTION_COLLECTION_PLUGIN. - Changing maturity for the INET6 data type plugin from experimental to alpha.
* | | | MDEV-20768 Turn INET functions into a function collection pluginAlexander Barkov2019-10-071-189/+5
| | | |
* | | | MDEV-20764 Add MariaDB_FUNCTION_COLLECTION_PLUGINAlexander Barkov2019-10-071-17/+97
| | | |
* | | | A cleanup `MDEV-19994 Add class Function_collection` (buildbot warnings)Alexander Barkov2019-07-101-6/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | plugin/versioning adds its own native functions by calling item_create_append(). So GIS functions initialized two times. Moving the initialization of GIS functions from item_create_append() to item_create_init().
* | | | MDEV-20004 Move Field_geom from field.cc to sql_type_geom.ccAlexander Barkov2019-07-091-0/+1
| | | |
* | | | MDEV-19994 Add class Function_collectionAlexander Barkov2019-07-091-1762/+14
| | | |
* | | | MDEV-19599 Change db_name, table_name to LEX_CSTRING in Item_ident and ↵Alexander Barkov2019-05-261-2/+2
| | | | | | | | | | | | | | | | Send_field
* | | | MDEV-19566 Remove Item::name related strlen() calls in constructors of some ↵Alexander Barkov2019-05-231-3/+3
|/ / / | | | | | | | | | Item_string descendands
* | | Merge branch '10.3' into 10.4Oleksandr Byelkin2019-05-191-1/+40
|\ \ \ | |/ /
| * | Merge branch '10.2' into 10.3Sergei Golubchik2019-05-171-0/+39
| |\ \ | | |/
| | * MDEV-13992 Implement JSON_MERGE_PATCH.Alexey Botchkov2019-05-171-0/+39
| | | | | | | | | | | | | | | JSON_MERGE_PATCH implemented. Added JSON_MERGE_PRESERVE as a synonim for the JSON_MERGE.
| * | Merge 10.2 into 10.3Marko Mäkelä2019-05-141-1/+1
| |\ \ | | |/
| | * Merge 10.1 into 10.2Marko Mäkelä2019-05-131-1/+1
| | |\
| | | * Merge branch '5.5' into 10.1Vicențiu Ciorbaru2019-05-111-1/+1
| | | |\
| | | | * Update FSF AddressVicențiu Ciorbaru2019-05-111-1/+1
| | | | | | | | | | | | | | | | | | | | * Update wrong zip-code
| * | | | Merge 10.2 into 10.3Marko Mäkelä2018-12-181-1/+1
| |\ \ \ \ | | |/ / /
| | * | | MDEV-14576 Include full name of object in message about incorrect value for ↵Alexey Botchkov2018-12-161-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | column. The error message modified. Then the TABLE_SHARE::error_table_name() implementation taken from 10.3, to be used as a name of the table in this message.
* | | | | Galera4Brave Galera Crew2019-01-231-0/+101
| | | | |
* | | | | Fixed ASAN failure for the test main.func_miscbb-10.4-16722Varun Gupta2018-08-241-1/+20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Moved the checks for arguments validation of Item_name_const from the constructor to Create_func_name_const::create_2_arg Also reverted the fix bf1c53e9be84437ada32393bb7b4a8ff06dbf369
* | | | | MDEV-16864 Implement class Item_func_timestampAlexander Barkov2018-07-311-2/+2
| | | | |
* | | | | MDEV-16806 Add Type_handler::create_literal_item()Alexander Barkov2018-07-241-78/+0
| | | | |
* | | | | MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operationsOleksandr Byelkin2018-07-041-4/+3
|/ / / /
* | | | Add likely/unlikely to speed up executionMonty2018-05-071-46/+46
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added to: - if (error) - Lex - sql_yacc.yy and sql_yacc_ora.yy - In header files to alloc() calls - Added thd argument to thd_net_is_killed()
* | | | MDEV-15915 Add Feature_json status variable.Alexey Botchkov2018-04-261-0/+26
| | | | | | | | | | | | | | | | Related implementations.
* | | | MDEV-15739 sql_mode=ORACLE: Make LPAD and RPAD return NULL instead of empty ↵halfspawn2018-04-031-8/+104
| | | | | | | | | | | | | | | | string
* | | | MDEV-15664 : sql_mode=ORACLE: Make TRIM return NULL instead of empty stringhalfspawn2018-03-291-2/+48
| | | |
* | | | MDEV-11952 Oracle-style packages: stage#5mariadb-10.3.5bb-10.3-compatibilityAlexander Barkov2018-02-251-5/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - CREATE PACKAGE [BODY] statements are now entirely written to mysql.proc with type='PACKAGE' and type='PACKAGE BODY'. - CREATE PACKAGE BODY now supports IF NOT EXISTS - DROP PACKAGE BODY now supports IF EXISTS - CREATE OR REPLACE PACKAGE [BODY] is now supported - CREATE PACKAGE [BODY] now support the DEFINER clause: CREATE DEFINER user@host PACKAGE pkg ... END; CREATE DEFINER user@host PACKAGE BODY pkg ... END; - CREATE PACKAGE [BODY] now supports SQL SECURITY and COMMENT clauses, e.g.: CREATE PACKAGE p1 SQL SECURITY INVOKER COMMENT "comment" AS ... END; - Package routines are now created from the package CREATE PACKAGE BODY statement and don't produce individual records in mysql.proc. - CREATE PACKAGE BODY now supports package-wide variables. Package variables can be read and set inside package routines. Package variables are stored in a separate sp_rcontext, which is cached in THD on the first packate routine call. - CREATE PACKAGE BODY now supports the initialization section. - All public routines (i.e. declared in CREATE PACKAGE) must have implementations in CREATE PACKAGE BODY - Only public package routines are available outside of the package - {CREATE|DROP} PACKAGE [BODY] now respects CREATE ROUTINE and ALTER ROUTINE privileges - "GRANT EXECUTE ON PACKAGE BODY pkg" is now supported - SHOW CREATE PACKAGE [BODY] is now supported - SHOW PACKAGE [BODY] STATUS is now supported - CREATE and DROP for PACKAGE [BODY] now works for non-current databases - mysqldump now supports packages - "SHOW {PROCEDURE|FUNCTION) CODE pkg.routine" now works for package routines - "SHOW PACKAGE BODY CODE pkg" now works (the package initialization section) - A new package body level MDL was added - Recursive calls for package procedures are now possible - Routine forward declarations in CREATE PACKATE BODY are now supported. - Package body variables now work as SP OUT parameters - Package body variables now work as SELECT INTO targets - Package body variables now support ROW, %ROWTYPE, %TYPE
* | | | MDEV-15091 : Windows, 64bit: reenable and fix warning C4267 (conversion from ↵Vladislav Vaintroub2018-02-061-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 'size_t' to 'type', possible loss of data) Handle string length as size_t, consistently (almost always:)) Change function prototypes to accept size_t, where in the past ulong or uint were used. change local/member variables to size_t when appropriate. This fix excludes rocksdb, spider,spider, sphinx and connect for now.
* | | | Change C_STRING_WITH_LEN to STRING_WITH_LENMonty2018-01-301-335/+335
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This preserves const str for constant strings Other things - A few variables where changed from LEX_STRING to LEX_CSTRING - Incident_log_event::Incident_log_event and record_incident where changed to take LEX_CSTRING* as an argument instead of LEX_STRING
* | | | Changed database, tablename and alias to be LEX_CSTRINGMonty2018-01-301-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This was done in, among other things: - thd->db and thd->db_length - TABLE_LIST tablename, db, alias and schema_name - Audit plugin database name - lex->db - All db and table names in Alter_table_ctx - st_select_lex db Other things: - Changed a lot of functions to take const LEX_CSTRING* as argument for db, table_name and alias. See init_one_table() as an example. - Changed some function arguments from LEX_CSTRING to const LEX_CSTRING - Changed some lists from LEX_STRING to LEX_CSTRING - threads_mysql.result changed because process list_db wasn't always correctly updated - New append_identifier() function that takes LEX_CSTRING* as arguments - Added new element tmp_buff to Alter_table_ctx to separate temp name handling from temporary space - Ensure we store the length after my_casedn_str() of table/db names - Removed not used version of rename_table_in_stat_tables() - Changed Natural_join_column::table_name and db_name() to never return NULL (used for print) - thd->get_db() now returns db as a printable string (thd->db.str or "")
* | | | System Versioning pre0.12Aleksey Midenkov2017-11-071-41/+10
|\ \ \ \ | | | | | | | | | | | | | | | Merge remote-tracking branch 'origin/archive/2017-10-17' into 10.3
| * | | | SQL: VTQ testing iface moved to plugin [closes #224]Aleksey Midenkov2017-07-071-159/+10
| | | | |
| * | | | IB, SQL: (0.4) COMMIT_ID-based ordering of transactionsAleksey Midenkov2017-05-051-45/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | IB: * removed CONCURR_TRX from VTQ; * new fields in VTQ: COMMIT_ID, ISO_LEVEL. SQL: * renamed BEGIN_TS, COMMIT_TS to VTQ_BEGIN_TS, VTQ_COMMIT_TS; * new functions: VTQ_COMMIT_ID, VTQ_ISO_LEVEL, VTQ_TRX_ID, VTQ_TRX_SEES, VTQ_TRX_SEES_EQ; * versioned SELECT for IB uses VTQ_TRX_SEES, VTQ_TRX_SEES_EQ. Closes #71
| * | | | IB: 0.2 part IVAleksey Midenkov2017-05-051-0/+88
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * BEGIN_TS(), COMMIT_TS() SQL functions; * VTQ instead of packed stores secs + usecs like my_timestamp_to_binary() does; * versioned SELECT to IB is translated with COMMIT_TS(); * SQL fixes: - FOR_SYSTEM_TIME_UNSPECIFIED condition compares to TIMESTAMP_MAX_VALUE; - segfault fix #36: multiple execute of prepared stmt; - different tables to same stored procedure fix (#39) * Fixes of previous parts: ON DUPLICATE KEY, other misc fixes.
* | | | | Merge remote-tracking branch 'origin/bb-10.2-ext' into 10.3Alexander Barkov2017-10-301-0/+50
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | TODO: enable MDEV-13049 optimization for 10.3
| * | | | | MDEV-14012 - sql_mode=Oracle: substr(): treat position 0 as position 1halfspawn2017-10-061-0/+50
| | | | | |
* | | | | | Merge bb-10.2-ext into 10.3Marko Mäkelä2017-10-041-1/+1
|\ \ \ \ \ \ | |/ / / / /
View Lorry Controller Status