Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Similar queries return different results with different orderings of the where clause #7048

Closed
algotr34 opened this issue Nov 24, 2023 · 7 comments
Closed

Similar queries return different results with different orderings of the where clause #7048

algotr34 opened this issue Nov 24, 2023 · 7 comments
Labels
analyzer bug Something isn't working correctness We don't return the same result as MySQL customer issue

Comments

@algotr34
Copy link

algotr34 commented Nov 24, 2023 •
edited
Loading

Is dolt running mysql or just an emulated mysql? because I get strange behavior from dolt sometimes, on very simple queries.

I am running these sample queries against the database at https://www.dolthub.com/repositories/post-no-preference/stocks

The test queries are:

  1. SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>"2023-11-01" AND o.act_symbol='ACHR';
  2. SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE o.date>"2023-11-01" AND o.act_symbol='ACHR' AND LENGTH(o.act_symbol)<5;
  3. SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE LENGTH(act_symbol)<5 AND date>"2023-11-01" AND act_symbol='ACHR';
  4. SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE date>"2023-11-01" AND act_symbol='ACHR' AND LENGTH(act_symbol)<5;

Please notice that these 4 queries are actually the same query. And they all should return data!

  • Query 1 and 2 are using "o" table alias, and the only difference between them is the position of the checks inside the WHERE clause.
  • Query 3 and 4 arent using table alias, and the only difference between them is the position of the checks inside the WHERE clause.

Now, when I run these queries through dbeaver (after loading the server by running: dolt sql-server), i get the following results:

  1. I get results !
  2. 0 results
  3. 0 results
  4. 0 results

Wtf?
When i try dolt sql -q "(query)", even the first query is getting stuck, and eventually returns no data.
Huh?

I'm guessing that its not a mysql bug... but you will be able to tell me...
@timsehn timsehn added bug Something isn't working analyzer correctness We don't return the same result as MySQL labels Nov 24, 2023
@timsehn
Copy link
Contributor

timsehn commented Nov 24, 2023

It's emulated MySQL.

We will look into this Monday.

@timsehn timsehn changed the title Strange behavior of the mysql of dolt Similar queries return different results with different orderings of the where clause Nov 27, 2023
@timsehn
Copy link
Contributor

timsehn commented Nov 27, 2023 •
edited
Loading

I am unable to repro if I change the double quotes to single quotes:

$ dolt clone post-no-preference/stocks
cloning https://doltremoteapi.dolthub.com/post-no-preference/stocks
$ cd stocks 
$ dolt sql -q "SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>"2023-11-01" AND o.act_symbol='ACHR';"
^C
$ dolt sql -q "SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>'2023-11-01' AND o.act_symbol='ACHR';"
+------------+------------+------+------+------+-------+---------+----------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(o.act_symbol) |
+------------+------------+------+------+------+-------+---------+----------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                    |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                    |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                    |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                    |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                    |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                    |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                    |
| 2023-11-13 | ACHR       | 4.99 | 5.20 | 4.88 | 5.20  | 6193570 | 4                    |
| 2023-11-14 | ACHR       | 5.48 | 5.99 | 5.48 | 5.98  | 9265805 | 4                    |
| 2023-11-15 | ACHR       | 6.10 | 6.58 | 6.03 | 6.45  | 9699982 | 4                    |
| 2023-11-16 | ACHR       | 6.39 | 6.41 | 6.10 | 6.26  | 7903983 | 4                    |
| 2023-11-17 | ACHR       | 6.37 | 6.44 | 6.17 | 6.32  | 5141332 | 4                    |
| 2023-11-20 | ACHR       | 6.44 | 6.65 | 6.13 | 6.24  | 6745410 | 4                    |
| 2023-11-21 | ACHR       | 6.15 | 6.22 | 5.83 | 5.90  | 6232083 | 4                    |
| 2023-11-22 | ACHR       | 5.96 | 6.09 | 5.86 | 6.02  | 3017880 | 4                    |
| 2023-11-24 | ACHR       | 5.86 | 6.34 | 5.85 | 6.12  | 2910114 | 4                    |
+------------+------------+------+------+------+-------+---------+----------------------+

