Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/ndb/t/

View File Name : ndb_fk_resources.test

-- source include/have_ndb.inc

--echo # bug#18082045 - TESTFK CREATEDROPWITHDATA NEED HIGH MAXNOOFCONCURRENTSCANS

create table t1 (
  a1 int not null,
  primary key using hash (a1)
) engine ndb;

create table t2 (
  a2 int not null,
  b2 int not null,
  primary key using hash (a2),
  key t2x1 (b2),
  -- cascade is not essential to demo the bug
  foreign key t2fk1 (b2) references t1 (a1) on delete cascade
) engine ndb;

# A full scan delete batch on t1 starts 64 parallel cascading scans
# on t2 each with (hardcoded) 4 fragment scans.  Our .cnf limits these
# to 64.  The 1024 rows here is more than enough to create such batches.

--disable_query_log
let $i=1024;
while ($i)
{
  eval insert into t1 values ($i);
  eval insert into t2 values ($i,$i);
  dec $i;
}
--enable_query_log

begin;
delete from t1;
rollback;
select count(*) from t1;
select count(*) from t2;

delete from t1;
select count(*) from t1;
select count(*) from t2;

# Using IN(...) we can create even more parallel cascading scans.
# This becomes a batch of PK deletes where triggers are executed
# at the end.

--disable_query_log
let $i=256;
let $s=0;
while ($i)
{
  eval insert into t1 values ($i);
  eval insert into t2 values ($i,$i);
  let $s=$s,$i;
  dec $i;
}
--enable_query_log

--eval begin; delete from t1 where a1 in ($s); rollback
select count(*) from t1;
select count(*) from t2;

--eval delete from t1 where a1 in ($s)
select count(*) from t1;
select count(*) from t2;

drop table t2, t1;