Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-7831

recreating a counter column after dropping it leaves in unusable state

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.11, 2.1.0
    • Component/s: None
    • Labels:
    • Severity:
      Normal

      Description

      create table counter_bug (t int, c counter, primary key (t));
      update counter_bug set c = c +1 where t = 1;
      select * from counter_bug ;

      t | c
      --+--
      1 | 1

      (1 rows)

      alter table counter_bug drop c;
      alter table counter_bug add c counter;
      update counter_bug set c = c +1 where t = 1;
      select * from counter_bug;

      (0 rows)

      update counter_bug set c = c +1 where t = 2;
      select * from counter_bug;

      (0 rows)

        Attachments

        1. 7831.txt
          0.9 kB
          Aleksey Yeschenko

          Activity

            People

            • Assignee:
              iamaleksey Aleksey Yeschenko
              Reporter:
              pmaedel Peter M├Ądel
              Authors:
              Aleksey Yeschenko
              Reviewers:
              Jonathan Ellis
              Tester:
              Philip Thompson
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: