← Back to branch summary

~maria-captains/maria/mysql-6.0-backup

« back to all changes in this revision

Viewing changes to mysql-test/t/having.test

  • Committer: Thava Alagu
  • Date: 2010-03-11 19:18:17 UTC
  • mfrom: (3719.14.62 mysql-6.0-codebase)
  • Revision ID: thavamuni.alagu@sun.com-20100311191817-5nigmq884xo9fuut
Merge from mysql-6.0-codebase

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/having.test
442
442
SELECT b, COUNT(DISTINCT a) FROM t1 GROUP BY b HAVING b is NULL;
443
443
DROP TABLE t1;
444
444
 
 
445
 
 
446
--echo #
 
447
--echo # Bug#50995 Having clause on subquery result produces incorrect results.
 
448
--echo #
 
449
 
 
450
CREATE TABLE t1
 
451
(
 
452
 id1 INT,
 
453
 id2 INT NOT NULL,
 
454
 INDEX id1(id2)
 
455
);
 
456
 
 
457
INSERT INTO t1 SET id1=1, id2=1;
 
458
INSERT INTO t1 SET id1=2, id2=1;
 
459
INSERT INTO t1 SET id1=3, id2=1;
 
460
 
 
461
SELECT t1.id1,
 
462
(SELECT 0 FROM DUAL
 
463
 WHERE t1.id1=t1.id1) AS amount FROM t1
 
464
WHERE t1.id2 = 1
 
465
HAVING amount > 0
 
466
ORDER BY t1.id1;
 
467
 
 
468
DROP TABLE t1;
 
469
 
 
470
 
445
471
--echo End of 5.0 tests
446
472
 
447
473
--echo #