MonetDB: ssdb - SSDBcooking: use correct SQLSTATE

[Fabian Groffen]

Changeset: b7b3e78eead1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b7b3e78eead1
Modified Files:
        sql/backends/monet5/UDF/ssdb.c
Branch: ssdb
Log Message:

SSDBcooking: use correct SQLSTATE


diffs (60 lines):

diff --git a/sql/backends/monet5/UDF/ssdb.c b/sql/backends/monet5/UDF/ssdb.c
--- a/sql/backends/monet5/UDF/ssdb.c
+++ b/sql/backends/monet5/UDF/ssdb.c
@@ -63,7 +63,7 @@ _append_bat(mvc *sql, sql_table *t, char
        sql_column *c = mvc_bind_column(sql, t, cname);
 
        if(!c)
-               return sql_message("42S02!COOKING(): no such column '%s.%s'", 
t->base.name, cname);
+               return sql_message("42S22!COOKING(): no such column '%s.%s'", 
t->base.name, cname);
        store_funcs.append_col(m->session->tr, c, b, TYPE_bat);
        return NULL;
 }
@@ -143,19 +143,19 @@ SSDBcooking(Client cntxt, MalBlkPtr mb, 
        /* RD_INS means we want the insert BATs, since all input tables are
         *   declared as TEMP */
        if(!(tin_imgid = _bind_bat(sql, tin, "imageid", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tin_name, "imageid");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tin_name, "imageid");
                goto CLEANUP_RETURN;
        }
        if(!(tin_x = _bind_bat(sql, tin, "x", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tin_name, "x");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tin_name, "x");
                goto CLEANUP_RETURN;
        }
        if(!(tin_y = _bind_bat(sql, tin, "y", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tin_name, "y");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tin_name, "y");
                goto CLEANUP_RETURN;
        }
        if(!(tin_val = _bind_bat(sql, tin, "val", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tin_name, "val");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tin_name, "val");
                goto CLEANUP_RETURN;
        }
 
@@ -224,19 +224,19 @@ SSDBcooking(Client cntxt, MalBlkPtr mb, 
        /* get the BATs of all columns of the output table 'tout_plg' */
        /*
        if(!(tout_plg_obsid = _bind_bat(sql, tout_plg, "obsid", TYPE_int, 
RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tout_name, "obsid");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tout_name, "obsid");
                goto CLEANUP_RETURN;
        }
        if(!(tout_plg_ord = _bind_bat(sql, tout_plg, "ord", TYPE_int, RD_INS))) 
{
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tout_name, "ord");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tout_name, "ord");
                goto CLEANUP_RETURN;
        }
        if(!(tout_plg_x = _bind_bat(sql, tout_plg, "x", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tout_name, "x");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tout_name, "x");
                goto CLEANUP_RETURN;
        }
        if(!(tout_plg_y = _bind_bat(sql, tout_plg, "y", TYPE_int, RD_INS))) {
-               msg = sql_message("42S02!COOKING(): no such column '%s.%s'", 
tout_name, "y");
+               msg = sql_message("42S22!COOKING(): no such column '%s.%s'", 
tout_name, "y");
                goto CLEANUP_RETURN;
        }
        */
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list