diff options
author | unknown <pem@mysql.comhem.se> | 2004-03-25 17:42:13 +0100 |
---|---|---|
committer | unknown <pem@mysql.comhem.se> | 2004-03-25 17:42:13 +0100 |
commit | df06466976e3d9e63ed8f95e5543578b7ec572ac (patch) | |
tree | b848643a5a893df72a10e6264bc0406b6c9ec236 /mysql-test/r/query_cache.result | |
parent | d8c5358115abb7134943a8ec9b1f2ec0fabcae26 (diff) | |
download | mariadb-git-df06466976e3d9e63ed8f95e5543578b7ec572ac.tar.gz |
Fixed BUG#3117: LAST_INSERT_ID() works incorrectly inside stored procedure.
This turned out to be a problem for prepared statements as well; the id was
evaluated once, at parse time.
mysql-test/r/auto_increment.result:
Updated results after bugfix in last_insert_id().
mysql-test/r/query_cache.result:
Updated results after bugfix in last_insert_id().
mysql-test/r/variables.result:
Updated results after bugfix in last_insert_id().
sql/item_func.cc:
Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
sql/item_func.h:
Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
sql/sql_yacc.yy:
Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
tests/client_test.c:
Test case for last_insert_id() in prepared statements.
Diffstat (limited to 'mysql-test/r/query_cache.result')
-rw-r--r-- | mysql-test/r/query_cache.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index 85bc50ef708..bbba7026b14 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -292,7 +292,7 @@ DATABASE() select ENCRYPT("test") from t1; ENCRYPT("test") select LAST_INSERT_ID() from t1; -last_insert_id() +LAST_INSERT_ID() select RAND() from t1; RAND() select UNIX_TIMESTAMP() from t1; |