I'm a little confused about how String prefixes work

[Randommist]

I encountered a problem when saving bot tokens from Telegram. The bot token looks like 1234567890:ASDFFsadDFdDFDF_AS and it is perceived as a pointer. Everything would be fine, but I did not immediately notice this because some tokens have a "-" symbol, which for some reason makes the database perceive such a line as a normal one and when saving, the s'...' prefix is ​​not added there.

in short, then

create bot:test set token = '123:foo_baz';
update bot:test set token = '123:foo-baz';

-------- Query 1 (167.397µs) --------

[
{
id: bot:test,
token: ⟨123⟩:foo_baz
}
]

-------- Query 2 (73.719µs) --------

[
{
id: bot:test,
token: '123:foo-baz'
}
]

[Randommist]

to be honest it reminds me of yaml in a not so good way :/

[Dhghomon]

Just to confirm, does adding the s string prefix before cases give you the results you want? Without them SurrealDB will always try to turn input ith a single : into a record ID, unless it can't like in your second example as - can't be used in simple record ids.