default value
Posted: Wed 09 Jul 2014 21:47
Ran into something, it might not really a bug, but not sure if correct generation of DDL for a table -
I have an integer field with the value of -1, in the Generated DDL that gets displayed
'int_score smallint(4) NOT NULL DEFAULT - 1'
Looked odd, might be legal and correct SQL but expected it to be
'int_score smallint(4) NOT NULL DEFAULT -1'
Again, nothing causing a problem and likely valid SQL just looked odd so wanted to pass it along.
Sandy
I have an integer field with the value of -1, in the Generated DDL that gets displayed
'int_score smallint(4) NOT NULL DEFAULT - 1'
Looked odd, might be legal and correct SQL but expected it to be
'int_score smallint(4) NOT NULL DEFAULT -1'
Again, nothing causing a problem and likely valid SQL just looked odd so wanted to pass it along.
Sandy