pkg/sql/logictest/tests/local/local_test: TestLogic_trigram_builtins failed

[cockroach-teamcity]

pkg/sql/logictest/tests/local/local_test.TestLogic_trigram_builtins failed with artifacts on master @ 06fb4c1b02fc90f8ef17ec1342bb6ce600278925:

=== RUN   TestLogic_trigram_builtins
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/17d51529c8db33db7856d8d7e9c7486f/logTestLogic_trigram_builtins4237608552
    test_log_scope.go:81: use -show-logs to present logs inline
[17:16:10] setting distsql_workmem='10851B';
    logic.go:2925: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/12023/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:45: SELECT similarity(a, b) FROM (VALUES
            ('', ''),
            ('foo', ''),
            ('', 'foo'),
            ('foo', NULL),
            (NULL, 'foo'),
            (NULL, NULL),
            ('foo', 'bar'),
            ('foo', 'far'),
            ('foo', 'for'),
            ('foo', 'foo')
          ) tbl(a, b)
        expected:
            0
            0
            0
            NULL
            NULL
            NULL
            0
            0.142857142857143
            0.333333333333333
            1
            
        but found (query options: "nosort") :
            0
            0
            0
            NULL
            NULL
            NULL
            0
            0.14285714285714285
            0.3333333333333333
            1
            
[17:16:10] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/12023/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins with config local: 6 tests, 1 failures
    logic.go:3983: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/12023/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:70: error while processing
    logic.go:3983: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/12023/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:70: too many errors encountered, skipping the rest of the input
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/17d51529c8db33db7856d8d7e9c7486f/logTestLogic_trigram_builtins4237608552
--- FAIL: TestLogic_trigram_builtins (1.70s)

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-30059

[cockroach-teamcity]

pkg/sql/logictest/tests/local/local_test.TestLogic_trigram_builtins failed with artifacts on master @ c917a6bd896730c86867e2ed6399725ec10e0ac2:

=== RUN   TestLogic_trigram_builtins
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/17d51529c8db33db7856d8d7e9c7486f/logTestLogic_trigram_builtins4244262921
    test_log_scope.go:81: use -show-logs to present logs inline
[17:35:17] setting distsql_workmem='67093B';
    logic.go:2925: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:45: SELECT similarity(a, b) FROM (VALUES
            ('', ''),
            ('foo', ''),
            ('', 'foo'),
            ('foo', NULL),
            (NULL, 'foo'),
            (NULL, NULL),
            ('foo', 'bar'),
            ('foo', 'far'),
            ('foo', 'for'),
            ('foo', 'foo')
          ) tbl(a, b)
        expected:
            0
            0
            0
            NULL
            NULL
            NULL
            0
            0.142857142857143
            0.333333333333333
            1
            
        but found (query options: "nosort") :
            0
            0
            0
            NULL
            NULL
            NULL
            0
            0.14285714285714285
            0.3333333333333333
            1
            
[17:35:17] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins with config local: 6 tests, 1 failures
    logic.go:3983: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:70: error while processing
    logic.go:3983: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/logictest/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/trigram_builtins:70: too many errors encountered, skipping the rest of the input
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/17d51529c8db33db7856d8d7e9c7486f/logTestLogic_trigram_builtins4244262921
--- FAIL: TestLogic_trigram_builtins (1.10s)

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

[michae2]

Dupe of #107461