$ dolt sql -q "SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE o.date>'2023-11-01' AND o.act_symbol='ACHR' AND LENGTH(o.act_symbol)<5;"
+------------+------------+------+------+------+-------+---------+----------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(o.act_symbol) |
+------------+------------+------+------+------+-------+---------+----------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                    |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                    |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                    |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                    |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                    |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                    |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                    |
| 2023-11-13 | ACHR       | 4.99 | 5.20 | 4.88 | 5.20  | 6193570 | 4                    |
| 2023-11-14 | ACHR       | 5.48 | 5.99 | 5.48 | 5.98  | 9265805 | 4                    |
| 2023-11-15 | ACHR       | 6.10 | 6.58 | 6.03 | 6.45  | 9699982 | 4                    |
| 2023-11-16 | ACHR       | 6.39 | 6.41 | 6.10 | 6.26  | 7903983 | 4                    |
| 2023-11-17 | ACHR       | 6.37 | 6.44 | 6.17 | 6.32  | 5141332 | 4                    |
| 2023-11-20 | ACHR       | 6.44 | 6.65 | 6.13 | 6.24  | 6745410 | 4                    |
| 2023-11-21 | ACHR       | 6.15 | 6.22 | 5.83 | 5.90  | 6232083 | 4                    |
| 2023-11-22 | ACHR       | 5.96 | 6.09 | 5.86 | 6.02  | 3017880 | 4                    |
| 2023-11-24 | ACHR       | 5.86 | 6.34 | 5.85 | 6.12  | 2910114 | 4                    |
+------------+------------+------+------+------+-------+---------+----------------------+

$ dolt sql -q "SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE LENGTH(act_symbol)<5 AND date>'2023-11-01' AND act_symbol='ACHR'"         
+------------+------------+------+------+------+-------+---------+--------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(act_symbol) |
+------------+------------+------+------+------+-------+---------+--------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                  |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                  |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                  |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                  |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                  |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                  |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                  |
| 2023-11-13 | ACHR       | 4.99 | 5.20 | 4.88 | 5.20  | 6193570 | 4                  |
| 2023-11-14 | ACHR       | 5.48 | 5.99 | 5.48 | 5.98  | 9265805 | 4                  |
| 2023-11-15 | ACHR       | 6.10 | 6.58 | 6.03 | 6.45  | 9699982 | 4                  |
| 2023-11-16 | ACHR       | 6.39 | 6.41 | 6.10 | 6.26  | 7903983 | 4                  |
| 2023-11-17 | ACHR       | 6.37 | 6.44 | 6.17 | 6.32  | 5141332 | 4                  |
| 2023-11-20 | ACHR       | 6.44 | 6.65 | 6.13 | 6.24  | 6745410 | 4                  |
| 2023-11-21 | ACHR       | 6.15 | 6.22 | 5.83 | 5.90  | 6232083 | 4                  |
| 2023-11-22 | ACHR       | 5.96 | 6.09 | 5.86 | 6.02  | 3017880 | 4                  |
| 2023-11-24 | ACHR       | 5.86 | 6.34 | 5.85 | 6.12  | 2910114 | 4                  |
+------------+------------+------+------+------+-------+---------+--------------------+

$ dolt sql -q "SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE date>'2023-11-01' AND act_symbol='ACHR' AND LENGTH(act_symbol)<5;"
+------------+------------+------+------+------+-------+---------+--------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(act_symbol) |
+------------+------------+------+------+------+-------+---------+--------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                  |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                  |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                  |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                  |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                  |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                  |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                  |
| 2023-11-13 | ACHR       | 4.99 | 5.20 | 4.88 | 5.20  | 6193570 | 4                  |
| 2023-11-14 | ACHR       | 5.48 | 5.99 | 5.48 | 5.98  | 9265805 | 4                  |
| 2023-11-15 | ACHR       | 6.10 | 6.58 | 6.03 | 6.45  | 9699982 | 4                  |
| 2023-11-16 | ACHR       | 6.39 | 6.41 | 6.10 | 6.26  | 7903983 | 4                  |
| 2023-11-17 | ACHR       | 6.37 | 6.44 | 6.17 | 6.32  | 5141332 | 4                  |
| 2023-11-20 | ACHR       | 6.44 | 6.65 | 6.13 | 6.24  | 6745410 | 4                  |
| 2023-11-21 | ACHR       | 6.15 | 6.22 | 5.83 | 5.90  | 6232083 | 4                  |
| 2023-11-22 | ACHR       | 5.96 | 6.09 | 5.86 | 6.02  | 3017880 | 4                  |
| 2023-11-24 | ACHR       | 5.86 | 6.34 | 5.85 | 6.12  | 2910114 | 4                  |
+------------+------------+------+------+------+-------+---------+--------------------+

$

Potentially this is a hell issue with the query terminating at the first double quote? Notice how I had to ctrl-c out of the query with the next double quotes...

@max-hoffman
Copy link
Contributor

Hi @algotr34. Using dolt v1.28.1, all of these have the same execution plan and result set:

stocks> Explain SELECT *,LENGTH(o.act_symbol) FROM ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>"2023-11-01" AND o.act_symbol='ACHR';
+-----------------------------------------------------------------------------------------------------+
| plan                                                                                                |
+-----------------------------------------------------------------------------------------------------+
| Project                                                                                             |
|  ├─ columns: [o.date, o.act_symbol, o.open, o.high, o.low, o.close, o.volume, length(o.act_symbol)] |
|  └─ Filter                                                                                          |
|      ├─ (((length(o.act_symbol) < 5) AND (o.date > '2023-11-01')) AND (o.act_symbol = 'ACHR'))      |
|      └─ TableAlias(o)                                                                               |
|          └─ IndexedTableAccess(ohlcv)                                                               |
|              ├─ index: [ohlcv.date,ohlcv.act_symbol]                                                |
|              ├─ filters: [{(2023-11-01, ∞), [ACHR, ACHR]}]                                          |
|              └─ columns: [date act_symbol open high low close volume]                               |
+-----------------------------------------------------------------------------------------------------+
9 rows in set (0.00 sec)

stocks> SELECT *,LENGTH(act_symbol) FROM ohlcv WHERE date>"2023-11-01" AND act_symbol='ACHR' AND LENGTH(act_symbol)<5;
+------------+------------+------+------+------+-------+---------+--------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(act_symbol) |
+------------+------------+------+------+------+-------+---------+--------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                  |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                  |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                  |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                  |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                  |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                  |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                  |
| 2023-11-13 | ACHR       | 4.99 | 5.20 | 4.88 | 5.20  | 6193570 | 4                  |
| 2023-11-14 | ACHR       | 5.48 | 5.99 | 5.48 | 5.98  | 9265805 | 4                  |
| 2023-11-15 | ACHR       | 6.10 | 6.58 | 6.03 | 6.45  | 9699982 | 4                  |
| 2023-11-16 | ACHR       | 6.39 | 6.41 | 6.10 | 6.26  | 7903983 | 4                  |
| 2023-11-17 | ACHR       | 6.37 | 6.44 | 6.17 | 6.32  | 5141332 | 4                  |
| 2023-11-20 | ACHR       | 6.44 | 6.65 | 6.13 | 6.24  | 6745410 | 4                  |
| 2023-11-21 | ACHR       | 6.15 | 6.22 | 5.83 | 5.90  | 6232083 | 4                  |
| 2023-11-22 | ACHR       | 5.96 | 6.09 | 5.86 | 6.02  | 3017880 | 4                  |
| 2023-11-24 | ACHR       | 5.86 | 6.34 | 5.85 | 6.12  | 2910114 | 4                  |
+------------+------------+------+------+------+-------+---------+--------------------+
16 rows in set (0.18 sec)

