JOIN using OR and winerror translation

Panagiotis Koutsourakis panagiotis.koutsourakis at monetdbsolutions.com
Tue Oct 22 15:57:38 CEST 2019


Hi Dan,

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.

Best regards,
Panos.

On 10/21/19 1:03 PM, Daniel Zvinca wrote:
> Hello,
> 
> 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,
> Dan
> 
> 
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/developers-list
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20191022/81f64d9d/attachment.sig>


More information about the developers-list mailing list