← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/t/derived.test

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/t/derived.test
100
100
# Test for select if database is not selected.
101
101
#
102
102
# Connect without a database
 
103
create user mysqltest_1;
103
104
create table t1 select 1 as a;
104
105
analyze table t1; # PBXT: Required to get a consitent result
105
106
connect (con1,localhost,mysqltest_1,,*NO-ONE*,$MASTER_MYPORT,$MASTER_MYSOCK);
272
273
select t2.* from (select * from t1) as A inner join t2 on A.ID = t2.FID;
273
274
drop table t1, t2;
274
275
 
 
276
disconnect con1;
 
277
connection default;
 
278
drop user mysqltest_1;
 
279
 
275
280
# End of 4.1 tests