summaryrefslogtreecommitdiff
path: root/sql/sql_parse.cc
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-7769 MY_CHARSET_INFO refactoring# On branch 10.2Alexander Barkov2016-10-101-5/+2
| | | | Part 3 (final): removing MY_CHARSET_HANDLER::well_formed_len().
* MDEV-10866 Extend PREPARE and EXECUTE IMMEDIATE to understand expressionsAlexander Barkov2016-10-081-0/+1
| | | | MDEV-10867 PREPARE..EXECUTE is not consistent about non-ASCII characters
* MDEV-10585 EXECUTE IMMEDIATE statementAlexander Barkov2016-10-081-0/+5
|
* Allowed to use WITH clauses before SELECT in CREATE ... SELECTbb-10.2-mdev9864Igor Babaev2016-09-221-2/+4
| | | | | and INSERT ... SELECT. Added test cases.
* Don't increment 'Empty_queries' for queries with errors.Monty2016-09-151-1/+1
|
* MDEV-10779 Failing assertion lex->proc_list.elements == 0 or syntax error on ↵Alexander Barkov2016-09-131-2/+16
| | | | | | | | | PROCEDURE ANALYSE in UNION Reverting a part of the patch for "MDEV-8909union parser cleanup", as a parenthesized SELECT with PROCEDURE followed by UNION is not disallowed by the grammar (only a non-parenthesized SELECT with PROCEDURE followed by a UNION is disallowed grammatically).
* Fix assertion/hang in read_init_file()Kristian Nielsen2016-09-091-1/+12
| | | | | | | | | | | If there are other threads running (for example binlog background thread), then the thread count may not drop to zero at the end of do_handle_bootstrap(). This caused an assertion and missing wakeup of the main thread. The missing wakeup is because THD::~THD() only signals the COND_thread_count mutex when the number of threads drops to zero. Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
* Merge branch '10.1' into 10.2Sergei Golubchik2016-09-091-6/+10
|\
| * MDEV-10545: Server crashed in my_copy_fix_mb on querying I_S and P_S tablesNirbhay Choubey2016-09-021-4/+3
| | | | | | | | | | | | Once THDs have been added to the global "threads" list, they must modify query_string only after acquiring per- thread LOCK_thd_data mutex.
| * Merge branch '10.0-galera' into bb-10.1-sergNirbhay Choubey2016-08-251-2/+5
| |\
| | * Merge branch '10.0' into 10.0-galeraNirbhay Choubey2016-08-241-0/+2
| | |\
| | * | Refs: MW-248sjaakola2016-08-211-9/+8
| | | | | | | | | | | | | | | | - some more code cleanup
| | * | Refs: MW-248sjaakola2016-08-211-12/+11
| | | | | | | | | | | | | | | | | | | | - test cases from PXC for reproducing the issue - initial fix
| | * | Cleanup: Remove dead codeNirbhay Choubey2016-08-211-21/+0
| | | |
| | * | Merge branch '10.0' into 10.0-galeraNirbhay Choubey2016-04-291-18/+27
| | |\ \
| * | \ \ Merge branch '10.0' into 10.1Sergei Golubchik2016-08-251-0/+2
| |\ \ \ \ | | | |_|/ | | |/| |
| | * | | Minor cleanupsMonty2016-08-221-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | - Remove impossible test in test_quick_select - Ensure that is_fatal_error is set if we run out of stack space
| | * | | MDEV-8569 build_table_filename() doesn't support temporary tables.Alexey Botchkov2016-07-181-0/+1
| | | |/ | | |/| | | | | | | | | Temporary tables support added for RENAME and ALTER TABLE.
* | | | MDEV-8909 union parser cleanupAlexander Barkov2016-09-071-16/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | This is the final patch removing some old remainders that are not needed anymore. (Other clean-ups were done in earlier commits)
* | | | Fixed length of codding of COM_MULTI parts.Oleksandr Byelkin2016-08-311-13/+24
| | | |
* | | | MDEV-8931: (server part of) session state trackingOleksandr Byelkin2016-08-311-13/+11
| | | | | | | | | | | | | | | | Transaction tracker
* | | | MDEV-8931: (server part of) session state trackingOleksandr Byelkin2016-08-311-0/+14
| | | | | | | | | | | | | | | | initial commit to test
* | | | Better SHOW PROCESSLIST for replicationMonty2016-08-291-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - When waiting for events, start time is now counted from start of wait - Instead of having "Connect" as "Command" for all replication threads we now have: - Slave_IO for Slave thread reading relay log - Slave_SQL for slave executing SQL commands or distribution queries to Slave workers - Slave_worker for slave threads executin SQL commands in parallel replication
* | | | MDEV-10084: SQL batch united responseOleksandr Byelkin2016-07-041-0/+1
| | | | | | | | | | | | | | | | Reduce number of network send() calls for batch update requests
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-06-301-20/+34
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-05-041-17/+26
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2016-04-261-5/+25
| | |\ \
| | | * | MDEV-9142 :Adding Constraint with no database referenceJan Lindström2016-04-231-5/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | results in ERROR 1046 (3D000) at line 13: No database selected. Use database from create table to foreign key database if nothing else is given.
| | * | | MDEV-9580 SHOW GRANTS FOR <current_user> failsSergei Golubchik2016-04-241-12/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | use get_current_user() to distinguish user name without a hostname and a role name. move privilege checks inside mysql_show_grants() to remove duplicate get_current_user() calls
* | | | | More tests for "MDEV-7563 Support CHECK constraint".Alexander Barkov2016-06-301-4/+2
| | | | | | | | | | | | | | | | | | | | Testing non-ASCII string literals.
* | | | | MDEV-5535: Cannot reopen temporary tableNirbhay Choubey2016-06-101-10/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysqld maintains a list of TABLE objects for all temporary tables created within a session in THD. Here each table is represented by a TABLE object. A query referencing a particular temporary table for more than once, however, failed with ER_CANT_REOPEN_TABLE error because a TABLE_SHARE was allocate together with the TABLE, so temporary tables always had only one TABLE per TABLE_SHARE. This patch lift this restriction by separating TABLE and TABLE_SHARE objects and storing TABLE_SHAREs for temporary tables in a list in THD, and TABLEs in a list within their respective TABLE_SHAREs.
* | | | | cleanup: thread_countSergei Golubchik2016-06-041-7/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | move thread_count handling into THD: * increment thread_count in THD constructor * decrement thread_count in THD destructor * never modify thread_count directly!
* | | | | MDEV-9947: COM_MULTI united responseOleksandr Byelkin2016-05-171-9/+28
| | | | |
* | | | | Fix of PSI & COM_MULTIOleksandr Byelkin2016-05-131-0/+8
| | | | |
* | | | | Merge commit 'd5822a3ad0657040114cdc185c6387b9eb3a12b2' into 10.2Monty2016-04-281-0/+1
|\ \ \ \ \ | |/ / / /
| * | | | MDEV-9621 INSERT DELAYED fails on insert for tables with many columnsMonty2016-04-071-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This fix also fixes a connection hang when trying to do INSERT DELAYED to a crashed table. Added crash_mysqld.inc to allow easy crash+restart of mysqld
* | | | | Merge ../10.2-window-funcs-r12 into 10.2Sergei Petrunia2016-04-121-4/+61
|\ \ \ \ \
| * \ \ \ \ Merge branch '10.2' into bb-10.2-mdev9543Sergei Petrunia2016-03-281-139/+544
| |\ \ \ \ \
| * | | | | | The class Window_spec now has pointers to the partition and order listsIgor Babaev2016-03-161-4/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | of the type SQL_I_List<ORDER> rather then the objects of this type. It allows to replace easily one instance of such a list for another. Besides it will facilitate to compare two lists if they originate from the same window specification. In fact any direct assignment for objects of the type SQL_I_List<ORDER> was not valid.
| * | | | | | Initial patch for the implementation of window functions (MDEV-6115):Igor Babaev2016-02-121-0/+47
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - All parsing problems look like resolved - Stub performing name resolution of window functions in simplest queries has been added.
| * | | | | | This is the consolidated patch for mdev-8646:bb-10.2-mdev8646Igor Babaev2016-02-091-4/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "Re-factor the code for post-join operations". The patch mainly contains the code ported from mysql-5.6 and created for two essential architectural changes: 1. WL#5558: Resolve ORDER BY execution method at the optimization stage 2. WL#6071: Inline tmp tables into the nested loops algorithm The first task was implemented for mysql-5.6 by Ole John Aske. It allows to make all decisions on ORDER BY operation at the optimization stage. The second task implemented for mysql-5.6 by Evgeny Potemkin adds JOIN_TAB nodes for post-join operations that require temporary tables. It allows to execute these operations within the nested loops algorithm that used to be used before this task only for join queries. Besides these task moves all planning on the execution of these operations from the execution phase to the optimization phase. Some other re-factoring changes of mysql-5.6 were pulled in, mainly because it was easier to pull them in than roll them back. In particular all changes concerning Ref_ptr_array were incorporated. The port required some changes in the MariaDB code that concerned the functionality of EXPLAIN and ANALYZE. This was done mainly by Sergey Petrunia.
* | | | | | | Fixed compiler warningsMichael Widenius2016-04-071-2/+1
| |/ / / / / |/| | | | |
* | | | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-03-231-47/+15
|\ \ \ \ \ \ | | |/ / / / | |/| | | |
| * | | | | MDEV-717 LP:1003679 - Wrong binlog order on concurrent DROP schema and ↵Alexey Botchkov2016-03-231-46/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | CREATE function. The cause of the issue is when DROP DATABASE takes metadata lock and is in progress through it's execution, a concurrently running CREATE FUNCTION checks for the existence of database which it succeeds and then it waits on the metadata lock. Once DROP DATABASE writes to BINLOG and finally releases the metadata lock on schema object, the CREATE FUNCTION waiting on metadata lock gets in it's code path and succeeds and writes to binlog.
| * | | | | Merge branch 'bb-10.1-serg' into 10.1Sergei Golubchik2016-03-221-1/+1
| |\ \ \ \ \
| | * \ \ \ \ Merge branch '10.0' into 10.1Sergei Golubchik2016-03-211-1/+1
| | |\ \ \ \ \ | | | | |/ / / | | | |/| | |
| | | * | | | Fix spelling: occurred, execute, which etcOtto Kekäläinen2016-03-041-1/+1
| | | | | | |
| * | | | | | MDEV-9696: CREATE SERVER statement does not replicate in Galera ClusterNirbhay Choubey2016-03-221-0/+6
| |/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | Enable replication of CREATE/ALTER/DROP SERVER statements in Galera cluster.
* | | | | | Manual merge of branch 'bb-10.2-mdev8789' into 10.2Igor Babaev2016-03-211-0/+4
|\ \ \ \ \ \
| * | | | | | MDEV-8789 Implement non-recursive common table expressionsGalina Shalygina2015-12-181-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Initial implementation