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
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@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list
participants (2)
-
Daniel Zvinca
-
Panagiotis Koutsourakis