Cannot create SQL index with INLINE_SIZE if ` is used

[Courtney Robinson]

If you use
>
> CREATE INDEX IF NOT EXISTS myIdx ON myTbl(myCol) INLINE_SIZE 200;

then this works as expected. If the column names are escaped then it fails
with a syntax error
so

> CREATE INDEX IF NOT EXISTS myIdx ON myTbl(`myCol`) INLINE_SIZE 200;

will fail with a syntax error.
I've found a workaround is to use " instead of `

> CREATE INDEX IF NOT EXISTS myIdx ON myTbl("myCol") INLINE_SIZE 200;


First found in 2.8.1 and verified to still fail on 2.9.1.

Regards,
Courtney Robinson
Founder and CEO, Hypi
Tel: ++44 208 123 2413 (GMT+0) <https://hypi.io>

<https://hypi.io>
https://hypi.io