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 |