View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008744 | VALENTINA SERVER | SQL | public | 2020-03-04 06:22 | 2020-03-05 11:27 |
| Reporter | Beatrix Willius | Assigned To | Ivan Smahin | ||
| Priority | high | Severity | crash | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 10.0.x | ||||
| Summary | 0008744: Hard crash when doing SQL with 2 unions | ||||
| Description | The 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. | ||||
| Tags | No tags attached. | ||||
| 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 |
