CONCAT with integer field and string argument crashes when using server-side cursors

[timgraham]

There are some known issues with CockroachDB + Django + psycopg3 server-side cursors. This one may be different. The exception is different, at least.

To Reproduce

Using the Django test suite:

./tests/runtests.py --settings=test_roach db_functions.text.test_concat.ConcatTests.test_concat_non_str

A simplified query (where age field is of type integer):

SELECT CONCAT("db_functions_author"."age", %s) AS "name_text" FROM "db_functions_author" args=(':',)

psycopg.errors.InvalidTextRepresentation: error in argument for $1: could not parse ":" as type int2: strconv.ParseInt: parsing ":": invalid syntax

Expected behavior

No crash (works on PostgreSQL).

Environment:

• CockroachDB version
  Build Tag: v25.1.0-alpha.00000000-dev-6a7b1e20e70c0ba8e6bb7a42d52512d9437cd75b
  Build Time: 2024/11/21 07:05:31

Additional context

CockroachDB 24.3 added support for CONCAT() to accept non-string data which fixed this query when using client-side cursors.

Jira issue: CRDB-44959

[blathers-crl]

Hi @timgraham, please add branch-* labels to identify which branch(es) this C-bug affects.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-foundations (found keywords: Django)
• @jordanlewis (commented on "could not determine data type of placeholder" with string arguments and psycopg3 #91396)
• @rytaft (commented on bulitins: rewrite concat() to accept any datum type #127098)
• @rafiss (commented on "could not determine data type of placeholder" with string arguments and psycopg3 #91396)
• @rickystewart (commented on bulitins: rewrite concat() to accept any datum type #127098)
• @mw5h (author of bulitins: rewrite concat() to accept any datum type #127098)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}