[
https://issues.apache.org/jira/browse/IGNITE-15567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17870207#comment-17870207
]
Pavel Pereslegin edited comment on IGNITE-15567 at 8/1/24 2:27 PM:
-------------------------------------------------------------------
I can't find which database supports this syntax.
{code:sql}
SELECT * FROM repeat(1, 10*1024) t1(b)
{code}
Anyway we support the following syntax for doing the same thing
{code:sql}
SELECT 1 FROM table(system_range(1, 10*1024)) t1(b)
{code}
And we support text REPEAT function, that is
{code:sql}
select repeat('Hello ', 2);
{code}
outputs
{noformat}
Hello Hello
{noformat}
Mentioned AI3 tests has been rewritten to use system_range
[here|https://github.com/apache/ignite-3/commit/6b12242727e6759e8937e8163f20c1b39c5e6420#diff-ffc43ce7aa1097d8608644700466fbe18dcd8bcfbfcd9444bc265498246ad278L16].
was (Author: xtern):
I can't find which database supports this syntax.
{code:sql}
SELECT * FROM repeat(1, 10*1024) t1(b)
{code}
Anyway we support the following syntax for doing the same thing
{code:sql}
SELECT 1 FROM table(system_range(1, 10*1024)) t1(b)
{code}
And we support text REPEAT function, that is
{code:sql}
select repeat('Hello ', 2);
{code:sql}
outputs
{noformat}
Hello Hello
{noformat}
Mentioned AI3 tests has been rewritten to use system_range
[here|https://github.com/apache/ignite-3/commit/6b12242727e6759e8937e8163f20c1b39c5e6420#diff-ffc43ce7aa1097d8608644700466fbe18dcd8bcfbfcd9444bc265498246ad278L16].
> Calcite. Support REPEAT functionality or remove it from tests.
> --------------------------------------------------------------
>
> Key: IGNITE-15567
> URL: https://issues.apache.org/jira/browse/IGNITE-15567
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Pavel Pereslegin
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> Now failed:
> {noformat}
> CREATE TABLE test2 AS SELECT * FROM repeat(1, 10*1024) t1(b), (SELECT 10)
> t2(c);
> {noformat}
> {noformat}
> /join/inner/test_join_duplicates.test[_ignored]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
