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

Assignee

Unassigned

Reporter

NT Man

Labels

Priority

Configure