diff options
| author | unknown <sanja@montyprogram.com> | 2013-01-22 13:29:59 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2013-01-22 13:29:59 +0200 |
| commit | 82e39cb1e1637794cc3f7c5049d2d20ce5a32576 (patch) | |
| tree | 01d95de6dea10214403faf03db10b6dd8873714e /mysql-test/t | |
| parent | 193c6f548b3702b4259560c40ca24c1243053388 (diff) | |
| download | mariadb-git-82e39cb1e1637794cc3f7c5049d2d20ce5a32576.tar.gz | |
Fixed typo in the function name.
test suite added.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_misc.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index 1f221ce9878..292db69a6e3 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -348,6 +348,25 @@ SELECT 1 from t1 HAVING NAME_CONST('', a); DROP TABLE t1; +--echo # +--echo # Test or correct maybe_null of last_value +--echo # +CREATE TABLE t1 (a char(2) not null ); +INSERT INTO t1 VALUES (4),(7),(1); +set @optimizer_switch_save= @@optimizer_switch; +set optimizer_switch='materialization=off'; +CREATE TABLE tv (e char(2) not null ) engine=mysql; +INSERT INTO tv VALUES (1); +CREATE ALGORITHM=MERGE VIEW v_merge AS SELECT * FROM tv; +CREATE ALGORITHM=MERGE VIEW vm AS SELECT * FROM tv; +explain extended +select a from t1 left join v_merge on (a=e) where last_value(NULL,e) not in (select last_value(NULL,e) from vm); +explain extended +select a from t1 left join v_merge on (a=e) where e not in (select last_value(NULL,e) from vm); +set optimizer_switch=@optimizer_switch_save; +drop view v_merge, vm; +drop table t1,tv; + --echo # --echo # End of 5.5 tests |