View Issue Details

IDProjectCategoryView StatusLast Update
0004005VALENTINA SERVERSQLpublic2009-02-19 14:20
ReporterDanny LewkinAssigned To 
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version4.0 
Target VersionFixed in Version4.0 
Summary0004005: Update query makes server crash
DescriptionHi,

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 :-)
TagsNo tags attached.

Activities

Ivan Smahin

Ivan Smahin

2009-02-09 06:28

manager   ~0004259

I have tried this issue on latest db which I got from you.

With this query:
UPDATE tbl_cells set
objptr_cell_managed_by =
(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.

Issue History

Date Modified Username Field Change
2009-02-09 06:14 Danny Lewkin New Issue
2009-02-09 06:28 Ivan Smahin Note Added: 0004259
2009-02-19 14:19 Ivan Smahin Status new => closed
2009-02-19 14:20 Ivan Smahin Resolution open => fixed
2009-02-19 14:20 Ivan Smahin Fixed in Version => 4.0