diff options
author | Georgi Kodinov <joro@sun.com> | 2009-08-31 17:08:10 +0300 |
---|---|---|
committer | Georgi Kodinov <joro@sun.com> | 2009-08-31 17:08:10 +0300 |
commit | 0366cbd56397231b6e935d4e92329d78b02523fd (patch) | |
tree | a293b462af55e0e746e490ba216fcbd1c526432e | |
parent | 8ca8f70daacc1853528b40ccf4f7f3f122c88a65 (diff) | |
parent | 56d903a9a3240ef392d9e4f9adb4f4719e8b3456 (diff) | |
download | mariadb-git-0366cbd56397231b6e935d4e92329d78b02523fd.tar.gz |
merge 5.0-main -> 5.0-bugteam
-rw-r--r-- | man/Makefile.am | 4 | ||||
-rw-r--r-- | mysql-test/r/view.result | 111 | ||||
-rw-r--r-- | mysql-test/t/view.test | 32 |
3 files changed, 2 insertions, 145 deletions
diff --git a/man/Makefile.am b/man/Makefile.am index d37ef81285b..7fdfc297f96 100644 --- a/man/Makefile.am +++ b/man/Makefile.am @@ -24,8 +24,8 @@ EXTRA_DIST = $(man1_MANS) $(man8_MANS) # 1) not needed in Unix binary packages, # 2) programs not generated in 5.0: install-data-hook: - rm -f $(DESTDIR)$(manlibdir)/man1/make_win_* - rm -f $(DESTDIR)$(manlibdir)/man1/ndb_print_* + rm -f $(DESTDIR)$(mandir)/man1/make_win_* + rm -f $(DESTDIR)$(mandir)/man1/ndb_print_* # Don't update the files from bitkeeper %::SCCS/s.% diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 48bcfbf7975..715fb225550 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3704,117 +3704,6 @@ SELECT * FROM v1 IGNORE INDEX (c2) WHERE c2=2; ERROR HY000: Key 'c2' doesn't exist in table 'v1' DROP VIEW v1; DROP TABLE t1; -# -# Bug #45806 crash when replacing into a view with a join! -# -CREATE TABLE t1(a INT UNIQUE); -CREATE VIEW v1 AS SELECT t1.a FROM t1, t1 AS a; -INSERT INTO t1 VALUES (1), (2); -REPLACE INTO v1(a) SELECT 1 FROM t1,t1 AS c; -SELECT * FROM v1; -a -1 -2 -1 -2 -REPLACE INTO v1(a) SELECT 3 FROM t1,t1 AS c; -SELECT * FROM v1; -a -1 -2 -3 -1 -2 -3 -1 -2 -3 -DELETE FROM t1 WHERE a=3; -INSERT INTO v1(a) SELECT 1 FROM t1,t1 AS c -ON DUPLICATE KEY UPDATE `v1`.`a`= 1; -SELECT * FROM v1; -a -1 -2 -1 -2 -CREATE VIEW v2 AS SELECT t1.a FROM t1, v1 AS a; -REPLACE INTO v2(a) SELECT 1 FROM t1,t1 AS c; -SELECT * FROM v2; -a -1 -2 -1 -2 -1 -2 -1 -2 -REPLACE INTO v2(a) SELECT 3 FROM t1,t1 AS c; -SELECT * FROM v2; -a -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -INSERT INTO v2(a) SELECT 1 FROM t1,t1 AS c -ON DUPLICATE KEY UPDATE `v2`.`a`= 1; -SELECT * FROM v2; -a -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -1 -2 -3 -DROP VIEW v1; -DROP VIEW v2; -DROP TABLE t1; -# -- End of test case for Bug#45806 # ----------------------------------------------------------------- # -- Bug#40825: Error 1356 while selecting from a view # -- with a "HAVING" clause though query works diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 5a4a7543a14..6f03ff12448 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3680,38 +3680,6 @@ SELECT * FROM v1 IGNORE INDEX (c2) WHERE c2=2; DROP VIEW v1; DROP TABLE t1; ---echo # ---echo # Bug #45806 crash when replacing into a view with a join! ---echo # -CREATE TABLE t1(a INT UNIQUE); -CREATE VIEW v1 AS SELECT t1.a FROM t1, t1 AS a; -INSERT INTO t1 VALUES (1), (2); - -REPLACE INTO v1(a) SELECT 1 FROM t1,t1 AS c; -SELECT * FROM v1; -REPLACE INTO v1(a) SELECT 3 FROM t1,t1 AS c; -SELECT * FROM v1; -DELETE FROM t1 WHERE a=3; -INSERT INTO v1(a) SELECT 1 FROM t1,t1 AS c -ON DUPLICATE KEY UPDATE `v1`.`a`= 1; -SELECT * FROM v1; - -CREATE VIEW v2 AS SELECT t1.a FROM t1, v1 AS a; - -REPLACE INTO v2(a) SELECT 1 FROM t1,t1 AS c; -SELECT * FROM v2; -REPLACE INTO v2(a) SELECT 3 FROM t1,t1 AS c; -SELECT * FROM v2; -INSERT INTO v2(a) SELECT 1 FROM t1,t1 AS c -ON DUPLICATE KEY UPDATE `v2`.`a`= 1; -SELECT * FROM v2; - -DROP VIEW v1; -DROP VIEW v2; -DROP TABLE t1; - ---echo # -- End of test case for Bug#45806 - --echo # ----------------------------------------------------------------- --echo # -- Bug#40825: Error 1356 while selecting from a view --echo # -- with a "HAVING" clause though query works |