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_big/

View File Name : bug37983.test

# The include statement below is a temp one for tests that are yet to
#be ported to run with InnoDB,
#but needs to be kept for tests that would need MyISAM in future.
--source include/force_myisam_default.inc

source suite.inc;
source include/have_ndb.inc;
result_format 2;

select version();

CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c3` text,
  PRIMARY KEY (`c1`) USING BTREE
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

## Load table...
disable_query_log;
let $i=1000;
while ($i)
{
  let $batch = 400; # Number of values to INSERT per batch
  let $separator = ;
  let $sql = INSERT t1 (c1, c3) VALUES;
  while($batch)
  {
    let $sql=$sql$separator($i*1000+$batch, REPEAT('ks87', 512*RAND()));
    dec $batch;
    let $separator = ,;
  }

  source run_query_with_retry.inc;

  dec $i;
}
enable_query_log;

## Check number of records in table..
let $count = `select count(*) from t1`;
if (!`select $count = 400000`)
{
  echo got: $count, expected: 400000;
  die  Wrong number of records loaded into table;
}
echo Table has $count number of records;

# Measure the time to run the query three times
source start_timer.inc;
# This is currently a very bad query for MySQL Cluster since
# each record has to be fetched into the mysql in order
# to see if it fulfills the where clause
select count(*) from t1 where length(c3) < 256;
select count(*) from t1 where length(c3) < 256;
select count(*) from t1 where length(c3) < 256;
source end_timer.inc;

drop table t1;

## Test suceeded
exit;