summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <sasha@mysql.sashanet.com>2001-09-10 17:30:29 -0600
committerunknown <sasha@mysql.sashanet.com>2001-09-10 17:30:29 -0600
commit8cfd4949c2725431d78605d30c1138c4d42ab4d2 (patch)
tree16ba4457be345a16fce35898ee96bb1c1248d0ef /mysql-test
parente7006ae7946f2fd0cf3ea30aeab7eb974e769a4d (diff)
downloadmariadb-git-8cfd4949c2725431d78605d30c1138c4d42ab4d2.tar.gz
fixed IDENTITY crisis
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/identity.result4
-rw-r--r--mysql-test/t/identity.test2
2 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/identity.result b/mysql-test/r/identity.result
new file mode 100644
index 00000000000..45968248d26
--- /dev/null
+++ b/mysql-test/r/identity.result
@@ -0,0 +1,4 @@
+last_insert_id(345)
+345
+@@IDENTITY last_insert_id()
+345 345
diff --git a/mysql-test/t/identity.test b/mysql-test/t/identity.test
new file mode 100644
index 00000000000..37183fd3b35
--- /dev/null
+++ b/mysql-test/t/identity.test
@@ -0,0 +1,2 @@
+select last_insert_id(345);
+select @@IDENTITY,last_insert_id();