~ubuntu-branches/ubuntu/utopic/mariadb-5.5/utopic-security

« back to all changes in this revision

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

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

Show diffs side-by-side

added

removed

mysql-test/t/information_schema2.test

7

7

select variable_name from information_schema.session_variables where variable_name =

8

8

(select variable_name from information_schema.session_variables where variable_name = 'basedir');

9

9

 

 

10

#

 

11

# information_schema tables inside subqueries, they should not be re-populated

 

12

# (i_s.columns needs to scan i_s itself, creating a tmp table for every i_s

 

13

# table. if it's re-populated, it'll do that multiple times)

 

14

#

 

15

create table t1 (a char);

 

16

insert t1 values ('a'),('t'),('z');

 

17

flush status;

 

18

select a, exists (select 1 from information_schema.columns where table_schema=concat('tes',a)) from t1;

 

19

# fix the result in ps-protocol

 

20

--replace_result 39 38

 

21

show status like 'created_tmp_tables';

 

22

drop table t1;

• Older »

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