DEFAULT USER 2007-05-30 - By Luca Calderano
Back
Using Maxdb I've found a strange error
I've defined a table this way:
CREATE TABLE FOO(
ID Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
NOTES Varchar (255) ASCII NOT NULL,
USERID Varchar (32) ASCII NOT NULL DEFAULT USER
)
I've defined 20 USERS which in order to insert records in the table above
defined have to exec the folowing stored procedure:
CREATE DBPROC "GestionePratiche"."spFOO_INS" ( IN @(protected) Fixed (10,0) ,
IN @(protected) varchar(32)
) AS
INSERT INTO FOO ( ID,
NOTES)
VALUES ( :@(protected), :@(protected));
//
here comes the error:
doesn't matter which user executes the stored, but the username recorded in
the table is the one of the first user who has logged in the database
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
