SQL generation bug for nullability change

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

SQL generation bug for nullability change

Kjell Rilbe-3
Hi,

In FR 0.9.3.2106 I just tried to change nullability of a couple of
columns using the column property dialog.

The generated SQL looks like this:

UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = NULL
WHERE RDB$FIELD_NAME = '"Name"' AND RDB$RELATION_NAME = 'Company';

As you can see, the column name is double quoted inside the string
literal. This is incorrect.

I have "Quote names only when needed" and "Treat quote characters like
other characters" unchecked. Any other settings you may want to know?

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

------------------------------------------------------------------------------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: SQL generation bug for nullability change

Michael Hieke
On 11.08.2011 13:00, Kjell Rilbe wrote:

> In FR 0.9.3.2106 I just tried to change nullability of a couple of
> columns using the column property dialog.
>
> The generated SQL looks like this:
>
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = NULL
> WHERE RDB$FIELD_NAME = '"Name"' AND RDB$RELATION_NAME = 'Company';
>
> As you can see, the column name is double quoted inside the string
> literal. This is incorrect.

Thanks for the report, hopefully fixed in SVN revision #2210.  Could you
please try whether things work correctly now, thanks.  I'm currently
uploading new snapshot builds.

Thanks

--
Michael Hieke

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel