~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where `t2`.`a` in (select `v1`.`a` AS `a` from `v1`) latin1 latin1_swedish_ci

720

v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where `t2`.`a` in (select `v1`.`a` from `v1`) latin1 latin1_swedish_ci

721

drop view v2, v1;

722

drop table t1, t2;

723

CREATE VIEW `v 1` AS select 5 AS `5`;

840

Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment

841

t1 MyISAM 10 Fixed 0 0 0 # 1024 0 NULL # # NULL latin1_swedish_ci NULL

842

v1 NULL NULL NULL NULL NULL NULL # NULL NULL NULL # # NULL NULL NULL NULL View 'test.v1' references invalid table(s) or column(s) or function(s) or define

843

Warnings:

844

Warning 1356 View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

843

845

drop view v1;

844

846

drop table t1;

845

847

create view v1 as select 99999999999999999999999999999999999999999999999999999 as col1;

2982

2984

Level Code Message

2983

2985

SHOW CREATE VIEW v1;

2984

2986

View Create View character_set_client collation_connection

2985

v1 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`pk` AS `pk` from (`t1` join `t2` on(((`t2`.`fk` = `t1`.`pk`) and (`t2`.`ver` = (select max(`t`.`ver`) AS `MAX(t.ver)` from `t2` `t` where (`t`.`org` = `t2`.`org`)))))) latin1 latin1_swedish_ci

2987

v1 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`pk` AS `pk` from (`t1` join `t2` on(((`t2`.`fk` = `t1`.`pk`) and (`t2`.`ver` = (select max(`t`.`ver`) from `t2` `t` where (`t`.`org` = `t2`.`org`)))))) latin1 latin1_swedish_ci

2986

2988

DROP VIEW v1;

2987

2989

DROP TABLE t1, t2;

2988

2990

DROP FUNCTION IF EXISTS f1;

3844

3846

ALTER TABLE v1;

3845

3847

DROP VIEW v1;

3846

3848

DROP TABLE t1;

3849

3850

# Bug#48449: hang on show create view after upgrading when

3851

# view contains function of view

3852

3853

DROP VIEW IF EXISTS v1,v2;

3854

DROP TABLE IF EXISTS t1,t2;

3855

DROP FUNCTION IF EXISTS f1;

3856

CREATE TABLE t1 (a INT);

3857

CREATE TABLE t2 (a INT);

3858

CREATE FUNCTION f1() RETURNS INT

3859

BEGIN

3860

SELECT a FROM v2 INTO @a;

3861

RETURN @a;

3862

END//

3863

# Trigger pre-locking when opening v2.

3864

CREATE VIEW v1 AS SELECT f1() FROM t1;

3865

SHOW CREATE VIEW v1;

3866

View Create View character_set_client collation_connection

3867

v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `f1`() AS `f1()` from `t1` latin1 latin1_swedish_ci

3868

Warnings:

3869

Note 1599 View `test`.`v2` has no creation context

3870

DROP VIEW v1,v2;

3871

DROP TABLE t1,t2;

3872

DROP FUNCTION f1;

3873

CREATE TABLE t1(f1 INT);

3874

INSERT INTO t1 VALUES ();

3875

CREATE VIEW v1 AS SELECT 1 FROM t1 WHERE

3876

ROW(1,1) >= ROW(1, (SELECT 1 FROM t1 WHERE f1 >= ANY ( SELECT '1' )));

3877

DROP VIEW v1;

3878

DROP TABLE t1;

3879

3880

# Bug#52120 create view cause Assertion failed: 0, file .\item_subselect.cc, line 817

3881

3882

CREATE TABLE t1 (a CHAR(1) CHARSET latin1, b CHAR(1) CHARSET utf8);

3883

CREATE VIEW v1 AS SELECT 1 from t1

3884

WHERE t1.b <=> (SELECT a FROM t1 WHERE a < SOME(SELECT '1'));

3885

DROP VIEW v1;

3886

DROP TABLE t1;

3887

3888

# Bug#57703 create view cause Assertion failed: 0, file .\item_subselect.cc, line 846

3889

3890

CREATE TABLE t1(a int);

3891

CREATE VIEW v1 AS SELECT 1 FROM t1 GROUP BY

3892

SUBSTRING(1 FROM (SELECT 3 FROM t1 WHERE a >= ANY(SELECT 1)));

3893

DROP VIEW v1;

3894

DROP TABLE t1;

3895

3896

# Bug#57352 valgrind warnings when creating view

3897

3898

CREATE VIEW v1 AS SELECT 1 IN (1 LIKE 2,0) AS f;

3899

DROP VIEW v1;

3900

3901

# Bug 11829681 - 60295: ERROR 1356 ON VIEW THAT EXECUTES FINE AS A QUERY

3902

3903

CREATE TABLE t1 (a INT);

3904

CREATE VIEW v1 AS SELECT s.* FROM t1 s, t1 b HAVING a;

3905

SELECT * FROM v1;

3906

3907

DROP VIEW v1;

3908

DROP TABLE t1;

3847

3909

# -----------------------------------------------------------------

3848

3910

# -- End of 5.1 tests.

3849

3911

# -----------------------------------------------------------------

Older »