1. Vertabelo
  2. Bugs
0
Pas un bug

default values not quoted

Rob Hill il y a 3 ans • mis à jour il y a 3 ans • 3

I have created a table with columns containing default values and the generated sql does not quote the value, causing the following failure message:

ERROR: cannot use column reference in DEFAULT expression

I also tried quoting the value in the "Default Value" property but in both cases the SQL generated failed to quote the vallue.

auto_renew boolean  NOT NULL DEFAULT FALSE,
À l'étude
Adam Mościcki il y a 3 ans
Pas un bug
Adam Mościcki il y a 3 ans

Hello,

This is an intended behavior. In fact, the "Default Value" property can be many things, i.e.:
- a constant, like FALSE, which indeed has to be quoted
- an expression like, nextval('sequence') which can't be quoted


Therefore we decided to not quote this property.


Hope this helps,
Adam

Rob Hill il y a 3 ans

OK.

But why, if I quote it, are the quotes ignored?

Service d'assistance aux clients par UserEcho