From 84017b1e0b7428e5b06a3497ed74e2a0fbf45ca9 Mon Sep 17 00:00:00 2001
From: Roger Demetrescu <roger.demetrescu@gmail.com>
Date: Sat, 6 Oct 2007 11:10:56 +0000
Subject: [PATCH] fixed reflection of Column's nullable property [firebird]

---
 CHANGES                              | 1 +
 lib/sqlalchemy/databases/firebird.py | 3 +++
 2 files changed, 4 insertions(+)

diff --git a/CHANGES b/CHANGES
index da48626ae0..7f2ed097c7 100644
--- a/CHANGES
+++ b/CHANGES
@@ -38,6 +38,7 @@
    - passthrough for stringified dates
 - firebird
     - supports_sane_rowcount() set to False due to ticket #370 (right way).
+    - fixed reflection of Column's nullable property.
       
 0.3.10
 - general
diff --git a/lib/sqlalchemy/databases/firebird.py b/lib/sqlalchemy/databases/firebird.py
index 514890dd14..03cb891a23 100644
--- a/lib/sqlalchemy/databases/firebird.py
+++ b/lib/sqlalchemy/databases/firebird.py
@@ -262,6 +262,9 @@ class FBDialect(ansisql.ANSIDialect):
             # is it a primary key?
             kw['primary_key'] = name in pkfields
 
+            # is it nullable ?
+            kw['nullable'] = not bool(row['NULL_FLAG'])
+
             table.append_column(schema.Column(*args, **kw))
             row = c.fetchone()
 
-- 
2.47.2