'Jean-Michel OLTRA' wrote: > > Le mardi 17 f�vrier 2004, Zabach, Elke a �crit... > > bonjour, > > > > http://lists.mysql.com/maxdb/19753 > > They are implemented, but not tested and containing many bugs. > > 7.5.1 is recommended. > > Hmmm ! instance crashes at early tries... > > For now I tried some insert using this dbfunction: > > INSERT INTO TABLENAME > VALUES > ((SELECT FUNC_IDSOCIETE ('val1', 'val2') FROM DUAL), other values...) > > and error message is: 'unknown table name'. > > The function compute correct key, and if I retreive the key with: > SELECT FUNC_IDSOCIETE ('val1', 'val2') FROM DUAL > and then insert the computed key, it works. > > -- > jm >
Thank you for reporting. This bug will be fixed in version 7.5.01. Unfortunately there is no workaround which will allow you to specify a user-defined-function in an insert with the current version. Elke SAP Labs Berlin > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
