~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/count_distinct3.test

• browse files at revision 150
• compare with another revision
• download diff
• download tarball
• view history from revision 150

• reverse the comparison (150 to 511.2.1)
• stop comparing with revision 511.2.1

Show diffs side-by-side

added

removed

tests/t/count_distinct3.test

1

 

#

2

 

# this is a test for error 1032 in count(distinct) + group by, introduced in 

3

 

# mysql-4.1

4

 

#

5

 

 

6

 

--disable_warnings

7

 

DROP TABLE IF EXISTS t1, t2;

8

 

--enable_warnings

9

 

 

10

 

CREATE TABLE t1 (id INTEGER, grp int, id_rev INTEGER);

11

 

 

12

 

--disable_query_log

13

 

SET @rnd_max= 2147483647;

14

 

let $1 = 1000;

15

 

while ($1)

16

 

{

17

 

  SET @rnd= RAND();

18

 

  SET @id = @rnd * @rnd_max;

19

 

  SET @id_rev= @rnd_max - @id;

20

 

  SET @grp= 127.0 * @rnd;

21

 

  INSERT INTO t1 (id, grp, id_rev) VALUES (@id, @grp, @id_rev); 

22

 

  dec $1;

23

 

}

24

 

set @@read_buffer_size=2*1024*1024;

25

 

CREATE TABLE t2 SELECT * FROM t1;

26

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

27

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

28

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

29

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

30

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

31

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

32

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

33

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

34

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

35

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

36

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

37

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

38

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

39

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

40

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

41

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

42

 

INSERT INTO t1 (id, grp, id_rev) SELECT id, grp, id_rev FROM t2;

43

 

INSERT INTO t2 (id, grp, id_rev) SELECT id, grp, id_rev FROM t1;

44

 

DROP TABLE t2;

45

 

--enable_query_log

46

 

 

47

 

SELECT COUNT(*) FROM t1;

48

 

 

49

 

# As t1 contains random numbers, results are different from test to test. 

50

 

# That's okay, because we test only that select doesn't yield an

51

 

# error. Note, that --disable_result_log doesn't suppress error output.

52

 

 

53

 

--disable_result_log

54

 

SELECT COUNT(DISTINCT id) FROM t1 GROUP BY grp;

55

 

--enable_result_log

56

 

DROP TABLE t1;

57

 

 

58

 

set @@read_buffer_size=default;

59

 

 

60

 

# End of 4.1 tests

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1