Hi,

please find attached a patch to always quote aliases in select statements. I need this to get non-ascii column names (which are re-used in aliases) to work, when running against postgresql-8.4.5 running on windows7.

I'm aware that that's most likely not an optimal solution - especially considering it's a workaround for a bug on a quite "niche" platform ;-).


Best Regards, David
--
dasz.at OG              Tel: +43 (0)664 2602670     Web: http://dasz.at
Klosterneuburg                                         UID: ATU64260999

       FB-Nr.: FN 309285 g          FB-Gericht: LG Korneuburg
Index: 
P:/NHibernate/NHibernate-3.0.0GA/src/NHibernate/SqlCommand/SelectFragment.cs
===================================================================
--- 
P:/NHibernate/NHibernate-3.0.0GA/src/NHibernate/SqlCommand/SelectFragment.cs    
    (revision 5376)
+++ 
P:/NHibernate/NHibernate-3.0.0GA/src/NHibernate/SqlCommand/SelectFragment.cs    
    (working copy)
@@ -156,7 +156,7 @@
 
                                        buf.Append(col)
                                                .Append(" as ")
-                                               .Append(new 
Alias(suffix).ToAliasString(columnAlias, dialect));
+                                               
.Append(dialect.QuoteForAliasName(new Alias(suffix).ToAliasString(columnAlias, 
dialect)));
 
                                        // Set the flag for the next time
                                        found = true;

Reply via email to