cockroachdb / cockroachdb/cockroach
sql: UDF error `internal error: invalid datum type given: RECORD, expected RECORD`
- 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
Assessment
This issue has not been assessed yet.