I do see timeouts in the DoltHub UI, but all of the plans are the same and LIMIT 1 returns results for all. I am asking the DoltHub team to gather more info about this. Is there a specific version of Dolt/specific database commit that you see correctness issues? Or are the DoltHub timeouts the issue?

@algotr34
Copy link
Author

algotr34 commented Nov 28, 2023 •
edited
Loading

I still get a different behavior between the queries.
I think one small issue with dolt sql command was due to " escaping (i think), but anyway the main issue still remains, and there are differences between the queries. only the first query works.

INFO

Dolt version 1.24.2
The database is updated until 2023-11-10

QUERIES

stocks>dolt sql -q "SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>'2023-11-01' AND o.act_symbol='ACHR';"
+------------+------------+------+------+------+-------+---------+----------------------+
| date       | act_symbol | open | high | low  | close | volume  | LENGTH(o.act_symbol) |
+------------+------------+------+------+------+-------+---------+----------------------+
| 2023-11-02 | ACHR       | 4.93 | 5.20 | 4.88 | 5.13  | 6424569 | 4                    |
| 2023-11-03 | ACHR       | 5.20 | 5.50 | 5.20 | 5.47  | 4632925 | 4                    |
| 2023-11-06 | ACHR       | 5.52 | 5.61 | 5.23 | 5.35  | 4554518 | 4                    |
| 2023-11-07 | ACHR       | 5.32 | 5.49 | 5.21 | 5.36  | 3422180 | 4                    |
| 2023-11-08 | ACHR       | 5.36 | 5.51 | 5.20 | 5.21  | 4770496 | 4                    |
| 2023-11-09 | ACHR       | 5.27 | 5.40 | 5.12 | 5.26  | 6423177 | 4                    |
| 2023-11-10 | ACHR       | 5.11 | 5.29 | 4.78 | 4.97  | 6779428 | 4                    |
+------------+------------+------+------+------+-------+---------+----------------------+


stocks>dolt sql -q "SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE o.date>'2023-11-01' AND o.act_symbol='ACHR' AND LENGTH(o.act_symbol)<5;"
(Nothing. No results.)

stocks>dolt sql -q "SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE LENGTH(act_symbol)<5 AND date>'2023-11-01' AND act_symbol='ACHR';"
(Nothing. No results.)

stocks>dolt sql -q "SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE date>'2023-11-01' AND act_symbol='ACHR' AND LENGTH(act_symbol)<5;"
(Nothing. No results.)

EXPLAIN QUERIES

stocks>dolt sql -q "EXPLAIN SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE LENGTH(o.act_symbol)<5 AND o.date>'2023-11-01' AND o.act_symbol='ACHR';"
+-----------------------------------------------------------------------------------------------------+
| plan                                                                                                |
+-----------------------------------------------------------------------------------------------------+
| Project                                                                                             |
|  ├─ columns: [o.date, o.act_symbol, o.open, o.high, o.low, o.close, o.volume, length(o.act_symbol)] |
|  └─ Filter                                                                                          |
|      ├─ (((length(o.act_symbol) < 5) AND (o.date > '2023-11-01')) AND (o.act_symbol = 'ACHR'))      |
|      └─ TableAlias(o)                                                                               |
|          └─ IndexedTableAccess(ohlcv)                                                               |
|              ├─ index: [ohlcv.date,ohlcv.act_symbol]                                                |
|              ├─ filters: [{(2023-11-01, ∞), [NULL, ∞)}]                                             |
|              └─ columns: [date act_symbol open high low close volume]                               |
+-----------------------------------------------------------------------------------------------------+


stocks>dolt sql -q "EXPLAIN SELECT *,LENGTH(o.act_symbol) FROM stocks.ohlcv o WHERE o.date>'2023-11-01' AND o.act_symbol='ACHR' AND LENGTH(o.act_symbol)<5;"
+-----------------------------------------------------------------------------------------------------+
| plan                                                                                                |
+-----------------------------------------------------------------------------------------------------+
| Project                                                                                             |
|  ├─ columns: [o.date, o.act_symbol, o.open, o.high, o.low, o.close, o.volume, length(o.act_symbol)] |
|  └─ Filter                                                                                          |
|      ├─ (((o.date > '2023-11-01') AND (o.act_symbol = 'ACHR')) AND (length(o.act_symbol) < 5))      |
|      └─ TableAlias(o)                                                                               |
|          └─ IndexedTableAccess(ohlcv)                                                               |
|              ├─ index: [ohlcv.date,ohlcv.act_symbol]                                                |
|              ├─ filters: [{(∞, ∞), (∞, ∞)}]                                                         |
|              └─ columns: [date act_symbol open high low close volume]                               |
+-----------------------------------------------------------------------------------------------------+


stocks>dolt sql -q "EXPLAIN SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE LENGTH(act_symbol)<5 AND date>'2023-11-01' AND act_symbol='ACHR';"
+-------------------------------------------------------------------------------------------------------------------------------------+
| plan                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------+
| Project                                                                                                                             |
|  ├─ columns: [ohlcv.date, ohlcv.act_symbol, ohlcv.open, ohlcv.high, ohlcv.low, ohlcv.close, ohlcv.volume, length(ohlcv.act_symbol)] |
|  └─ Filter                                                                                                                          |
|      ├─ ((ohlcv.date > '2023-11-01') AND (ohlcv.act_symbol = 'ACHR'))                                                               |
|      └─ IndexedTableAccess(ohlcv)                                                                                                   |
|          ├─ index: [ohlcv.date,ohlcv.act_symbol]                                                                                    |
|          ├─ filters: [{(∞, ∞), (∞, ∞)}]                                                                                             |
|          └─ columns: [date act_symbol open high low close volume]                                                                   |
+-------------------------------------------------------------------------------------------------------------------------------------+


stocks>dolt sql -q "EXPLAIN SELECT *,LENGTH(act_symbol) FROM stocks.ohlcv WHERE date>'2023-11-01' AND act_symbol='ACHR' AND LENGTH(act_symbol)<5;"
+-------------------------------------------------------------------------------------------------------------------------------------+
| plan                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------+
| Project                                                                                                                             |
|  ├─ columns: [ohlcv.date, ohlcv.act_symbol, ohlcv.open, ohlcv.high, ohlcv.low, ohlcv.close, ohlcv.volume, length(ohlcv.act_symbol)] |
|  └─ Filter                                                                                                                          |
|      ├─ ((ohlcv.date > '2023-11-01') AND (ohlcv.act_symbol = 'ACHR'))                                                               |
|      └─ IndexedTableAccess(ohlcv)                                                                                                   |
|          ├─ index: [ohlcv.date,ohlcv.act_symbol]                                                                                    |
|          ├─ filters: [{(∞, ∞), (∞, ∞)}]                                                                                             |
|          └─ columns: [date act_symbol open high low close volume]                                                                   |
+-------------------------------------------------------------------------------------------------------------------------------------+

@max-hoffman
Copy link
Contributor

@algotr34 I can repro your observations with v1.24.2. I think the related fixes are these PRs: dolthub/go-mysql-server#2134, dolthub/go-mysql-server#2146, dolthub/go-mysql-server#2152, dolthub/go-mysql-server#2149. Index scan ranges should be greedy, order invariant, and logically equivalent to the filters they replace. The newer versions of Dolt have made progress here, if you find issues in main we are happy to follow up with more fixes and better testing.

@algotr34
Copy link
Author

I checked again with dolt version 1.28.2 and it seems to be fixed.
amazing progress for just 3 weeks. nice.

@timsehn
Copy link
Contributor

timsehn commented Nov 28, 2023 •
edited
Loading

Great. Keep any bugs you find coming.

@timsehn timsehn closed this as completed Nov 28, 2023
@BrewTestBot BrewTestBot mentioned this issue Dec 1, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
analyzer bug Something isn't working correctness We don't return the same result as MySQL customer issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@timsehn @max-hoffman @coffeegoddd @algotr34