← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select.test

Merged Eric from lp:~eday/drizzle/eday-merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/select.test
2320
2320
# 1. has integer type, 
2321
2321
# 2. can be used with the "@@name" syntax
2322
2322
# 3. available in every server build
2323
 
INSERT INTO t1 VALUES(@@connect_timeout);
2324
 
INSERT INTO t2 VALUES(@@connect_timeout);
 
2323
INSERT INTO t1 VALUES(@@server_id);
 
2324
INSERT INTO t2 VALUES(@@server_id);
2325
2325
 
2326
2326
# We only need to ensure 1 row is returned to validate the results
2327
2327
--replace_column 1 X 2 X
2328
 
SELECT * FROM t1 JOIN t2 ON t1.c0 = t2.c0 WHERE (t1.c0 <=> @@connect_timeout);
 
2328
SELECT * FROM t1 JOIN t2 ON t1.c0 = t2.c0 WHERE (t1.c0 <=> @@server_id);
2329
2329
 
2330
2330
DROP TABLE t1, t2;
2331
2331