dcapwell commented on PR #3776: URL: https://github.com/apache/cassandra/pull/3776#issuecomment-2574123252
Applied this patch on https://issues.apache.org/jira/browse/CASSANDRA-20156 to help validate if its working... here are my findings # compare_v4_to_v6_as_equal = false ``` 170: SELECT * FROM ks1.tbl WHERE v1 > '47fe:f4df:4a7:b021:abcd:620:8de4:8b97'; -- v1 inet, indexed with SAI, on node1, fetch size 100 at accord.utils.Property$StatefulBuilder.check(Property.java:504) at org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.test(SingleNodeTableWalkTest.java:279) Caused by: java.lang.AssertionError: Missing rows: pk0 | pk1 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2 '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '145.202.92.88' | '2885:df2e:dc71:e9bc:65f:8df1:9866:438' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '219b:ff91:80ca:66b9:4cb5:591e:5a10:7c19' | '135.154.32.243' | null '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '310c:1a2a:b7a0:4756:9a79:c100:d0a9:5f57' | '264:b6c:2dca:3df5:f769:75c2:be53:9187' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '35ec:a011:1ce3:10e9:afe2:d307:7bcd:38e0' | '162.233.147.185' | '1e6f:b92b:2737:a405:35a8:8ef4:1ae6:d209' 'fdd:967a:e08f:e4d2:76c9:820:316a:8326' | '6df4:a7da:949:ab6:fb8b:cf4a:a642:31ca' | '35.217.142.163' | '83e3:63ab:ba1a:40e1:bb6e:dd5:81b8:f8f9' | null | null | 'fa1f:838:af30:9749:3b99:a146:f741:45c5' | '211.199.119.5' | '54.50.53.237' Expected: pk0 | pk1 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2 '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '133.255.97.88' | '171.226.52.162' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '4c93:a465:39dc:906f:aa82:8362:6ae2:81b7' | 'fd6b:ec3c:e395:4974:10e5:fd1b:2224:2e40' | '64.175.22.8' '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '145.202.92.88' | '2885:df2e:dc71:e9bc:65f:8df1:9866:438' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '219b:ff91:80ca:66b9:4cb5:591e:5a10:7c19' | '135.154.32.243' | null '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '310c:1a2a:b7a0:4756:9a79:c100:d0a9:5f57' | '264:b6c:2dca:3df5:f769:75c2:be53:9187' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '35ec:a011:1ce3:10e9:afe2:d307:7bcd:38e0' | '162.233.147.185' | '1e6f:b92b:2737:a405:35a8:8ef4:1ae6:d209' 'fdd:967a:e08f:e4d2:76c9:820:316a:8326' | '6df4:a7da:949:ab6:fb8b:cf4a:a642:31ca' | '35.217.142.163' | '83e3:63ab:ba1a:40e1:bb6e:dd5:81b8:f8f9' | null | null | 'fa1f:838:af30:9749:3b99:a146:f741:45c5' | '211.199.119.5' | '54.50.53.237' at org.apache.cassandra.harry.model.ASTSingleTableModel.validateAnyOrder(ASTSingleTableModel.java:457) ``` # compare_v4_to_v6_as_equal = true ``` 170: SELECT * FROM ks1.tbl WHERE v1 > '47fe:f4df:4a7:b021:abcd:620:8de4:8b97'; -- v1 inet, indexed with SAI, on node1, fetch size 100 at accord.utils.Property$StatefulBuilder.check(Property.java:504) at org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.test(SingleNodeTableWalkTest.java:279) Caused by: java.lang.AssertionError: Missing rows: pk0 | pk1 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2 '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '145.202.92.88' | '2885:df2e:dc71:e9bc:65f:8df1:9866:438' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '219b:ff91:80ca:66b9:4cb5:591e:5a10:7c19' | '135.154.32.243' | null '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '310c:1a2a:b7a0:4756:9a79:c100:d0a9:5f57' | '264:b6c:2dca:3df5:f769:75c2:be53:9187' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '35ec:a011:1ce3:10e9:afe2:d307:7bcd:38e0' | '162.233.147.185' | '1e6f:b92b:2737:a405:35a8:8ef4:1ae6:d209' 'fdd:967a:e08f:e4d2:76c9:820:316a:8326' | '6df4:a7da:949:ab6:fb8b:cf4a:a642:31ca' | '35.217.142.163' | '83e3:63ab:ba1a:40e1:bb6e:dd5:81b8:f8f9' | null | null | 'fa1f:838:af30:9749:3b99:a146:f741:45c5' | '211.199.119.5' | '54.50.53.237' Expected: pk0 | pk1 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2 '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '133.255.97.88' | '171.226.52.162' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '4c93:a465:39dc:906f:aa82:8362:6ae2:81b7' | 'fd6b:ec3c:e395:4974:10e5:fd1b:2224:2e40' | '64.175.22.8' '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '145.202.92.88' | '2885:df2e:dc71:e9bc:65f:8df1:9866:438' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '219b:ff91:80ca:66b9:4cb5:591e:5a10:7c19' | '135.154.32.243' | null '10.235.137.142' | 'd1b4:a45d:231a:2bbe:8792:afcb:825d:28a' | '310c:1a2a:b7a0:4756:9a79:c100:d0a9:5f57' | '264:b6c:2dca:3df5:f769:75c2:be53:9187' | 'ab2f:bf9f:624d:444b:a3b1:43b2:9873:2b2f' | '2ded:3f20:5172:998:aed3:313d:6d73:b1fb' | '35ec:a011:1ce3:10e9:afe2:d307:7bcd:38e0' | '162.233.147.185' | '1e6f:b92b:2737:a405:35a8:8ef4:1ae6:d209' 'fdd:967a:e08f:e4d2:76c9:820:316a:8326' | '6df4:a7da:949:ab6:fb8b:cf4a:a642:31ca' | '35.217.142.163' | '83e3:63ab:ba1a:40e1:bb6e:dd5:81b8:f8f9' | null | null | 'fa1f:838:af30:9749:3b99:a146:f741:45c5' | '211.199.119.5' | '54.50.53.237' at org.apache.cassandra.harry.model.ASTSingleTableModel.validateAnyOrder(ASTSingleTableModel.java:457) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
