summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-6512/+0
|
* Merge branch 'bb-10.2-ext' into 10.3Sergei Golubchik2018-02-231-108/+0
|\
| * Merge branch '10.2' into bb-10.2-extSergei Golubchik2018-02-221-108/+0
| |\
| | * Merge branch '10.1' into 10.2Sergei Golubchik2018-02-221-108/+0
| | |\
| | | * Merge branch '10.0' into 10.1Sergei Golubchik2018-02-221-108/+0
| | | |\
| | | | * Merge branch '5.5' into 10.0Sergei Golubchik2018-02-221-108/+0
| | | | |\
| | | | | * cleanup: remove a duplicated test caseSergei Golubchik2018-02-111-108/+0
| | | | | |
* | | | | | Merge bb-10.2-ext into 10.3Marko Mäkelä2018-02-151-14/+14
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Added Max_index_length and Temporary to SHOW TABLE STATUSMonty2018-02-121-14/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Max_index_length is supported by MyISAM and Aria tables. - Temporary is a placeholder to signal that a table is a temporary table. For the moment this is always "N", except "Y" for generated information_schema tables and NULL for views. Full temporary table support will be done in another task. (No reason to have to update a lot of result files twice in a row)
* | | | | | Merge bb-10.2-ext into 10.3Marko Mäkelä2018-01-041-0/+14
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extMonty2018-01-011-0/+14
| |\ \ \ \ \ | | |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: cmake/make_dist.cmake.in mysql-test/r/func_json.result mysql-test/r/ps.result mysql-test/t/func_json.test mysql-test/t/ps.test sql/item_cmpfunc.h
| | * | | | Merge remote-tracking branch 'origin/10.1' into 10.2Vicențiu Ciorbaru2017-12-221-0/+14
| | |\ \ \ \ | | | |/ / /
| | | * | | Merge branch '10.0' into 10.1Vicențiu Ciorbaru2017-12-201-0/+14
| | | |\ \ \ | | | | |/ /
| | | | * | Merge remote-tracking branch '5.5' into 10.0Vicențiu Ciorbaru2017-12-201-0/+14
| | | | |\ \ | | | | | |/
| | | | | * MDEV-14619: VIEW and GROUP_CONCATOleksandr Byelkin2017-12-171-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | Correctly print separator string in single quotes.
| | | * | | Merge branch '10.0' into 10.1Vicențiu Ciorbaru2017-09-191-3/+0
| | | |\ \ \ | | | | |/ /
| | | | * | Merge branch '5.5' into 10.0Vicențiu Ciorbaru2017-09-191-3/+0
| | | | |\ \ | | | | | |/
| | | | | * MDEV-11240: Server crashes in check_view_single_update or Assertion ↵Oleksandr Byelkin2017-08-161-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | `derived->table' failed in mysql_derived_merge_for_insert Before "merge" view shoud be inited to maintaing transitive attributes like "multitable".
| * | | | | Post-merge fix: Adjust message codes in resultsMarko Mäkelä2017-12-121-1/+1
| | | | | |
* | | | | | Merge bb-10.2-ext into 10.3Marko Mäkelä2017-12-121-1/+1
|\ \ \ \ \ \ | |/ / / / /
* | | | | | Changed "const row not found" to "Const row not found"Monty2017-12-021-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also changed Unique row not found to use uppercase first. This was done to make these messages consistent with the rest
* | | | | | Merge bb-10.2-ext into 10.3Marko Mäkelä2017-11-301-1/+1
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-11-201-1/+1
| |\ \ \ \ \ | | |/ / / /
* | | | | | Merge remote-tracking branch 'shagalla/10.3-mdev12172' into 10.3Igor Babaev2017-11-011-5/+5
|\ \ \ \ \ \ | |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | As a result of this merge the code for the following tasks appears in 10.3: - MDEV-12172 Implement tables specified by table value constructors - MDEV-12176 Transform [NOT] IN predicate with long list of values INTO [NOT] IN subquery.
| * | | | | Mistakes corrected. Test results corrected.Galina Shalygina2017-10-291-5/+5
| | | | | |
* | | | | | MDEV-12874 UPDATE statements with the same source and targethalfspawn2017-10-031-70/+0
| | | | | |
* | | | | | After-merge fix: Adjust some results.Marko Mäkelä2017-09-201-1/+1
| | | | | |
* | | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-09-131-0/+23
|\ \ \ \ \ \ | | |/ / / / | |/| | | |
| * | | | | MDEV-13436 PREPARE doesn't work as expected & throws errors but MySQL is ↵Oleksandr Byelkin2017-09-111-0/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | working fine Now we allow derived in the from clause of subqueries so set flag which prevent optimisation of subqueries during view creation before derived processing so subquery will be correctly printed in the view .frm.
* | | | | | Merge 10.2 into bb-10.2-extMarko Mäkelä2017-09-071-0/+35
|\ \ \ \ \ \ | |/ / / / /
| * | | | | MDEV-13523: Group By in a View, called within a Stored Routine causes Error ↵Oleksandr Byelkin2017-09-061-0/+35
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Code 1356 when a non-root user runs the routine for a second time it is actually test suite for second code chunk fix in MDEV-13439
* | | | | | Merge branch '10.2' into bb-10.2-extSergei Golubchik2017-08-251-0/+11
|\ \ \ \ \ \ | |/ / / / /
| * | | | | MDEV-11240: Server crashes in check_view_single_update or Assertion ↵mariadb-10.2.8Oleksandr Byelkin2017-08-171-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | `derived->table' failed in mysql_derived_merge_for_insert Before "merge" view shoud be inited to maintaing transitive attributes like "multitable".
| * | | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-08-171-0/+14
| |\ \ \ \ \ | | | |/ / / | | |/| | |
| | * | | | Merge branch '10.0' into 10.1Sergei Golubchik2017-08-081-0/+14
| | |\ \ \ \ | | | | |/ / | | | |/| |
| | | * | | Merge remote-tracking branch 'origin/5.5' into 10.0Vicențiu Ciorbaru2017-07-251-0/+14
| | | |\ \ \ | | | | | |/ | | | | |/|
| | | | * | MDEV-11240: Server crashes in check_view_single_update or Assertion ↵Oleksandr Byelkin2017-07-181-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | `derived->table' failed in mysql_derived_merge_for_insert Move table pointer for single table view (even if it is view over other view) to make the access universal.
* | | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexey Botchkov2017-08-111-0/+19
|\ \ \ \ \ \ | |/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: sql/item_cmpfunc.cc storage/innobase/buf/buf0flu.cc storage/innobase/include/ut0stage.h storage/innobase/row/row0upd.cc
| * | | | | MDEV-13439: Database permissions are not enough to run a subquery with GROUP ↵Oleksandr Byelkin2017-08-101-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | BY within a view The bug is result adding ability to have derived tables inside views. Fixed checks should be a switch between view/derived or select derived and information schema.
* | | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-08-071-1/+1
|\ \ \ \ \ \ | |/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: mysql-test/r/func_json.result mysql-test/r/win.result mysql-test/t/func_json.test mysql-test/t/win.test sql/share/errmsg-utf8.txt storage/rocksdb/ha_rocksdb.cc storage/rocksdb/mysql-test/rocksdb/r/tbl_opt_data_index_dir.result
* | | | | | MDEV-12137 DELETE statement with the same source and targetSergei Golubchik2017-07-071-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * various cleanups (mostly cosmetic) * remove useless tests (that were tesing the error condition) * optimize delete_use_source test (from 6 mins to 50 seconds, mainly by removing two huge rollbacks at the end).
* | | | | | MDEV-12137 DELETE statement with the same source and targethalfspawn2017-07-071-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | single-table deletes only
* | | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-07-071-0/+80
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-07-051-0/+80
| |\ \ \ \ \ | | |/ / / /
| | * | | | Merge branch 'bb-10.1-vicentiu' into 10.1Vicențiu Ciorbaru2017-06-271-0/+62
| | |\ \ \ \
| | | * \ \ \ Merge remote-tracking branch '10.0' into 10.1Vicențiu Ciorbaru2017-06-211-0/+62
| | | |\ \ \ \ | | | | |/ / /
| | | | * | | MDEV-12666: CURRENT_ROLE() and DATABASE() does not work in a viewVicențiu Ciorbaru2017-06-151-0/+62
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The problem lies in how CURRENT_ROLE is defined. The Item_func_current_role inherits from Item_func_sysconst, which defines a safe_charset_converter to be a const_charset_converter. During view creation, if there is no role previously set, the current_role() function returns NULL. This is captured on item instantiation and the const_charset_converter call subsequently returns an Item_null. In turn, the function is replaced with Item_null and the view is then created with an Item_null instead of Item_func_current_role. Without this patch, the first SHOW CREATE VIEW from the testcase would have a where clause of WHERE role_name = NULL, while the second SHOW CREATE VIEW would show a correctly created view. The same applies for the DATABASE function, as it can change as well. There is an additional problem with CURRENT_ROLE() when used in a prepared statement. During prepared statement creation we used to set the string_value of the function to the current role as well as the null_value flag. During execution, if CURRENT_ROLE was not null, the null_value flag was never set to not-null during fix_fields. Item_func_current_user however can never be NULL so it did not show this problem in a view before. At the same time, the CURRENT_USER() can not be changed between prepared statement execution and creation so the implementation where the value is stored during fix_fields is sufficient. Note also that DATABASE() function behaves differently during prepared statements. See bug 25843 for details or commit 7e0ad09edff587dadc3e9855fc81e1b7de8f2199
| | * | | | | MDEV-12819 order by ordering expression changed to empty string when creatin ↵Oleksandr Byelkin2017-06-221-0/+18
| | |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | view with union prepare of "fake_select" for union made in JOIN::prepare only if we do not execute it then before reset, i.e it was for PS prepare and now required for CREATE VIEW to make global ORDER BY which belongs to "fake_select" prepared.
* | | | | | MDEV-13197 Parser refactoring for CREATE VIEW,TRIGGER,SP,UDF,EVENTAlexander Barkov2017-07-011-0/+11
| | | | | |
* | | | | | Improved warning "xxx is not BASE TABLE/SEQUENCE"Monty2017-06-021-14/+14
| |_|_|_|/ |/| | | | | | | | | | | | | | | | | | | - Changed warning to "'%-.192s.%-.192s' is not of type '%s'" to make the english a bit more correct
View Lorry Controller Status