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

Inserted values were corrupt while using InnoDB storage engine on arm architecture

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5.51
    • N/A
    • Arm-marvell.
      $ uname -a
      Linux NASDE8472 3.4.6 #1 Thu Sep 8 11:01:50 CST 2016 armv5tel unknown
      $ gcc --version
      gcc (GCC) 4.1.3 20070929 (prerelease) (Ubuntu 4.1.2-16ubuntu2)

    Description

      I was using InnoDB on arm marvell environment.
      The compilation was successful.
      However, when I inserted data into an InnoDB based table, the values were corrupted.

      Here's the snippet of my toolchain file:
      SET(STACK_DIRECTION 1)

      And here are my reproduce steps:
      1. Create an InnoDB based database 'test1'.
      2. Create table 'foo':

      create table foo (
      Id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
      URL TEXT CHARACTER SET 'utf8', 
      type INT, 
      name VARCHAR (255), 
      LastUpdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
      

      3. Insert data:

      insert into foo (URL, type, name) values ('google.com', 1, 'noname');
      

      4. Select data from table 'foo':

      select * from foo \G
      

      The data shown in the console was garbled text, please refer to the attached snapshot.
      The collation of the database is utf8_general_ci.
      The attached db.tgz is the file of the database and table.

      Is there any incorrect variable in my toolchain file? Or does InnoDB cannot work well on arm-marvell environment?

      Attachments

        1. garbled_text.jpg
          garbled_text.jpg
          32 kB
        2. db.tgz
          1 kB
        3. data.tgz
          638 kB
        4. result.txt
          23 kB

        Activity

          People

            marko Marko Mäkelä
            Dorothy Tsai Dorothy Tsai
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.