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.

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

select from itab not possible #181

Open
mem1b opened this issue Sep 9, 2022 · 2 comments
Open

select from itab not possible #181

mem1b opened this issue Sep 9, 2022 · 2 comments

Comments

@mem1b
Copy link

mem1b commented Sep 9, 2022

Hello

I'm at the https://exercism.org/tracks/abap/exercises/itab-aggregation and solved it with a select from itab.
But ran into the following error:
image

Code:

  METHOD perform_aggregation.

    SELECT
      FROM @initial_numbers as a
      FIELDS group,
             COUNT( * ) AS count,
             SUM( number ) AS sum,
             MIN( number ) AS min,
             MAX( number ) AS max,
             AVG( number ) AS avg
      GROUP BY group
      ORDER BY group ASCENDING
      INTO TABLE @aggregated_data.

  ENDMETHOD.

Copied the testclass to my local class on a 7.55 Release and there was no issue:
image

Guess at the moment there is no downport for this case.

@larshp
Copy link
Member

larshp commented Sep 9, 2022

thanks, yea, its a bug, not supported yet

@larshp
Copy link
Member

larshp commented Sep 18, 2022

in order to support FROM @itab fully, the runner will need a database connection, just like in normal ABAP

for performance reasons, we probably dont want to startup a database for each exercism ABAP run

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants