Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-653

LP:827299 - NOW('2011-07-20 11:44:51') not working, crashing replication

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • None
    • None
    • None

    Description

      select NOW('2011-07-20 11:44:51'); gives an error in mariadb 5.3, but works on 5.2.7. Thus a slave with 5.3 connected to a 5.2 master crashes as soon as such an INSERT is in the binlog.

      5.3 beta:

      MariaDB [master]> select  @@version;select NOW('2011-07-20 11:44:51');
      +---------------------------------------+
      | @@version                             |
      +---------------------------------------+
      | 5.3.0-MariaDB-beta-mariadb101~squeeze |
      +---------------------------------------+
      1 row in set (0.00 sec)
       
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2011-07-20 11:44:51')' at line 1

      old 5.2.7 version:

      MariaDB [master]>  select  @@version;select NOW('2011-07-20 11:44:51');
      +--------------------------------------+
      | @@version                            |
      +--------------------------------------+
      | 5.2.7-MariaDB-mariadb101~squeeze-log |
      +--------------------------------------+
      1 row in set (0.00 sec)
       
      +----------------------------+
      | NOW('2011-07-20 11:44:51') |
      +----------------------------+
      | 2011-08-16 14:01:41        |
      +----------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [master]>

      Attachments

        Activity

          People

            serg Sergei Golubchik
            floyd floyd (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.