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

vcol.not_supported, vcol.vcol_keys_innodb failed with timeout in buildbot

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0
    • Component/s: Tests
    • Labels:
      None

      Description

      Logs are not available

      10.0	44554d611194e2ac02e5beaf4b88ffe5	kvm-deb-trusty-amd64	2016-04-26 16:02:19	2704	nm	Normal run, no --ps-protocol	vcol.not_supported		timeout after 900 seconds
      vcol.not_supported                       w3 [ fail ]  timeout after 900 seconds
              Test ended at 2016-04-26 13:54:07
       
      Test case timeout after 900 seconds
       
      == /run/shm/var/3/log/not_supported.log == 
      select * from t8;
      a	b	v
      1234567890	2	2009-02-14 09:31:30
      set time_zone='+1:00';
      select * from t1;
      a	b	v
      1	2	0.3333333333333333333
      select * from t5;
      a	b	v
      20141010	2	octubre
      select * from t6;
      a	b	v
      20141010	2	viernes
      select * from t7;
      a	b	v
      20141010	2	viernes vie octubre oct
      select * from t8;
      a	b	v
      1234567890	2	2009-02-14 09:31:30
      flush tables;
       
       == /run/shm/var/3/tmp/analyze-timeout-mysqld.1.err ==
      

      vcol.vcol_keys_innodb 'xtradb'           w4 [ fail ]  timeout after 9000 seconds
              Test ended at 2016-04-26 20:49:41
       
      Test case timeout after 9000 seconds
       
      == /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/4/log/vcol_keys_innodb.log == 
      # Rejected FK options.
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on update set null);
      ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on update cascade);
      ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
      create table t1 (a int, b int as (a+1) persistent,
      foreign key (b) references t2(a) on delete set null);
      ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
      create table t1 (a int, b int as (a+1) persistent);
      alter table t1 add foreign key (b) references t2(a) on update set null;
      ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
      alter table t1 add foreign key (b) references t2(a) on update cascade;
      ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
      alter table t1 add foreign key (b) references t2(a) on delete set null;
      ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
      drop table t1;
      create table t1 (a int, b int as (a+1),
      foreign key (b) references t2(a));
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: