View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008513 | VCOMPONENT-VKERNEL | Join of Tables | public | 2019-04-25 08:47 | 2019-05-22 07:54 |
| Reporter | Sergey Pashkov | Assigned To | Ivan Smahin | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 9.1.x | ||||
| Target Version | 9.1.x | Fixed in Version | 9.1.x | ||
| Summary | 0008513: Ability to define any condition for JOIN | ||||
| Description | Try to execute the following: SELECT * FROM t1 JOIN t2 on t1.ID = t2.ID AND t1.f1 = t2.f1 11:45:48 Kernel error: 0x55000. Semantic error. This works: SELECT * FROM t1 join t2 on t1.ID = t2.ID AND t1.f1 <> t2.f1 Adding t1.f1 = t2.f1 to WHERE works. | ||||
| Additional Information | Will be very useful for MERGE command as there is no workaround for it https://valentina-db.com/de/discussion-forums/5709-updating-records-while-importing | ||||
| Tags | No tags attached. | ||||
| related to | 0008538 | resolved | Ivan Smahin | "MERGE...ON ...<multi-join-conditions>...WHEN NOT MATCHED" |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-04-25 08:47 | Sergey Pashkov | New Issue | |
| 2019-04-25 14:19 | Sergey Pashkov | Additional Information Updated | View Revisions |
| 2019-05-13 08:52 | Ivan Smahin | Assigned To | => Ivan Smahin |
| 2019-05-13 08:52 | Ivan Smahin | Status | new => resolved |
| 2019-05-13 08:52 | Ivan Smahin | Resolution | open => fixed |
| 2019-05-13 08:52 | Ivan Smahin | Fixed in Version | => 9.1.x |
| 2019-05-22 07:54 | Ivan Smahin | Relationship added | related to 0008538 |
