## Historical - [x] #9666 @qw4990 #9693 cherry-picked - [x] #9667 @qw4990 #9702 cherry-picked - [x] #9669 @zyycj #9685 cherry-picked - [x] #9710 @qw4990 #9884 cherry-picked - [x] #9711 @qw4990 #9884 cherry-picked - [x] #9713 @qw4990 #9975 cherry-picked - [x] #9715 @b41sh #9874 cherry-picked - [x] #9727 @erjiaqing #10329 cherry-picked - [x] #9728 @WangXiangUSTC #10116 cherry-picked - [x] #9729 @wjhuang2016 #9751 **WON'T FIX** - [x] #9730 @qw4990 #10314 cherry-picked - [x] #9731 @wjhuang2016 #9746 #9750 - [x] #9732 @qw4990 #10109 cherry-picked - [x] #9734 @WangXiangUSTC #9933 cherry-picked - [x] #9735 @AndrewDi #10074 cherry-picked - [x] #9736 @qw4990 #10380 cherry-picked - [x] #9764 @erjiaqing #10313 cherry-picked - [x] #9767 @b41sh #9856 cherry-picked - [x] #9769 @qw4990 #10368 cherry-picked - [x] #9770 @Debiancc #9899 cherry-picked - [x] #9773 @b41sh #9819 cherry-picked - [x] #9774 @lzmhhh123 #9841 cherry-picked - [x] #9775 @WangXiangUSTC #9822 cherry-picked - [x] #10051 **WON'T FIX** - [x] #9776 **INVALID** - [x] #10346 @erjiaqing #10347 cherry-picked - [x] #10361 @qw4990 #10368 cherry-picked - [x] #9813 @winoros #9830 cherry-picked - [x] #10382 @mantuliu #10383 cherry-picked - [x] #9763 @qw4990 #10753
Historical
str_to_dateis incompatible with Mysql #9666 @qw4990 types: fix incompatible issue for builtin functionstr_to_date#9693 cherry-pickeddate_addanddate_subdon't check datetime field overflow #9667 @qw4990 expression: fix issue thatdate_addanddate_subis incompatible with MySQL #9702 cherry-pickeddefault_week_formatdoesn't work #9669 @zyycj expression: fix week func format #9685 cherry-pickedunix_timestamp()-unix_timestamp(now())is wrong and not stable #9710 @qw4990 expression: fix issue that results ofunix_timestamp()-unix_timestamp(now())is wrong and not stable #9884 cherry-pickedselect now()-curdate()*1000000-curtime()is not stable #9711 @qw4990 expression: fix issue that results ofunix_timestamp()-unix_timestamp(now())is wrong and not stable #9884 cherry-pickeddaynameis incompatible with Mysql #9713 @qw4990 expression: fix issue that functiondaynameis incompatible with Mysql when doing arithmetic #9975 cherry-pickeddate_addanddate_subare incompatible with Mysql #9715 @b41sh types: refine the parsing logic of INTERVAL to correct DATE_ADD/DATE_SUB #9874 cherry-pickeddatetimeandintervalis not compatible with Mysql #9727 @erjiaqing expression: addition betweendatetimeandintervalis not compatible with Mysql #10329 cherry-pickeddayofmonthmonthquarterandyearare not compatible with Mysql #9728 @WangXiangUSTC types: extract month support 0 #10116 cherry-pickedunix_timestampis not compatible with Mysql #9729 @wjhuang2016 expression: fixunix_timestampfunction which is not compatible with Mysql #9751 WON'T FIXtimestampaddis not compatible with Mysql #9730 @qw4990 expression: fix issue thattimestampaddis not compatible with Mysql #10314 cherry-pickedlast_dayis not compatible with Mysql #9731 @wjhuang2016 expression: fix last_day function #9746 expression: fix last_day function #9750monthnameis not compatible with Mysql #9732 @qw4990 expression: fix issue thatmonthnameis not compatible with Mysql #10109 cherry-pickedMAKETIMEis not compatible with Mysql #9735 @AndrewDi expression: handle maketime unsigned hour overflow #10074 cherry-pickedPERIOD_ADDis not compatible with Mysql #9736 @qw4990 expression: check if period is valid inperiod_add#10380 cherry-pickedDATE/DATETIMEcomparison inBETWEENfunction #9764 @erjiaqing planner: fix wrongDATE/DATETIMEcomparison inBETWEENfunction #10313 cherry-pickedYEARstring is not compatible with Mysql #9767 @b41sh fix invalidYEARstring is not compatible with Mysql #9856 cherry-pickeddateerror #9769 @qw4990 expression: fixcast(-num as datetime)to return null instead of error #10368 cherry-pickeddecimaltodatetimeortimestampwhen insert is not compatible with MySQL #9770 @Debiancc types: fix converting decimal to datetime and timestamp #9899 cherry-pickedstr_to_dateis not compatible with MySQL #9773 @b41sh fixstr_to_datefunc compatible issues 9773 #9819 cherry-pickedTIME_FORMATis not compatible with MySQL #9774 @lzmhhh123 types: fixtime_formatis not compatible with MySQL. #9841 cherry-pickedset time_zoneis not compatible with MySQL #9775 @WangXiangUSTC sessionctx: add time zone check #9822 cherry-pickedunix_timestampis not compatible with MySQL #10051 WON'T FIXconvert_tzis not compatible with MySQL #9776 INVALIDdatetimeand realintervalis not compatible with Mysql #10346 @erjiaqing expression: addition betweendatetimeand realintervalis not compatible with Mysql #10347 cherry-pickedunix_timestampis not compatible with MySQL #10361 @qw4990 expression: fixcast(-num as datetime)to return null instead of error #10368 cherry-pickedmysql.Time. #9813 @winoros *: add_date can return mysql.Time #9830 cherry-pickedperiod_diffis not compatible with MySQL 8.0 #10382 @mantuliu expression: fix issue thatperiod_diffis not compatible with MySQL 8.0 #10383 cherry-pickeddatetimeis not compatible with MySQL #9763 @qw4990 expression: fix issue thatTimeIsNullis not compatible with MySQL #10753