← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/odbc.result

  • Committer: Brian Aker
  • Date: 2010-12-08 22:35:56 UTC
  • mfrom: (1819.9.158 update-innobase)
  • Revision ID: brian@tangent.org-20101208223556-37mi4omqg7lkjzf3
Merge in Stewart's changes, 1.3 changes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/odbc.result
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;