github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/vectorize_telemetry (about)

     1  # LogicTest: local
     2  
     3  # Run this test only in local mode since we don't get any new information in
     4  # other configs.
     5  
     6  statement ok
     7  SET CLUSTER SETTING sql.defaults.vectorize='on'
     8  
     9  statement ok
    10  SET CLUSTER SETTING sql.defaults.vectorize='201auto'
    11  
    12  statement ok
    13  SET CLUSTER SETTING sql.defaults.vectorize='off'
    14  
    15  # Test that telemetry is gathered when setting the vectorized cluster setting.
    16  statement ok
    17  CREATE VIEW cur_telemetry as SELECT feature_name, usage_count FROM crdb_internal.feature_usage WHERE feature_name LIKE '%vectorized-setting%'
    18  
    19  query T rowsort
    20  SELECT feature_name FROM cur_telemetry
    21  ----
    22  sql.exec.vectorized-setting.201auto
    23  sql.exec.vectorized-setting.off
    24  sql.exec.vectorized-setting.on
    25  
    26  # Save the usage counts.
    27  statement ok
    28  CREATE TABLE telemetry_test AS SELECT * FROM cur_telemetry
    29  
    30  statement error invalid string value
    31  SET CLUSTER SETTING sql.defaults.vectorize='invalid'
    32  
    33  # This query should return no results because the invalid setting above should
    34  # not be tracked.
    35  query T
    36  SELECT feature_name FROM cur_telemetry WHERE feature_name NOT IN (SELECT feature_name FROM telemetry_test)
    37  ----
    38  
    39  # This view gets the feature name where the usage count is one more than what
    40  # was stored in telemetry_test.
    41  statement ok
    42  CREATE VIEW incremented_feature_names AS SELECT current.feature_name FROM cur_telemetry AS current, telemetry_test AS previous WHERE current.feature_name = previous.feature_name AND current.usage_count=previous.usage_count+1
    43  
    44  statement ok
    45  SET CLUSTER SETTING sql.defaults.vectorize='off'
    46  
    47  query T
    48  SELECT * FROM incremented_feature_names
    49  ----
    50  sql.exec.vectorized-setting.off
    51  
    52  statement ok
    53  SET CLUSTER SETTING sql.defaults.vectorize='on'
    54  
    55  # On should now be in incremented_feature_names.
    56  query T rowsort
    57  SELECT * FROM incremented_feature_names
    58  ----
    59  sql.exec.vectorized-setting.on
    60  sql.exec.vectorized-setting.off