| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |\ |
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
When parser parses function convert_tz it loads available timezone tables in
thd->lex->time_zone_tables_used. But view have another lex that main query.
Thus time_zone_tables_used of main query left uninitialized.
When Item_func_conver_tz is fixed it takes timezone tables from main query
and later when it executed it assumes that timezone tables are loaded and
failed that assertion.
|
| | | |
|
| |\ \
| |/
|/|
| | |
into mysql.com:/home/alexi/dev/mysql-5.0-13000
|
| | |
| |
| |
| | |
DAYOFWEEK(), and WEEKDAY().
|
| | | |
|
| | | |
|
| |\ \
| |/
|/|
| | |
into sanja.is.com.ua:/home/bell/mysql/bk/work-owner2-5.0
|
| | |
| |
| |
| |
| | |
view definer information syntax/storage/replication
fixed SOURCE field of .frm
|
| |\ \
| | |
| | |
| | | |
into neptunus.(none):/home/msvensson/mysql/bug10713_new/my50-bug10713_new
|
| | |\ \ |
|
| | | |/
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
When view column aliased in subselect alias is set on ref which represents
field. When tmp table is created for subselect, it takes name of original field
not ref. Because of this alias on view column in subselect is lost. Which
results in reported error.
Now when alias is set on ref, it's set on ref real item too.
|
| |\ \ \
| |/ /
| | |
| | | |
into neptunus.(none):/home/msvensson/mysql/bug10713_new/my50-bug10713_new
|
| | |/
| |
| |
| |
| | |
The problem was in that add_table_to_list was testing for duplicate tables
in a list of tables that included the created view.
|
| |/
|
|
|
| |
- Update test results
- Updates after review
|
| |\ |
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
Fields of view represented by Item_direct_view_ref. When complex expression
such as if(sum()>...,...) is splited in simpler parts by refs was ignored.
Beside this direct ref doesn't use it's result_field and thus can't store
it's result in tmp table which is needed for sum() ... group.
All this results in reported bug.
Item::split_sum_func2() now converts Item_direct_view_ref to Item_ref to
make fields from view being storable in tmp table.
|
| |/
|
|
|
|
| |
put newly
created item into item->result_field, not *(item->ref)->result_field.
|
| |\
| |
| |
| | |
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
|
| | |\
| | |
| | |
| | | |
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
|
| | | |
| | |
| | |
| | |
| | |
| | | |
update (BUG#10773)
frequently used command sequence replaced with inline function
|
| | | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
view.
For Item_func_strcmp print() was not defined and for this class was called
print_op of it's parent class. Because of this strcmp() was printed wrongly
and this results int creation of broken view.
Added function Item_func_strcmp::print() which correctly prints strcmp()
function.
|
| |\ \ \
| | | |
| | | |
| | | | |
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug1-5.0
|
| | | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
correct exit from mysql_create_view to restore ennvironment (BUG#12468)
view.result, view.test:
test of CRETE VIEW in SP
|
| |\ \ \ \
| | | | |
| | | | |
| | | | | |
into lmy004.:/work/mysql-5.0-bug12533-2
|
| | | |/ /
| |/| | |
|
| |/ / / |
|
| |\ \ \ |
|
| | |/ /
| | |
| | |
| | |
| | |
| | |
| | | |
results.
st_select_lex_unit::print() was losing UNION ALL if in statement were present
UNION DISTINCT.
|
| |/ /
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
Added a test case for bug #10970.
view.result:
Added a test case for bug #10970.
Modified the error messages for error ER_VIEW_SELECT_TMPTABLE.
sql_view.cc:
Fixed bug #10970.
In the function mysql_create_view if a view does not refer
any tables directly the variable table must be updated
after the call of open_and_lock_tables.
errmsg.txt:
Modified the error messages for error ER_VIEW_SELECT_TMPTABLE
(when fixing bug #10970).
|
| | |
| |
| |
| |
| |
| |
| |
| | |
view being created.
Item_func_timestamp_diff::func_name() were returning function name as
"timestamp_diff" thus when view was executed function parameters wasn't
properly recognized and error was raised.
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
Fixed bug #12470.
A misplaced initialization of the cond_count counter
resulted in a wrong calculation of it. This caused a memory
corruption since this counter was used as a parameter of
some memory allocation.
view.test:
Added a test case for bug #12470.
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
Fixed bug #12382.
INSERT statement effectively changed thd->set_query_id to 0,
while SELECT statement changed it to 0. As a result
the insert_fields function that expanded '*' was called
with different values of thd->set_query_id for the query
SELECT * FROM view depending on whether it was run after
an INSERT or after a SELECT statement. This was corrected
by restoring the old value of thd->set_query_id when
returning from the function setup_fields where possible
reset could occur.
If the value of thd->set_query_id == 0 then the fields
substituted instead of '*' were not registered as used
for bitmaps used_keys. This caused selection of an invalid
execution plan for the query SELECT * from <view>.
view.result, view.test:
Added a test case for bug #12382.
|
| | |
| |
| |
| |
| |
| |
| |
| |
| | |
* Cleanup SP Cache code, now SP Cache only deletes sp_head objects in
sp_cache_flush_obsolete() invalidates all pointers to routines in the cache.
* Use new SP Cache use contract in the code.
There is no test case because it doesn't seem to be possible to cause thread races to end
the same way they end in heavy-load test. This patch removes the crash in heavy test.
|
| | | |
|
| |\ \ |
|
| | | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
Item_type_holder doesn't store information about length and exact type of
original item which results in redefining length to max_length and geometry
type to longtext.
Changed the way derived tables except unions are built. Now they are created
from original field list instead of list of Item_type_holder.
|
| |\ \ \ |
|
| | | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
prelocked mode for
its body, but lets each statement to get/release its own locks. This allows a broader set
of statements to be executed inside PROCEDUREs (but breaks replication)
This patch should fix BUG#8072, BUG#8766, BUG#9563, BUG#11126
|
| |/ / /
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
Fixed bug #11412.
Reversed the patch of cs 1.1934 for the function
create_tmp_table. Modified the function to support
tem_ref objects created for view fields.
item_buff.cc:
Fixed bug #11412.
Modified implementation of new_Cached_item to support
cacheing of view fields.
item.h:
Fixed bug #11412.
Changed implementation of Item_ref::get_tmp_table_field and
added Item_ref::get_tmp_table_item to support Item_ref objects
created for view fields.
view.test, view.result:
Added a test case for bug #11412.
|
| |\ \ \
| | | |
| | | |
| | | | |
into moonbone.local:/work/mysql-5.0-bug-11760
|
| | | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
by subtime() in view
Item_func_add_time::print() were printing arg[0] instead of arg[1] which
results in wrongly created view. Functions addtime() and subtime were
affected by this bug.
|
| |/ / /
| | |
| | |
| | |
| | |
| | |
| | | |
"Triggers have the wrong namespace"
"Triggers: duplicate names allowed"
"Triggers: CREATE TRIGGER does not accept fully qualified names"
"SHOW TRIGGERS"
|
| | | | |
|
| |\ \ \
| | | |
| | | |
| | | | |
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug6-5.0
|
| | | | |
| | | |
| | | |
| | | | |
correct value of CURRENT_USER() in SP with "security definer" (BUG#7291)
|
| | |/ /
|/| |
| | |
| | |
| | | |
try to find most suitable table, to avouid pickup table with too low locking mode or occupy table with write mode for select when it will be need for update later
(BUG#9597)
|
| |\ \ \ |
|
| | | | | |
|
| |\ \ \ \
| | | | |
| | | | |
| | | | | |
into moonbone.local:/work/mysql-5.0-bug-11709
|
