sqllogictest: Check-in [0937105b6d]

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.

      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;








|
|
<


<
<
>

      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;