View Issue Details

IDProjectCategoryView StatusLast Update
0008744VALENTINA SERVERSQLpublic2020-03-05 11:27
ReporterBeatrix Willius Assigned ToIvan Smahin  
Status resolvedResolutionfixed 
Fixed in Version10.0.x 
Summary0008744: Hard crash when doing SQL with 2 unions
DescriptionThe following SQL makes a hard crash in Valentina Studio:

((select RecID, MailboxPath as FinalPath, WhereClause, PathSort(MailboxPathNatSort), '' as usernamefinal from mailbox where username = 'sa')
(select recid, UsernameAndMailboxPath as FinalPath, WhereClause, PathSort(MailboxPathNatSort), username as usernamefinal from mailbox where username in ('testuser', 'default user')))
(select * from mailbox)
order by usernamefinal, 4

See attached database and crash log.
TagsNo tags attached.


Beatrix Willius

Beatrix Willius

2020-03-04 06:22


Mail (136,779 bytes)
valentina.rtf (97,316 bytes)

Issue History

Date Modified Username Field Change
2020-03-04 06:22 Beatrix Willius New Issue
2020-03-04 06:22 Beatrix Willius File Added: Mail
2020-03-04 06:22 Beatrix Willius File Added: valentina.rtf
2020-03-05 11:27 Ivan Smahin Assigned To => Ivan Smahin
2020-03-05 11:27 Ivan Smahin Status new => resolved
2020-03-05 11:27 Ivan Smahin Resolution open => fixed
2020-03-05 11:27 Ivan Smahin Fixed in Version => 10.0.x