Merge

1 files changed, 107 insertions, 0 deletions

diff --git a/storage/ibmdb2i/db2i_misc.h b/storage/ibmdb2i/db2i_misc.h
new file mode 100644
index 00000000000..1cc3f962cfc
--- /dev/null
+++ b/storage/ibmdb2i/db2i_misc.h
@@ -0,0 +1,107 @@
+/*
+Licensed Materials - Property of IBM
+DB2 Storage Engine Enablement
+Copyright IBM Corporation 2007,2008
+All rights reserved
+
+Redistribution and use in source and binary forms, with or without modification,
+are permitted provided that the following conditions are met: 
+ (a) Redistributions of source code must retain this list of conditions, the
+     copyright notice in section {d} below, and the disclaimer following this
+     list of conditions. 
+ (b) Redistributions in binary form must reproduce this list of conditions, the
+     copyright notice in section (d) below, and the disclaimer following this
+     list of conditions, in the documentation and/or other materials provided
+     with the distribution. 
+ (c) The name of IBM may not be used to endorse or promote products derived from
+     this software without specific prior written permission. 
+ (d) The text of the required copyright notice is: 
+       Licensed Materials - Property of IBM
+       DB2 Storage Engine Enablement 
+       Copyright IBM Corporation 2007,2008 
+       All rights reserved
+
+THIS SOFTWARE IS PROVIDED BY IBM CORPORATION "AS IS" AND ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT
+SHALL IBM CORPORATION BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
+EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
+OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+CONTRACT, STRICT LIABILITY, OR TORT INCLUDING NEGLIGENCE OR OTHERWISE) ARISING
+IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY
+OF SUCH DAMAGE.
+*/
+
+#ifndef DB2I_MISC_H
+#define DB2I_MISC_H
+ 
+/**
+  Undelimit quote-delimited DB2 names in-place
+*/
+void stripExtraQuotes(char* name, uint maxLen)
+{
+  char* oldName = (char*)sql_strdup(name);
+  uint i = 0;
+  uint j = 0;
+  do
+  {
+    name[j] = oldName[i];
+    if (oldName[i] == '"' && oldName[i+1] == '"')
+      ++i;
+  } while (++j < maxLen && oldName[++i]);
+  
+  if (j == maxLen)
+    --j;
+  name[j] = 0;
+}
+
+/**
+  Convert a MySQL identifier name into a DB2 compatible format
+  
+  @parm input  The MySQL name
+  @parm output  The DB2 name
+  @parm outlen  The amount of space allocated for output
+  @parm delimit  Should delimiting quotes be placed around the converted name?
+  @parm delimitQuotes  Should quotes in the MySQL be delimited with additional quotes?
+  
+  @return FALSE if output was too small and name was truncated; TRUE otherwise
+*/
+bool convertMySQLNameToDB2Name(const char* input, 
+                               char* output, 
+                               size_t outlen,
+                               bool delimit = true,
+                               bool delimitQuotes = true)
+{
+  uint o = 0;
+  if (delimit)
+    output[o++] = '"';    
+
+  uint i = 0;
+  do
+  {
+    output[o] = input[i];
+    if (delimitQuotes && input[i] == '"')
+      output[++o] = '"';
+  } while (++o < outlen-2 && input[++i]);
+  
+  if (delimit)
+    output[o++] = '"';
+  output[min(o, outlen-1)] = 0; // This isn't the most user-friendly way to handle overflows,
+                                  // but at least its safe.
+  return (o <= outlen-1);
+}
+
+bool isUpperOrQuote(const CHARSET_INFO* cs, const char* s)
+{
+  while (*s)
+  {
+    if (my_isupper(cs, *s) || (*s == '"'))
+      ++s;
+    else
+      return false;
+  }
+  return true;
+}
+  
+#endif