In a future release, we'd like to introduce the possibility of comparing the value of two field, like this:
`field1` = `field2`
Today, it's complicated and slow to compare fields. For example, consider this:
field1 = field2
This doesn't mean compare the value of field1 to the value of field2. Instead, it means compare the value of field1 to the string "field2". Instead one has to write something like this:
x := field1 == field2 | x = true
By making ` a reserved character now, we can enable the syntax in the first code snippet above.
We don't expect this will have a huge impact on users, but we do see a few queries that use the back tick character in our logs from cloud users today. However, only from sandboxes. We hope the benefit of enabling comparison of fields will outweigh any inconvenience to our users.
In a future release, we'd like to introduce the possibility of comparing the value of two field, like this:
Today, it's complicated and slow to compare fields. For example, consider this:
This doesn't mean compare the value of
field1
to the value offield2
. Instead, it means compare the value offield1
to the string"field2"
. Instead one has to write something like this:By making
`
a reserved character now, we can enable the syntax in the first code snippet above.We don't expect this will have a huge impact on users, but we do see a few queries that use the back tick character in our logs from cloud users today. However, only from sandboxes. We hope the benefit of enabling comparison of fields will outweigh any inconvenience to our users.