[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-15905:
-
Source Control Link:
https://github.com/apache/cassandra/commit/9251b8116ff89b528b6b9eaa43d4dc2d1bc0bbaf
Resolution: Fixed
Status: Resolved (was: Ready to Commit)
Committed to 3.11 (with very small backport) and trunk, thanks!
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
> Fix For: 3.11.7, 4.0-alpha5
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-15905:
-
Reviewers: Brandon Williams, Brandon Williams (was: Brandon Williams)
Brandon Williams, Brandon Williams
Status: Review In Progress (was: Patch Available)
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
> Fix For: 3.11.7, 4.0-alpha5
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-15905:
-
Test and Documentation Plan: dtest added
Status: Patch Available (was: Open)
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
> Fix For: 3.11.7, 4.0-alpha5
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-15905:
-
Status: Ready to Commit (was: Review In Progress)
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
> Fix For: 3.11.7, 4.0-alpha5
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-15905:
-
Fix Version/s: 4.0-alpha5
3.11.7
Since Version: 3.10
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
> Fix For: 3.11.7, 4.0-alpha5
>
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yifan Cai updated CASSANDRA-15905:
--
Bug Category: Parent values: Degradation(12984)Level 1 values: Performance
Bug/Regression(12997)
Complexity: Low Hanging Fruit
Discovered By: User Report
Severity: Normal
Assignee: Yifan Cai
Status: Open (was: Triage Needed)
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Assignee: Yifan Cai
>Priority: Normal
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yifan Cai updated CASSANDRA-15905:
--
Description:
The cqlsh in trunk only display the first page when running in the batch mode,
i.e. using {{--execute}} or {{--file}} option.
It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
It can be reproduced in 3 steps.
{code:java}
1. ccm create trunk -v git:trunk -n1 && ccm start
2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
write 1000 rows
3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
fetch all rows
{code}
There are 1000 rows written. But the output in step 3 will only list 100 rows,
which is the first page.
{code:java}
➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
105{code}
The related change was introduced in
https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
script no longer fetch all rows when not using tty in the print_result method.
was:
The cqlsh in trunk only display the first page when running in the batch mode,
i.e. using {{\-\-execute}} or {{\-\-file}} option.
It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
It can be reproduced in 3 steps.
{code:java}
1. ccm create trunk -v git:trunk -n1 && ccm start
2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1"
3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"
{code}
There are 1000 rows written. But the output in step 3 will only list 100 rows,
which is the first page.
The related change was introduced in
https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
script no longer fetch all rows when not using tty in the print_result method.
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Priority: Normal
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{--execute}} or {{--file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1" //
> write 1000 rows
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"//
> fetch all rows
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
> {code:java}
> ➜ bin/cqlsh -e "SELECT * FROM keyspace1.standard1" | wc -l
> 105{code}
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-15905) cqlsh not able to fetch all rows when in batch mode
[
https://issues.apache.org/jira/browse/CASSANDRA-15905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yifan Cai updated CASSANDRA-15905:
--
Description:
The cqlsh in trunk only display the first page when running in the batch mode,
i.e. using {{\-\-execute}} or {{\-\-file}} option.
It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
It can be reproduced in 3 steps.
{code:java}
1. ccm create trunk -v git:trunk -n1 && ccm start
2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1"
3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"
{code}
There are 1000 rows written. But the output in step 3 will only list 100 rows,
which is the first page.
The related change was introduced in
https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
script no longer fetch all rows when not using tty in the print_result method.
was:
The cqlsh in trunk only display the first page when running in the batch mode,
i.e. using `--execute` or `--file` option.
It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
It can be reproduced in 3 steps.
# ccm create trunk -v git:trunk -n1 && ccm start
# tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1"
# bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"
There are 1000 rows written. But the output in step 3 will only list 100 rows,
which is the first page.
The related change was introduced in
https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
script no longer fetch all rows when not using tty in the print_result method.
> cqlsh not able to fetch all rows when in batch mode
> ---
>
> Key: CASSANDRA-15905
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15905
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
>Reporter: Yifan Cai
>Priority: Normal
>
> The cqlsh in trunk only display the first page when running in the batch
> mode, i.e. using {{\-\-execute}} or {{\-\-file}} option.
>
> It is a change of behavior. In 3.x branches, the cqlsh returns all rows.
>
> It can be reproduced in 3 steps.
> {code:java}
> 1. ccm create trunk -v git:trunk -n1 && ccm start
> 2. tools/bin/cassandra-stress write n=1k -schema keyspace="keyspace1"
> 3. bin/cqlsh -e "SELECT * FROM keyspace1.standard1;"
> {code}
>
> There are 1000 rows written. But the output in step 3 will only list 100
> rows, which is the first page.
>
> The related change was introduced in
> https://issues.apache.org/jira/browse/CASSANDRA-11534, where the cqlsh.py
> script no longer fetch all rows when not using tty in the print_result
> method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
