~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/odbc.result

  • Committer: Jay Pipes
  • Date: 2008-12-19 21:38:38 UTC
  • mto: This revision was merged to the branch mainline in revision 729.
  • Revision ID: jpipes@serialcoder-20081219213838-o8a3lwtxajisy3dm
Fixes odbc.test.  We don't support the SQL_NO_CACHE keyword

Show diffs side-by-side

added added

removed removed

Lines of Context:
16
16
drop table t1;
17
17
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY);
18
18
INSERT INTO t1 VALUES (NULL);
19
 
SELECT sql_no_cache a, last_insert_id() FROM t1 WHERE a IS NULL;
 
19
SELECT a, last_insert_id() FROM t1 WHERE a IS NULL;
20
20
a       last_insert_id()
21
21
1       1
22
 
SELECT sql_no_cache a, last_insert_id() FROM t1 WHERE a IS NULL;
 
22
SELECT a, last_insert_id() FROM t1 WHERE a IS NULL;
23
23
a       last_insert_id()
24
 
SELECT sql_no_cache a, last_insert_id() FROM t1;
 
24
SELECT a, last_insert_id() FROM t1;
25
25
a       last_insert_id()
26
26
1       1
27
27
DROP TABLE t1;