View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004005||VALENTINA SERVER||SQL||public||2009-02-09 06:14||2009-02-19 14:20|
|Reporter||Danny Lewkin||Assigned To|
|Target Version||Fixed in Version||4.0|
|Summary||0004005: Update query makes server crash|
this query crashed the server:
UPDATE tbl_cells set objptr_managed_by = (SELECT Recid FROM tbl_typelistvalues WHERE listvalue = 1 AND objptr_typelist->typelistname = 'Information_Managed_by_List');
Now, I can understand that what I did will not work, but Vserver should NOT crash on this!
It should give error message...
And even so, It would maybe be nice it this could work, so if usable, this is also a feature request :-)
|Tags||No tags attached.|
I have tried this issue on latest db which I got from you.
With this query:
UPDATE tbl_cells set
(SELECT Recid FROM tbl_typelistvalues WHERE listvalue = 1 AND objptr_typelist->typelistname = 'Information_Managed_by_List');
It works - no crash.
So please send me the database for playing and any relevant info.