From fc2276c9555c170686979e2531a89730456aa639 Mon Sep 17 00:00:00 2001
From: Marcus Boerger <helly@php.net>
Date: Sun, 20 Feb 2005 19:25:17 +0000
Subject: [PATCH] - Change tests to use ' instead of " for string values
 becuase that is   working for more SQL dialects.

---
 ext/pdo/tests/pdo_001.inc |  6 +++---
 ext/pdo/tests/pdo_002.inc |  6 +++---
 ext/pdo/tests/pdo_003.inc |  6 +++---
 ext/pdo/tests/pdo_004.inc |  6 +++---
 ext/pdo/tests/pdo_005.inc |  8 ++++----
 ext/pdo/tests/pdo_006.inc |  6 +++---
 ext/pdo/tests/pdo_007.inc |  6 +++---
 ext/pdo/tests/pdo_008.inc |  6 +++---
 ext/pdo/tests/pdo_009.inc | 14 +++++++-------
 9 files changed, 32 insertions(+), 32 deletions(-)

diff --git a/ext/pdo/tests/pdo_001.inc b/ext/pdo/tests/pdo_001.inc
index f56757b5ad..ac3882a612 100755
--- a/ext/pdo/tests/pdo_001.inc
+++ b/ext/pdo/tests/pdo_001.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "B")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); 
 set_sql('select',  'SELECT * FROM test');
 
 
diff --git a/ext/pdo/tests/pdo_002.inc b/ext/pdo/tests/pdo_002.inc
index 61165aef9f..1bc19592d7 100755
--- a/ext/pdo/tests/pdo_002.inc
+++ b/ext/pdo/tests/pdo_002.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "B")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); 
 set_sql('select',  'SELECT * FROM test');
 
 
diff --git a/ext/pdo/tests/pdo_003.inc b/ext/pdo/tests/pdo_003.inc
index cac03a64c1..5c541fd1fb 100755
--- a/ext/pdo/tests/pdo_003.inc
+++ b/ext/pdo/tests/pdo_003.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "B")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); 
 set_sql('select',  'SELECT * FROM test');
 
 
diff --git a/ext/pdo/tests/pdo_004.inc b/ext/pdo/tests/pdo_004.inc
index 4cbcf16567..a4efca0e05 100755
--- a/ext/pdo/tests/pdo_004.inc
+++ b/ext/pdo/tests/pdo_004.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "B")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); 
 set_sql('select',  'SELECT * FROM test');
 
 
diff --git a/ext/pdo/tests/pdo_005.inc b/ext/pdo/tests/pdo_005.inc
index 353f19a7e9..1aa392cfd3 100755
--- a/ext/pdo/tests/pdo_005.inc
+++ b/ext/pdo/tests/pdo_005.inc
@@ -3,10 +3,10 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A", "AA")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "B", "BB")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C", "CC")'); 
-set_sql('select',  'SELECT * FROM test');
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'AA\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'BB\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\', \'CC\')'); 
+set_sql('select',  'SELECT id, val, val2 FROM test');
 
 
 $DB->exec($SQL['create']);
diff --git a/ext/pdo/tests/pdo_006.inc b/ext/pdo/tests/pdo_006.inc
index 1b1a682afd..9a745612f1 100755
--- a/ext/pdo/tests/pdo_006.inc
+++ b/ext/pdo/tests/pdo_006.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES(1, "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES(2, "A")'); 
-set_sql('insert3', 'INSERT INTO test VALUES(3, "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(2, \'A\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); 
 set_sql('select',  'SELECT val, id FROM test');
 
 
diff --git a/ext/pdo/tests/pdo_007.inc b/ext/pdo/tests/pdo_007.inc
index dad004af06..00c209d1ae 100755
--- a/ext/pdo/tests/pdo_007.inc
+++ b/ext/pdo/tests/pdo_007.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES("A", "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES("B", "A")'); 
-set_sql('insert3', 'INSERT INTO test VALUES("C", "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); 
 set_sql('select',  'SELECT id, val FROM test');
 
 $DB->exec($SQL['create']);
diff --git a/ext/pdo/tests/pdo_008.inc b/ext/pdo/tests/pdo_008.inc
index 0ae6878b83..5eb94e25cc 100755
--- a/ext/pdo/tests/pdo_008.inc
+++ b/ext/pdo/tests/pdo_008.inc
@@ -3,9 +3,9 @@
 require_once('pdo.inc');
 
 set_sql('create',  'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))');
-set_sql('insert1', 'INSERT INTO test VALUES("A", "A")'); 
-set_sql('insert2', 'INSERT INTO test VALUES("B", "A")'); 
-set_sql('insert3', 'INSERT INTO test VALUES("C", "C")'); 
+set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); 
+set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); 
+set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); 
 set_sql('select',  'SELECT val, id FROM test');
 
 $DB->exec($SQL['create']);
diff --git a/ext/pdo/tests/pdo_009.inc b/ext/pdo/tests/pdo_009.inc
index 6fbcf21879..5ad8cdc137 100755
--- a/ext/pdo/tests/pdo_009.inc
+++ b/ext/pdo/tests/pdo_009.inc
@@ -3,14 +3,14 @@
 require_once('pdo.inc');
 	
 set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(10) UNIQUE)');
-set_sql('insert1', 'INSERT INTO classtypes VALUES(0, "stdClass")'); 
-set_sql('insert2', 'INSERT INTO classtypes VALUES(1, "Test1")'); 
-set_sql('insert3', 'INSERT INTO classtypes VALUES(2, "Test2")'); 
+set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); 
+set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'Test1\')'); 
+set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'Test2\')'); 
 set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(10))');
-set_sql('insert4', 'INSERT INTO test VALUES(1, 0, "A")'); 
-set_sql('insert5', 'INSERT INTO test VALUES(2, 1, "B")'); 
-set_sql('insert6', 'INSERT INTO test VALUES(3, 2, "C")'); 
-set_sql('insert7', 'INSERT INTO test VALUES(4, 3, "D")'); 
+set_sql('insert4', 'INSERT INTO test VALUES(1, 0, \'A\')'); 
+set_sql('insert5', 'INSERT INTO test VALUES(2, 1, \'B\')'); 
+set_sql('insert6', 'INSERT INTO test VALUES(3, 2, \'C\')'); 
+set_sql('insert7', 'INSERT INTO test VALUES(4, 3, \'D\')'); 
 set_sql('select',  'SELECT classtypes.name, test.id AS id, test.val AS val FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id');
 
 $DB->exec($SQL['create1']);
-- 
2.40.0