cockroachdb / cockroachdb/cockroach

sql: UDF error `internal error: invalid datum type given: RECORD, expected RECORD`

Open
#140,773 3 comments 0 reactions 0 assignees View on GitHub
A-sql-routine branch-master branch-release-23.1 branch-release-23.2 branch-release-24.1 branch-release-24.2 branch-release-24.3 branch-release-25.1 C-test-failure O-roachtest O-robot O-rsg P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.sqlsmith/setup=empty/setting=default [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/18769722?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/18769722?buildTab=artifacts#/sqlsmith/setup=empty/setting=default) on release-25.1 @ [b1f3d91f5dcf5631baf4e66827469859209106ec](https://github.com/cockroachdb/cockroach/commits/b1f3d91f5dcf5631baf4e66827469859209106ec):

```
(sqlsmith.go:255).func3: error: pq: internal error: invalid datum type given: RECORD, expected RECORD
stmt:
WITH
with_112 (col_712, col_713)
AS (
SELECT
*
FROM
(
VALUES
(
'8a4802bd-137a-47cd-b088-a72f7a1a67d8':::UUID,
func_1('{"b": "foo", "foo": false}':::JSONB::JSONB, NULL::DECIMAL, (-40482892):::INT8::INT4, B'01001001100100100101101110011010011101101010110'::BIT(47), '{"PtFJDZc": {"8cHjUN7a": ["LUpRL"], "c": "b"}, "bar": true, "c": 1.2367371855476617, "xuyrxMSlh": true}':::JSONB::JSONB, 'Y':::STRING::BPCHAR)::RECORD
),
(
'6784dab1-ae45-4bd5-bbd6-161d08abbfd7':::UUID,
('xfkcat':::typ_1, '2':::STRING, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET)
)
)
AS tab_342 (col_712, col_713)
)
SELECT
cte_ref_33.col_713 AS col_714, cte_ref_33.col_712 AS col_715
FROM
with_112 AS cte_ref_33
LIMIT
58:::INT8;
test artifacts and logs in: /artifacts/sqlsmith/setup=empty/setting=default/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- metamorphicLeases=default
- runtimeAssertionsBuild=false
- ssd=0
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

See: [Grafana](https://go.crdb.dev/roachtest-grafana/teamcity-18769722/sqlsmith-setup-empty-setting-default/1738996500125/1738996664166)

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*sqlsmith/setup=empty/setting=default.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-47356

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.