Incomplete support for syntax for bit-string constants b'101'

[emarsden]

The b'101' syntax is being read as bytes, but should be read as a bit-string for compatibility with PostgreSQL.

root=> SELECT B'101'::integer;
 int8 
------
    5
(1 ligne)
root=> SELECT b'101'::integer;
ERROR:  invalid cast: bytes -> int

Running CockroachDB CCL v23.1.7 (x86_64-pc-linux-gnu, built 2023/07/27 00:54:56, go1.19.10)

Jira issue: CRDB-30409

[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 was unable to automatically find someone to ping.

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.}

[rafiss]

relates to: #26128