Closed fwheinz closed 2 years ago
In some cases, the order of the attributes gets mixed up on a right outer join. See this query:
pi City ({ Kdnr:number,Name:string,PC1:number 137, John, 31337 } right outer join PC1=PC2 { City:string,PC2:number Philadelphia,31338 })
The result is:
31338
If the projection is removed, one can see that some table columns are missing in the data, but not in the header of the table.
Fixed by f25be62
r-prem
commented
2 years ago
In some cases, the order of the attributes gets mixed up on a right outer join. See this query:
pi City ({ Kdnr:number,Name:string,PC1:number 137, John, 31337 } right outer join PC1=PC2 { City:string,PC2:number Philadelphia,31338 })
The result is:
City
31338
If the projection is removed, one can see that some table columns are missing in the data, but not in the header of the table.