sql: unsupported binary operator: <jsonb> #>> <string>

[intech]

CREATE TABLE users (
	uuid UUID NOT NULL,
	username VARCHAR(255) NULL,
	settings JSONB NULL,
	CONSTRAINT "primary" PRIMARY KEY (uuid ASC),
	UNIQUE INDEX users_uuid_key (uuid ASC),
	FAMILY "primary" (uuid, username, settings)
);
INSERT INTO users (uuid,username,settings) VALUES 
('6bb54756-3761-4104-ae9e-90058029e513','test','{"contacts": {"tg": "test"}}');

SELECT * FROM users AS u WHERE u.settings #>> '{contacts,tg}' = 'test'

SQL Error [22023]: ERROR: unsupported binary operator: <jsonb> #>> <string>

Environment:

• CockroachDB version: 19.1.5
• Server OS: Debian
• Client app DBeaver 6.2.2

[awoods187]

This now works in 19.2:

                  uuid                 | username |           settings
+--------------------------------------+----------+------------------------------+
  6bb54756-3761-4104-ae9e-90058029e513 | test     | {"contacts": {"tg": "test"}}
(1 row)

Time: 10.982ms

We have a beta publicly available and expect to release 19.2 in the near future. Let us know if you have additional questions.

[intech]

@awoods187 In docs is wrong information for version 19.1.5:
https://www.cockroachlabs.com/docs/stable/functions-and-operators.html#supported-operations

[awoods187]

@intech we supported #>> string[] in 19.1. Unfortunately, we did not support implicitly converting string -> string[]. We now support this in 19.2 due to #23299. Let me know if that makes sense.