https://issues.apache.org/ooo/show_bug.cgi?id=121492

--- Comment #5 from hanya <[email protected]> ---
I do not know '{D ''2013-01-10'' }' is correct SQL statement but 
once I remove braces and D it worked with HSQLDB.

Index: connectivity/source/parse/sqlnode.cxx
===================================================================
--- connectivity/source/parse/sqlnode.cxx    (revision 1447781)
+++ connectivity/source/parse/sqlnode.cxx    (working copy)
@@ -1016,10 +1016,10 @@
 {
     ::rtl::OUString aEmptyString;
     OSQLParseNode* pNewNode = new OSQLInternalNode(aEmptyString,
SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::set_fct_spec));
-    pNewNode->append(new
OSQLInternalNode(::rtl::OUString::createFromAscii("{"), SQL_NODE_PUNCTUATION));
+    //pNewNode->append(new
OSQLInternalNode(::rtl::OUString::createFromAscii("{"), SQL_NODE_PUNCTUATION));
     OSQLParseNode* pDateNode = new OSQLInternalNode(aEmptyString,
SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::odbc_fct_spec));
     pNewNode->append(pDateNode);
-    pNewNode->append(new
OSQLInternalNode(::rtl::OUString::createFromAscii("}"), SQL_NODE_PUNCTUATION));
+    //pNewNode->append(new
OSQLInternalNode(::rtl::OUString::createFromAscii("}"), SQL_NODE_PUNCTUATION));

     switch (nType)
     {
@@ -2464,8 +2464,17 @@
             if (rString.getLength())
                 rString.appendAscii(" ");

-            const ::rtl::OString sT = OSQLParser::TokenIDToStr(m_nNodeID,
rParam.bInternational ? &rParam.m_rContext :  NULL);
-           
rString.append(::rtl::OUString(sT,sT.getLength(),RTL_TEXTENCODING_UTF8));
+            switch ( m_nNodeID )
+            {
+                case SQL_TOKEN_D:
+                case SQL_TOKEN_T:
+                case SQL_TOKEN_TS:
+                    break;
+                default:
+                    const ::rtl::OString sT =
OSQLParser::TokenIDToStr(m_nNodeID, rParam.bInternational ? &rParam.m_rContext
:  NULL);
+                   
rString.append(::rtl::OUString(sT,sT.getLength(),RTL_TEXTENCODING_UTF8));
+                    break;
+            }
         }   break;
         case SQL_NODE_STRING:
             if (rString.getLength())

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

Reply via email to