Debian Codegraph @

mysql-test/suite/ndb/t/ndb_limit.test

raw
1 -- source include/have_ndb.inc
2
3 --disable_warnings
4 DROP TABLE IF EXISTS t2;
5 --enable_warnings
6
7
8 CREATE TABLE t2 (
9 a bigint unsigned NOT NULL PRIMARY KEY,
10 b int unsigned not null,
11 c int unsigned
12 ) engine=ndbcluster;
13
14
15 #
16 # insert records into table
17 #
18 let $1=1000;
19 disable_query_log;
20 while ($1)
21 {
22 eval insert into t2 values($1*10, $1+9, 5*$1), ($1*10+1, $1+10, 7),($1*10+2, $1+10, 7*$1), ($1*10+3, $1+10, 10+$1), ($1*10+4, $1+10, 70*$1), ($1*10+5, $1+10, 7), ($1*10+6, $1+10, 9), ($1*10+7, $1+299, 899), ($1*10+8, $1+10, 12), ($1*10+9, $1+10, 14*$1);
23 dec $1;
24 }
25 enable_query_log;
26
27 select count(*) from t2;
28
29 delete from t2 limit 1;
30 select count(*) from t2;
31
32 delete from t2 limit 100;
33 select count(*) from t2;
34
35 delete from t2 limit 1000;
36 select count(*) from t2;
37
38 update t2 set c=12345678 limit 100;
39 select count(*) from t2 where c=12345678;
40 select count(*) from t2 where c=12345678 limit 1000;
41
42 select * from t2 limit 0;
43
44 drop table t2;
45
46 CREATE TABLE `t2` (
47 `views` int(11) NOT NULL default '0',
48 `clicks` int(11) NOT NULL default '0',
49 `day` date NOT NULL,
50 `hour` tinyint(4) NOT NULL default '0',
51 `bannerid` smallint(6) NOT NULL default '0',
52 `zoneid` smallint(6) NOT NULL default '0',
53 `source` varchar(50) NOT NULL default '',
54 PRIMARY KEY (`day`,`hour`,`bannerid`,`zoneid`,`source`),
55 KEY `bannerid_day` (`bannerid`,`day`),
56 KEY `zoneid` (`zoneid`)
57 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
58
59 INSERT INTO `t2` VALUES
60 ( 1,0,'2004-09-17', 5,100,100,''),
61 ( 1,0,'2004-09-18', 7,100,100,''),
62 ( 17,0,'2004-09-27',20,132,100,''),
63 ( 4,0,'2004-09-16',23,132,100,''),
64 ( 86,0,'2004-09-18', 7,196,196,''),
65 ( 11,0,'2004-09-16',16,132,100,''),
66 (140,0,'2004-09-18', 0,100,164,''),
67 ( 2,0,'2004-09-17', 7,132,100,''),
68 (846,0,'2004-09-27',11,132,164,''),
69 ( 1,0,'2004-09-18', 8,132,100,''),
70 ( 22,0,'2004-09-27', 9,164,132,''),
71 (711,0,'2004-09-27', 9,100,164,''),
72 ( 11,0,'2004-09-18', 0,196,132,''),
73 ( 41,0,'2004-09-27',15,196,132,''),
74 ( 57,0,'2004-09-18', 2,164,196,'');
75
76 SELECT DATE_FORMAT(day, '%Y%m%d') as date, DATE_FORMAT(day, '%d-%m-%Y')
77 as date_formatted FROM t2 GROUP BY day ORDER BY day DESC;
78
79 SELECT DATE_FORMAT(day, '%Y%m%d') as date, DATE_FORMAT(day, '%d-%m-%Y')
80 as date_formatted FROM t2 GROUP BY day ORDER BY day DESC LIMIT 2;
81
82 drop table t2;
83
84 # End of 4.1 tests