All issues

LP:1028296 - Changing Server SQL Mode not apply to stored procedures
MDEV-3769
LP:684144 - Various Valgrind warnings around index intersection in maria-5.1-wl21
MDEV-3763
LP:393761 - Optimizer won't use partial primary key if another index can prevent filesort
MDEV-3762
LP:876306 - Assertion `count <= lock->read_no_write_count && count2 <= 100' failed in check_locks with numerous subqueries
MDEV-3761
LP:1035271 - ruby dbi connection to Mariadb break after beeing idle for 10 minutes
MDEV-3758
LP:855505 - ST_TOUCHES reports TRUE for intersecting polygon and linestring
MDEV-3755
LP:756387 - The innodb.innodb_bug60049 test fails in 5.5.11
MDEV-3753
LP:841622 - Assertion `t->rp->type == Gcalc_function::shape_line' failed in Gcalc_operation_reducer::end_line in maria-5.3-gis
MDEV-3752
LP:724275 - Crash in JOIN::optimize in maria-5.3
MDEV-3747
LP:1008334 - Benchmark Query 4x Faster on MySQL 5.5
MDEV-3745
LP:849809 - Second assertion `t->rp->type == Gcalc_function::shape_line' in Gcalc_operation_reducer::end_line()
MDEV-3741
LP:772335 - Second crash in copy_fields() in maria-5.3
MDEV-3740
LP:1029835 - Incorect results in union & subqueries
MDEV-3738
LP:960587 - Bit Field Causing Issues with Inner Join
MDEV-3733
LP:912510 - Crash in do_copy_not_null with semijoin=ON, firstmatch=ON, aggregate function, IN subquery
MDEV-3731
LP:992983 - Aborted_clients metric is growing up even though formal connection close
MDEV-3730
LP:609121 - RQG: wrong result on aggregate + NOT IN + HAVING and partial_match_table_scan=on
MDEV-3729
LP:857051 - ST_EQUALS returns TRUE on two nonidentical MULTIPOINTs
MDEV-3728
LP:516148 - Test maria.maria3 fails when --without-maria-tmp-tables is set
MDEV-3722
LP:491097 - main.create-big fails on mariadb 5.2 (64bit linux)
MDEV-3721
LP:712714 - handlersocket does not properly detect MariaDB version
MDEV-3715
LP:635633 - OQGRAPH is silently not compiled if boost is missing
MDEV-3714
LP:849739 - Wrong result with double GROUP BY and subquery
MDEV-3713
LP:613423 - ma_page.c:430: _ma_new: Assertion `key_del_current != share->state.key_del && (key_del_current != 0) && ((key_del_current == (~ (my_off_t) 0)) || (key_del_current <= (share->state.state.key_file_length - block_size)))' failed.
MDEV-3711
LP:669893 - my_compiler.h: No such file or directory
MDEV-3705
LP:878753 - Assertion `0' failed in replace_where_subcondition with derived_merge and first execution of prepared statement
MDEV-3704
LP:680005 - Second assertion `cache != __null' failed in sub_select_cache() on EXPLAIN in maria-5.3-mwl89
MDEV-3703
LP:455520 - mariadb .debs: /var/lib/mysql/test owned by root and so unusable
MDEV-3701
LP:681761 - OQGraph table contents are lost on restart
MDEV-3699
LP:1011543 - JOIN statement inside the DELETE query are broken
MDEV-3691
LP:776285 - Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics
MDEV-3690
LP:983423 - Different execution plans for subquery
MDEV-3685
LP:801475 - ST_UNION() does not perform duplicate weedout in maria-5.3-gis
MDEV-3684
LP:888165 - crash when updating tables with foreign keys
MDEV-3676
LP:693127 - optimizer_use_mrr option not settable via the mysqld command line
MDEV-3674
LP:1034131 - select unix_timestamp('0000-00-00') returns NULL instead of 0
MDEV-3672
LP:848901 - Assertion `fabs(cur_isc->x-m_cur_intersection->x) + fabs(cur_isc->y-m_cur_intersection->y) < 0.000000000001' failed in Gcalc_scan_iterator::intersection_scan() in maria-5.3-gis
MDEV-3668
LP:482846 - integer math errors with large numbers and no errors or warnings given
MDEV-3661
LP:884631 - Table elimination works 5.3 release builds even if turned off
MDEV-3660
LP:695006 - Queries with "converting HEAP to Aria" status do not respond to KILL QUERY
MDEV-3659
LP:668237 - Assertion `table_ref->has_record' failed in maria-5.3-mwl128 with join_cache_level=4, join_buffer_size=1
MDEV-3656
LP:922254 - Assertion `0' failed at item_cmpfunc.cc:5899: Item* Item_equal::get_first(JOIN_TAB*, Item*) with semijoin+materialization on EXPLAIN
MDEV-3654
LP:524679 - make test ORDER BY date_ord ASC
MDEV-3652
LP:644192 - ma_pagecache.c:1341: unlink_block: Assertion `block->next_used != ((void *)0)' failed.
MDEV-3651
LP:595277 - 5.2 beta rpm's unsigned
MDEV-3650
LP:509922 - Test runner doesn't honor --vs-config option when searching for mysqld
MDEV-3649
LP:671489 - Wrong result with Aria and MRR in maria-5.3-mwl128-dsmrr-cpk
MDEV-3645
LP:909414 - Valgrind warnings "Syscall param epoll_ctl(event) points to uninitialised byte(s)unitialized bytes" at threadpool_unix.cc
MDEV-3644
LP:849789 - Second assertion `m_poly_borders->next' failed in Gcalc_operation_reducer::count_slice in maria-5.3-gis
MDEV-3643
LP:798448 - section with no package header
MDEV-3631
issue 1 of 7601

LP:1028296 - Changing Server SQL Mode not apply to stored procedures

Description

Changing Server SQL Mode not apply to stored procedures

SET sql_mode='NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE';

Query: insert into bonus_results (calc_date, id_prod_type, id_user) value ('2012-08-00', 1, 2)

Error Code: 1292
Incorrect date value: '2012-08-00' for column 'calc_date' at row 1

It's right, but same SQL in stored procedures continue work

Workaround only recreate all stored procedures

Environment

None

Status

Assignee

Unassigned

Reporter

NT Man

Labels

External issue ID

None

External issue ID

None

Priority