sqllogictest
Check-in [0937105b6d]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix the schema deleter in the ODBC3 driver so that it works with PostgreSQL.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0937105b6da8a49f4764d664b1e73d880575b7b5
User & Date: drh 2008-12-02 16:06:07
Context
2008-12-02
16:27
Update the references scripts in test/ to conform to the lastest prototypes and to the latest version of the sqllogictest program. check-in: 2024d548ed user: drh tags: trunk
16:06
Fix the schema deleter in the ODBC3 driver so that it works with PostgreSQL. check-in: 0937105b6d user: drh tags: trunk
15:49
Fix an ODBC parameter that should not be NULL. check-in: c33e964f18 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/slt_odbc3.c.

233
234
235
236
237
238
239
240
241
242
243
244
245
246

247
248
249
250
251
252
253
      pc2 += 9;
      while( *pc2 && (*pc2!=';') ) *pc1++ = *pc2++;
      *pc1 = '\0';
    }
  
    /* for each valid table found, drop it */
    for( i=0; !rc && (i+4<res.nUsed); i+=5 ){
      if(    (0 == strcmp(res.azValue[i], zDbName))
          && (   (0 == strcmp(res.azValue[i+1], "dbo"))
              || (0 == strcmp(res.azValue[i+1], "(empty)")) ) /* MySQL */
          && (strlen(res.azValue[i+2])>0)
          && (0 == strcmp(res.azValue[i+3], "TABLE"))
          && (   (0 == strcmp(res.azValue[i+4], "NULL")) 
              || (0 == strcmp(res.azValue[i+1], "(empty)")) ) ){ /* MySQL */

        sprintf(zSql, "DROP TABLE %s", res.azValue[i+2]);
        rc = ODBC3Statement(pODBC3conn, zSql);
      }
    }
  }
  
  return rc;







|
|
<


<
<
>







233
234
235
236
237
238
239
240
241

242
243


244
245
246
247
248
249
250
251
      pc2 += 9;
      while( *pc2 && (*pc2!=';') ) *pc1++ = *pc2++;
      *pc1 = '\0';
    }
  
    /* for each valid table found, drop it */
    for( i=0; !rc && (i+4<res.nUsed); i+=5 ){
      if(    (0 == strcmp(res.azValue[i], zDbName)
               || 0 == strcmp(res.azValue[i], "NULL"))

          && (strlen(res.azValue[i+2])>0)
          && (0 == strcmp(res.azValue[i+3], "TABLE"))


      ){
        sprintf(zSql, "DROP TABLE %s", res.azValue[i+2]);
        rc = ODBC3Statement(pODBC3conn, zSql);
      }
    }
  }
  
  return rc;