493.dbal.patch

Typo3, 开源里边最强大的

diff -urN adodb493/adodb-lib.inc.php adodb/adodb-lib.inc.php
--- adodb493/adodb-lib.inc.php	2006-10-10 09:54:43.000000000 +0200
+++ adodb/adodb-lib.inc.php	2006-10-13 22:46:51.000000000 +0200
@@ -848,7 +848,7 @@
 	$values = substr($values, 0, -2);
 
 	// Append the fields and their values to the insert query.
-	return 'INSERT INTO '.$tableName.' ( '.$fields.' ) VALUES ( '.$values.' )';
+	return 'INSERT INTO '.$zthis->nameQuote.$tableName.$zthis->nameQuote.' ( '.$fields.' ) VALUES ( '.$values.' )';
 }
 
 
diff -urN adodb493/datadict/datadict-oci8.inc.php adodb/datadict/datadict-oci8.inc.php
--- adodb493/datadict/datadict-oci8.inc.php	2006-10-10 09:54:29.000000000 +0200
+++ adodb/datadict/datadict-oci8.inc.php	2006-10-13 22:46:51.000000000 +0200
@@ -109,6 +109,7 @@
 	
 	function AddColumnSQL($tabname, $flds)
 	{
+		$tabname = $this->TableName ($tabname);
 		$f = array();
 		list($lines,$pkey) = $this->_GenFields($flds);
 		$s = "ALTER TABLE $tabname ADD (";
@@ -123,6 +124,7 @@
 	
 	function AlterColumnSQL($tabname, $flds)
 	{
+		$tabname = $this->TableName ($tabname);
 		$f = array();
 		list($lines,$pkey) = $this->_GenFields($flds);
 		$s = "ALTER TABLE $tabname MODIFY(";
@@ -136,6 +138,7 @@
 	
 	function DropColumnSQL($tabname, $flds)
 	{
+		$tabname = $this->TableName ($tabname);
 		if (!is_array($flds)) $flds = explode(',',$flds);
 		foreach ($flds as $k => $v) $flds[$k] = $this->NameQuote($v);
 		
@@ -251,9 +254,9 @@
 		}
 		
 		if ( is_array($flds) )
-			$flds = implode(', ',$flds);
-		$s = 'CREATE' . $unique . ' INDEX ' . $idxname . ' ON ' . $tabname . ' (' . $flds . ')';
-		
+			$flds = implode('", "',$flds);
+		$s = 'CREATE' . $unique . ' INDEX "' . $idxname . '" ON "' .$tabname . '" ("' . $flds . '")';
+
 		if ( isset($idxoptions[$this->upperName]) )
 			$s .= $idxoptions[$this->upperName];
 		
@@ -279,4 +282,4 @@
 		return  "COMMENT ON COLUMN $table.$col IS $cmt";
 	}
 }
-?>
\ No newline at end of file
+?>
diff -urN adodb493/datadict/datadict-postgres.inc.php adodb/datadict/datadict-postgres.inc.php
--- adodb493/datadict/datadict-postgres.inc.php	2006-10-10 09:54:29.000000000 +0200
+++ adodb/datadict/datadict-postgres.inc.php	2006-10-13 22:46:51.000000000 +0200
@@ -342,7 +342,7 @@
 		
 		$unique = isset($idxoptions['UNIQUE']) ? ' UNIQUE' : '';
 		
-		$s = 'CREATE' . $unique . ' INDEX ' . $idxname . ' ON ' . $tabname . ' ';
+		$s = 'CREATE' . $unique . ' INDEX "' . $idxname . '" ON "' . $tabname . '" ';
 		
 		if (isset($idxoptions['HASH']))
 			$s .= 'USING HASH ';
@@ -351,8 +351,8 @@
 			$s .= $idxoptions[$this->upperName];
 		
 		if ( is_array($flds) )
-			$flds = implode(', ',$flds);
-		$s .= '(' . $flds . ')';
+			$flds = implode('", "',$flds);
+		$s .= '("' . $flds . '")';
 		$sql[] = $s;
 		
 		return $sql;
diff -urN adodb493/drivers/adodb-oci8.inc.php adodb/drivers/adodb-oci8.inc.php
--- adodb493/drivers/adodb-oci8.inc.php	2006-10-10 09:54:40.000000000 +0200
+++ adodb/drivers/adodb-oci8.inc.php	2006-10-13 22:46:51.000000000 +0200
@@ -105,7 +105,7 @@
 		$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
 		if ($this->fetchMode !== false) $savem = $this->SetFetchMode(false);
 		
-		$rs = $this->Execute(sprintf($this->metaColumnsSQL,strtoupper($table)));
+		$rs = $this->Execute(sprintf($this->metaColumnsSQL,$table));
 		
 		if (isset($savem)) $this->SetFetchMode($savem);
 		$ADODB_FETCH_MODE = $save;