File: EscapeProcessorRegressionTest.cpp

package info (click to toggle)
mysql-connector-c%2B%2B 1.1.0~r814-1
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 4,388 kB
  • ctags: 3,838
  • sloc: cpp: 39,820; ansic: 2,114; perl: 936; php: 528; xml: 399; sql: 399; sh: 85; makefile: 47
file content (78 lines) | stat: -rw-r--r-- 2,204 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
/*
   Copyright 2007 - 2008 MySQL AB, 2008 - 2010 Sun Microsystems, Inc.  All rights reserved.

   The MySQL Connector/C++ is licensed under the terms of the GPL
   <http://www.gnu.org/licenses/old-licenses/gpl-2.0.html>, like most
   MySQL Connectors. There are special exceptions to the terms and
   conditions of the GPL as it is applied to this software, see the
   FLOSS License Exception
   <http://www.mysql.com/about/legal/licensing/foss-exception.html>.
 */

#include "EscapeProcessorRegressionTest.h"

namespace testsuite
{
namespace regression
{

/**
 * Tests fix for BUG#11797 - Escape tokenizer doesn't respect stacked single
 * quotes for escapes.
 *
 * @throws Exception
 *             if the test fails.
 */

/* throws Exception */
void EscapeProcessorRegressionTest::testBug11797()
{
  ASSERT_EQUALS("select 'ESCAPED BY ''\\'' ON {tbl_name | * | *.* | db_name.*}'",
                this->conn->nativeSQL("select 'ESCAPED BY ''\\'' ON {tbl_name | * | *.* | db_name.*}'"));
}

/**
 * Tests fix for BUG#11498 - Escape processor didn't honor strings
 * demarcated with double quotes.
 *
 * @throws Exception
 *             if the test fails.
 */

/* throws Exception */
void EscapeProcessorRegressionTest::testBug11498()
{
  ASSERT_EQUALS(
                "replace into t1 (id, f1, f4) VALUES(1,\"\",\"tko { zna gdje se sakrio\"),(2,\"a\",\"sedmi { kontinentio\"),(3,\"a\",\"a } cigov si ti?\")",
                this->conn->nativeSQL("replace into t1 (id, f1, f4) VALUES(1,\"\",\"tko { zna gdje se sakrio\"),(2,\"a\",\"sedmi { kontinentio\"),(3,\"a\",\"a } cigov si ti?\")"));
}

/**
 * Tests fix for BUG#14909 - escape processor replaces quote character in
 * quoted string with string delimiter.
 *
 * @throws Exception
 */

/* throws Exception */
void EscapeProcessorRegressionTest::testBug14909()
{
  ASSERT_EQUALS("select '{\"','}'", this->conn->nativeSQL("select '{\"','}'"));
}

/**
 * Tests fix for BUG#25399 - EscapeProcessor gets confused by multiple backslashes
 *
 * @throws Exception if the test fails.
 */

/* throws Exception */
void EscapeProcessorRegressionTest::testBug25399()
{
  /*
  ASSERT_EQUALS("\\' {d}",
  getSingleValueWithQuery("SELECT '\\\\\\' {d}'"));*/

}
}
}