Test case to reproduce (added to JdbcThinMultiStatementSelfTest):
@Test
public void testInlineSizeOptionWithBacktick() throws Exception {
execute(
"CREATE TABLE public.backticks (pk INT, id INT, k VARCHAR, v
VARCHAR, PRIMARY KEY (pk, id)); " +
"CREATE INDEX backticks_id_k_v ON public.backticks (`id`, `k`,
`v`) INLINE_SIZE 150; "
);
}
On Sat, Feb 6, 2021 at 2:38 PM Courtney Robinson <[email protected]>
wrote:
> 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
>
