Robin Meade

I'm going to use a workaround of using the envsubst [1] command to expand references to environment variables of the form $VARIABLE or ${VARIABLE}.

I'm trying to export the results of a multiline SQL query that has a PL variable. This works: /* script.sql */ * *DSV_COL_DELIM = , * *NULL_REP_TOKEN = * *DSV_TARGET_FILE = output.csv * id = 15 \xq select i.id, p.name, it.quantity, it.cost from item it join product p on it.productid = p.id join invoice i on it.invoiceid = i.id where i.id = *{id} but I wanted multiline SQL. I tried: /* script.sql */ * *DSV_COL_DELIM = , * *NULL_REP_TOKEN = * *DSV_TARGET_FILE = output.csv * id = 15 \. select i.id,...

Hi HSQLDB developers, I'm using sqltool to export csv files using the /xq command. It works great. Today, I tried the ALL_QUOTED option and I noticed two things about the output: Numeric values are quoted (this makes sense for an option called ALL_QUOTED) The null value (whether empty string or value of NULL_REP_TOKEN) is not quoted. Perhaps the null value should be quoted as well, when the ALL_QUOTED option is in effect. The reason I tried the ALL_QUOTED option today is that I was trying to reproduce...