Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-63

Transaction does not get committed by the "commit" command after selecting the unix_timestamp() function

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.0.0
    • ExeMgr
    • None

    Description

      Build tested:

      getcalpontsoftwareinfo Fri May 20 13:28:21 2016

      Name : infinidb-platform Relocations: (not relocatable)
      Version : 5.0 Vendor: MariaDB, Inc.
      Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
      Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder

      This issue is uncovered by the DMLRate test in Autopilot.

      set autocommit=0;
      select unix_timestamp();
      insert into lineitem values(700000000,10000,1000,1,10,950.50,0.03,0.02,'N','O','1999-01-01','1999-01-01','1999-01-01','DELIVER IN PERSON','TRUCK','test test test test test');
      select unix_timestamp();
      commit;

      The commit command does not commit the transaction. Another query session did not see the inserted row and the table lock remained in place.

      If the "select unix_timestamp();" after insert is omitted, then the transaction worked as expected.

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.