Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0
    • Fix Version/s: 2.2.1, 2.3.0
    • Component/s: SQL
    • Labels:
      None

      Description

      create temporary view data as select * from values
      (1, 1),
      (1, 2),
      (2, 1),
      (2, 2),
      (3, 1),
      (3, 2)
      as data(a, b);

      select 3, 4, sum(b) from data group by 1, 2;
      When running this case, the following exception occurred:
      Error in query: GROUP BY position 4 is not in select list (valid range is [1, 3]); line 1 pos 10

      But this case can run normally:select 1, 2, sum(b) from data group by 1, 2;

        Attachments

          Activity

            People

            • Assignee:
              10110346 liuxian
              Reporter:
              10110346 liuxian
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: