JOIN using OR and winerror translation
panagiotis.koutsourakis at monetdbsolutions.com
Tue Oct 22 15:57:38 CEST 2019
Could you please file a bug report at http://bugs.monetdb.org about the winerror translation? This does not seem like a high priority bug, but eventually someone will get around to it, if it is recorded in our bug tracker.
On 10/21/19 1:03 PM, Daniel Zvinca wrote:
> During a complex join between two tables that involve an OR operation, I
> received the following error message:
> !OS: The printer is out of paper.
> This corresponds to error number 28 in Windows OS, yet in errno.h, 28 is
> for ENOSPC, which is the expected one.
> In the meanwhile, I fixed that join, replacing the complex condition that
> included one OR into a UNION ALL (conditions made that possible),
> but I think it's worth investigating possible optimization that would do
> this internally (transforming join conditions using OR with plain UNION).
> Anyway, if above suggestion is just something to think about (as long as it
> always exists a solution in the hands of the SQL developer),
> the winerror translation certainly requires a review. (mutils.c / int
> winerror(int e));
> Thank you,
> developers-list mailing list
> developers-list at monetdb.org
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 833 bytes
Desc: OpenPGP digital signature
More information about the developers-list