List:Bugs« Previous MessageNext Message »
From:L'ubomir Trebula Date:June 11 2002 1:50pm
Subject:SELECT @@IDENTITY; doesn't work
View as plain text  
Description:

Although manual at "F.2.15 (D.2.29 in current manual) Changes in release
3.23.25", line 4
claims: "Added @@IDENTITY as a synonym for LAST_INSERT_ID(). (This is for
Visual Basic compatibility.)",
"SELECT @@IDENTITY;" returns "ERROR 1064: You have an error in your SQL
syntax near '@IDENTITY' at line 1".

"SELECT version();" returns "3.23.38"


How-To-Repeat:
        SELECT @@IDENTITY;
>Category:      mysql
>Release:       mysql-3.23.38 (Official MySQL binary)

System: OSF1 dssalpha.datasystemsoft.sk V5.1 732 alpha
Machine: alpha
Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/cc
Compilation info: CC='cc -pthread'
 CFLAGS='-O4 -ansi_alias -ansi_args -fast -i\
nline speed -speculate all'  CXX='cxx -pthread'
 CXXFLAGS='-O4 -ansi_alias -fas\
t -inline speed -speculate all -noexceptions -nortti'  LDFLAGS=''
LIBC:
lrwxrwxrwx   1 root     system        17 Sep 18  2001 /lib/libc.a ->
../ccs/lib\
/libc.a
lrwxrwxrwx   1 root     system        17 Sep 18  2001 /usr/lib/libc.a ->
../ccs\
/lib/libc.a
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Offic\
ial MySQL
binary' --with-extra-charsets=complex --with-server-suffix= --with-pr\
efix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared
'--wit\
h-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared




Thread
SELECT @@IDENTITY; doesn't workL'ubomir Trebula11 Jun
  • RE: SELECT @@IDENTITY; doesn't workKaido Karner11 Jun
    • RE: SELECT @@IDENTITY; doesn't workMichael Widenius12 Jun
  • Re: SELECT @@IDENTITY; doesn't workSinisa Milivojevic11 Jun
RE: SELECT @@IDENTITY; doesn't workSinisa Milivojevic11 Jun