sql - STR_TO_DATE discrepancy between MySQL 5.5 and MySQL 5.6 -


this sql returns date in mysql 5.5 null in mysql 5.6. why?

select date(str_to_date('2015-01', '%y-%m')) + interval 1 day;

here's sql fiddle mysql 5.5 , 5.6. str_to_date returns date in both instances. converting result using date works. problem comes when trying add interval. doesn't matter if add interval str_to_date(...) or date(str_to_date(...)), result same. however, removing str_to_date makes work.

select     str_to_date('2015-01', '%y-%m') same_a1,     str_to_date('2015-01-01', '%y-%m') same_a2,     str_to_date('2015-01', '%y-%m-%d') same_a3,     str_to_date('2015-01-01', '%y-%m-%d') same_a4,     date(str_to_date('2015-01', '%y-%m')) same_b1,     date(str_to_date('2015-01-01', '%y-%m')) same_b2,     date(str_to_date('2015-01', '%y-%m-%d')) same_b3,     date(str_to_date('2015-01-01', '%y-%m-%d')) same_b4,     str_to_date('2015-01', '%y-%m') + interval 1 day same_c1,     str_to_date('2015-01-01', '%y-%m') + interval 1 day same_c2,     str_to_date('2015-01', '%y-%m-%d') + interval 1 day same_c3,     str_to_date('2015-01-01', '%y-%m-%d') + interval 1 day same_c4,     date(str_to_date('2015-01', '%y-%m')) + interval 1 day different_d1,     date(str_to_date('2015-01-01', '%y-%m')) + interval 1 day different_d2,     date(str_to_date('2015-01', '%y-%m-%d')) + interval 1 day different_d3,     date(str_to_date('2015-01-01', '%y-%m-%d')) + interval 1 day same_d4,     date('2015-01') + interval 1 day same_e1,     date('2015-01-01') + interval 1 day same_e2 ;

i searched release notes couldn't find anything. going on? known change? bug?

it's known change, unwittingly introduced versions 5.1.59, 5.5.16 , 5.6.3 (but rolled in versions 5.1.62 , 5.5.21; retained in 5.6 line):

incompatible change: handling of date-related assertion modified.

however, consequence of change several functions become more strict when passed date() function value argument , reject incomplete dates day part of zero. these functions affected: convert_tz(), date_add(), date_sub(), dayofyear(), last_day(), timestampdiff(), to_days(), to_seconds(), week(), weekday(), weekofyear(), yearweek(). because changes date-handling behavior in general availability-status series (mysql 5.1 , 5.5), reverted in 5.1.62 , 5.5.21. change retained in mysql 5.6.

references: see bug #13458237.

you affected because + interval notation syntactic sugar around date_add() function.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

ruby on rails - Seeing duplicate requests handled with Unicorn -

recently upgraded our ec2 instances c3.large in order boost more unicorn workers handle increased traffic our site. (6xworkers per machine - 2 ec2 instances). when did this, started seeing duplicate records being created! looks somehow, maybe 2 unicorn workers attempting process same request? in nginx logs see 1 [post] request particular rails controller - yet 2 records being created in database. i'm hitting kind of race condition issue - have no idea how debug this. doesn't happen time, when it's frustrating well. noticed 2 database records within 5 seconds of each other. (and yes disable button when user clicks submit button). unicorn 4.8.2 ruby 1.9.3 rails 3.2.14 any great! thanks! although may not fix problem, upgrade ruby 2.0.0. there blog mentioning idea upgrade ruby 2.0.0 if using unicorn. for example: https://www.digitalocean.com/community/articles/how-to-optimize-unicorn-workers-in-a-ruby-on-rails-app specifically: if using ruby 1.9, ...
Read more