Details

    • Type: Sub-task Sub-task
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Fix Version/s: 1.2.4
    • Component/s: API
    • Labels:

      Description

      Dense composite supports adding records where only a prefix of all the component specifying the key is defined. In other words, with:

      CREATE TABLE connections (
         userid int,
         ip text,
         port int,
         protocol text,
         time timestamp,
         PRIMARY KEY (userid, ip, port, protocol)
      ) WITH COMPACT STORAGE
      

      you can insert

      INSERT INTO connections (userid, ip, port, time) VALUES (2, '192.168.0.1', 80, 123456789);
      

      You cannot however select that column specifically (i.e, without selecting column (2, '192.168.0.1', 80, 'http') for instance).
      This ticket proposes to allow that though 'null', i.e. to allow

      SELECT * FROM connections WHERE userid = 2 AND ip = '192.168.0.1' AND port = 80 AND protocol = null;
      

      It would then also make sense to support:

      INSERT INTO connections (userid, ip, port, protocol, time) VALUES (2, '192.168.0.1', 80, null, 123456789);
      

      as an equivalent to the insert query above.

      1. 3783-wip-v1.patch
        2 kB
        Michał Michalski
      2. 3783-v2.patch
        11 kB
        Michał Michalski
      3. 3783-v3.patch
        11 kB
        Michał Michalski
      4. 3783-v4.txt
        12 kB
        Sylvain Lebresne
      5. 3783-v5.txt
        11 kB
        Aleksey Yeschenko

        Issue Links

          Activity

          Sylvain Lebresne created issue -
          Sylvain Lebresne made changes -
          Field Original Value New Value
          Fix Version/s 1.1 [ 12317615 ]
          Sylvain Lebresne made changes -
          Component/s API [ 12313742 ]
          Sylvain Lebresne made changes -
          Fix Version/s 1.1.1 [ 12319857 ]
          Fix Version/s 1.1 [ 12317615 ]
          Jonathan Ellis made changes -
          Fix Version/s 1.1.2 [ 12321445 ]
          Fix Version/s 1.1.1 [ 12319857 ]
          Sylvain Lebresne made changes -
          Fix Version/s 1.1.3 [ 12321881 ]
          Fix Version/s 1.1.2 [ 12321445 ]
          Jonathan Ellis made changes -
          Fix Version/s 1.2 [ 12319262 ]
          Fix Version/s 1.1.3 [ 12321881 ]
          Jonathan Ellis made changes -
          Fix Version/s 1.2.1 [ 12322953 ]
          Fix Version/s 1.2.0 [ 12319262 ]
          Jonathan Ellis made changes -
          Fix Version/s 1.2.2 [ 12323924 ]
          Fix Version/s 1.2.1 [ 12322953 ]
          Gavin made changes -
          Workflow no-reopen-closed, patch-avail [ 12650521 ] patch-available, re-open possible [ 12753109 ]
          Gavin made changes -
          Workflow patch-available, re-open possible [ 12753109 ] reopen-resolved, no closed status, patch-avail, testing [ 12755761 ]
          Michał Michalski made changes -
          Attachment 3783-wip-v1.patch [ 12568760 ]
          Michał Michalski made changes -
          Attachment 3783-v2.patch [ 12570097 ]
          Michał Michalski made changes -
          Assignee Michał Michalski [ michalm ]
          Sylvain Lebresne made changes -
          Fix Version/s 1.2.3 [ 12324089 ]
          Fix Version/s 1.2.2 [ 12323924 ]
          Michał Michalski made changes -
          Attachment 3783-v3.patch [ 12572138 ]
          Sylvain Lebresne made changes -
          Fix Version/s 1.2.4 [ 12324157 ]
          Fix Version/s 1.2.3 [ 12324089 ]
          Sylvain Lebresne made changes -
          Attachment 3783-v4.txt [ 12574797 ]
          Sylvain Lebresne made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Anonymous made changes -
          Status Patch Available [ 10002 ] Testing [ 10012 ]
          Brandon Williams made changes -
          Status Testing [ 10012 ] Open [ 1 ]
          Aleksey Yeschenko made changes -
          Reviewer iamaleksey
          Aleksey Yeschenko made changes -
          Attachment 3783-v5.txt [ 12577004 ]
          Sylvain Lebresne made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Aleksey Yeschenko made changes -
          Link This issue is duplicated by CASSANDRA-5416 [ CASSANDRA-5416 ]

            People

            • Assignee:
              Michał Michalski
              Reporter:
              Sylvain Lebresne
              Reviewer:
              Aleksey Yeschenko
            • Votes:
              4 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development