You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Wrong Number of Rows is Presented When Using LIMIT with LT JOIN Queries #164
changed the title [-]Wrong Number of Rows When Using LIMIT with LT JOIN Queries[/-][+]Wrong Number of Rows is Presented When Using LIMIT with LT JOIN Queries[/+]on Jun 15, 2023
CREATE TABLE 'train' (
id DOUBLE,
date TIMESTAMP,
store_nbr DOUBLE,
family SYMBOL,
sales DOUBLE,
onpromotion DOUBLE
) timestamp(date);
run this INSERT INTO train SELECT * FROM train.csv
run this SELECT * FROM (train d LT JOIN (train c LT JOIN (train b LT JOIN (train a WHERE a.date<'2017-08-01' and a.date>'2017-06-15' AND a.family='HOME AND KITCHEN I') ON family WHERE b.date<'2017-08-01' and b.date>'2017-06-15' AND b.family='HOME AND KITCHEN I') ON family WHERE c.date<'2017-08-01' and c.date>'2017-06-15' AND c.family='HOME AND KITCHEN I') ON family WHERE d.date<'2017-08-01' and d.date>'2017-06-15' AND d.family='HOME AND KITCHEN I') LIMIT 3,99999999999999999
Activity
[-]Wrong Number of Rows When Using LIMIT with LT JOIN Queries[/-][+]Wrong Number of Rows is Presented When Using LIMIT with LT JOIN Queries[/+]insmac commentedon Jun 15, 2023
Hey @superichmann, thanks for submitting the issue.
Could you specify the following:
countproperty in/execXHR API response for this query?superichmann commentedon Jun 23, 2023
reproduce:
INSERT INTO train SELECT * FROM train.csvSELECT * FROM (train d LT JOIN (train c LT JOIN (train b LT JOIN (train a WHERE a.date<'2017-08-01' and a.date>'2017-06-15' AND a.family='HOME AND KITCHEN I') ON family WHERE b.date<'2017-08-01' and b.date>'2017-06-15' AND b.family='HOME AND KITCHEN I') ON family WHERE c.date<'2017-08-01' and c.date>'2017-06-15' AND c.family='HOME AND KITCHEN I') ON family WHERE d.date<'2017-08-01' and d.date>'2017-06-15' AND d.family='HOME AND KITCHEN I') LIMIT 3,99999999999999999