Bug in generated SQL

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug in generated SQL

Kjell Rilbe-3
Hi,

I just tried to remove the "not null" constraint on one of my columns,
but the generated SQL is buggy:

UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = NULL
WHERE RDB$FIELD_NAME = '"ColumnName"' AND RDB$RELATION_NAME = 'MyTable';

Note the doublequtes for ColumnName.

I have none of the checkboxes checked on "Sql Statement Generation".

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: [hidden email]
Telefon: 08-761 06 55
Mobil: 0733-44 24 64


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug in generated SQL

Michael Hieke
Hi,

-------- Original-Nachricht --------

> I just tried to remove the "not null" constraint on one of my columns,
> but the generated SQL is buggy:
>
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = NULL
> WHERE RDB$FIELD_NAME = '"ColumnName"' AND RDB$RELATION_NAME = 'MyTable';

which FR version is that?  I just tried with SVN revision 2242, and it works there.

Note that SVN revision 2210 has a bug fix with the comment

  * Fix bug reported 2011-08-11 by Kjell Rilbe on dev list:
    "SQL generation bug for nullability change"

- maybe that's the same one?

Regards

--
Michael Hieke

--
Michael Hieke



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel