To reproduce

1. Create a new table: CREATE TABLE TEST ("MY_COL" INT)
2. Try to alter a column name by putting it in double quotes: ALTER TABLE TEST ALTER COLUMN "MY_COL" FLOAT

column '"MY_COL"' does not exist in table 'TEST'

3. Try to alter a column name by putting it in single quotes: ALTER TABLE TEST ALTER COLUMN 'MY_COL' FLOAT

column ''MY_COL'' does not exist in table 'TEST'

This prevents altering columns with unique names that might include special characters. Also it does not match the consistency of CREATE TABLE which can contain quotes.

QuestDB version:

9.3.3

OS, in case of Docker specify Docker and the Host OS:

Mac OS (Docker)

File System, in case of Docker specify Host File System:

Host File System

Full Name:

Jason Thomas

Affiliation:

OpenC3

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response