View Issue Details

IDProjectCategoryView StatusLast Update
0008744VALENTINA SERVERSQLpublic2020-03-05 11:27
ReporterBeatrix WilliusAssigned ToIvan Smahin 
PriorityhighSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed 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')
union
(select recid, UsernameAndMailboxPath as FinalPath, WhereClause, PathSort(MailboxPathNatSort), username as usernamefinal from mailbox where username in ('testuser', 'default user')))
UNION
(select * from mailbox)
order by usernamefinal, 4

See attached database and crash log.
TagsNo tags attached.

Activities

Beatrix Willius

Beatrix Willius

2020-03-04 06:22

reporter  

Mail Archive.vdb.zip (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 Archive.vdb.zip
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