Done issues

Field ROUTINE_DEFINITION in INFORMATION_SCHEMA.`ROUTINES` contains broken procedure body when used shielding quotes inside.
MDEV-7231
Add continuous binary log backup to mysqlbinlog
MDEV-8713
5.5.48-galera release
MDEV-9555
10.0.24-galera release
MDEV-9645
Donor's rsync SST script hangs if FTWRL fails
MDEV-9598
libgalera_smm.so moved from lib/ to lib/galera without documentation.
MDEV-9633
information_schema.user_variables
MDEV-7331
Table cache cleanups
MDEV-9488
MySQL refuse to start after a crash
MDEV-8575
sys_vars.secure_file_priv fails sporadically if it's executed with --mem
MDEV-4070
Window function produces incorrect value
MDEV-9634
tokudb.cluster_filter_unpack_varchar_hidden fails sporadically in buildbot
MDEV-7907
10.2 merge
MDEV-9636
Galera replication wont start in 10.1.11
MDEV-9632
Apparently valid SQL query gives wrong result (nested WHERE)
MDEV-8988
SHOW AUTHORS list
MDEV-6826
SHOW CONTRIBUTORS does not list all MariaDB Foundation members and sponsors
MDEV-6821
Server crashes when slave works with partitioned tables copied from Windows to Linux
MDEV-9424
Server without encryption configs crashes if selecting from an implicitly encrypted table
MDEV-9559
group_concat_max_len not being read from /etc/my.cnf
MDEV-9474
Timezone problem
MDEV-9611
Customized Roles
MDEV-9625
10.1.12 merge
MDEV-9583
Bug after upgrade to 10.1.10 (and 10.1.11)
MDEV-9500
Assertion `is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed in Field_timestamp::store_TIME_with_warning
MDEV-8411
[PATCH] solaris10 build fixes
MDEV-9381
from mariadb 10.0.22 upgrade to mariadb 10.1.10
MDEV-9399
mysqldump creating malformed PERSISTENT SQL
MDEV-9454
Crash with signal 11 since last update (2 time in one month)
MDEV-9377
Mariadb 10.1 Crashes when replicating from 10.0
MDEV-9560
I can't finish my_install_db using binary tar distribution
MDEV-9475
Trigger doing "SET NEW.auctionStart = NOW();" on a timestamp kills MariaDB server.
MDEV-9535
SHOW SPATIAL_REF_SYS and SHOW SYSTEM_VARIABLES return empty results with numerous warnings
MDEV-9540
Server crashes in make_columns_old_format on SHOW GEOMETRY_COLUMNS
MDEV-9539
Server crashes in check_show_access on SHOW STATISTICS
MDEV-9538
COUNT(NULL) returns incorrect result with sequence storage engine
MDEV-9550
Server crashes in fix_fields, main.null fails with ps-protocol #2
MDEV-9606
syntax error on view with nullif and count
MDEV-9576
FROM_UNIXTIME same date time from two different timestamp
MDEV-9608
Galera test failures on Power8
MDEV-7654
Client build does not build gssapi_client plugin
MDEV-9601
Remove restrictions on subqueries in VIEWs FROM clause
MDEV-9607
mysql_config --libs output contains invalid -l-pthread
MDEV-9388
[PATCH] SphinxSE: add support for json filtering
MDEV-9303
maria_add_gis_sp.sql installed twice
MDEV-9529
DATA/INDEX DIRECTORY are not in information_schema.TABLES
MDEV-9307
Server crashes in fix_fields, main.null fails with ps-protocol
MDEV-9503
COLUMN_GET on a subkey with more than three key value pairs returns a corrupted dyncol_blob
MDEV-9429
Assertion `0' failed in Protocol::end_statement() on UNION ALL
MDEV-9489
please close - fixed
MDEV-9600
issue 1 of 5769

Field ROUTINE_DEFINITION in INFORMATION_SCHEMA.`ROUTINES` contains broken procedure body when used shielding quotes inside.

Description

Demonstration:

1 2 3 4 SELECT (SELECT ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.`ROUTINES` IR WHERE IR.ROUTINE_SCHEMA = 'BPLNew' AND IR.`SPECIFIC_NAME` = 'get_dict_source') = (SELECT body FROM `mysql`.`proc` mp WHERE mp.db='BPLnew' AND mp.`name` = 'get_dict_source') compare
1 2 3 compare --------- 0

As you can see on the screenshot comparison only difference is the amount of shielding quotes.

Why?

Yet another example:

Example:

1 2 3 4 5 6 7 8 9 10 11 SHOW CREATE PROCEDURE test DELIMITER $$ CREATE PROCEDURE `test`( ) BEGIN SELECT CONCAT('ABC = ''',1,''''), CONCAT('ABC = ',2); END$$ DELIMITER ;

Information schema:

1 SELECT ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.`ROUTINES` IR WHERE IR.ROUTINE_SCHEMA = 'test' AND IR.`SPECIFIC_NAME` = 'test'
1 2 3 4 5 ROUTINE_DEFINITION --------------------------------------------------------------- BEGIN select concat('ABC = '',1,'''), CONCAT('ABC = ',2); END

mysql:

1 SELECT body FROM `mysql`.`proc` mp WHERE mp.db='test' AND mp.`name` = 'test'
1 2 3 4 5 body ----------------------------------------------------------------- BEGIN select concat('ABC = ''',1,''''), CONCAT('ABC = ',2); END

Environment

Linux Fedora 21

Status

Assignee

Alexander Barkov

Reporter

МихаилГ

External issue ID

None

External issue ID

None

Components

Sprint

None

Fix versions

Affects versions

5.3.12
10.0
5.1.67
5.2.14
5.5

Priority

Major