- Add support to NULL values. This concern the MYSQL

  and ODBC table types. Not supported yet for indexes.

modified:
  storage/connect/colblk.cpp
  storage/connect/colblk.h
  storage/connect/connect.cc
  storage/connect/ha_connect.cc
  storage/connect/tabmysql.cpp
  storage/connect/tabodbc.cpp
  storage/connect/valblk.cpp
  storage/connect/valblk.h
  storage/connect/value.cpp
  storage/connect/value.h
  storage/connect/xindex.cpp

1 files changed, 7 insertions, 1 deletions

diff --git a/storage/connect/xindex.cpp b/storage/connect/xindex.cpp
index 073767752d3..5971f578113 100644
--- a/storage/connect/xindex.cpp
+++ b/storage/connect/xindex.cpp
@@ -279,7 +279,7 @@ int XINDEX::Qcompare(int *i1, int *i2)
 bool XINDEX::Make(PGLOBAL g, PIXDEF sxp)
   {
   /*********************************************************************/
-  /*  Table can be accessed through an index.                         */
+  /*  Table can be accessed through an index.                          */
   /*********************************************************************/
   int     k, rc = RC_OK;
   int   *bof, i, j, n, ndf, nkey;
@@ -2861,6 +2861,12 @@ bool KXYCOL::Init(PGLOBAL g, PCOL colp, int n, bool sm, int kln)
   {
   int len = colp->GetLength(), prec = colp->GetPrecision();
 
+  // Currently no indexing on NULL columns
+  if (colp->IsNullable()) {
+    sprintf(g->Message, "Cannot index nullable column %s", colp->GetName());
+    return true;
+    } // endif nullable
+
   if (kln && len > kln && colp->GetResultType() == TYPE_STRING) {
     len = kln;
     Prefix = true;