PageRenderTime 82ms CodeModel.GetById 36ms RepoModel.GetById 1ms app.codeStats 0ms

/connectivity/source/parse/sqlnode.cxx

https://bitbucket.org/mst/ooo340
C++ | 2829 lines | 2333 code | 241 blank | 255 comment | 779 complexity | 7147a23ca9fe06cd985031abbf1341a9 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, LGPL-3.0, AGPL-1.0, BSD-3-Clause-No-Nuclear-License-2014, GPL-3.0, GPL-2.0, BSD-3-Clause, LGPL-2.1 
    

  1. /*************************************************************************
    2. 

  2.  *
    3. 

  3.  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
    4. 

  4.  * 
    5. 

  5.  * Copyright 2000, 2010 Oracle and/or its affiliates.
    6. 

  6.  *
    7. 

  7.  * OpenOffice.org - a multi-platform office productivity suite
    8. 

  8.  *
    9. 

  9.  * This file is part of OpenOffice.org.
    10. 

  10.  *
    11. 

  11.  * OpenOffice.org is free software: you can redistribute it and/or modify
    12. 

  12.  * it under the terms of the GNU Lesser General Public License version 3
    13. 

  13.  * only, as published by the Free Software Foundation.
    14. 

  14.  *
    15. 

  15.  * OpenOffice.org is distributed in the hope that it will be useful,
    16. 

  16.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
    17. 

  17.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    18. 

  18.  * GNU Lesser General Public License version 3 for more details
    19. 

  19.  * (a copy is included in the LICENSE file that accompanied this code).
    20. 

  20.  *
    21. 

  21.  * You should have received a copy of the GNU Lesser General Public License
    22. 

  22.  * version 3 along with OpenOffice.org.  If not, see
    23. 

  23.  * <http://www.openoffice.org/license.html>
    24. 

  24.  * for a copy of the LGPLv3 License.
    25. 

  25.  *
    26. 

  26.  ************************************************************************/
    27. 

  27. 

  28. // MARKER(update_precomp.py): autogen include statement, do not remove
    29. 

  29. #include "precompiled_connectivity.hxx"
    30. 

  30. 

  31. 

  32. #include <connectivity/sqlnode.hxx>
    33. 

  33. #include <connectivity/sqlerror.hxx>
    34. 

  34. #include <internalnode.hxx>
    35. 

  35. #define YYBISON	  1
    36. 

  36. #ifndef BISON_INCLUDED
    37. 

  37. #define BISON_INCLUDED
    38. 

  38. #include <sqlbison.hxx>
    39. 

  39. #endif
    40. 

  40. #include <connectivity/sqlparse.hxx>
    41. 

  41. #include <com/sun/star/lang/Locale.hpp>
    42. 

  42. #include <com/sun/star/util/XNumberFormatter.hpp>
    43. 

  43. #include <com/sun/star/util/XNumberFormatTypes.hpp>
    44. 

  44. #include <com/sun/star/i18n/NumberFormatIndex.hpp>
    45. 

  45. #include <com/sun/star/beans/XPropertySet.hpp>
    46. 

  46. #include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
    47. 

  47. #include <com/sun/star/sdbc/DataType.hpp>
    48. 

  48. #include <com/sun/star/sdb/XQueriesSupplier.hpp>
    49. 

  49. #include <com/sun/star/sdb/ErrorCondition.hpp>
    50. 

  50. #include <com/sun/star/util/XNumberFormatter.hpp>
    51. 

  51. #include <com/sun/star/util/XNumberFormatsSupplier.hpp>
    52. 

  52. #include <com/sun/star/util/XNumberFormats.hpp>
    53. 

  53. #include <com/sun/star/util/NumberFormat.hpp>
    54. 

  54. #include <com/sun/star/util/XNumberFormatTypes.hpp>
    55. 

  55. #include <com/sun/star/lang/Locale.hpp>
    56. 

  56. #include <com/sun/star/i18n/KParseType.hpp>
    57. 

  57. #include <com/sun/star/i18n/KParseTokens.hpp>
    58. 

  58. #include "connectivity/dbconversion.hxx"
    59. 

  59. #include <com/sun/star/util/DateTime.hpp>
    60. 

  60. #include <com/sun/star/util/Time.hpp>
    61. 

  61. #include <com/sun/star/util/Date.hpp>
    62. 

  62. #include "TConnection.hxx"
    63. 

  63. #include "sqlscan.hxx"
    64. 

  64. #include <comphelper/numbers.hxx>
    65. 

  65. #include <comphelper/processfactory.hxx>
    66. 

  66. #include <comphelper/stl_types.hxx>
    67. 

  67. #include "connectivity/dbtools.hxx"
    68. 

  68. #include "connectivity/dbmetadata.hxx"
    69. 

  69. #include "connectivity/sqlerror.hxx"
    70. 

  70. #include <tools/diagnose_ex.h>
    71. 

  71. #include <string.h>
    72. 

  72. #include <boost/bind.hpp>
    73. 

  73. #include <algorithm>
    74. 

  74. #include <functional>
    75. 

  75. #include <rtl/logfile.hxx>
    76. 

  76. #include <rtl/ustrbuf.hxx>
    77. 

  77. 

  78. using namespace ::com::sun::star::sdbc;
    79. 

  79. using namespace ::com::sun::star::util;
    80. 

  80. using namespace ::com::sun::star::beans;
    81. 

  81. using namespace ::com::sun::star::sdb;
    82. 

  82. using namespace ::com::sun::star::uno;
    83. 

  83. using namespace ::com::sun::star::lang;
    84. 

  84. using namespace ::com::sun::star::i18n;
    85. 

  85. using namespace ::com::sun::star;
    86. 

  86. using namespace ::osl;
    87. 

  87. using namespace ::dbtools;
    88. 

  88. using namespace ::comphelper;
    89. 

  89. 

  90. 

  91. extern int SQLyyparse (void);
    92. 

  92. extern ::rtl::OUString ConvertLikeToken(const ::connectivity::OSQLParseNode* pTokenNode, const ::connectivity::OSQLParseNode* pEscapeNode, sal_Bool bInternational);
    93. 

  93. extern void setParser( ::connectivity::OSQLParser* );
    94. 

  94. 

  95. namespace
    96. 

  96. {
    97. 

  97.     // -----------------------------------------------------------------------------
    98. 

  98. 	sal_Bool lcl_saveConvertToNumber(const Reference< XNumberFormatter > & _xFormatter,sal_Int32 _nKey,const ::rtl::OUString& _sValue,double& _nrValue)
    99. 

  99. 	{
    100. 

  100. 		sal_Bool bRet = sal_False;
    101. 

  101. 		try
    102. 

  102. 		{
    103. 

  103. 			_nrValue = _xFormatter->convertStringToNumber(_nKey, _sValue);
    104. 

  104. 			bRet = sal_True;
    105. 

  105. 		}
    106. 

  106. 		catch(Exception&)
    107. 

  107. 		{
    108. 

  108. 		}
    109. 

  109. 		return bRet;
    110. 

  110. 	}
    111. 

  111.     // -----------------------------------------------------------------------------
    112. 

  112.     void replaceAndReset(connectivity::OSQLParseNode*& _pResetNode,connectivity::OSQLParseNode* _pNewNode)
    113. 

  113.     {
    114. 

  114.         _pResetNode->getParent()->replace(_pResetNode, _pNewNode);
    115. 

  115.         delete _pResetNode;
    116. 

  116.         _pResetNode = _pNewNode;
    117. 

  117.     }
    118. 

  118.     // -----------------------------------------------------------------------------
    119. 

  119.     /** quotes a string and search for quotes inside the string and replace them with the new quote
    120. 

  120.         @param  rValue
    121. 

  121.             The value to be quoted.
    122. 

  122.         @param  rQuot
    123. 

  123.             The quote
    124. 

  124.         @param  rQuotToReplace
    125. 

  125.             The quote to replace with
    126. 

  126.         @return
    127. 

  127.             The quoted string.
    128. 

  128.     */
    129. 

  129.     ::rtl::OUString SetQuotation(const ::rtl::OUString& rValue, const ::rtl::OUString& rQuot, const ::rtl::OUString& rQuotToReplace)
    130. 

  130.     {
    131. 

  131.         ::rtl::OUString rNewValue = rQuot;
    132. 

  132.         rNewValue += rValue;
    133. 

  133.         sal_Int32 nIndex = (sal_Int32)-1;   // Quotes durch zweifache Quotes ersetzen, sonst kriegt der Parser Probleme
    134. 

  134. 

  135.         if (rQuot.getLength())
    136. 

  136.         {
    137. 

  137.             do
    138. 

  138.             {
    139. 

  139.                 nIndex += 2;
    140. 

  140.                 nIndex = rNewValue.indexOf(rQuot,nIndex);
    141. 

  141.                 if(nIndex != -1)
    142. 

  142.                     rNewValue = rNewValue.replaceAt(nIndex,rQuot.getLength(),rQuotToReplace);
    143. 

  143.             } while (nIndex != -1);
    144. 

  144.         }
    145. 

  145. 

  146.         rNewValue += rQuot;
    147. 

  147.         return rNewValue;
    148. 

  148.     }
    149. 

  149. }
    150. 

  150. 

  151. namespace connectivity
    152. 

  152. {
    153. 

  153. 

  154. //=============================================================================
    155. 

  155. struct OSQLParser_Data
    156. 

  156. {
    157. 

  157.     ::com::sun::star::lang::Locale  aLocale;
    158. 

  158.     ::connectivity::SQLError        aErrors;
    159. 

  159. 

  160.     OSQLParser_Data( const Reference< XMultiServiceFactory >& _xServiceFactory )
    161. 

  161.         :aErrors( _xServiceFactory )
    162. 

  162.     {
    163. 

  163.     }
    164. 

  164. };
    165. 

  165. 

  166. //=============================================================================
    167. 

  167. //= SQLParseNodeParameter
    168. 

  168. //=============================================================================
    169. 

  169. //-----------------------------------------------------------------------------
    170. 

  170. SQLParseNodeParameter::SQLParseNodeParameter( const Reference< XConnection >& _rxConnection,
    171. 

  171. 		const Reference< XNumberFormatter >& _xFormatter, const Reference< XPropertySet >& _xField,
    172. 

  172. 		const Locale& _rLocale, const IParseContext* _pContext,
    173. 

  173.         bool _bIntl, bool _bQuote, sal_Char _cDecSep, bool _bPredicate, bool _bParseToSDBC )
    174. 

  174.     :rLocale(_rLocale)
    175. 

  175.     ,aMetaData( _rxConnection )
    176. 

  176.     ,pParser( NULL )
    177. 

  177.     ,pSubQueryHistory( new QueryNameSet )
    178. 

  178.     ,xFormatter(_xFormatter)
    179. 

  179.     ,xField(_xField)
    180. 

  180.     ,m_rContext( _pContext ? (const IParseContext&)(*_pContext) : (const IParseContext&)OSQLParser::s_aDefaultContext )
    181. 

  181.     ,cDecSep(_cDecSep)
    182. 

  182.     ,bQuote(_bQuote)
    183. 

  183. 	,bInternational(_bIntl)
    184. 

  184. 	,bPredicate(_bPredicate)
    185. 

  185.     ,bParseToSDBCLevel( _bParseToSDBC )
    186. 

  186. {
    187. 

  187. }
    188. 

  188. 

  189. //-----------------------------------------------------------------------------
    190. 

  190. SQLParseNodeParameter::~SQLParseNodeParameter()
    191. 

  191. {
    192. 

  192. }
    193. 

  193. 

  194. //=============================================================================
    195. 

  195. //= OSQLParseNode
    196. 

  196. //=============================================================================
    197. 

  197. //-----------------------------------------------------------------------------
    198. 

  198. ::rtl::OUString OSQLParseNode::convertDateString(const SQLParseNodeParameter& rParam, const ::rtl::OUString& rString) const
    199. 

  199. {
    200. 

  200.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::convertDateString" );
    201. 

  201. 	Date aDate = DBTypeConversion::toDate(rString);
    202. 

  202. 	Reference< XNumberFormatsSupplier > xSupplier(rParam.xFormatter->getNumberFormatsSupplier());
    203. 

  203. 	Reference< XNumberFormatTypes >		xTypes(xSupplier->getNumberFormats(), UNO_QUERY);
    204. 

  204. 

  205. 	double fDate = DBTypeConversion::toDouble(aDate,DBTypeConversion::getNULLDate(xSupplier));
    206. 

  206. 	sal_Int32 nKey = xTypes->getStandardIndex(rParam.rLocale) + 36; // XXX hack
    207. 

  207. 	return rParam.xFormatter->convertNumberToString(nKey, fDate);
    208. 

  208. }
    209. 

  209. 

  210. //-----------------------------------------------------------------------------
    211. 

  211. ::rtl::OUString OSQLParseNode::convertDateTimeString(const SQLParseNodeParameter& rParam, const ::rtl::OUString& rString) const
    212. 

  212. {
    213. 

  213.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::convertDateTimeString" );
    214. 

  214. 	DateTime aDate = DBTypeConversion::toDateTime(rString);
    215. 

  215. 	Reference< XNumberFormatsSupplier >  xSupplier(rParam.xFormatter->getNumberFormatsSupplier());
    216. 

  216. 	Reference< XNumberFormatTypes >  xTypes(xSupplier->getNumberFormats(), UNO_QUERY);
    217. 

  217. 

  218. 	double fDateTime = DBTypeConversion::toDouble(aDate,DBTypeConversion::getNULLDate(xSupplier));
    219. 

  219. 	sal_Int32 nKey = xTypes->getStandardIndex(rParam.rLocale) + 51; // XXX hack
    220. 

  220. 	return rParam.xFormatter->convertNumberToString(nKey, fDateTime);
    221. 

  221. }
    222. 

  222. 

  223. //-----------------------------------------------------------------------------
    224. 

  224. ::rtl::OUString OSQLParseNode::convertTimeString(const SQLParseNodeParameter& rParam, const ::rtl::OUString& rString) const
    225. 

  225. {
    226. 

  226.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::convertTimeString" );
    227. 

  227. 	Time aTime = DBTypeConversion::toTime(rString);
    228. 

  228. 	Reference< XNumberFormatsSupplier >  xSupplier(rParam.xFormatter->getNumberFormatsSupplier());
    229. 

  229. 

  230. 	Reference< XNumberFormatTypes >  xTypes(xSupplier->getNumberFormats(), UNO_QUERY);
    231. 

  231. 

  232. 	double fTime = DBTypeConversion::toDouble(aTime);
    233. 

  233. 	sal_Int32 nKey = xTypes->getStandardIndex(rParam.rLocale) + 41; // XXX hack
    234. 

  234. 	return rParam.xFormatter->convertNumberToString(nKey, fTime);
    235. 

  235. }
    236. 

  236. 

  237. //-----------------------------------------------------------------------------
    238. 

  238. void OSQLParseNode::parseNodeToStr(::rtl::OUString& rString,
    239. 

  239. 								   const Reference< XConnection >& _rxConnection,
    240. 

  240. 								   const IParseContext* pContext,
    241. 

  241. 								   sal_Bool _bIntl,
    242. 

  242. 								   sal_Bool _bQuote) const
    243. 

  243. {
    244. 

  244.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseNodeToStr" );
    245. 

  245. 

  246. 	parseNodeToStr(
    247. 

  247. 		rString, _rxConnection, NULL, NULL,
    248. 

  248. 		pContext ? pContext->getPreferredLocale() : OParseContext::getDefaultLocale(),
    249. 

  249. 		pContext, _bIntl, _bQuote, '.', false, false );
    250. 

  250. }
    251. 

  251. 

  252. //-----------------------------------------------------------------------------
    253. 

  253. void OSQLParseNode::parseNodeToPredicateStr(::rtl::OUString& rString,
    254. 

  254. 											  const Reference< XConnection >& _rxConnection,
    255. 

  255. 											  const Reference< XNumberFormatter > & xFormatter,
    256. 

  256. 											  const ::com::sun::star::lang::Locale& rIntl,
    257. 

  257. 											  sal_Char _cDec,
    258. 

  258. 											  const IParseContext* pContext ) const
    259. 

  259. {
    260. 

  260.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseNodeToPredicateStr" );
    261. 

  261. 

  262. 	OSL_ENSURE(xFormatter.is(), "OSQLParseNode::parseNodeToPredicateStr:: no formatter!");
    263. 

  263. 

  264. 	if (xFormatter.is())
    265. 

  265. 		parseNodeToStr(rString, _rxConnection, xFormatter, NULL, rIntl, pContext, sal_True, sal_True, _cDec, true, false);
    266. 

  266. }
    267. 

  267. 

  268. //-----------------------------------------------------------------------------
    269. 

  269. void OSQLParseNode::parseNodeToPredicateStr(::rtl::OUString& rString,
    270. 

  270. 											  const Reference< XConnection > & _rxConnection,
    271. 

  271. 											  const Reference< XNumberFormatter > & xFormatter,
    272. 

  272. 											  const Reference< XPropertySet > & _xField,
    273. 

  273. 											  const ::com::sun::star::lang::Locale& rIntl,
    274. 

  274. 											  sal_Char _cDec,
    275. 

  275. 											  const IParseContext* pContext ) const
    276. 

  276. {
    277. 

  277.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseNodeToPredicateStr" );
    278. 

  278. 

  279. 	OSL_ENSURE(xFormatter.is(), "OSQLParseNode::parseNodeToPredicateStr:: no formatter!");
    280. 

  280. 

  281. 	if (xFormatter.is())
    282. 

  282. 		parseNodeToStr( rString, _rxConnection, xFormatter, _xField, rIntl, pContext, true, true, _cDec, true, false );
    283. 

  283. }
    284. 

  284. 

  285. //-----------------------------------------------------------------------------
    286. 

  286. void OSQLParseNode::parseNodeToStr(::rtl::OUString& rString,
    287. 

  287. 					  const Reference< XConnection > & _rxConnection,
    288. 

  288. 					  const Reference< XNumberFormatter > & xFormatter,
    289. 

  289. 					  const Reference< XPropertySet > & _xField,
    290. 

  290. 					  const ::com::sun::star::lang::Locale& rIntl,
    291. 

  291. 					  const IParseContext* pContext,
    292. 

  292. 					  bool _bIntl,
    293. 

  293. 					  bool _bQuote,
    294. 

  294. 					  sal_Char _cDecSep,
    295. 

  295. 					  bool _bPredicate,
    296. 

  296.                       bool _bSubstitute) const
    297. 

  297. {
    298. 

  298.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseNodeToStr" );
    299. 

  299. 

  300. 	OSL_ENSURE( _rxConnection.is(), "OSQLParseNode::parseNodeToStr: invalid connection!" );
    301. 

  301. 

  302. 	if ( _rxConnection.is() )
    303. 

  303. 	{
    304. 

  304.         ::rtl::OUStringBuffer sBuffer = rString;
    305. 

  305.         try
    306. 

  306.         {
    307. 

  307. 		    OSQLParseNode::impl_parseNodeToString_throw( sBuffer,
    308. 

  308. 			    SQLParseNodeParameter(
    309. 

  309.                     _rxConnection, xFormatter, _xField, rIntl, pContext,
    310. 

  310.                     _bIntl, _bQuote, _cDecSep, _bPredicate, _bSubstitute
    311. 

  311.                 ) );
    312. 

  312.         }
    313. 

  313.         catch( const SQLException& )
    314. 

  314.         {
    315. 

  315.             OSL_ENSURE( false, "OSQLParseNode::parseNodeToStr: this should not throw!" );
    316. 

  316.             // our callers don't expect this method to throw anything. The only known situation
    317. 

  317.             // where impl_parseNodeToString_throw can throw is when there is a cyclic reference
    318. 

  318.             // in the sub queries, but this cannot be the case here, as we do not parse to
    319. 

  319.             // SDBC level.
    320. 

  320.         }
    321. 

  321.         rString = sBuffer.makeStringAndClear();
    322. 

  322. 	}
    323. 

  323. }
    324. 

  324. //-----------------------------------------------------------------------------
    325. 

  325. bool OSQLParseNode::parseNodeToExecutableStatement( ::rtl::OUString& _out_rString, const Reference< XConnection >& _rxConnection,
    326. 

  326.     OSQLParser& _rParser, ::com::sun::star::sdbc::SQLException* _pErrorHolder ) const
    327. 

  327. {
    328. 

  328.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseNodeToExecutableStatement" );
    329. 

  329.     OSL_PRECOND( _rxConnection.is(), "OSQLParseNode::parseNodeToExecutableStatement: invalid connection!" );
    330. 

  330.     SQLParseNodeParameter aParseParam( _rxConnection,
    331. 

  331.         NULL, NULL, OParseContext::getDefaultLocale(), NULL, false, true, '.', false, true );
    332. 

  332. 

  333.     if ( aParseParam.aMetaData.supportsSubqueriesInFrom() )
    334. 

  334.     {
    335. 

  335.         Reference< XQueriesSupplier > xSuppQueries( _rxConnection, UNO_QUERY );
    336. 

  336.         OSL_ENSURE( xSuppQueries.is(), "OSQLParseNode::parseNodeToExecutableStatement: cannot substitute everything without a QueriesSupplier!" );
    337. 

  337.         if ( xSuppQueries.is() )
    338. 

  338.             aParseParam.xQueries = xSuppQueries->getQueries();
    339. 

  339.     }
    340. 

  340. 

  341.     aParseParam.pParser = &_rParser;
    342. 

  342. 

  343.     _out_rString = ::rtl::OUString();
    344. 

  344.     ::rtl::OUStringBuffer sBuffer;
    345. 

  345.     bool bSuccess = false;
    346. 

  346.     try
    347. 

  347.     {
    348. 

  348.         impl_parseNodeToString_throw( sBuffer, aParseParam );
    349. 

  349.         bSuccess = true;
    350. 

  350.     }
    351. 

  351.     catch( const SQLException& e )
    352. 

  352.     {
    353. 

  353.         if ( _pErrorHolder )
    354. 

  354.             *_pErrorHolder = e;
    355. 

  355.     }
    356. 

  356.     _out_rString = sBuffer.makeStringAndClear();
    357. 

  357.     return bSuccess;
    358. 

  358. }
    359. 

  359. 

  360. //-----------------------------------------------------------------------------
    361. 

  361. namespace
    362. 

  362. {
    363. 

  363.     bool lcl_isAliasNamePresent( const OSQLParseNode& _rTableNameNode )
    364. 

  364.     {
    365. 

  365.         return OSQLParseNode::getTableRange(_rTableNameNode.getParent()).getLength() != 0;
    366. 

  366.     }
    367. 

  367. }
    368. 

  368. 

  369. //-----------------------------------------------------------------------------
    370. 

  370. void OSQLParseNode::impl_parseNodeToString_throw(::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam) const
    371. 

  371. {
    372. 

  372.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::getTableRange" );
    373. 

  373.     if ( isToken() )
    374. 

  374.     {
    375. 

  375. 		parseLeaf(rString,rParam);
    376. 

  376.         return;
    377. 

  377.     }
    378. 

  378. 

  379. 	// einmal auswerten wieviel Subtrees dieser Knoten besitzt
    380. 

  380. 	sal_uInt32 nCount = count();
    381. 

  381. 

  382.     bool bHandled = false;
    383. 

  383.     switch ( getKnownRuleID() )
    384. 

  384.     {
    385. 

  385.     // special handling for parameters
    386. 

  386.     case parameter:
    387. 

  387.     {
    388. 

  388. 		if(rString.getLength())
    389. 

  389. 			rString.appendAscii(" ");
    390. 

  390. 		if (nCount == 1)	// ?
    391. 

  391. 			m_aChildren[0]->impl_parseNodeToString_throw( rString, rParam );
    392. 

  392. 		else if (nCount == 2)	// :Name
    393. 

  393. 		{
    394. 

  394. 			m_aChildren[0]->impl_parseNodeToString_throw( rString, rParam );
    395. 

  395. 			rString.append(m_aChildren[1]->m_aNodeValue);
    396. 

  396. 		}				    // [Name]
    397. 

  397. 		else
    398. 

  398. 		{
    399. 

  399. 			m_aChildren[0]->impl_parseNodeToString_throw( rString, rParam );
    400. 

  400. 			rString.append(m_aChildren[1]->m_aNodeValue);
    401. 

  401. 			rString.append(m_aChildren[2]->m_aNodeValue);
    402. 

  402. 		}
    403. 

  403.         bHandled = true;
    404. 

  404. 	}
    405. 

  405.     break;
    406. 

  406. 

  407.     // table refs
    408. 

  408.     case table_ref:
    409. 

  409.         if (  ( nCount == 2 ) || ( nCount == 3 ) || ( nCount == 5 ) )
    410. 

  410.         {
    411. 

  411. 		    impl_parseTableRangeNodeToString_throw( rString, rParam );
    412. 

  412.             bHandled = true;
    413. 

  413.         }
    414. 

  414.         break;
    415. 

  415. 

  416.     // table name - might be a query name
    417. 

  417.     case table_name:
    418. 

  418.         bHandled = impl_parseTableNameNodeToString_throw( rString, rParam );
    419. 

  419.         break;
    420. 

  420. 

  421.     case as:
    422. 

  422.         if ( rParam.aMetaData.generateASBeforeCorrelationName() )
    423. 

  423.             rString.append(::rtl::OUString::createFromAscii( " AS" ));
    424. 

  424.         bHandled = true;
    425. 

  425.         break;
    426. 

  426. 

  427.     case like_predicate:
    428. 

  428. 	    // je nachdem ob international angegeben wird oder nicht wird like anders behandelt
    429. 

  429. 	    // interanational: *, ? sind Platzhalter
    430. 

  430. 	    // sonst SQL92 konform: %, _
    431. 

  431. 		impl_parseLikeNodeToString_throw( rString, rParam );
    432. 

  432.         bHandled = true;
    433. 

  433.         break;
    434. 

  434. 

  435.     case general_set_fct:
    436. 

  436.     case set_fct_spec:
    437. 

  437.     case position_exp:
    438. 

  438.     case extract_exp:
    439. 

  439.     case length_exp:
    440. 

  440.     case char_value_fct:
    441. 

  441. 	{
    442. 

  442. 		if (!addDateValue(rString, rParam))
    443. 

  443. 		{
    444. 

  444. 			// Funktionsname nicht quoten
    445. 

  445. 			SQLParseNodeParameter aNewParam(rParam);
    446. 

  446. 			aNewParam.bQuote = ( SQL_ISRULE(this,length_exp)	|| SQL_ISRULE(this,char_value_fct) );
    447. 

  447. 

  448. 			m_aChildren[0]->impl_parseNodeToString_throw( rString, aNewParam );
    449. 

  449. 			aNewParam.bQuote = rParam.bQuote;
    450. 

  450. 			//aNewParam.bPredicate = sal_False; // disable [ ] around names // look at i73215 
    451. 

  451. 			::rtl::OUStringBuffer aStringPara;
    452. 

  452. 			for (sal_uInt32 i=1; i<nCount; i++)
    453. 

  453. 			{
    454. 

  454. 				const OSQLParseNode * pSubTree = m_aChildren[i];
    455. 

  455. 				if (pSubTree)
    456. 

  456. 				{
    457. 

  457. 					pSubTree->impl_parseNodeToString_throw( aStringPara, aNewParam );
    458. 

  458. 

  459. 					// bei den CommaListen zwischen alle Subtrees Commas setzen
    460. 

  460. 					if ((m_eNodeType == SQL_NODE_COMMALISTRULE) 	&& (i < (nCount - 1)))
    461. 

  461. 						aStringPara.appendAscii(",");
    462. 

  462. 				}
    463. 

  463.                 else
    464. 

  464.                     i++;
    465. 

  465. 			}
    466. 

  466. 			rString.append(aStringPara.makeStringAndClear());
    467. 

  467. 		}
    468. 

  468.         bHandled = true;
    469. 

  469. 	}
    470. 

  470.     break;
    471. 

  471.     default:
    472. 

  472.         break;
    473. 

  473.     }   // switch ( getKnownRuleID() )
    474. 

  474. 

  475.     if ( !bHandled )
    476. 

  476. 	{
    477. 

  477. 		for (OSQLParseNodes::const_iterator i = m_aChildren.begin();
    478. 

  478. 			i != m_aChildren.end();)
    479. 

  479. 		{
    480. 

  480. 			const OSQLParseNode* pSubTree = *i;
    481. 

  481. 			if ( !pSubTree )
    482. 

  482.             {
    483. 

  483.                 ++i;
    484. 

  484.                 continue;
    485. 

  485.             }
    486. 

  486. 

  487. 			SQLParseNodeParameter aNewParam(rParam);
    488. 

  488. 

  489. 			// don't replace the field for subqueries
    490. 

  490. 			if (rParam.xField.is() && SQL_ISRULE(pSubTree,subquery))
    491. 

  491. 				aNewParam.xField = NULL;
    492. 

  492. 

  493. 			// if there is a field given we don't display the fieldname, if there is any
    494. 

  494. 			if (rParam.xField.is() && SQL_ISRULE(pSubTree,column_ref))
    495. 

  495. 			{
    496. 

  496. 				sal_Bool bFilter = sal_False;
    497. 

  497. 				// retrieve the fields name
    498. 

  498. 				::rtl::OUString aFieldName;
    499. 

  499. 				try
    500. 

  500. 				{
    501. 

  501. 					sal_Int32 nNamePropertyId = PROPERTY_ID_NAME;
    502. 

  502. 					if ( rParam.xField->getPropertySetInfo()->hasPropertyByName( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_REALNAME ) ) )
    503. 

  503. 						nNamePropertyId = PROPERTY_ID_REALNAME;
    504. 

  504. 					rParam.xField->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( nNamePropertyId ) ) >>= aFieldName;
    505. 

  505. 				}
    506. 

  506. 				catch ( Exception& )
    507. 

  507. 				{
    508. 

  508. 				}
    509. 

  509. 

  510. 				if(pSubTree->count())
    511. 

  511. 				{
    512. 

  512. 					const OSQLParseNode* pCol = pSubTree->m_aChildren[pSubTree->count()-1];
    513. 

  513. 					if	(	(	SQL_ISRULE(pCol,column_val)
    514. 

  514. 							&&	pCol->getChild(0)->getTokenValue().equalsIgnoreAsciiCase(aFieldName)
    515. 

  515. 							)
    516. 

  516. 						||	pCol->getTokenValue().equalsIgnoreAsciiCase(aFieldName)
    517. 

  517. 						)
    518. 

  518. 						bFilter = sal_True;
    519. 

  519. 				}
    520. 

  520. 

  521. 				// ok we found the field, if the following node is the
    522. 

  522. 				// comparision operator '=' we filter it as well
    523. 

  523. 				if (bFilter)
    524. 

  524. 				{
    525. 

  525. 					if (SQL_ISRULE(this, comparison_predicate))
    526. 

  526. 					{
    527. 

  527. 						++i;
    528. 

  528. 						if(i != m_aChildren.end())
    529. 

  529. 						{
    530. 

  530. 							pSubTree = *i;
    531. 

  531. 							if (pSubTree && pSubTree->getNodeType() == SQL_NODE_EQUAL)
    532. 

  532. 								i++;
    533. 

  533. 						}
    534. 

  534. 					}
    535. 

  535. 					else
    536. 

  536. 						i++;
    537. 

  537. 				}
    538. 

  538. 				else
    539. 

  539. 				{
    540. 

  540. 					pSubTree->impl_parseNodeToString_throw( rString, aNewParam );
    541. 

  541. 					i++;
    542. 

  542. 

  543. 					// bei den CommaListen zwischen alle Subtrees Commas setzen
    544. 

  544. 					if ((m_eNodeType == SQL_NODE_COMMALISTRULE) 	&& (i != m_aChildren.end()))
    545. 

  545. 						rString.appendAscii(",");
    546. 

  546. 				}
    547. 

  547. 			}
    548. 

  548. 			else
    549. 

  549. 			{
    550. 

  550. 				pSubTree->impl_parseNodeToString_throw( rString, aNewParam );
    551. 

  551. 				i++;
    552. 

  552. 

  553. 				// bei den CommaListen zwischen alle Subtrees Commas setzen
    554. 

  554. 				if ((m_eNodeType == SQL_NODE_COMMALISTRULE) 	&& (i != m_aChildren.end()))
    555. 

  555. 				{
    556. 

  556. 					if (SQL_ISRULE(this,value_exp_commalist) && rParam.bPredicate)
    557. 

  557. 						rString.appendAscii(";");
    558. 

  558. 					else
    559. 

  559. 						rString.appendAscii(",");
    560. 

  560. 				}
    561. 

  561. 			}
    562. 

  562. 		}
    563. 

  563. 	}
    564. 

  564. }
    565. 

  565. 

  566. //-----------------------------------------------------------------------------
    567. 

  567. bool OSQLParseNode::impl_parseTableNameNodeToString_throw( ::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam ) const
    568. 

  568. {
    569. 

  569.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::impl_parseTableNameNodeToString_throw" );
    570. 

  570.     // is the table_name part of a table_ref?
    571. 

  571.     OSL_ENSURE( getParent(), "OSQLParseNode::impl_parseTableNameNodeToString_throw: table_name without parent?" );
    572. 

  572.     if ( !getParent() || ( getParent()->getKnownRuleID() != table_ref ) )
    573. 

  573.         return false;
    574. 

  574. 

  575.     // if it's a query, maybe we need to substitute the SQL statement ...
    576. 

  576.     if ( !rParam.bParseToSDBCLevel )
    577. 

  577.         return false;
    578. 

  578. 

  579.     if ( !rParam.xQueries.is() )
    580. 

  580.         // connection does not support queries in queries, or was no query supplier
    581. 

  581.         return false;
    582. 

  582. 

  583.     try
    584. 

  584.     {
    585. 

  585.         ::rtl::OUString sTableOrQueryName( getChild(0)->getTokenValue() );
    586. 

  586.         bool bIsQuery = rParam.xQueries->hasByName( sTableOrQueryName );
    587. 

  587.         if ( !bIsQuery )
    588. 

  588.             return false;
    589. 

  589. 

  590.         // avoid recursion (e.g. "foo" defined as "SELECT * FROM bar" and "bar" defined as "SELECT * FROM foo".
    591. 

  591.         if ( rParam.pSubQueryHistory->find( sTableOrQueryName ) != rParam.pSubQueryHistory->end() )
    592. 

  592.         {
    593. 

  593.             ::rtl::OUString sMessage( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "cyclic sub queries" ) ) );
    594. 

  594.             OSL_ENSURE( rParam.pParser, "OSQLParseNode::impl_parseTableNameNodeToString_throw: no parser?" );
    595. 

  595.             if ( rParam.pParser )
    596. 

  596.             {
    597. 

  597.                 const SQLError& rErrors( rParam.pParser->getErrorHelper() );
    598. 

  598.                 rErrors.raiseException( sdb::ErrorCondition::PARSER_CYCLIC_SUB_QUERIES );
    599. 

  599.             }
    600. 

  600.             else
    601. 

  601.             {
    602. 

  602.                 SQLError aErrors( ::comphelper::getProcessServiceFactory() );
    603. 

  603.                 aErrors.raiseException( sdb::ErrorCondition::PARSER_CYCLIC_SUB_QUERIES );
    604. 

  604.             }
    605. 

  605.         }
    606. 

  606.         rParam.pSubQueryHistory->insert( sTableOrQueryName );
    607. 

  607. 

  608.         Reference< XPropertySet > xQuery( rParam.xQueries->getByName( sTableOrQueryName ), UNO_QUERY_THROW );
    609. 

  609. 

  610.         // substitute the query name with the constituting command
    611. 

  611.         ::rtl::OUString sCommand;
    612. 

  612.         OSL_VERIFY( xQuery->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_COMMAND ) ) >>= sCommand );
    613. 

  613. 

  614.         sal_Bool bEscapeProcessing = sal_False;
    615. 

  615.         OSL_VERIFY( xQuery->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_ESCAPEPROCESSING ) ) >>= bEscapeProcessing );
    616. 

  616. 

  617.         // the query we found here might itself be based on another query, so parse it recursively
    618. 

  618.         OSL_ENSURE( rParam.pParser, "OSQLParseNode::impl_parseTableNameNodeToString_throw: cannot analyze sub queries without a parser!" );
    619. 

  619.         if ( bEscapeProcessing && rParam.pParser )
    620. 

  620.         {
    621. 

  621.             ::rtl::OUString sError;
    622. 

  622.             ::std::auto_ptr< OSQLParseNode > pSubQueryNode( rParam.pParser->parseTree( sError, sCommand, sal_False ) );
    623. 

  623.             if ( pSubQueryNode.get() )
    624. 

  624.             {
    625. 

  625.                 // parse the sub-select to SDBC level, too
    626. 

  626.                 ::rtl::OUStringBuffer sSubSelect;
    627. 

  627.                 pSubQueryNode->impl_parseNodeToString_throw( sSubSelect, rParam );
    628. 

  628.                 if ( sSubSelect.getLength() )
    629. 

  629.                     sCommand = sSubSelect.makeStringAndClear();
    630. 

  630.             }
    631. 

  631.         }
    632. 

  632. 

  633.         rString.appendAscii( " ( " );
    634. 

  634.         rString.append(sCommand);
    635. 

  635.         rString.appendAscii( " )" );
    636. 

  636. 

  637.         // append the query name as table alias, since it might be referenced in other
    638. 

  638.         // parts of the statement - but only if there's no other alias name present
    639. 

  639.         if ( !lcl_isAliasNamePresent( *this ) )
    640. 

  640.         {
    641. 

  641.             rString.appendAscii( " AS " );
    642. 

  642.             if ( rParam.bQuote )
    643. 

  643.                 rString.append(SetQuotation( sTableOrQueryName,
    644. 

  644.                     rParam.aMetaData.getIdentifierQuoteString(), rParam.aMetaData.getIdentifierQuoteString() ));
    645. 

  645.         }
    646. 

  646. 

  647.         // don't forget to remove the query name from the history, else multiple inclusions
    648. 

  648.         // won't work
    649. 

  649.         // #i69227# / 2006-10-10 / frank.schoenheit@sun.com
    650. 

  650.         rParam.pSubQueryHistory->erase( sTableOrQueryName );
    651. 

  651. 

  652.         return true;
    653. 

  653.     }
    654. 

  654.     catch( const SQLException& )
    655. 

  655.     {
    656. 

  656.         throw;
    657. 

  657.     }
    658. 

  658.     catch( const Exception& )
    659. 

  659.     {
    660. 

  660.         DBG_UNHANDLED_EXCEPTION();
    661. 

  661.     }
    662. 

  662.     return false;
    663. 

  663. }
    664. 

  664. 

  665. //-----------------------------------------------------------------------------
    666. 

  666. void OSQLParseNode::impl_parseTableRangeNodeToString_throw(::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam) const
    667. 

  667. {
    668. 

  668.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::impl_parseTableRangeNodeToString_throw" );
    669. 

  669.     OSL_PRECOND(  ( count() == 2 ) || ( count() == 3 ) || ( count() == 5 ) ,"Illegal count");
    670. 

  670. 	
    671. 

  671. 	// rString += ::rtl::OUString::createFromAscii(" ");
    672. 

  672.     ::std::for_each(m_aChildren.begin(),m_aChildren.end(),
    673. 

  673.         boost::bind( &OSQLParseNode::impl_parseNodeToString_throw, _1, boost::ref( rString ), boost::cref( rParam ) ));
    674. 

  674. }
    675. 

  675. 

  676. //-----------------------------------------------------------------------------
    677. 

  677. void OSQLParseNode::impl_parseLikeNodeToString_throw( ::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam ) const
    678. 

  678. {
    679. 

  679.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::impl_parseLikeNodeToString_throw" );
    680. 

  680. 	OSL_ENSURE(count() >= 4,"count != 5: Prepare for GPF");
    681. 

  681. 

  682. 	const OSQLParseNode* pEscNode = NULL;
    683. 

  683. 	const OSQLParseNode* pParaNode = NULL;
    684. 

  684. 

  685. 	SQLParseNodeParameter aNewParam(rParam);
    686. 

  686. 	//aNewParam.bQuote = sal_True; // why setting this to true? @see http://www.openoffice.org/issues/show_bug.cgi?id=75557
    687. 

  687. 

  688. 	// if there is a field given we don't display the fieldname, if there are any
    689. 

  689. 	sal_Bool bAddName = sal_True;
    690. 

  690. 	if (rParam.xField.is())
    691. 

  691. 	{
    692. 

  692. 		// retrieve the fields name
    693. 

  693. 		::rtl::OUString aFieldName;
    694. 

  694. 		try
    695. 

  695. 		{
    696. 

  696. 			// retrieve the fields name
    697. 

  697. 			rtl::OUString aString;
    698. 

  698. 			rParam.xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)) >>= aString;
    699. 

  699. 			aFieldName = aString.getStr();
    700. 

  700. 		}
    701. 

  701. 		catch ( Exception& )
    702. 

  702. 		{
    703. 

  703. 			OSL_ENSURE( false, "OSQLParseNode::impl_parseLikeNodeToString_throw Exception occured!" );
    704. 

  704. 		}
    705. 

  705. 		if ( !m_aChildren[0]->isLeaf() )
    706. 

  706. 		{
    707. 

  707. 			const OSQLParseNode* pCol = m_aChildren[0]->getChild(m_aChildren[0]->count()-1);
    708. 

  708. 			if ((SQL_ISRULE(pCol,column_val) && pCol->getChild(0)->getTokenValue().equalsIgnoreAsciiCase(aFieldName)) ||
    709. 

  709. 				pCol->getTokenValue().equalsIgnoreAsciiCase(aFieldName) )
    710. 

  710. 				bAddName = sal_False;
    711. 

  711. 		}
    712. 

  712. 	}
    713. 

  713. 

  714. 	if (bAddName)
    715. 

  715. 		m_aChildren[0]->impl_parseNodeToString_throw( rString, aNewParam );
    716. 

  716. 

  717. 	m_aChildren[1]->impl_parseNodeToString_throw( rString, aNewParam );
    718. 

  718. 	if(count() == 5)
    719. 

  719. 		m_aChildren[2]->impl_parseNodeToString_throw( rString, aNewParam );
    720. 

  720. 

  721. 	sal_Int32 nCurentPos = m_aChildren.size()-2;
    722. 

  722. 	pParaNode = m_aChildren[nCurentPos];
    723. 

  723. 	pEscNode = m_aChildren[nCurentPos+1];
    724. 

  724. 

  725. 	if (pParaNode->isToken())
    726. 

  726. 	{
    727. 

  727. 		::rtl::OUString aStr = ConvertLikeToken(pParaNode, pEscNode, rParam.bInternational);
    728. 

  728. 		rString.appendAscii(" ");
    729. 

  729. 		rString.append(SetQuotation(aStr,::rtl::OUString::createFromAscii("\'"),::rtl::OUString::createFromAscii("\'\'")));
    730. 

  730. 	}
    731. 

  731. 	else
    732. 

  732. 		pParaNode->impl_parseNodeToString_throw( rString, aNewParam );
    733. 

  733. 

  734. 	pEscNode->impl_parseNodeToString_throw( rString, aNewParam );
    735. 

  735. }
    736. 

  736. 

  737. 

  738. // -----------------------------------------------------------------------------
    739. 

  739. sal_Bool OSQLParseNode::getTableComponents(const OSQLParseNode* _pTableNode,
    740. 

  740. 											::com::sun::star::uno::Any &_rCatalog,
    741. 

  741. 											::rtl::OUString &_rSchema,
    742. 

  742. 											::rtl::OUString &_rTable,
    743. 

  743.                                             const Reference< XDatabaseMetaData >& _xMetaData)
    744. 

  744. {
    745. 

  745.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::getTableComponents" );
    746. 

  746. 	OSL_ENSURE(_pTableNode,"Wrong use of getTableComponents! _pTableNode is not allowed to be null!");
    747. 

  747. 	if(_pTableNode)
    748. 

  748. 	{
    749. 

  749.         const sal_Bool bSupportsCatalog = _xMetaData.is() && _xMetaData->supportsCatalogsInDataManipulation();
    750. 

  750.         const sal_Bool bSupportsSchema = _xMetaData.is() && _xMetaData->supportsSchemasInDataManipulation();
    751. 

  751. 		const OSQLParseNode* pTableNode = _pTableNode;
    752. 

  752. 		// clear the parameter given
    753. 

  753. 		_rCatalog = Any();
    754. 

  754. 		_rSchema = _rTable = ::rtl::OUString();
    755. 

  755. 		// see rule catalog_name: in sqlbison.y
    756. 

  756. 		if (SQL_ISRULE(pTableNode,catalog_name))
    757. 

  757. 		{
    758. 

  758. 			OSL_ENSURE(pTableNode->getChild(0) && pTableNode->getChild(0)->isToken(),"Invalid parsenode!");
    759. 

  759. 			_rCatalog <<= pTableNode->getChild(0)->getTokenValue();
    760. 

  760. 			pTableNode = pTableNode->getChild(2);
    761. 

  761. 		}
    762. 

  762. 		// check if we have schema_name rule
    763. 

  763. 		if(SQL_ISRULE(pTableNode,schema_name))
    764. 

  764. 		{
    765. 

  765.             if ( bSupportsCatalog && !bSupportsSchema )
    766. 

  766.                 _rCatalog <<= pTableNode->getChild(0)->getTokenValue();
    767. 

  767.             else
    768. 

  768. 			    _rSchema = pTableNode->getChild(0)->getTokenValue();
    769. 

  769. 			pTableNode = pTableNode->getChild(2);
    770. 

  770. 		}
    771. 

  771. 		// check if we have table_name rule
    772. 

  772. 		if(SQL_ISRULE(pTableNode,table_name))
    773. 

  773. 		{
    774. 

  774. 			_rTable = pTableNode->getChild(0)->getTokenValue();
    775. 

  775. 		}
    776. 

  776. 		else
    777. 

  777. 		{
    778. 

  778. 			OSL_ENSURE(0,"Error in parse tree!");
    779. 

  779. 		}
    780. 

  780. 	}
    781. 

  781. 	return _rTable.getLength() != 0;
    782. 

  782. }
    783. 

  783. // -----------------------------------------------------------------------------
    784. 

  784. void OSQLParser::killThousandSeparator(OSQLParseNode* pLiteral)
    785. 

  785. {
    786. 

  786.     if ( pLiteral )
    787. 

  787. 	{
    788. 

  788.         if ( s_xLocaleData->getLocaleItem( m_pData->aLocale ).decimalSeparator.toChar() == ',' )
    789. 

  789. 		{
    790. 

  790. 		    pLiteral->m_aNodeValue = pLiteral->m_aNodeValue.replace('.', sal_Unicode());
    791. 

  791. 		    // and replace decimal
    792. 

  792. 		    pLiteral->m_aNodeValue = pLiteral->m_aNodeValue.replace(',', '.');
    793. 

  793. 		}
    794. 

  794. 	    else
    795. 

  795. 		    pLiteral->m_aNodeValue = pLiteral->m_aNodeValue.replace(',', sal_Unicode());
    796. 

  796. 		}
    797. 

  797. }
    798. 

  798. // -----------------------------------------------------------------------------
    799. 

  799. OSQLParseNode* OSQLParser::convertNode(sal_Int32 nType,OSQLParseNode*& pLiteral)
    800. 

  800. {
    801. 

  801.     if ( !pLiteral )
    802. 

  802.         return NULL;
    803. 

  803. 

  804.     OSQLParseNode* pReturn = pLiteral;
    805. 

  805. 

  806.     if ( ( pLiteral->isRule() && !SQL_ISRULE(pLiteral,value_exp) ) || SQL_ISTOKEN(pLiteral,FALSE) || SQL_ISTOKEN(pLiteral,TRUE) )
    807. 

  807.     {
    808. 

  808. 		switch(nType)
    809. 

  809. 		{
    810. 

  810. 			case DataType::CHAR:
    811. 

  811. 			case DataType::VARCHAR:
    812. 

  812. 			case DataType::LONGVARCHAR:
    813. 

  813. 			case DataType::CLOB:
    814. 

  814. 				if ( !SQL_ISRULE(pReturn,char_value_exp) && !buildStringNodes(pReturn) )
    815. 

  815. 					pReturn = NULL;
    816. 

  816. 			default:
    817. 

  817. 			    break;
    818. 

  818. 		}
    819. 

  819. 	}
    820. 

  820. 	else
    821. 

  821. 	{
    822. 

  822. 		switch(pLiteral->getNodeType())
    823. 

  823. 		{
    824. 

  824.         case SQL_NODE_STRING:
    825. 

  825.             switch(nType)
    826. 

  826.             {
    827. 

  827.                 case DataType::CHAR:
    828. 

  828.                 case DataType::VARCHAR:
    829. 

  829.                 case DataType::LONGVARCHAR:
    830. 

  830. 				case DataType::CLOB:
    831. 

  831.                     break;
    832. 

  832.                 case DataType::DATE:
    833. 

  833.                 case DataType::TIME:
    834. 

  834.                 case DataType::TIMESTAMP:
    835. 

  835.                     if (m_xFormatter.is())
    836. 

  836.                     pReturn = buildDate( nType, pReturn);
    837. 

  837.                     break;
    838. 

  838.                 default:
    839. 

  839.                     m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_COMPARE);
    840. 

  840.                     break;
    841. 

  841.             }
    842. 

  842.             break;
    843. 

  843.         case SQL_NODE_ACCESS_DATE:
    844. 

  844.             switch(nType)
    845. 

  845.             {
    846. 

  846.                 case DataType::DATE:
    847. 

  847.                 case DataType::TIME:
    848. 

  848.                 case DataType::TIMESTAMP:
    849. 

  849.                 if ( m_xFormatter.is() )
    850. 

  850.                     pReturn = buildDate( nType, pReturn);
    851. 

  851.                     else
    852. 

  852.                         m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_DATE_COMPARE);
    853. 

  853.                     break;
    854. 

  854.                 default:
    855. 

  855.                     m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_COMPARE);
    856. 

  856.                     break;
    857. 

  857.             }
    858. 

  858.             break;
    859. 

  859.         case SQL_NODE_INTNUM:
    860. 

  860.             switch(nType)
    861. 

  861.             {
    862. 

  862.                 case DataType::BIT:
    863. 

  863.                 case DataType::BOOLEAN:
    864. 

  864.                 case DataType::DECIMAL:
    865. 

  865.                 case DataType::NUMERIC:
    866. 

  866.                 case DataType::TINYINT:
    867. 

  867.                 case DataType::SMALLINT:
    868. 

  868.                 case DataType::INTEGER:
    869. 

  869.                 case DataType::BIGINT:
    870. 

  870.                 case DataType::FLOAT:
    871. 

  871.                 case DataType::REAL:
    872. 

  872.                 case DataType::DOUBLE:
    873. 

  873.                     // kill thousand seperators if any
    874. 

  874. 					killThousandSeparator(pReturn);
    875. 

  875.                     break;
    876. 

  876.                 case DataType::CHAR:
    877. 

  877.                 case DataType::VARCHAR:
    878. 

  878.                 case DataType::LONGVARCHAR:
    879. 

  879. 				case DataType::CLOB:
    880. 

  880. 					pReturn = buildNode_STR_NUM(pReturn);
    881. 

  881.                     break;
    882. 

  882.                 default:
    883. 

  883.                     m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_INT_COMPARE);
    884. 

  884.                     break;
    885. 

  885.             }
    886. 

  886.             break;
    887. 

  887.         case SQL_NODE_APPROXNUM:
    888. 

  888.             switch(nType)
    889. 

  889.             {
    890. 

  890.                 case DataType::DECIMAL:
    891. 

  891.                 case DataType::NUMERIC:
    892. 

  892.                 case DataType::FLOAT:
    893. 

  893.                 case DataType::REAL:
    894. 

  894.                 case DataType::DOUBLE:
    895. 

  895.                         // kill thousand seperators if any
    896. 

  896. 					killThousandSeparator(pReturn);
    897. 

  897.                     break;
    898. 

  898.                 case DataType::CHAR:
    899. 

  899.                 case DataType::VARCHAR:
    900. 

  900.                 case DataType::LONGVARCHAR:
    901. 

  901. 				case DataType::CLOB:
    902. 

  902. 					pReturn = buildNode_STR_NUM(pReturn);
    903. 

  903.                     break;
    904. 

  904.                 case DataType::INTEGER:
    905. 

  905.                 default:
    906. 

  906.                     m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_REAL_COMPARE);
    907. 

  907.                     break;
    908. 

  908.             }
    909. 

  909.             break;
    910. 

  910.         default:
    911. 

  911.             ;
    912. 

  912. 		}
    913. 

  913. 	}
    914. 

  914.     return pReturn;
    915. 

  915. }
    916. 

  916. // -----------------------------------------------------------------------------
    917. 

  917. sal_Int16 OSQLParser::buildPredicateRule(OSQLParseNode*& pAppend,OSQLParseNode* pLiteral,OSQLParseNode*& pCompare,OSQLParseNode* pLiteral2)
    918. 

  918. {
    919. 

  919.     OSL_ENSURE(inPredicateCheck(),"Only in predicate check allowed!");
    920. 

  920. 	sal_Int16 nErg = 0;
    921. 

  921. 	if ( m_xField.is() )
    922. 

  922. 	{
    923. 

  923.         sal_Int32 nType = 0;
    924. 

  924. 	    try
    925. 

  925. 	    {
    926. 

  926. 		    m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)) >>= nType;
    927. 

  927. 	    }
    928. 

  928. 	    catch( Exception& )
    929. 

  929. 	    {
    930. 

  930. 		    return nErg;
    931. 

  931. 		}
    932. 

  932. 

  933.         OSQLParseNode* pNode1 = convertNode(nType,pLiteral);
    934. 

  934.         if ( pNode1 )
    935. 

  935.         {
    936. 

  936.             OSQLParseNode* pNode2 = convertNode(nType,pLiteral2);
    937. 

  937.             if ( !m_sErrorMessage.getLength() )
    938. 

  938.                 nErg = buildNode(pAppend,pCompare,pNode1,pNode2);
    939. 

  939. 		}
    940. 

  940. 	}
    941. 

  941. 	if (!pCompare->getParent()) // I have no parent so I was not used and I must die :-)
    942. 

  942. 		delete pCompare;
    943. 

  943. 	return nErg;
    944. 

  944. }
    945. 

  945. // -----------------------------------------------------------------------------
    946. 

  946. sal_Int16 OSQLParser::buildLikeRule(OSQLParseNode*& pAppend, OSQLParseNode*& pLiteral, const OSQLParseNode* pEscape)
    947. 

  947. {
    948. 

  948. 	sal_Int16 nErg = 0;
    949. 

  949. 	sal_Int32 nType = 0;
    950. 

  950. 

  951. 	if (!m_xField.is())
    952. 

  952. 		return nErg;
    953. 

  953. 	try
    954. 

  954. 	{
    955. 

  955. 		Any aValue;
    956. 

  956. 		{
    957. 

  957. 			aValue = m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE));
    958. 

  958. 			aValue >>= nType;
    959. 

  959. 		}
    960. 

  960. 	}
    961. 

  961. 	catch( Exception& )
    962. 

  962. 	{
    963. 

  963. 		return nErg;
    964. 

  964. 	}
    965. 

  965. 

  966. 	switch (nType)
    967. 

  967. 	{
    968. 

  968. 		case DataType::CHAR:
    969. 

  969. 		case DataType::VARCHAR:
    970. 

  970. 		case DataType::LONGVARCHAR:
    971. 

  971. 		case DataType::CLOB:
    972. 

  972. 			if(pLiteral->isRule())
    973. 

  973. 			{
    974. 

  974. 				pAppend->append(pLiteral);
    975. 

  975. 				nErg = 1;
    976. 

  976. 			}
    977. 

  977. 			else
    978. 

  978. 			{
    979. 

  979. 				switch(pLiteral->getNodeType())
    980. 

  980. 				{
    981. 

  981. 					case SQL_NODE_STRING:
    982. 

  982. 						pLiteral->m_aNodeValue = ConvertLikeToken(pLiteral, pEscape, sal_False);
    983. 

  983. 						pAppend->append(pLiteral);
    984. 

  984. 						nErg = 1;
    985. 

  985. 						break;
    986. 

  986. 					case SQL_NODE_APPROXNUM:
    987. 

  987. 						if (m_xFormatter.is() && m_nFormatKey)
    988. 

  988. 						{
    989. 

  989. 							sal_Int16 nScale = 0;
    990. 

  990. 							try
    991. 

  991. 							{
    992. 

  992. 								Any aValue = getNumberFormatProperty( m_xFormatter, m_nFormatKey, ::rtl::OUString::createFromAscii("Decimals") );
    993. 

  993. 								aValue >>= nScale;
    994. 

  994. 							}
    995. 

  995. 							catch( Exception& )
    996. 

  996. 							{
    997. 

  997. 							}
    998. 

  998. 

  999. 							pAppend->append(new OSQLInternalNode(stringToDouble(pLiteral->getTokenValue(),nScale),SQL_NODE_STRING));
    1000. 

  1000. 						}
    1001. 

  1001. 						else
    1002. 

  1002. 							pAppend->append(new OSQLInternalNode(pLiteral->getTokenValue(),SQL_NODE_STRING));
    1003. 

  1003. 

  1004. 						delete pLiteral;
    1005. 

  1005. 						nErg = 1;
    1006. 

  1006. 						break;
    1007. 

  1007. 					default:
    1008. 

  1008. 						m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_VALUE_NO_LIKE);
    1009. 

  1009. 						m_sErrorMessage = m_sErrorMessage.replaceAt(m_sErrorMessage.indexOf(::rtl::OUString::createFromAscii("#1")),2,pLiteral->getTokenValue());
    1010. 

  1010.                         break;
    1011. 

  1011. 				}
    1012. 

  1012. 			}
    1013. 

  1013. 			break;
    1014. 

  1014. 		default:
    1015. 

  1015. 			m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_FIELD_NO_LIKE);
    1016. 

  1016.             break;
    1017. 

  1017. 	}
    1018. 

  1018. 	return nErg;
    1019. 

  1019. }
    1020. 

  1020. //-----------------------------------------------------------------------------
    1021. 

  1021. OSQLParseNode* OSQLParser::buildNode_Date(const double& fValue, sal_Int32 nType)
    1022. 

  1022. {
    1023. 

  1023.     ::rtl::OUString aEmptyString;
    1024. 

  1024.     OSQLParseNode* pNewNode = new OSQLInternalNode(aEmptyString, SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::set_fct_spec));
    1025. 

  1025. 	pNewNode->append(new OSQLInternalNode(::rtl::OUString::createFromAscii("{"), SQL_NODE_PUNCTUATION));
    1026. 

  1026. 	OSQLParseNode* pDateNode = new OSQLInternalNode(aEmptyString, SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::odbc_fct_spec));
    1027. 

  1027. 	pNewNode->append(pDateNode);
    1028. 

  1028. 	pNewNode->append(new OSQLInternalNode(::rtl::OUString::createFromAscii("}"), SQL_NODE_PUNCTUATION));
    1029. 

  1029. 

  1030. 	switch (nType)
    1031. 

  1031. 	{
    1032. 

  1032. 		case DataType::DATE:
    1033. 

  1033. 		{
    1034. 

  1034. 			Date aDate = DBTypeConversion::toDate(fValue,DBTypeConversion::getNULLDate(m_xFormatter->getNumberFormatsSupplier()));
    1035. 

  1035. 			::rtl::OUString aString = DBTypeConversion::toDateString(aDate);
    1036. 

  1036. 			pDateNode->append(new OSQLInternalNode(aEmptyString, SQL_NODE_KEYWORD, SQL_TOKEN_D));
    1037. 

  1037. 			pDateNode->append(new OSQLInternalNode(aString, SQL_NODE_STRING));
    1038. 

  1038. 			break;
    1039. 

  1039. 		}
    1040. 

  1040. 		case DataType::TIME:
    1041. 

  1041. 		{
    1042. 

  1042. 			Time aTime = DBTypeConversion::toTime(fValue);
    1043. 

  1043. 			::rtl::OUString aString = DBTypeConversion::toTimeString(aTime);
    1044. 

  1044. 			pDateNode->append(new OSQLInternalNode(aEmptyString, SQL_NODE_KEYWORD, SQL_TOKEN_T));
    1045. 

  1045. 			pDateNode->append(new OSQLInternalNode(aString, SQL_NODE_STRING));
    1046. 

  1046. 			break;
    1047. 

  1047. 		}
    1048. 

  1048. 		case DataType::TIMESTAMP:
    1049. 

  1049. 		{
    1050. 

  1050. 			DateTime aDateTime = DBTypeConversion::toDateTime(fValue,DBTypeConversion::getNULLDate(m_xFormatter->getNumberFormatsSupplier()));
    1051. 

  1051. 			if (aDateTime.Seconds || aDateTime.Minutes || aDateTime.Hours)
    1052. 

  1052. 			{
    1053. 

  1053. 				::rtl::OUString aString = DBTypeConversion::toDateTimeString(aDateTime);
    1054. 

  1054. 				pDateNode->append(new OSQLInternalNode(aEmptyString, SQL_NODE_KEYWORD, SQL_TOKEN_TS));
    1055. 

  1055. 				pDateNode->append(new OSQLInternalNode(aString, SQL_NODE_STRING));
    1056. 

  1056. 			}
    1057. 

  1057. 			else
    1058. 

  1058. 			{
    1059. 

  1059. 				Date aDate(aDateTime.Day,aDateTime.Month,aDateTime.Year);
    1060. 

  1060. 				pDateNode->append(new OSQLInternalNode(aEmptyString, SQL_NODE_KEYWORD, SQL_TOKEN_D));
    1061. 

  1061. 				pDateNode->append(new OSQLInternalNode(DBTypeConversion::toDateString(aDate), SQL_NODE_STRING));
    1062. 

  1062. 			}
    1063. 

  1063. 			break;
    1064. 

  1064. 		}
    1065. 

  1065. 	}
    1066. 

  1066. 

  1067. 	return pNewNode;
    1068. 

  1068. }
    1069. 

  1069. // -----------------------------------------------------------------------------
    1070. 

  1070. OSQLParseNode* OSQLParser::buildNode_STR_NUM(OSQLParseNode*& _pLiteral)
    1071. 

  1071. {
    1072. 

  1072. 	OSQLParseNode* pReturn = NULL;
    1073. 

  1073.     if ( _pLiteral )
    1074. 

  1074.     {
    1075. 

  1075. 	    if (m_nFormatKey)
    1076. 

  1076. 	    {
    1077. 

  1077. 		    sal_Int16 nScale = 0;
    1078. 

  1078. 		    ::rtl::OUString aDec;
    1079. 

  1079. 		    try
    1080. 

  1080. 		    {
    1081. 

  1081.                 Any aValue = getNumberFormatProperty( m_xFormatter, m_nFormatKey, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Decimals")) );
    1082. 

  1082. 			    aValue >>= nScale;
    1083. 

  1083. 		    }
    1084. 

  1084. 		    catch( Exception& )
    1085. 

  1085. 		    {
    1086. 

  1086. 		    }
    1087. 

  1087. 

  1088.             pReturn = new OSQLInternalNode(stringToDouble(_pLiteral->getTokenValue(),nScale),SQL_NODE_STRING);
    1089. 

  1089. 	    }
    1090. 

  1090. 	    else
    1091. 

  1091.             pReturn = new OSQLInternalNode(_pLiteral->getTokenValue(),SQL_NODE_STRING);
    1092. 

  1092. 

  1093.         delete _pLiteral;
    1094. 

  1094.         _pLiteral = NULL;
    1095. 

  1095.     }
    1096. 

  1096.     return pReturn;
    1097. 

  1097. }
    1098. 

  1098. // -----------------------------------------------------------------------------
    1099. 

  1099. ::rtl::OUString OSQLParser::stringToDouble(const ::rtl::OUString& _rValue,sal_Int16 _nScale)
    1100. 

  1100. {
    1101. 

  1101. 	::rtl::OUString aValue;
    1102. 

  1102. 	if(!m_xCharClass.is())
    1103. 

  1103. 		m_xCharClass  = Reference<XCharacterClassification>(m_xServiceFactory->createInstance(::rtl::OUString::createFromAscii("com.sun.star.i18n.CharacterClassification")),UNO_QUERY);
    1104. 

  1104. 	if(m_xCharClass.is() && s_xLocaleData.is())
    1105. 

  1105. 	{
    1106. 

  1106. 		try
    1107. 

  1107. 		{
    1108. 

  1108. 			ParseResult aResult = m_xCharClass->parsePredefinedToken(KParseType::ANY_NUMBER,_rValue,0,m_pData->aLocale,0,::rtl::OUString(),KParseType::ANY_NUMBER,::rtl::OUString());
    1109. 

  1109. 			if((aResult.TokenType & KParseType::IDENTNAME) && aResult.EndPos == _rValue.getLength())
    1110. 

  1110. 			{
    1111. 

  1111. 				aValue = ::rtl::OUString::valueOf(aResult.Value);
    1112. 

  1112. 				sal_Int32 nPos = aValue.lastIndexOf(::rtl::OUString::createFromAscii("."));
    1113. 

  1113. 				if((nPos+_nScale) < aValue.getLength())
    1114. 

  1114. 					aValue = aValue.replaceAt(nPos+_nScale,aValue.getLength()-nPos-_nScale,::rtl::OUString());
    1115. 

  1115. 				aValue = aValue.replaceAt(aValue.lastIndexOf(::rtl::OUString::createFromAscii(".")),1,s_xLocaleData->getLocaleItem(m_pData->aLocale).decimalSeparator);
    1116. 

  1116. 				return aValue;
    1117. 

  1117. 			}
    1118. 

  1118. 		}
    1119. 

  1119. 		catch(Exception&)
    1120. 

  1120. 		{
    1121. 

  1121. 		}
    1122. 

  1122. 	}
    1123. 

  1123. 	return aValue;
    1124. 

  1124. }
    1125. 

  1125. // -----------------------------------------------------------------------------
    1126. 

  1126. 

  1127. ::osl::Mutex& OSQLParser::getMutex()
    1128. 

  1128. {
    1129. 

  1129. 	static ::osl::Mutex aMutex;
    1130. 

  1130. 	return aMutex;
    1131. 

  1131. }
    1132. 

  1132. 

  1133. //-----------------------------------------------------------------------------
    1134. 

  1134. OSQLParseNode* OSQLParser::predicateTree(::rtl::OUString& rErrorMessage, const ::rtl::OUString& rStatement,
    1135. 

  1135.  										 const Reference< ::com::sun::star::util::XNumberFormatter > & xFormatter,
    1136. 

  1136. 										 const Reference< XPropertySet > & xField)
    1137. 

  1137. {
    1138. 

  1138. 

  1139. 

  1140. 	// mutex for parsing
    1141. 

  1141. 	static ::osl::Mutex aMutex;
    1142. 

  1142. 

  1143. 	// Guard the parsing
    1144. 

  1144. 	::osl::MutexGuard aGuard(getMutex());
    1145. 

  1145. 	// must be reset
    1146. 

  1146. 	setParser(this);
    1147. 

  1147. 

  1148. 

  1149. 	// reset the parser
    1150. 

  1150. 	m_xField		= xField;
    1151. 

  1151. 	m_xFormatter	= xFormatter;
    1152. 

  1152. 

  1153. 	if (m_xField.is())
    1154. 

  1154. 	{
    1155. 

  1155. 		sal_Int32 nType=0;
    1156. 

  1156. 		try
    1157. 

  1157. 		{
    1158. 

  1158. 			// get the field name
    1159. 

  1159. 			rtl::OUString aString;
    1160. 

  1160. 

  1161. 			// retrieve the fields name
    1162. 

  1162. 			// #75243# use the RealName of the column if there is any otherwise the name which could be the alias
    1163. 

  1163. 			// of the field
    1164. 

  1164.             Reference< XPropertySetInfo> xInfo = m_xField->getPropertySetInfo();
    1165. 

  1165. 			if ( xInfo->hasPropertyByName(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_REALNAME)))
    1166. 

  1166. 				m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_REALNAME)) >>= aString;
    1167. 

  1167. 			else
    1168. 

  1168. 				m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)) >>= aString;
    1169. 

  1169. 

  1170. 			m_sFieldName = aString;
    1171. 

  1171. 

  1172. 			// get the field format key
    1173. 

  1173. 			if ( xInfo->hasPropertyByName(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FORMATKEY)))
    1174. 

  1174. 				m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FORMATKEY)) >>= m_nFormatKey;
    1175. 

  1175. 			else
    1176. 

  1176. 				m_nFormatKey = 0;
    1177. 

  1177. 

  1178. 			// get the field type
    1179. 

  1179. 			m_xField->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)) >>= nType;
    1180. 

  1180. 		}
    1181. 

  1181. 		catch ( Exception& )
    1182. 

  1182. 		{
    1183. 

  1183. 			OSL_ASSERT(0);
    1184. 

  1184. 		}
    1185. 

  1185. 

  1186. 		if (m_nFormatKey && m_xFormatter.is())
    1187. 

  1187. 		{
    1188. 

  1188. 			Any aValue = getNumberFormatProperty( m_xFormatter, m_nFormatKey, OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_LOCALE) );
    1189. 

  1189. 			OSL_ENSURE(aValue.getValueType() == ::getCppuType((const ::com::sun::star::lang::Locale*)0), "OSQLParser::PredicateTree : invalid language property !");
    1190. 

  1190. 

  1191. 			if (aValue.getValueType() == ::getCppuType((const ::com::sun::star::lang::Locale*)0))
    1192. 

  1192. 				aValue >>= m_pData->aLocale;
    1193. 

  1193. 		}
    1194. 

  1194. 		else
    1195. 

  1195. 			m_pData->aLocale = m_pContext->getPreferredLocale();
    1196. 

  1196. 

  1197. 		if ( m_xFormatter.is() )
    1198. 

  1198. 		{
    1199. 

  1199. 			try
    1200. 

  1200. 			{
    1201. 

  1201. 				Reference< ::com::sun::star::util::XNumberFormatsSupplier >  xFormatSup = m_xFormatter->getNumberFormatsSupplier();
    1202. 

  1202. 				if ( xFormatSup.is() )
    1203. 

  1203. 				{
    1204. 

  1204. 					Reference< ::com::sun::star::util::XNumberFormats >  xFormats = xFormatSup->getNumberFormats();
    1205. 

  1205. 					if ( xFormats.is() )
    1206. 

  1206. 					{
    1207. 

  1207. 						::com::sun::star::lang::Locale aLocale;
    1208. 

  1208. 						aLocale.Language = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("en"));
    1209. 

  1209. 						aLocale.Country = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("US"));
    1210. 

  1210. 						::rtl::OUString sFormat(RTL_CONSTASCII_USTRINGPARAM("YYYY-MM-DD"));
    1211. 

  1211. 						m_nDateFormatKey = xFormats->queryKey(sFormat,aLocale,sal_False);
    1212. 

  1212. 						if ( m_nDateFormatKey == sal_Int32(-1) )
    1213. 

  1213. 							m_nDateFormatKey = xFormats->addNew(sFormat, aLocale);
    1214. 

  1214. 					}
    1215. 

  1215. 				}
    1216. 

  1216. 			}
    1217. 

  1217. 			catch ( Exception& )
    1218. 

  1218. 			{
    1219. 

  1219. 				OSL_ENSURE(0,"DateFormatKey");
    1220. 

  1220. 			}
    1221. 

  1221. 		}
    1222. 

  1222. 

  1223. 		switch (nType)
    1224. 

  1224. 		{
    1225. 

  1225. 			case DataType::DATE:
    1226. 

  1226. 			case DataType::TIME:
    1227. 

  1227. 			case DataType::TIMESTAMP:
    1228. 

  1228. 				s_pScanner->SetRule(s_pScanner->GetDATERule());
    1229. 

  1229. 				break;
    1230. 

  1230. 			case DataType::CHAR:
    1231. 

  1231. 			case DataType::VARCHAR:
    1232. 

  1232. 			case DataType::LONGVARCHAR:
    1233. 

  1233. 			case DataType::CLOB:
    1234. 

  1234. 				s_pScanner->SetRule(s_pScanner->GetSTRINGRule());
    1235. 

  1235. 				break;
    1236. 

  1236. 			default:
    1237. 

  1237. 				if ( s_xLocaleData->getLocaleItem( m_pData->aLocale ).decimalSeparator.toChar() == ',' )
    1238. 

  1238. 					s_pScanner->SetRule(s_pScanner->GetGERRule());
    1239. 

  1239. 				else
    1240. 

  1240. 					s_pScanner->SetRule(s_pScanner->GetENGRule());
    1241. 

  1241. 		}
    1242. 

  1242. 

  1243. 	}
    1244. 

  1244. 	else
    1245. 

  1245. 		s_pScanner->SetRule(s_pScanner->GetSQLRule());
    1246. 

  1246. 

  1247. 	s_pScanner->prepareScan(rStatement, m_pContext, sal_True);
    1248. 

  1248. 

  1249. 	SQLyylval.pParseNode = NULL;
    1250. 

  1250. 	//	SQLyypvt = NULL;
    1251. 

  1251. 	m_pParseTree = NULL;
    1252. 

  1252. 	m_sErrorMessage= ::rtl::OUString();
    1253. 

  1253. 

  1254. 	// ... und den Parser anwerfen ...
    1255. 

  1255. 	if (SQLyyparse() != 0)
    1256. 

  1256. 	{
    1257. 

  1257. 		m_sFieldName= ::rtl::OUString();
    1258. 

  1258. 	m_xField.clear();
    1259. 

  1259. 	m_xFormatter.clear();
    1260. 

  1260. 		m_nFormatKey = 0;
    1261. 

  1261. 		m_nDateFormatKey = 0;
    1262. 

  1262. 

  1263. 		if (!m_sErrorMessage.getLength())
    1264. 

  1264. 			m_sErrorMessage = s_pScanner->getErrorMessage();
    1265. 

  1265. 		if (!m_sErrorMessage.getLength())
    1266. 

  1266. 			m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_GENERAL);
    1267. 

  1267. 

  1268. 		rErrorMessage = m_sErrorMessage;
    1269. 

  1269. 

  1270. 		// clear the garbage collector
    1271. 

  1271.         (*s_pGarbageCollector)->clearAndDelete();
    1272. 

  1272. 		return NULL;
    1273. 

  1273. 	}
    1274. 

  1274. 	else
    1275. 

  1275. 	{
    1276. 

  1276. 		(*s_pGarbageCollector)->clear();
    1277. 

  1277. 

  1278. 		m_sFieldName= ::rtl::OUString();
    1279. 

  1279. 	m_xField.clear();
    1280. 

  1280. 	m_xFormatter.clear();
    1281. 

  1281. 		m_nFormatKey = 0;
    1282. 

  1282. 		m_nDateFormatKey = 0;
    1283. 

  1283. 

  1284. 		// Das Ergebnis liefern (den Root Parse Node):
    1285. 

  1285. 

  1286. 		// Stattdessen setzt die Parse-Routine jetzt den Member pParseTree
    1287. 

  1287. 		// - einfach diesen zurueckliefern:
    1288. 

  1288. 		OSL_ENSURE(m_pParseTree != NULL,"OSQLParser: Parser hat keinen ParseTree geliefert");
    1289. 

  1289. 		return m_pParseTree;
    1290. 

  1290. 	}
    1291. 

  1291. }
    1292. 

  1292. 

  1293. //=============================================================================
    1294. 

  1294. //-----------------------------------------------------------------------------
    1295. 

  1295. OSQLParser::OSQLParser(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _xServiceFactory,const IParseContext* _pContext)
    1296. 

  1296. 	:m_pContext(_pContext)
    1297. 

  1297. 	,m_pParseTree(NULL)
    1298. 

  1298. 	,m_pData( new OSQLParser_Data( _xServiceFactory ) )
    1299. 

  1299. 	,m_nFormatKey(0)
    1300. 

  1300. 	,m_nDateFormatKey(0)
    1301. 

  1301. 	,m_xServiceFactory(_xServiceFactory)
    1302. 

  1302. {
    1303. 

  1303. 

  1304. 

  1305. 	setParser(this);
    1306. 

  1306. 

  1307. #ifdef SQLYYDEBUG
    1308. 

  1308. #ifdef SQLYYDEBUG_ON
    1309. 

  1309. 	SQLyydebug = 1;
    1310. 

  1310. #endif
    1311. 

  1311. #endif
    1312. 

  1312. 

  1313. 	::osl::MutexGuard aGuard(getMutex());
    1314. 

  1314. 	// do we have to initialize the data
    1315. 

  1315. 	if (s_nRefCount == 0)
    1316. 

  1316. 	{
    1317. 

  1317. 		s_pScanner = new OSQLScanner();
    1318. 

  1318. 		s_pScanner->setScanner();
    1319. 

  1319. 		s_pGarbageCollector = new OSQLParseNodesGarbageCollector();
    1320. 

  1320. 

  1321. 		if(!s_xLocaleData.is())
    1322. 

  1322. 			s_xLocaleData = Reference<XLocaleData>(m_xServiceFactory->createInstance(::rtl::OUString::createFromAscii("com.sun.star.i18n.LocaleData")),UNO_QUERY);
    1323. 

  1323. 

  1324. 		// auf 0 zuruecksetzen
    1325. 

  1325. 		memset(OSQLParser::s_nRuleIDs,0,sizeof(OSQLParser::s_nRuleIDs[0]) * (OSQLParseNode::rule_count+1));
    1326. 

  1326. 

  1327.         struct
    1328. 

  1328.         {
    1329. 

  1329.             OSQLParseNode::Rule eRule;      // the parse node's ID for the rule
    1330. 

  1330.             ::rtl::OString      sRuleName;  // the name of the rule ("select_statement")
    1331. 

  1331.         }   aRuleDescriptions[] =
    1332. 

  1332.         {
    1333. 

  1333.             { OSQLParseNode::select_statement, "select_statement" },
    1334. 

  1334.             { OSQLParseNode::table_exp, "table_exp" },
    1335. 

  1335.             { OSQLParseNode::table_ref_commalist, "table_ref_commalist" },
    1336. 

  1336.             { OSQLParseNode::table_ref, "table_ref" },
    1337. 

  1337.             { OSQLParseNode::catalog_name, "catalog_name" },
    1338. 

  1338.             { OSQLParseNode::schema_name, "schema_name" },
    1339. 

  1339.             { OSQLParseNode::table_name, "table_name" },
    1340. 

  1340.             { OSQLParseNode::opt_column_commalist, "opt_column_commalist" },
    1341. 

  1341.             { OSQLParseNode::column_commalist, "column_commalist" },
    1342. 

  1342.             { OSQLParseNode::column_ref_commalist, "column_ref_commalist" },
    1343. 

  1343.             { OSQLParseNode::column_ref, "column_ref" },
    1344. 

  1344.             { OSQLParseNode::opt_order_by_clause, "opt_order_by_clause" },
    1345. 

  1345.             { OSQLParseNode::ordering_spec_commalist, "ordering_spec_commalist" },
    1346. 

  1346.             { OSQLParseNode::ordering_spec, "ordering_spec" },
    1347. 

  1347.             { OSQLParseNode::opt_asc_desc, "opt_asc_desc" },
    1348. 

  1348.             { OSQLParseNode::where_clause, "where_clause" },
    1349. 

  1349.             { OSQLParseNode::opt_where_clause, "opt_where_clause" },
    1350. 

  1350.             { OSQLParseNode::search_condition, "search_condition" },
    1351. 

  1351.             { OSQLParseNode::comparison_predicate, "comparison_predicate" },
    1352. 

  1352.             { OSQLParseNode::between_predicate, "between_predicate" },
    1353. 

  1353.             { OSQLParseNode::like_predicate, "like_predicate" },
    1354. 

  1354.             { OSQLParseNode::opt_escape, "opt_escape" },
    1355. 

  1355.             { OSQLParseNode::test_for_null, "test_for_null" },
    1356. 

  1356.             { OSQLParseNode::scalar_exp_commalist, "scalar_exp_commalist" },
    1357. 

  1357.             { OSQLParseNode::scalar_exp, "scalar_exp" },
    1358. 

  1358.             { OSQLParseNode::parameter_ref, "parameter_ref" },
    1359. 

  1359.             { OSQLParseNode::parameter, "parameter" },
    1360. 

  1360.             { OSQLParseNode::general_set_fct, "general_set_fct" },
    1361. 

  1361.             { OSQLParseNode::range_variable, "range_variable" },
    1362. 

  1362.             { OSQLParseNode::column, "column" },
    1363. 

  1363.             { OSQLParseNode::delete_statement_positioned, "delete_statement_positioned" },
    1364. 

  1364.             { OSQLParseNode::delete_statement_searched, "delete_statement_searched" },
    1365. 

  1365.             { OSQLParseNode::update_statement_positioned, "update_statement_positioned" },
    1366. 

  1366.             { OSQLParseNode::update_statement_searched, "update_statement_searched" },
    1367. 

  1367.             { OSQLParseNode::assignment_commalist, "assignment_commalist" },
    1368. 

  1368.             { OSQLParseNode::assignment, "assignment" },
    1369. 

  1369.             { OSQLParseNode::values_or_query_spec, "values_or_query_spec" },
    1370. 

  1370.             { OSQLParseNode::insert_statement, "insert_statement" },
    1371. 

  1371.             { OSQLParseNode::insert_atom_commalist, "insert_atom_commalist" },
    1372. 

  1372.             { OSQLParseNode::insert_atom, "insert_atom" },
    1373. 

  1373.             { OSQLParseNode::predicate_check, "predicate_check" },
    1374. 

  1374.             { OSQLParseNode::from_clause, "from_clause" },
    1375. 

  1375.             { OSQLParseNode::qualified_join, "qualified_join" },
    1376. 

  1376.             { OSQLParseNode::cross_union, "cross_union" },
    1377. 

  1377.             { OSQLParseNode::select_sublist, "select_sublist" },
    1378. 

  1378.             { OSQLParseNode::derived_column, "derived_column" },
    1379. 

  1379.             { OSQLParseNode::column_val, "column_val" },
    1380. 

  1380.             { OSQLParseNode::set_fct_spec, "set_fct_spec" },
    1381. 

  1381.             { OSQLParseNode::boolean_term, "boolean_term" },
    1382. 

  1382.             { OSQLParseNode::boolean_primary, "boolean_primary" },
    1383. 

  1383.             { OSQLParseNode::num_value_exp, "num_value_exp" },
    1384. 

  1384.             { OSQLParseNode::join_type, "join_type" },
    1385. 

  1385.             { OSQLParseNode::position_exp, "position_exp" },
    1386. 

  1386.             { OSQLParseNode::extract_exp, "extract_exp" },
    1387. 

  1387.             { OSQLParseNode::length_exp, "length_exp" },
    1388. 

  1388.             { OSQLParseNode::char_value_fct, "char_value_fct" },
    1389. 

  1389.             { OSQLParseNode::odbc_call_spec, "odbc_call_spec" },
    1390. 

  1390.             { OSQLParseNode::in_predicate, "in_predicate" },
    1391. 

  1391.             { OSQLParseNode::existence_test, "existence_test" },
    1392. 

  1392.             { OSQLParseNode::unique_test, "unique_test" },
    1393. 

  1393.             { OSQLParseNode::all_or_any_predicate, "all_or_any_predicate" },
    1394. 

  1394.             { OSQLParseNode::named_columns_join, "named_columns_join" },
    1395. 

  1395.             { OSQLParseNode::join_condition, "join_condition" },
    1396. 

  1396.             { OSQLParseNode::joined_table, "joined_table" },
    1397. 

  1397.             { OSQLParseNode::boolean_factor, "boolean_factor" },
    1398. 

  1398.             { OSQLParseNode::sql_not, "sql_not" },
    1399. 

  1399.             { OSQLParseNode::boolean_test, "boolean_test" },
    1400. 

  1400.             { OSQLParseNode::manipulative_statement, "manipulative_statement" },
    1401. 

  1401.             { OSQLParseNode::subquery, "subquery" },
    1402. 

  1402.             { OSQLParseNode::value_exp_commalist, "value_exp_commalist" },
    1403. 

  1403.             { OSQLParseNode::odbc_fct_spec, "odbc_fct_spec" },
    1404. 

  1404.             { OSQLParseNode::union_statement, "union_statement" },
    1405. 

  1405.             { OSQLParseNode::outer_join_type, "outer_join_type" },
    1406. 

  1406.             { OSQLParseNode::char_value_exp, "char_value_exp" },
    1407. 

  1407.             { OSQLParseNode::term, "term" },
    1408. 

  1408.             { OSQLParseNode::value_exp_primary, "value_exp_primary" },
    1409. 

  1409.             { OSQLParseNode::value_exp, "value_exp" },
    1410. 

  1410.             { OSQLParseNode::selection, "selection" },
    1411. 

  1411.             { OSQLParseNode::fold, "fold" },
    1412. 

  1412.             { OSQLParseNode::char_substring_fct, "char_substring_fct" },
    1413. 

  1413.             { OSQLParseNode::factor, "factor" },
    1414. 

  1414.             { OSQLParseNode::base_table_def, "base_table_def" },
    1415. 

  1415.             { OSQLParseNode::base_table_element_commalist, "base_table_element_commalist" },
    1416. 

  1416.             { OSQLParseNode::data_type, "data_type" },
    1417. 

  1417.             { OSQLParseNode::column_def, "column_def" },
    1418. 

  1418.             { OSQLParseNode::table_node, "table_node" },
    1419. 

  1419.             { OSQLParseNode::as, "as" },
    1420. 

  1420.             { OSQLParseNode::op_column_commalist, "op_column_commalist" },
    1421. 

  1421.             { OSQLParseNode::table_primary_as_range_column, "table_primary_as_range_column" },
    1422. 

  1422.             { OSQLParseNode::datetime_primary, "datetime_primary" },
    1423. 

  1423.             { OSQLParseNode::concatenation, "concatenation" },
    1424. 

  1424.             { OSQLParseNode::char_factor, "char_factor" },
    1425. 

  1425.             { OSQLParseNode::bit_value_fct, "bit_value_fct" }
    1426. 

  1426.         };
    1427. 

  1427.         size_t nRuleMapCount = sizeof( aRuleDescriptions ) / sizeof( aRuleDescriptions[0] );
    1428. 

  1428.         OSL_ENSURE( nRuleMapCount == size_t( OSQLParseNode::rule_count ), "OSQLParser::OSQLParser: added a new rule? Adjust this map!" );
    1429. 

  1429. 

  1430.         for ( size_t mapEntry = 0; mapEntry < nRuleMapCount; ++mapEntry )
    1431. 

  1431.         {
    1432. 

  1432.             // look up the rule description in the our identifier map
    1433. 

  1433.             sal_uInt32 nParserRuleID = StrToRuleID( aRuleDescriptions[ mapEntry ].sRuleName );
    1434. 

  1434.             // map the parser's rule ID to the OSQLParseNode::Rule
    1435. 

  1435.             s_aReverseRuleIDLookup[ nParserRuleID ] = aRuleDescriptions[ mapEntry ].eRule;
    1436. 

  1436.             // and map the OSQLParseNode::Rule to the parser's rule ID
    1437. 

  1437.             s_nRuleIDs[ aRuleDescriptions[ mapEntry ].eRule ] = nParserRuleID;
    1438. 

  1438.         }
    1439. 

  1439. 	}
    1440. 

  1440. 	++s_nRefCount;
    1441. 

  1441. 

  1442. 	if (m_pContext == NULL)
    1443. 

  1443. 		// take the default context
    1444. 

  1444. 		m_pContext = &s_aDefaultContext;
    1445. 

  1445. 

  1446.     m_pData->aLocale = m_pContext->getPreferredLocale();
    1447. 

  1447. }
    1448. 

  1448. 

  1449. //-----------------------------------------------------------------------------
    1450. 

  1450. OSQLParser::~OSQLParser()
    1451. 

  1451. {
    1452. 

  1452. 	{
    1453. 

  1453. 		::osl::MutexGuard aGuard(getMutex());
    1454. 

  1454. 		OSL_ENSURE(s_nRefCount > 0, "OSQLParser::~OSQLParser() : suspicious call : have a refcount of 0 !");
    1455. 

  1455. 		if (!--s_nRefCount)
    1456. 

  1456. 		{
    1457. 

  1457. 			s_pScanner->setScanner(sal_True);
    1458. 

  1458. 			delete s_pScanner;
    1459. 

  1459. 			s_pScanner = NULL;
    1460. 

  1460. 

  1461. 			delete s_pGarbageCollector;
    1462. 

  1462. 			s_pGarbageCollector = NULL;
    1463. 

  1463. 			// is only set the first time so we should delete it only when there no more instances
    1464. 

  1464. 			s_xLocaleData = NULL;
    1465. 

  1465. 

  1466.             RuleIDMap aEmpty;
    1467. 

  1467.             s_aReverseRuleIDLookup.swap( aEmpty );
    1468. 

  1468. 		}
    1469. 

  1469. 		m_pParseTree = NULL;
    1470. 

  1470. 	}
    1471. 

  1471. }
    1472. 

  1472. // -----------------------------------------------------------------------------
    1473. 

  1473. void OSQLParseNode::substituteParameterNames(OSQLParseNode* _pNode)
    1474. 

  1474. {
    1475. 

  1475.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::substituteParameterNames" );
    1476. 

  1476. 	sal_Int32 nCount = _pNode->count();
    1477. 

  1477. 	for(sal_Int32 i=0;i < nCount;++i)
    1478. 

  1478. 	{
    1479. 

  1479. 		OSQLParseNode* pChildNode = _pNode->getChild(i);
    1480. 

  1480. 		if(SQL_ISRULE(pChildNode,parameter) && pChildNode->count() > 1)
    1481. 

  1481. 		{
    1482. 

  1482. 			OSQLParseNode* pNewNode = new OSQLParseNode(::rtl::OUString::createFromAscii("?") ,SQL_NODE_PUNCTUATION,0);
    1483. 

  1483. 			delete pChildNode->replace(pChildNode->getChild(0),pNewNode);
    1484. 

  1484. 			sal_Int32 nChildCount = pChildNode->count();
    1485. 

  1485. 			for(sal_Int32 j=1;j < nChildCount;++j)
    1486. 

  1486. 				delete pChildNode->removeAt(1);
    1487. 

  1487. 		}
    1488. 

  1488. 		else
    1489. 

  1489. 			substituteParameterNames(pChildNode);
    1490. 

  1490. 

  1491. 	}
    1492. 

  1492. }
    1493. 

  1493. // -----------------------------------------------------------------------------
    1494. 

  1494. bool OSQLParser::extractDate(OSQLParseNode* pLiteral,double& _rfValue)
    1495. 

  1495. {
    1496. 

  1496.     Reference< XNumberFormatsSupplier > xFormatSup = m_xFormatter->getNumberFormatsSupplier();
    1497. 

  1497. 	Reference< XNumberFormatTypes > xFormatTypes;
    1498. 

  1498.     if ( xFormatSup.is() )
    1499. 

  1499.         xFormatTypes = xFormatTypes.query( xFormatSup->getNumberFormats() );
    1500. 

  1500. 

  1501.     // if there is no format key, yet, make sure we have a feasible one for our locale
    1502. 

  1502. 	try
    1503. 

  1503. 	{
    1504. 

  1504. 		if ( !m_nFormatKey && xFormatTypes.is() )
    1505. 

  1505. 			m_nFormatKey = ::dbtools::getDefaultNumberFormat( m_xField, xFormatTypes, m_pData->aLocale );
    1506. 

  1506.     }
    1507. 

  1507.     catch( Exception& ) { }
    1508. 

  1508.     ::rtl::OUString sValue = pLiteral->getTokenValue();
    1509. 

  1509.     sal_Int32 nTryFormat = m_nFormatKey;
    1510. 

  1510.     bool bSuccess = lcl_saveConvertToNumber( m_xFormatter, nTryFormat, sValue, _rfValue );
    1511. 

  1511. 

  1512.     // If our format key didn't do, try the default date format for our locale.
    1513. 

  1513.     if ( !bSuccess && xFormatTypes.is() )
    1514. 

  1514.     {
    1515. 

  1515. 		try
    1516. 

  1516. 		{
    1517. 

  1517.             nTryFormat = xFormatTypes->getStandardFormat( NumberFormat::DATE, m_pData->aLocale );
    1518. 

  1518. 		}
    1519. 

  1519.         catch( Exception& ) { }
    1520. 

  1520.         bSuccess = lcl_saveConvertToNumber( m_xFormatter, nTryFormat, sValue, _rfValue );
    1521. 

  1521.     }
    1522. 

  1522. 

  1523.     // if this also didn't do, try ISO format
    1524. 

  1524.     if ( !bSuccess && xFormatTypes.is() )
    1525. 

  1525.     {
    1526. 

  1526. 		try
    1527. 

  1527. 		{
    1528. 

  1528.             nTryFormat = xFormatTypes->getFormatIndex( NumberFormatIndex::DATE_DIN_YYYYMMDD, m_pData->aLocale );
    1529. 

  1529. 		}
    1530. 

  1530.         catch( Exception& ) { }
    1531. 

  1531.         bSuccess = lcl_saveConvertToNumber( m_xFormatter, nTryFormat, sValue, _rfValue );
    1532. 

  1532.     }
    1533. 

  1533. 

  1534.     // if this also didn't do, try fallback date format (en-US)
    1535. 

  1535.     if ( !bSuccess )
    1536. 

  1536.     {
    1537. 

  1537.         nTryFormat = m_nDateFormatKey;
    1538. 

  1538.         bSuccess = lcl_saveConvertToNumber( m_xFormatter, nTryFormat, sValue, _rfValue );
    1539. 

  1539.     }
    1540. 

  1540.     return bSuccess;
    1541. 

  1541. }
    1542. 

  1542. // -----------------------------------------------------------------------------
    1543. 

  1543. OSQLParseNode* OSQLParser::buildDate(sal_Int32 _nType,OSQLParseNode*& pLiteral)
    1544. 

  1544. {
    1545. 

  1545.     // try converting the string into a date, according to our format key
    1546. 

  1546. 	double fValue = 0.0;
    1547. 

  1547.     OSQLParseNode* pFCTNode = NULL;
    1548. 

  1548. 

  1549.     if ( extractDate(pLiteral,fValue) )
    1550. 

  1550. 		pFCTNode = buildNode_Date( fValue, _nType);
    1551. 

  1551. 

  1552.     delete pLiteral;
    1553. 

  1553.     pLiteral = NULL;
    1554. 

  1554. 

  1555.     if ( !pFCTNode )
    1556. 

  1556. 		m_sErrorMessage = m_pContext->getErrorMessage(IParseContext::ERROR_INVALID_DATE_COMPARE);
    1557. 

  1557. 

  1558.     return pFCTNode;
    1559. 

  1559. }
    1560. 

  1560. // -----------------------------------------------------------------------------
    1561. 

  1561. //-----------------------------------------------------------------------------
    1562. 

  1562. OSQLParseNode::OSQLParseNode(const sal_Char * pNewValue,
    1563. 

  1563.                              SQLNodeType eNewNodeType,
    1564. 

  1564.                              sal_uInt32 nNewNodeID)
    1565. 

  1565.         :m_pParent(NULL)
    1566. 

  1566.         ,m_aNodeValue(pNewValue,strlen(pNewValue),RTL_TEXTENCODING_UTF8)
    1567. 

  1567.         ,m_eNodeType(eNewNodeType)
    1568. 

  1568.         ,m_nNodeID(nNewNodeID)
    1569. 

  1569. {
    1570. 

  1570.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::OSQLParseNode" );
    1571. 

  1571. 

  1572.     OSL_ENSURE(m_eNodeType >= SQL_NODE_RULE && m_eNodeType <= SQL_NODE_CONCAT,"OSQLParseNode: mit unzulaessigem NodeType konstruiert");
    1573. 

  1573. }
    1574. 

  1574. //-----------------------------------------------------------------------------
    1575. 

  1575. OSQLParseNode::OSQLParseNode(const ::rtl::OString &_rNewValue,
    1576. 

  1576.                              SQLNodeType eNewNodeType,
    1577. 

  1577.                              sal_uInt32 nNewNodeID)
    1578. 

  1578.         :m_pParent(NULL)
    1579. 

  1579.         ,m_aNodeValue(_rNewValue,_rNewValue.getLength(),RTL_TEXTENCODING_UTF8)
    1580. 

  1580.         ,m_eNodeType(eNewNodeType)
    1581. 

  1581.         ,m_nNodeID(nNewNodeID)
    1582. 

  1582. {
    1583. 

  1583.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::OSQLParseNode" );
    1584. 

  1584. 

  1585.     OSL_ENSURE(m_eNodeType >= SQL_NODE_RULE && m_eNodeType <= SQL_NODE_CONCAT,"OSQLParseNode: mit unzulaessigem NodeType konstruiert");
    1586. 

  1586. }
    1587. 

  1587. //-----------------------------------------------------------------------------
    1588. 

  1588. OSQLParseNode::OSQLParseNode(const sal_Unicode * pNewValue,
    1589. 

  1589.                                  SQLNodeType eNewNodeType,
    1590. 

  1590.                                  sal_uInt32 nNewNodeID)
    1591. 

  1591.         :m_pParent(NULL)
    1592. 

  1592.         ,m_aNodeValue(pNewValue)
    1593. 

  1593.         ,m_eNodeType(eNewNodeType)
    1594. 

  1594.         ,m_nNodeID(nNewNodeID)
    1595. 

  1595. {
    1596. 

  1596.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::OSQLParseNode" );
    1597. 

  1597. 

  1598.     OSL_ENSURE(m_eNodeType >= SQL_NODE_RULE && m_eNodeType <= SQL_NODE_CONCAT,"OSQLParseNode: mit unzulaessigem NodeType konstruiert");
    1599. 

  1599. }
    1600. 

  1600. //-----------------------------------------------------------------------------
    1601. 

  1601. OSQLParseNode::OSQLParseNode(const ::rtl::OUString &_rNewValue,
    1602. 

  1602.                                  SQLNodeType eNewNodeType,
    1603. 

  1603.                                  sal_uInt32 nNewNodeID)
    1604. 

  1604.         :m_pParent(NULL)
    1605. 

  1605.         ,m_aNodeValue(_rNewValue)
    1606. 

  1606.         ,m_eNodeType(eNewNodeType)
    1607. 

  1607.         ,m_nNodeID(nNewNodeID)
    1608. 

  1608. {
    1609. 

  1609.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::OSQLParseNode" );
    1610. 

  1610. 

  1611.     OSL_ENSURE(m_eNodeType >= SQL_NODE_RULE && m_eNodeType <= SQL_NODE_CONCAT,"OSQLParseNode: mit unzulaessigem NodeType konstruiert");
    1612. 

  1612. }
    1613. 

  1613. //-----------------------------------------------------------------------------
    1614. 

  1614. OSQLParseNode::OSQLParseNode(const OSQLParseNode& rParseNode)
    1615. 

  1615. {
    1616. 

  1616.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::OSQLParseNode" );
    1617. 

  1617. 

  1618.     // klemm den getParent auf NULL
    1619. 

  1619.     m_pParent = NULL;
    1620. 

  1620. 

  1621.     // kopiere die member
    1622. 

  1622.     m_aNodeValue = rParseNode.m_aNodeValue;
    1623. 

  1623.     m_eNodeType  = rParseNode.m_eNodeType;
    1624. 

  1624.     m_nNodeID    = rParseNode.m_nNodeID;
    1625. 

  1625. 

  1626. 

  1627.     // denk dran, dass von Container abgeleitet wurde, laut SV-Help erzeugt
    1628. 

  1628.     // copy-Constructor des Containers einen neuen Container mit den gleichen
    1629. 

  1629.     // Zeigern als Inhalt -> d.h. nach dem Kopieren des Container wird fuer
    1630. 

  1630.     // alle Zeiger ungleich NULL eine Kopie hergestellt und anstelle des alten
    1631. 

  1631.     // Zeigers wieder eingehangen.
    1632. 

  1632. 

  1633.     // wenn kein Blatt, dann SubTrees bearbeiten
    1634. 

  1634.     for (OSQLParseNodes::const_iterator i = rParseNode.m_aChildren.begin();
    1635. 

  1635.          i != rParseNode.m_aChildren.end(); i++)
    1636. 

  1636.         append(new OSQLParseNode(**i));
    1637. 

  1637. }
    1638. 

  1638. // -----------------------------------------------------------------------------
    1639. 

  1639. //-----------------------------------------------------------------------------
    1640. 

  1640. OSQLParseNode& OSQLParseNode::operator=(const OSQLParseNode& rParseNode)
    1641. 

  1641. {
    1642. 

  1642.     if (this != &rParseNode)
    1643. 

  1643.     {
    1644. 

  1644.         // kopiere die member - pParent bleibt der alte
    1645. 

  1645.         m_aNodeValue = rParseNode.m_aNodeValue;
    1646. 

  1646.         m_eNodeType  = rParseNode.m_eNodeType;
    1647. 

  1647.         m_nNodeID    = rParseNode.m_nNodeID;
    1648. 

  1648. 

  1649.         for (OSQLParseNodes::const_iterator i = m_aChildren.begin();
    1650. 

  1650.             i != m_aChildren.end(); i++)
    1651. 

  1651.             delete *i;
    1652. 

  1652. 

  1653.         m_aChildren.clear();
    1654. 

  1654. 

  1655.         for (OSQLParseNodes::const_iterator j = rParseNode.m_aChildren.begin();
    1656. 

  1656.              j != rParseNode.m_aChildren.end(); j++)
    1657. 

  1657.             append(new OSQLParseNode(**j));
    1658. 

  1658.     }
    1659. 

  1659.     return *this;
    1660. 

  1660. }
    1661. 

  1661. 

  1662. //-----------------------------------------------------------------------------
    1663. 

  1663. sal_Bool OSQLParseNode::operator==(OSQLParseNode& rParseNode) const
    1664. 

  1664. {
    1665. 

  1665.     // die member muessen gleich sein
    1666. 

  1666.     sal_Bool bResult = (m_nNodeID  == rParseNode.m_nNodeID) &&
    1667. 

  1667.                    (m_eNodeType == rParseNode.m_eNodeType) &&
    1668. 

  1668.                    (m_aNodeValue == rParseNode.m_aNodeValue) &&
    1669. 

  1669.                     count() == rParseNode.count();
    1670. 

  1670. 

  1671.     // Parameters are not equal!
    1672. 

  1672.     bResult = bResult && !SQL_ISRULE(this, parameter);
    1673. 

  1673. 

  1674.     // compare childs
    1675. 

  1675.     for (sal_uInt32 i=0; bResult && i < count(); i++)
    1676. 

  1676.         bResult = *getChild(i) == *rParseNode.getChild(i);
    1677. 

  1677. 

  1678.     return bResult;
    1679. 

  1679. }
    1680. 

  1680. 

  1681. //-----------------------------------------------------------------------------
    1682. 

  1682. OSQLParseNode::~OSQLParseNode()
    1683. 

  1683. {
    1684. 

  1684.     for (OSQLParseNodes::const_iterator i = m_aChildren.begin();
    1685. 

  1685.          i != m_aChildren.end(); i++)
    1686. 

  1686.         delete *i;
    1687. 

  1687.     m_aChildren.clear();
    1688. 

  1688. }
    1689. 

  1689. 

  1690. //-----------------------------------------------------------------------------
    1691. 

  1691. void OSQLParseNode::append(OSQLParseNode* pNewNode)
    1692. 

  1692. {
    1693. 

  1693.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::append" );
    1694. 

  1694. 

  1695.     OSL_ENSURE(pNewNode != NULL, "OSQLParseNode: ungueltiger NewSubTree");
    1696. 

  1696.     OSL_ENSURE(pNewNode->getParent() == NULL, "OSQLParseNode: Knoten ist kein Waise");
    1697. 

  1697.     OSL_ENSURE(::std::find(m_aChildren.begin(), m_aChildren.end(), pNewNode) == m_aChildren.end(),
    1698. 

  1698.             "OSQLParseNode::append() Node already element of parent");
    1699. 

  1699. 

  1700.     // stelle Verbindung zum getParent her:
    1701. 

  1701.     pNewNode->setParent( this );
    1702. 

  1702.     // und haenge den SubTree hinten an
    1703. 

  1703.     m_aChildren.push_back(pNewNode);
    1704. 

  1704. }
    1705. 

  1705. // -----------------------------------------------------------------------------
    1706. 

  1706. sal_Bool OSQLParseNode::addDateValue(::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam) const
    1707. 

  1707. {
    1708. 

  1708.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::addDateValue" );
    1709. 

  1709.     // special display for date/time values
    1710. 

  1710.     if (SQL_ISRULE(this,set_fct_spec) && SQL_ISPUNCTUATION(m_aChildren[0],"{"))
    1711. 

  1711.     {
    1712. 

  1712.         const OSQLParseNode* pODBCNode = m_aChildren[1];
    1713. 

  1713.         const OSQLParseNode* pODBCNodeChild = pODBCNode->m_aChildren[0];
    1714. 

  1714. 

  1715.         if (pODBCNodeChild->getNodeType() == SQL_NODE_KEYWORD && (
    1716. 

  1716.             SQL_ISTOKEN(pODBCNodeChild, D) ||
    1717. 

  1717.             SQL_ISTOKEN(pODBCNodeChild, T) ||
    1718. 

  1718.             SQL_ISTOKEN(pODBCNodeChild, TS) ))
    1719. 

  1719.         {
    1720. 

  1720. 			::rtl::OUString suQuote(::rtl::OUString::createFromAscii("'"));
    1721. 

  1721. 			if (rParam.bPredicate)
    1722. 

  1722. 			{
    1723. 

  1723. 				 if (rParam.aMetaData.shouldEscapeDateTime())
    1724. 

  1724. 				 {
    1725. 

  1725. 					 suQuote = ::rtl::OUString::createFromAscii("#");
    1726. 

  1726. 				 }
    1727. 

  1727. 			}
    1728. 

  1728. 			else
    1729. 

  1729. 			{
    1730. 

  1730. 				 if (rParam.aMetaData.shouldEscapeDateTime())
    1731. 

  1731. 				 {
    1732. 

  1732. 					 // suQuote = ::rtl::OUString::createFromAscii("'");
    1733. 

  1733. 					 return sal_False;
    1734. 

  1734. 				 }
    1735. 

  1735. 			}
    1736. 

  1736. 

  1737. 			if (rString.getLength())
    1738. 

  1738.                 rString.appendAscii(" ");
    1739. 

  1739. 			rString.append(suQuote);
    1740. 

  1740. 			const ::rtl::OUString sTokenValue = pODBCNode->m_aChildren[1]->getTokenValue();
    1741. 

  1741.             if (SQL_ISTOKEN(pODBCNodeChild, D))
    1742. 

  1742. 			{
    1743. 

  1743. 				rString.append(rParam.bPredicate ? convertDateString(rParam, sTokenValue) : sTokenValue);
    1744. 

  1744. 			}
    1745. 

  1745.             else if (SQL_ISTOKEN(pODBCNodeChild, T))
    1746. 

  1746. 			{
    1747. 

  1747. 				rString.append(rParam.bPredicate ? convertTimeString(rParam, sTokenValue) : sTokenValue);
    1748. 

  1748. 			}
    1749. 

  1749.             else
    1750. 

  1750. 			{
    1751. 

  1751. 				rString.append(rParam.bPredicate ? convertDateTimeString(rParam, sTokenValue) : sTokenValue);
    1752. 

  1752. 			}
    1753. 

  1753. 			rString.append(suQuote);
    1754. 

  1754.             return sal_True;
    1755. 

  1755.         }
    1756. 

  1756.     }
    1757. 

  1757.     return sal_False;
    1758. 

  1758. }
    1759. 

  1759. // -----------------------------------------------------------------------------
    1760. 

  1760. void OSQLParseNode::replaceNodeValue(const ::rtl::OUString& rTableAlias,const ::rtl::OUString& rColumnName)
    1761. 

  1761. {
    1762. 

  1762.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::replaceNodeValue" );
    1763. 

  1763.     for (sal_uInt32 i=0;i<count();++i)
    1764. 

  1764.     {
    1765. 

  1765.         if (SQL_ISRULE(this,column_ref) && count() == 1 && getChild(0)->getTokenValue() == rColumnName)
    1766. 

  1766.         {
    1767. 

  1767.             OSQLParseNode * pCol = removeAt((sal_uInt32)0);
    1768. 

  1768.             append(new OSQLParseNode(rTableAlias,SQL_NODE_NAME));
    1769. 

  1769.             append(new OSQLParseNode(::rtl::OUString::createFromAscii("."),SQL_NODE_PUNCTUATION));
    1770. 

  1770.             append(pCol);
    1771. 

  1771.         }
    1772. 

  1772.         else
    1773. 

  1773.             getChild(i)->replaceNodeValue(rTableAlias,rColumnName);
    1774. 

  1774.     }
    1775. 

  1775. }
    1776. 

  1776. //-----------------------------------------------------------------------------
    1777. 

  1777. OSQLParseNode* OSQLParseNode::getByRule(OSQLParseNode::Rule eRule) const
    1778. 

  1778. {
    1779. 

  1779.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::getByRule" );
    1780. 

  1780.     OSQLParseNode* pRetNode = 0;
    1781. 

  1781.     if (isRule() && OSQLParser::RuleID(eRule) == getRuleID())
    1782. 

  1782.         pRetNode = (OSQLParseNode*)this;
    1783. 

  1783.     else
    1784. 

  1784.     {
    1785. 

  1785.         for (OSQLParseNodes::const_iterator i = m_aChildren.begin();
    1786. 

  1786.             !pRetNode && i != m_aChildren.end(); i++)
    1787. 

  1787.             pRetNode = (*i)->getByRule(eRule);
    1788. 

  1788.     }
    1789. 

  1789.     return pRetNode;
    1790. 

  1790. }
    1791. 

  1791. //-----------------------------------------------------------------------------
    1792. 

  1792. OSQLParseNode* MakeANDNode(OSQLParseNode *pLeftLeaf,OSQLParseNode *pRightLeaf)
    1793. 

  1793. {
    1794. 

  1794.     OSQLParseNode* pNewNode = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_term));
    1795. 

  1795.     pNewNode->append(pLeftLeaf);
    1796. 

  1796.     pNewNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii("AND"),SQL_NODE_KEYWORD,SQL_TOKEN_AND));
    1797. 

  1797.     pNewNode->append(pRightLeaf);
    1798. 

  1798.     return pNewNode;
    1799. 

  1799. }
    1800. 

  1800. //-----------------------------------------------------------------------------
    1801. 

  1801. OSQLParseNode* MakeORNode(OSQLParseNode *pLeftLeaf,OSQLParseNode *pRightLeaf)
    1802. 

  1802. {
    1803. 

  1803.     OSQLParseNode* pNewNode = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::search_condition));
    1804. 

  1804.     pNewNode->append(pLeftLeaf);
    1805. 

  1805.     pNewNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii("OR"),SQL_NODE_KEYWORD,SQL_TOKEN_OR));
    1806. 

  1806.     pNewNode->append(pRightLeaf);
    1807. 

  1807.     return pNewNode;
    1808. 

  1808. }
    1809. 

  1809. //-----------------------------------------------------------------------------
    1810. 

  1810. void OSQLParseNode::disjunctiveNormalForm(OSQLParseNode*& pSearchCondition)
    1811. 

  1811. {
    1812. 

  1812.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::disjunctiveNormalForm" );
    1813. 

  1813.     if(!pSearchCondition) // no where condition at entry point
    1814. 

  1814.         return;
    1815. 

  1815. 

  1816.     OSQLParseNode::absorptions(pSearchCondition);
    1817. 

  1817.     // '(' search_condition ')'
    1818. 

  1818.     if (SQL_ISRULE(pSearchCondition,boolean_primary))
    1819. 

  1819.     {
    1820. 

  1820.         OSQLParseNode* pLeft    = pSearchCondition->getChild(1);
    1821. 

  1821.         disjunctiveNormalForm(pLeft);
    1822. 

  1822.     }
    1823. 

  1823.     // search_condition SQL_TOKEN_OR boolean_term
    1824. 

  1824.     else if (SQL_ISRULE(pSearchCondition,search_condition))
    1825. 

  1825.     {
    1826. 

  1826.         OSQLParseNode* pLeft    = pSearchCondition->getChild(0);
    1827. 

  1827.         disjunctiveNormalForm(pLeft);
    1828. 

  1828. 

  1829.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    1830. 

  1830.         disjunctiveNormalForm(pRight);
    1831. 

  1831.     }
    1832. 

  1832.     // boolean_term SQL_TOKEN_AND boolean_factor
    1833. 

  1833.     else if (SQL_ISRULE(pSearchCondition,boolean_term))
    1834. 

  1834.     {
    1835. 

  1835.         OSQLParseNode* pLeft    = pSearchCondition->getChild(0);
    1836. 

  1836.         disjunctiveNormalForm(pLeft);
    1837. 

  1837. 

  1838.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    1839. 

  1839.         disjunctiveNormalForm(pRight);
    1840. 

  1840. 

  1841.         OSQLParseNode* pNewNode = NULL;
    1842. 

  1842.         // '(' search_condition ')' on left side
    1843. 

  1843.         if(pLeft->count() == 3 && SQL_ISRULE(pLeft,boolean_primary) && SQL_ISRULE(pLeft->getChild(1),search_condition))
    1844. 

  1844.         {
    1845. 

  1845.             // and-or tree  on left side
    1846. 

  1846.             OSQLParseNode* pOr = pLeft->getChild(1);
    1847. 

  1847.             OSQLParseNode* pNewLeft = NULL;
    1848. 

  1848.             OSQLParseNode* pNewRight = NULL;
    1849. 

  1849. 

  1850.             // cut right from parent
    1851. 

  1851.             pSearchCondition->removeAt(2);
    1852. 

  1852. 

  1853.             pNewRight   = MakeANDNode(pOr->removeAt(2)      ,pRight);
    1854. 

  1854.             pNewLeft    = MakeANDNode(pOr->removeAt((sal_uInt32)0)  ,new OSQLParseNode(*pRight));
    1855. 

  1855.             pNewNode    = MakeORNode(pNewLeft,pNewRight);
    1856. 

  1856.             // and append new Node
    1857. 

  1857.             replaceAndReset(pSearchCondition,pNewNode);
    1858. 

  1858. 

  1859.             disjunctiveNormalForm(pSearchCondition);
    1860. 

  1860.         }
    1861. 

  1861.         else if(pRight->count() == 3 && SQL_ISRULE(pRight,boolean_primary) && SQL_ISRULE(pRight->getChild(1),search_condition))
    1862. 

  1862.         {   // '(' search_condition ')' on right side
    1863. 

  1863.             // and-or tree  on right side
    1864. 

  1864.             // a and (b or c)
    1865. 

  1865.             OSQLParseNode* pOr = pRight->getChild(1);
    1866. 

  1866.             OSQLParseNode* pNewLeft = NULL;
    1867. 

  1867.             OSQLParseNode* pNewRight = NULL;
    1868. 

  1868. 

  1869.             // cut left from parent
    1870. 

  1870.             pSearchCondition->removeAt((sal_uInt32)0);
    1871. 

  1871. 

  1872.             pNewRight   = MakeANDNode(pLeft,pOr->removeAt(2));
    1873. 

  1873.             pNewLeft    = MakeANDNode(new OSQLParseNode(*pLeft),pOr->removeAt((sal_uInt32)0));
    1874. 

  1874.             pNewNode    = MakeORNode(pNewLeft,pNewRight);
    1875. 

  1875. 

  1876.             // and append new Node
    1877. 

  1877.             replaceAndReset(pSearchCondition,pNewNode);
    1878. 

  1878.             disjunctiveNormalForm(pSearchCondition);
    1879. 

  1879.         }
    1880. 

  1880.         else if(SQL_ISRULE(pLeft,boolean_primary) && (!SQL_ISRULE(pLeft->getChild(1),search_condition) || !SQL_ISRULE(pLeft->getChild(1),boolean_term)))
    1881. 

  1881.             pSearchCondition->replace(pLeft, pLeft->removeAt(1));
    1882. 

  1882.         else if(SQL_ISRULE(pRight,boolean_primary) && (!SQL_ISRULE(pRight->getChild(1),search_condition) || !SQL_ISRULE(pRight->getChild(1),boolean_term)))
    1883. 

  1883.             pSearchCondition->replace(pRight, pRight->removeAt(1));
    1884. 

  1884.     }
    1885. 

  1885. }
    1886. 

  1886. //-----------------------------------------------------------------------------
    1887. 

  1887. void OSQLParseNode::negateSearchCondition(OSQLParseNode*& pSearchCondition,sal_Bool bNegate)
    1888. 

  1888. {
    1889. 

  1889.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::negateSearchCondition" );
    1890. 

  1890.     if(!pSearchCondition) // no where condition at entry point
    1891. 

  1891.         return;
    1892. 

  1892.     // '(' search_condition ')'
    1893. 

  1893.     if (pSearchCondition->count() == 3 && SQL_ISRULE(pSearchCondition,boolean_primary))
    1894. 

  1894.     {
    1895. 

  1895.         OSQLParseNode* pRight = pSearchCondition->getChild(1);
    1896. 

  1896.         negateSearchCondition(pRight,bNegate);
    1897. 

  1897.     }
    1898. 

  1898.     // search_condition SQL_TOKEN_OR boolean_term
    1899. 

  1899.     else if (SQL_ISRULE(pSearchCondition,search_condition))
    1900. 

  1900.     {
    1901. 

  1901.         OSQLParseNode* pLeft    = pSearchCondition->getChild(0);
    1902. 

  1902.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    1903. 

  1903.         if(bNegate)
    1904. 

  1904.         {
    1905. 

  1905.             OSQLParseNode* pNewNode = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_term));
    1906. 

  1906.             pNewNode->append(pSearchCondition->removeAt((sal_uInt32)0));
    1907. 

  1907.             pNewNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii("AND"),SQL_NODE_KEYWORD,SQL_TOKEN_AND));
    1908. 

  1908.             pNewNode->append(pSearchCondition->removeAt((sal_uInt32)1));
    1909. 

  1909.             replaceAndReset(pSearchCondition,pNewNode);
    1910. 

  1910. 

  1911.             pLeft   = pNewNode->getChild(0);
    1912. 

  1912.             pRight  = pNewNode->getChild(2);
    1913. 

  1913.         }
    1914. 

  1914. 

  1915.         negateSearchCondition(pLeft,bNegate);
    1916. 

  1916.         negateSearchCondition(pRight,bNegate);
    1917. 

  1917.     }
    1918. 

  1918.     // boolean_term SQL_TOKEN_AND boolean_factor
    1919. 

  1919.     else if (SQL_ISRULE(pSearchCondition,boolean_term))
    1920. 

  1920.     {
    1921. 

  1921.         OSQLParseNode* pLeft    = pSearchCondition->getChild(0);
    1922. 

  1922.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    1923. 

  1923.         if(bNegate)
    1924. 

  1924.         {
    1925. 

  1925.             OSQLParseNode* pNewNode = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::search_condition));
    1926. 

  1926.             pNewNode->append(pSearchCondition->removeAt((sal_uInt32)0));
    1927. 

  1927.             pNewNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii("OR"),SQL_NODE_KEYWORD,SQL_TOKEN_OR));
    1928. 

  1928.             pNewNode->append(pSearchCondition->removeAt((sal_uInt32)1));
    1929. 

  1929.             replaceAndReset(pSearchCondition,pNewNode);
    1930. 

  1930. 

  1931.             pLeft   = pNewNode->getChild(0);
    1932. 

  1932.             pRight  = pNewNode->getChild(2);
    1933. 

  1933.         }
    1934. 

  1934. 

  1935.         negateSearchCondition(pLeft,bNegate);
    1936. 

  1936.         negateSearchCondition(pRight,bNegate);
    1937. 

  1937.     }
    1938. 

  1938.     // SQL_TOKEN_NOT ( boolean_test )
    1939. 

  1939.     else if (SQL_ISRULE(pSearchCondition,boolean_factor))
    1940. 

  1940.     {
    1941. 

  1941.         OSQLParseNode *pNot = pSearchCondition->removeAt((sal_uInt32)0);
    1942. 

  1942.         delete pNot;
    1943. 

  1943.         OSQLParseNode *pBooleanTest = pSearchCondition->removeAt((sal_uInt32)0);
    1944. 

  1944.         // TODO is this needed // pBooleanTest->setParent(NULL);
    1945. 

  1945.         replaceAndReset(pSearchCondition,pBooleanTest);
    1946. 

  1946. 

  1947.         if (!bNegate)
    1948. 

  1948.             negateSearchCondition(pSearchCondition,sal_True);   //  negate all deeper values
    1949. 

  1949.     }
    1950. 

  1950.     // row_value_constructor comparison row_value_constructor
    1951. 

  1951.     // row_value_constructor comparison any_all_some subquery
    1952. 

  1952.     else if(bNegate && (SQL_ISRULE(pSearchCondition,comparison_predicate) || SQL_ISRULE(pSearchCondition,all_or_any_predicate)))
    1953. 

  1953.     {
    1954. 

  1954.         OSQLParseNode* pComparison = pSearchCondition->getChild(1);
    1955. 

  1955.         OSQLParseNode* pNewComparison = NULL;
    1956. 

  1956.         switch(pComparison->getNodeType())
    1957. 

  1957.         {
    1958. 

  1958.             case SQL_NODE_EQUAL:
    1959. 

  1959.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii("<>"),SQL_NODE_NOTEQUAL,SQL_NOTEQUAL);
    1960. 

  1960.                 break;
    1961. 

  1961.             case SQL_NODE_LESS:
    1962. 

  1962.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii(">="),SQL_NODE_GREATEQ,SQL_GREATEQ);
    1963. 

  1963.                 break;
    1964. 

  1964.             case SQL_NODE_GREAT:
    1965. 

  1965.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii("<="),SQL_NODE_LESSEQ,SQL_LESSEQ);
    1966. 

  1966.                 break;
    1967. 

  1967.             case SQL_NODE_LESSEQ:
    1968. 

  1968.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii(">"),SQL_NODE_GREAT,SQL_GREAT);
    1969. 

  1969.                 break;
    1970. 

  1970.             case SQL_NODE_GREATEQ:
    1971. 

  1971.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii("<"),SQL_NODE_LESS,SQL_LESS);
    1972. 

  1972.                 break;
    1973. 

  1973.             case SQL_NODE_NOTEQUAL:
    1974. 

  1974.                 pNewComparison = new OSQLParseNode(::rtl::OUString::createFromAscii("="),SQL_NODE_EQUAL,SQL_EQUAL);
    1975. 

  1975.                 break;
    1976. 

  1976.             default:
    1977. 

  1977.                 OSL_ENSURE( false, "OSQLParseNode::negateSearchCondition: unexpected node type!" );
    1978. 

  1978.                 break;
    1979. 

  1979.         }
    1980. 

  1980.         pSearchCondition->replace(pComparison, pNewComparison);
    1981. 

  1981.         delete pComparison;
    1982. 

  1982.     }
    1983. 

  1983. 

  1984.     else if(bNegate && (SQL_ISRULE(pSearchCondition,test_for_null) || SQL_ISRULE(pSearchCondition,in_predicate) ||
    1985. 

  1985.                         SQL_ISRULE(pSearchCondition,between_predicate) || SQL_ISRULE(pSearchCondition,boolean_test) ))
    1986. 

  1986.     {
    1987. 

  1987.         sal_uInt32 nNotPos = 0;
    1988. 

  1988.         // row_value_constructor not SQL_TOKEN_IN in_predicate_value
    1989. 

  1989.         // row_value_constructor not SQL_TOKEN_BETWEEN row_value_constructor SQL_TOKEN_AND row_value_constructor
    1990. 

  1990.         if  (   SQL_ISRULE( pSearchCondition, in_predicate )
    1991. 

  1991.             ||  SQL_ISRULE( pSearchCondition, between_predicate )
    1992. 

  1992.             )
    1993. 

  1993.             nNotPos = 1;
    1994. 

  1994.         // row_value_constructor SQL_TOKEN_IS not SQL_TOKEN_NULL
    1995. 

  1995.         // boolean_primary SQL_TOKEN_IS not truth_value
    1996. 

  1996.         else if (   SQL_ISRULE( pSearchCondition, test_for_null )
    1997. 

  1997.                 ||  SQL_ISRULE( pSearchCondition, boolean_test )
    1998. 

  1998.                 )
    1999. 

  1999.             nNotPos = 2;
    2000. 

  2000. 

  2001.         OSQLParseNode* pNot = pSearchCondition->getChild(nNotPos);
    2002. 

  2002.         OSQLParseNode* pNotNot = NULL;
    2003. 

  2003.         if(pNot->isRule())
    2004. 

  2004.             pNotNot = new OSQLParseNode(::rtl::OUString::createFromAscii("NOT"),SQL_NODE_KEYWORD,SQL_TOKEN_NOT);
    2005. 

  2005.         else
    2006. 

  2006.             pNotNot = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::sql_not));
    2007. 

  2007.         pSearchCondition->replace(pNot, pNotNot);
    2008. 

  2008.         delete pNot;
    2009. 

  2009.     }
    2010. 

  2010.     else if(bNegate && (SQL_ISRULE(pSearchCondition,like_predicate)))
    2011. 

  2011.     {
    2012. 

  2012.         OSQLParseNode* pCheckForNOT = pSearchCondition->getChild( 1 );
    2013. 

  2013.         if ( SQL_ISTOKEN(pCheckForNOT,NOT) )
    2014. 

  2014.             delete pSearchCondition->removeAt( 1 );
    2015. 

  2015.         else
    2016. 

  2016.         {
    2017. 

  2017.             OSQLParseNode* pNot = new OSQLParseNode( ::rtl::OUString::createFromAscii( "NOT" ), SQL_NODE_KEYWORD, SQL_TOKEN_NOT );
    2018. 

  2018.             pSearchCondition->insert( 1, pNot );
    2019. 

  2019.         }
    2020. 

  2020.     }
    2021. 

  2021. }
    2022. 

  2022. //-----------------------------------------------------------------------------
    2023. 

  2023. void OSQLParseNode::eraseBraces(OSQLParseNode*& pSearchCondition)
    2024. 

  2024. {
    2025. 

  2025.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::eraseBraces" );
    2026. 

  2026.     if (pSearchCondition && (SQL_ISRULE(pSearchCondition,boolean_primary) || (pSearchCondition->count() == 3 && SQL_ISPUNCTUATION(pSearchCondition->getChild(0),"(") &&
    2027. 

  2027.          SQL_ISPUNCTUATION(pSearchCondition->getChild(2),")"))))
    2028. 

  2028.     {
    2029. 

  2029.         OSQLParseNode* pRight = pSearchCondition->getChild(1);
    2030. 

  2030.         absorptions(pRight);
    2031. 

  2031.         // if child is not a or or and tree then delete () around child
    2032. 

  2032.         if(!(SQL_ISRULE(pSearchCondition->getChild(1),boolean_term) || SQL_ISRULE(pSearchCondition->getChild(1),search_condition)) ||
    2033. 

  2033.             SQL_ISRULE(pSearchCondition->getChild(1),boolean_term) || // and can always stand without ()
    2034. 

  2034.             (SQL_ISRULE(pSearchCondition->getChild(1),search_condition) && SQL_ISRULE(pSearchCondition->getParent(),search_condition)))
    2035. 

  2035.         {
    2036. 

  2036.             OSQLParseNode* pNode = pSearchCondition->removeAt(1);
    2037. 

  2037.             replaceAndReset(pSearchCondition,pNode);
    2038. 

  2038.         }
    2039. 

  2039.     }
    2040. 

  2040. }
    2041. 

  2041. //-----------------------------------------------------------------------------
    2042. 

  2042. void OSQLParseNode::absorptions(OSQLParseNode*& pSearchCondition)
    2043. 

  2043. {
    2044. 

  2044.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::absorptions" );
    2045. 

  2045.     if(!pSearchCondition) // no where condition at entry point
    2046. 

  2046.         return;
    2047. 

  2047. 

  2048.     eraseBraces(pSearchCondition);
    2049. 

  2049. 

  2050.     if(SQL_ISRULE(pSearchCondition,boolean_term) || SQL_ISRULE(pSearchCondition,search_condition))
    2051. 

  2051.     {
    2052. 

  2052.         OSQLParseNode* pLeft = pSearchCondition->getChild(0);
    2053. 

  2053.         absorptions(pLeft);
    2054. 

  2054.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    2055. 

  2055.         absorptions(pRight);
    2056. 

  2056.     }
    2057. 

  2057. 

  2058.     sal_uInt32 nPos = 0;
    2059. 

  2059.     // a and a || a or a
    2060. 

  2060.     OSQLParseNode* pNewNode = NULL;
    2061. 

  2061.     if(( SQL_ISRULE(pSearchCondition,boolean_term) || SQL_ISRULE(pSearchCondition,search_condition))
    2062. 

  2062.         && *pSearchCondition->getChild(0) == *pSearchCondition->getChild(2))
    2063. 

  2063.     {
    2064. 

  2064.         pNewNode = pSearchCondition->removeAt((sal_uInt32)0);
    2065. 

  2065.         replaceAndReset(pSearchCondition,pNewNode);
    2066. 

  2066.     }
    2067. 

  2067.     // (a or b) and a || ( b or c ) and a
    2068. 

  2068.     // a and ( a or b) || a and ( b or c )
    2069. 

  2069.     else if (   SQL_ISRULE(pSearchCondition,boolean_term)
    2070. 

  2070.             &&  (
    2071. 

  2071.                     (       SQL_ISRULE(pSearchCondition->getChild(nPos = 0),boolean_primary)
    2072. 

  2072.                         ||  SQL_ISRULE(pSearchCondition->getChild(nPos),search_condition)
    2073. 

  2073.                     )
    2074. 

  2074.                 ||  (       SQL_ISRULE(pSearchCondition->getChild(nPos = 2),boolean_primary)
    2075. 

  2075.                         ||  SQL_ISRULE(pSearchCondition->getChild(nPos),search_condition)
    2076. 

  2076.                     )
    2077. 

  2077.                 )
    2078. 

  2078.             )
    2079. 

  2079.     {
    2080. 

  2080.         OSQLParseNode* p2ndSearch = pSearchCondition->getChild(nPos);
    2081. 

  2081.         if ( SQL_ISRULE(p2ndSearch,boolean_primary) )
    2082. 

  2082.             p2ndSearch = p2ndSearch->getChild(1);
    2083. 

  2083. 

  2084.         if ( *p2ndSearch->getChild(0) == *pSearchCondition->getChild(2-nPos) ) // a and ( a or b) -> a or b
    2085. 

  2085.         {
    2086. 

  2086.             pNewNode = pSearchCondition->removeAt((sal_uInt32)0);
    2087. 

  2087.             replaceAndReset(pSearchCondition,pNewNode);
    2088. 

  2088. 

  2089.         }
    2090. 

  2090.         else if ( *p2ndSearch->getChild(2) == *pSearchCondition->getChild(2-nPos) ) // a and ( b or a) -> a or b
    2091. 

  2091.         {
    2092. 

  2092.             pNewNode = pSearchCondition->removeAt((sal_uInt32)2);
    2093. 

  2093.             replaceAndReset(pSearchCondition,pNewNode);
    2094. 

  2094.         }
    2095. 

  2095.         else if ( p2ndSearch->getByRule(OSQLParseNode::search_condition) )
    2096. 

  2096.         {
    2097. 

  2097.             // a and ( b or c ) -> ( a and b ) or ( a and c )
    2098. 

  2098.             // ( b or c ) and a -> ( a and b ) or ( a and c )
    2099. 

  2099.             OSQLParseNode* pC = p2ndSearch->removeAt((sal_uInt32)2);
    2100. 

  2100.             OSQLParseNode* pB = p2ndSearch->removeAt((sal_uInt32)0);
    2101. 

  2101.             OSQLParseNode* pA = pSearchCondition->removeAt((sal_uInt32)2-nPos);
    2102. 

  2102. 

  2103.             OSQLParseNode* p1stAnd = MakeANDNode(pA,pB);
    2104. 

  2104.             OSQLParseNode* p2ndAnd = MakeANDNode(new OSQLParseNode(*pA),pC);
    2105. 

  2105.             pNewNode = MakeORNode(p1stAnd,p2ndAnd);
    2106. 

  2106. 			OSQLParseNode* pNode = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_primary));
    2107. 

  2107.             pNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii("("),SQL_NODE_PUNCTUATION));
    2108. 

  2108.             pNode->append(pNewNode);
    2109. 

  2109.             pNode->append(new OSQLParseNode(::rtl::OUString::createFromAscii(")"),SQL_NODE_PUNCTUATION));
    2110. 

  2110. 			OSQLParseNode::eraseBraces(p1stAnd);
    2111. 

  2111.             OSQLParseNode::eraseBraces(p2ndAnd);
    2112. 

  2112.             replaceAndReset(pSearchCondition,pNode);
    2113. 

  2113.         }
    2114. 

  2114.     }
    2115. 

  2115.     // a or a and b || a or b and a
    2116. 

  2116.     else if(SQL_ISRULE(pSearchCondition,search_condition) && SQL_ISRULE(pSearchCondition->getChild(2),boolean_term))
    2117. 

  2117.     {
    2118. 

  2118.         if(*pSearchCondition->getChild(2)->getChild(0) == *pSearchCondition->getChild(0))
    2119. 

  2119.         {
    2120. 

  2120.             pNewNode = pSearchCondition->removeAt((sal_uInt32)0);
    2121. 

  2121.             replaceAndReset(pSearchCondition,pNewNode);
    2122. 

  2122.         }
    2123. 

  2123.         else if(*pSearchCondition->getChild(2)->getChild(2) == *pSearchCondition->getChild(0))
    2124. 

  2124.         {
    2125. 

  2125.             pNewNode = pSearchCondition->removeAt((sal_uInt32)0);
    2126. 

  2126.             replaceAndReset(pSearchCondition,pNewNode);
    2127. 

  2127.         }
    2128. 

  2128.     }
    2129. 

  2129.     // a and b or a || b and a or a
    2130. 

  2130.     else if(SQL_ISRULE(pSearchCondition,search_condition) && SQL_ISRULE(pSearchCondition->getChild(0),boolean_term))
    2131. 

  2131.     {
    2132. 

  2132.         if(*pSearchCondition->getChild(0)->getChild(0) == *pSearchCondition->getChild(2))
    2133. 

  2133.         {
    2134. 

  2134.             pNewNode = pSearchCondition->removeAt((sal_uInt32)2);
    2135. 

  2135.             replaceAndReset(pSearchCondition,pNewNode);
    2136. 

  2136.         }
    2137. 

  2137.         else if(*pSearchCondition->getChild(0)->getChild(2) == *pSearchCondition->getChild(2))
    2138. 

  2138.         {
    2139. 

  2139.             pNewNode = pSearchCondition->removeAt((sal_uInt32)2);
    2140. 

  2140.             replaceAndReset(pSearchCondition,pNewNode);
    2141. 

  2141.         }
    2142. 

  2142.     }
    2143. 

  2143.     eraseBraces(pSearchCondition);
    2144. 

  2144. }
    2145. 

  2145. //-----------------------------------------------------------------------------
    2146. 

  2146. void OSQLParseNode::compress(OSQLParseNode *&pSearchCondition)
    2147. 

  2147. {
    2148. 

  2148.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::compress" );
    2149. 

  2149.     if(!pSearchCondition) // no where condition at entry point
    2150. 

  2150.         return;
    2151. 

  2151. 

  2152.     OSQLParseNode::eraseBraces(pSearchCondition);
    2153. 

  2153. 

  2154.     if(SQL_ISRULE(pSearchCondition,boolean_term) || SQL_ISRULE(pSearchCondition,search_condition))
    2155. 

  2155.     {
    2156. 

  2156.         OSQLParseNode* pLeft = pSearchCondition->getChild(0);
    2157. 

  2157.         compress(pLeft);
    2158. 

  2158. 

  2159.         OSQLParseNode* pRight = pSearchCondition->getChild(2);
    2160. 

  2160.         compress(pRight);
    2161. 

  2161.     }
    2162. 

  2162.     else if( SQL_ISRULE(pSearchCondition,boolean_primary) || (pSearchCondition->count() == 3 && SQL_ISPUNCTUATION(pSearchCondition->getChild(0),"(") &&
    2163. 

  2163.              SQL_ISPUNCTUATION(pSearchCondition->getChild(2),")")))
    2164. 

  2164.     {
    2165. 

  2165.         OSQLParseNode* pRight = pSearchCondition->getChild(1);
    2166. 

  2166.         compress(pRight);
    2167. 

  2167.         // if child is not a or or and tree then delete () around child
    2168. 

  2168.         if(!(SQL_ISRULE(pSearchCondition->getChild(1),boolean_term) || SQL_ISRULE(pSearchCondition->getChild(1),search_condition)) ||
    2169. 

  2169.             (SQL_ISRULE(pSearchCondition->getChild(1),boolean_term) && SQL_ISRULE(pSearchCondition->getParent(),boolean_term)) ||
    2170. 

  2170.             (SQL_ISRULE(pSearchCondition->getChild(1),search_condition) && SQL_ISRULE(pSearchCondition->getParent(),search_condition)))
    2171. 

  2171.         {
    2172. 

  2172.             OSQLParseNode* pNode = pSearchCondition->removeAt(1);
    2173. 

  2173.             replaceAndReset(pSearchCondition,pNode);
    2174. 

  2174.         }
    2175. 

  2175.     }
    2176. 

  2176. 

  2177.     // or with two and trees where one element of the and trees are equal
    2178. 

  2178.     if(SQL_ISRULE(pSearchCondition,search_condition) && SQL_ISRULE(pSearchCondition->getChild(0),boolean_term) && SQL_ISRULE(pSearchCondition->getChild(2),boolean_term))
    2179. 

  2179.     {
    2180. 

  2180.         if(*pSearchCondition->getChild(0)->getChild(0) == *pSearchCondition->getChild(2)->getChild(0))
    2181. 

  2181.         {
    2182. 

  2182.             OSQLParseNode* pLeft    = pSearchCondition->getChild(0)->removeAt(2);
    2183. 

  2183.             OSQLParseNode* pRight = pSearchCondition->getChild(2)->removeAt(2);
    2184. 

  2184.             OSQLParseNode* pNode    = MakeORNode(pLeft,pRight);
    2185. 

  2185. 

  2186.             OSQLParseNode* pNewRule = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_primary));
    2187. 

  2187.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii("("),SQL_NODE_PUNCTUATION));
    2188. 

  2188.             pNewRule->append(pNode);
    2189. 

  2189.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii(")"),SQL_NODE_PUNCTUATION));
    2190. 

  2190. 

  2191.             OSQLParseNode::eraseBraces(pLeft);
    2192. 

  2192.             OSQLParseNode::eraseBraces(pRight);
    2193. 

  2193. 

  2194.             pNode = MakeANDNode(pSearchCondition->getChild(0)->removeAt((sal_uInt32)0),pNewRule);
    2195. 

  2195.             replaceAndReset(pSearchCondition,pNode);
    2196. 

  2196.         }
    2197. 

  2197.         else if(*pSearchCondition->getChild(0)->getChild(2) == *pSearchCondition->getChild(2)->getChild(0))
    2198. 

  2198.         {
    2199. 

  2199.             OSQLParseNode* pLeft = pSearchCondition->getChild(0)->removeAt((sal_uInt32)0);
    2200. 

  2200.             OSQLParseNode* pRight = pSearchCondition->getChild(2)->removeAt(2);
    2201. 

  2201.             OSQLParseNode* pNode = MakeORNode(pLeft,pRight);
    2202. 

  2202. 

  2203.             OSQLParseNode* pNewRule = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_primary));
    2204. 

  2204.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii("("),SQL_NODE_PUNCTUATION));
    2205. 

  2205.             pNewRule->append(pNode);
    2206. 

  2206.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii(")"),SQL_NODE_PUNCTUATION));
    2207. 

  2207. 

  2208.             OSQLParseNode::eraseBraces(pLeft);
    2209. 

  2209.             OSQLParseNode::eraseBraces(pRight);
    2210. 

  2210. 

  2211.             pNode = MakeANDNode(pSearchCondition->getChild(0)->removeAt(1),pNewRule);
    2212. 

  2212.             replaceAndReset(pSearchCondition,pNode);
    2213. 

  2213.         }
    2214. 

  2214.         else if(*pSearchCondition->getChild(0)->getChild(0) == *pSearchCondition->getChild(2)->getChild(2))
    2215. 

  2215.         {
    2216. 

  2216.             OSQLParseNode* pLeft    = pSearchCondition->getChild(0)->removeAt(2);
    2217. 

  2217.             OSQLParseNode* pRight = pSearchCondition->getChild(2)->removeAt((sal_uInt32)0);
    2218. 

  2218.             OSQLParseNode* pNode    = MakeORNode(pLeft,pRight);
    2219. 

  2219. 

  2220.             OSQLParseNode* pNewRule = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_primary));
    2221. 

  2221.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii("("),SQL_NODE_PUNCTUATION));
    2222. 

  2222.             pNewRule->append(pNode);
    2223. 

  2223.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii(")"),SQL_NODE_PUNCTUATION));
    2224. 

  2224. 

  2225.             OSQLParseNode::eraseBraces(pLeft);
    2226. 

  2226.             OSQLParseNode::eraseBraces(pRight);
    2227. 

  2227. 

  2228.             pNode = MakeANDNode(pSearchCondition->getChild(0)->removeAt((sal_uInt32)0),pNewRule);
    2229. 

  2229.             replaceAndReset(pSearchCondition,pNode);
    2230. 

  2230.         }
    2231. 

  2231.         else if(*pSearchCondition->getChild(0)->getChild(2) == *pSearchCondition->getChild(2)->getChild(2))
    2232. 

  2232.         {
    2233. 

  2233.             OSQLParseNode* pLeft    = pSearchCondition->getChild(0)->removeAt((sal_uInt32)0);
    2234. 

  2234.             OSQLParseNode* pRight = pSearchCondition->getChild(2)->removeAt((sal_uInt32)0);
    2235. 

  2235.             OSQLParseNode* pNode    = MakeORNode(pLeft,pRight);
    2236. 

  2236. 

  2237.             OSQLParseNode* pNewRule = new OSQLParseNode(::rtl::OUString(),SQL_NODE_RULE,OSQLParser::RuleID(OSQLParseNode::boolean_primary));
    2238. 

  2238.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii("("),SQL_NODE_PUNCTUATION));
    2239. 

  2239.             pNewRule->append(pNode);
    2240. 

  2240.             pNewRule->append(new OSQLParseNode(::rtl::OUString::createFromAscii(")"),SQL_NODE_PUNCTUATION));
    2241. 

  2241. 

  2242.             OSQLParseNode::eraseBraces(pLeft);
    2243. 

  2243.             OSQLParseNode::eraseBraces(pRight);
    2244. 

  2244. 

  2245.             pNode = MakeANDNode(pSearchCondition->getChild(0)->removeAt(1),pNewRule);
    2246. 

  2246.             replaceAndReset(pSearchCondition,pNode);
    2247. 

  2247.         }
    2248. 

  2248.     }
    2249. 

  2249. }
    2250. 

  2250. #if OSL_DEBUG_LEVEL > 0
    2251. 

  2251. // -----------------------------------------------------------------------------
    2252. 

  2252. void OSQLParseNode::showParseTree( ::rtl::OUString& rString ) const
    2253. 

  2253. {
    2254. 

  2254.     ::rtl::OUStringBuffer aBuf;
    2255. 

  2255.     showParseTree( aBuf, 0 );
    2256. 

  2256.     rString = aBuf.makeStringAndClear();
    2257. 

  2257. }
    2258. 

  2258. 

  2259. // -----------------------------------------------------------------------------
    2260. 

  2260. void OSQLParseNode::showParseTree( ::rtl::OUStringBuffer& _inout_rBuffer, sal_uInt32 nLevel ) const
    2261. 

  2261. {
    2262. 

  2262.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::showParseTree" );
    2263. 

  2263. 

  2264.     for ( sal_uInt32 j=0; j<nLevel; ++j)
    2265. 

  2265.         _inout_rBuffer.appendAscii( "  " );
    2266. 

  2266. 

  2267.     if ( !isToken() )
    2268. 

  2268.     {
    2269. 

  2269.         // Regelnamen als rule: ...
    2270. 

  2270.         _inout_rBuffer.appendAscii( "RULE_ID: " );
    2271. 

  2271.         _inout_rBuffer.append( (sal_Int32)getRuleID() );
    2272. 

  2272.         _inout_rBuffer.append( sal_Unicode( '(' ) );
    2273. 

  2273.         _inout_rBuffer.append( OSQLParser::RuleIDToStr( getRuleID() ) );
    2274. 

  2274.         _inout_rBuffer.append( sal_Unicode( ')' ) );
    2275. 

  2275.         _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2276. 

  2276. 

  2277.         // hol dir den ersten Subtree
    2278. 

  2278.         for (   OSQLParseNodes::const_iterator i = m_aChildren.begin();
    2279. 

  2279.                 i != m_aChildren.end();
    2280. 

  2280.                 ++i
    2281. 

  2281.              )
    2282. 

  2282.             (*i)->showParseTree( _inout_rBuffer, nLevel+1 );
    2283. 

  2283.     }
    2284. 

  2284.     else
    2285. 

  2285.     {
    2286. 

  2286.         // ein Token gefunden
    2287. 

  2287.         switch (m_eNodeType)
    2288. 

  2288.         {
    2289. 

  2289. 

  2290.         case SQL_NODE_KEYWORD:
    2291. 

  2291.             _inout_rBuffer.appendAscii( "SQL_KEYWORD: " );
    2292. 

  2292.             _inout_rBuffer.append( ::rtl::OStringToOUString( OSQLParser::TokenIDToStr( getTokenID() ), RTL_TEXTENCODING_UTF8 ) );
    2293. 

  2293.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2294. 

  2294.             break;
    2295. 

  2295. 

  2296.         case SQL_NODE_COMPARISON:
    2297. 

  2297.             _inout_rBuffer.appendAscii( "SQL_COMPARISON: " );
    2298. 

  2298.             _inout_rBuffer.append( m_aNodeValue );
    2299. 

  2299.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2300. 

  2300.             break;
    2301. 

  2301. 

  2302.         case SQL_NODE_NAME:
    2303. 

  2303.             _inout_rBuffer.appendAscii( "SQL_NAME: " );
    2304. 

  2304.             _inout_rBuffer.append( sal_Unicode( '"' ) );
    2305. 

  2305.             _inout_rBuffer.append( m_aNodeValue );
    2306. 

  2306.             _inout_rBuffer.append( sal_Unicode( '"' ) );
    2307. 

  2307.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2308. 

  2308.              break;
    2309. 

  2309. 

  2310.         case SQL_NODE_STRING:
    2311. 

  2311.             _inout_rBuffer.appendAscii( "SQL_STRING: " );
    2312. 

  2312.             _inout_rBuffer.append( sal_Unicode( '\'' ) );
    2313. 

  2313.             _inout_rBuffer.append( m_aNodeValue );
    2314. 

  2314.             _inout_rBuffer.append( sal_Unicode( '\'' ) );
    2315. 

  2315.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2316. 

  2316.             break;
    2317. 

  2317. 

  2318.         case SQL_NODE_INTNUM:
    2319. 

  2319.             _inout_rBuffer.appendAscii( "SQL_INTNUM: " );
    2320. 

  2320.             _inout_rBuffer.append( m_aNodeValue );
    2321. 

  2321.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2322. 

  2322.             break;
    2323. 

  2323. 

  2324.         case SQL_NODE_APPROXNUM:
    2325. 

  2325.             _inout_rBuffer.appendAscii( "SQL_APPROXNUM: " );
    2326. 

  2326.             _inout_rBuffer.append( m_aNodeValue );
    2327. 

  2327.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2328. 

  2328.              break;
    2329. 

  2329. 

  2330.         case SQL_NODE_PUNCTUATION:
    2331. 

  2331.             _inout_rBuffer.appendAscii( "SQL_PUNCTUATION: " );
    2332. 

  2332.             _inout_rBuffer.append( m_aNodeValue );
    2333. 

  2333.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2334. 

  2334.             break;
    2335. 

  2335. 

  2336.         case SQL_NODE_AMMSC:
    2337. 

  2337.             _inout_rBuffer.appendAscii( "SQL_AMMSC: " );
    2338. 

  2338.             _inout_rBuffer.append( m_aNodeValue );
    2339. 

  2339.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2340. 

  2340.             break;
    2341. 

  2341. 

  2342.         case SQL_NODE_EQUAL:
    2343. 

  2343.         case SQL_NODE_LESS:
    2344. 

  2344.         case SQL_NODE_GREAT:
    2345. 

  2345.         case SQL_NODE_LESSEQ:
    2346. 

  2346.         case SQL_NODE_GREATEQ:
    2347. 

  2347.         case SQL_NODE_NOTEQUAL:
    2348. 

  2348.             _inout_rBuffer.append( m_aNodeValue );
    2349. 

  2349.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2350. 

  2350.             break;
    2351. 

  2351. 

  2352.         case SQL_NODE_ACCESS_DATE:
    2353. 

  2353.             _inout_rBuffer.appendAscii( "SQL_ACCESS_DATE: " );
    2354. 

  2354.             _inout_rBuffer.append( m_aNodeValue );
    2355. 

  2355.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2356. 

  2356.             break;
    2357. 

  2357. 

  2358.         case SQL_NODE_DATE:
    2359. 

  2359.             _inout_rBuffer.appendAscii( "SQL_DATE: " );
    2360. 

  2360.             _inout_rBuffer.append( m_aNodeValue );
    2361. 

  2361.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2362. 

  2362.             break;
    2363. 

  2363. 

  2364.         case SQL_NODE_CONCAT:
    2365. 

  2365.             _inout_rBuffer.appendAscii( "||" );
    2366. 

  2366.             _inout_rBuffer.append( sal_Unicode( '\n' ) );
    2367. 

  2367.             break;
    2368. 

  2368. 

  2369.         default:
    2370. 

  2370.             OSL_TRACE( "-- %i", int( m_eNodeType ) );
    2371. 

  2371.             OSL_ENSURE( false, "OSQLParser::ShowParseTree: unzulaessiger NodeType" );
    2372. 

  2372.         }
    2373. 

  2373.     }
    2374. 

  2374. }
    2375. 

  2375. #endif // OSL_DEBUG_LEVEL > 0
    2376. 

  2376. // -----------------------------------------------------------------------------
    2377. 

  2377. // Insert-Methoden
    2378. 

  2378. //-----------------------------------------------------------------------------
    2379. 

  2379. void OSQLParseNode::insert(sal_uInt32 nPos, OSQLParseNode* pNewSubTree)
    2380. 

  2380. {
    2381. 

  2381.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::insert" );
    2382. 

  2382.     OSL_ENSURE(pNewSubTree != NULL, "OSQLParseNode: ungueltiger NewSubTree");
    2383. 

  2383.     OSL_ENSURE(pNewSubTree->getParent() == NULL, "OSQLParseNode: Knoten ist kein Waise");
    2384. 

  2384. 

  2385.     // stelle Verbindung zum getParent her:
    2386. 

  2386.     pNewSubTree->setParent( this );
    2387. 

  2387.     m_aChildren.insert(m_aChildren.begin() + nPos, pNewSubTree);
    2388. 

  2388. }
    2389. 

  2389. 

  2390. // removeAt-Methoden
    2391. 

  2391. //-----------------------------------------------------------------------------
    2392. 

  2392. OSQLParseNode* OSQLParseNode::removeAt(sal_uInt32 nPos)
    2393. 

  2393. {
    2394. 

  2394.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::removeAt" );
    2395. 

  2395.     OSL_ENSURE(nPos < m_aChildren.size(),"Illegal position for removeAt");
    2396. 

  2396.     OSQLParseNodes::iterator aPos(m_aChildren.begin() + nPos);
    2397. 

  2397.     OSQLParseNode* pNode = *aPos;
    2398. 

  2398. 

  2399.     // setze den getParent des removeten auf NULL
    2400. 

  2400.     pNode->setParent( NULL );
    2401. 

  2401. 

  2402.     m_aChildren.erase(aPos);
    2403. 

  2403.     return pNode;
    2404. 

  2404. }
    2405. 

  2405. //-----------------------------------------------------------------------------
    2406. 

  2406. OSQLParseNode* OSQLParseNode::remove(OSQLParseNode* pSubTree)
    2407. 

  2407. {
    2408. 

  2408.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::remove" );
    2409. 

  2409.     OSL_ENSURE(pSubTree != NULL, "OSQLParseNode: ungueltiger SubTree");
    2410. 

  2410.     OSQLParseNodes::iterator aPos = ::std::find(m_aChildren.begin(), m_aChildren.end(), pSubTree);
    2411. 

  2411.     if (aPos != m_aChildren.end())
    2412. 

  2412.     {
    2413. 

  2413.         // setze den getParent des removeten auf NULL
    2414. 

  2414.         pSubTree->setParent( NULL );
    2415. 

  2415.         m_aChildren.erase(aPos);
    2416. 

  2416.         return pSubTree;
    2417. 

  2417.     }
    2418. 

  2418.     else
    2419. 

  2419.         return NULL;
    2420. 

  2420. }
    2421. 

  2421. 

  2422. // Replace-Methoden
    2423. 

  2423. //-----------------------------------------------------------------------------
    2424. 

  2424. OSQLParseNode* OSQLParseNode::replaceAt(sal_uInt32 nPos, OSQLParseNode* pNewSubNode)
    2425. 

  2425. {
    2426. 

  2426.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::replaceAt" );
    2427. 

  2427.     OSL_ENSURE(pNewSubNode != NULL, "OSQLParseNode: invalid nodes");
    2428. 

  2428.     OSL_ENSURE(pNewSubNode->getParent() == NULL, "OSQLParseNode: node already has getParent");
    2429. 

  2429.     OSL_ENSURE(nPos < m_aChildren.size(), "OSQLParseNode: invalid position");
    2430. 

  2430.     OSL_ENSURE(::std::find(m_aChildren.begin(), m_aChildren.end(), pNewSubNode) == m_aChildren.end(),
    2431. 

  2431.             "OSQLParseNode::Replace() Node already element of parent");
    2432. 

  2432. 

  2433.     OSQLParseNode* pOldSubNode = m_aChildren[nPos];
    2434. 

  2434. 

  2435.     // stelle Verbindung zum getParent her:
    2436. 

  2436.     pNewSubNode->setParent( this );
    2437. 

  2437.     pOldSubNode->setParent( NULL );
    2438. 

  2438. 

  2439.     m_aChildren[nPos] = pNewSubNode;
    2440. 

  2440.     return pOldSubNode;
    2441. 

  2441. }
    2442. 

  2442. 

  2443. //-----------------------------------------------------------------------------
    2444. 

  2444. OSQLParseNode* OSQLParseNode::replace (OSQLParseNode* pOldSubNode, OSQLParseNode* pNewSubNode )
    2445. 

  2445. {
    2446. 

  2446.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::replace " );
    2447. 

  2447.     OSL_ENSURE(pOldSubNode != NULL && pNewSubNode != NULL, "OSQLParseNode: invalid nodes");
    2448. 

  2448.     OSL_ENSURE(pNewSubNode->getParent() == NULL, "OSQLParseNode: node already has getParent");
    2449. 

  2449.     OSL_ENSURE(::std::find(m_aChildren.begin(), m_aChildren.end(), pOldSubNode) != m_aChildren.end(),
    2450. 

  2450.             "OSQLParseNode::Replace() Node not element of parent");
    2451. 

  2451.     OSL_ENSURE(::std::find(m_aChildren.begin(), m_aChildren.end(), pNewSubNode) == m_aChildren.end(),
    2452. 

  2452.             "OSQLParseNode::Replace() Node already element of parent");
    2453. 

  2453. 

  2454.     pOldSubNode->setParent( NULL );
    2455. 

  2455.     pNewSubNode->setParent( this );
    2456. 

  2456.     ::std::replace(m_aChildren.begin(), m_aChildren.end(), pOldSubNode, pNewSubNode);
    2457. 

  2457.     return pOldSubNode;
    2458. 

  2458. }
    2459. 

  2459. // -----------------------------------------------------------------------------
    2460. 

  2460. void OSQLParseNode::parseLeaf(::rtl::OUStringBuffer& rString, const SQLParseNodeParameter& rParam) const
    2461. 

  2461. {
    2462. 

  2462.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::parseLeaf" );
    2463. 

  2463.     // ein Blatt ist gefunden
    2464. 

  2464.     // Inhalt dem Ausgabestring anfuegen
    2465. 

  2465.     switch (m_eNodeType)
    2466. 

  2466.     {
    2467. 

  2467.         case SQL_NODE_KEYWORD:
    2468. 

  2468.         {
    2469. 

  2469.             if (rString.getLength())
    2470. 

  2470.                 rString.appendAscii(" ");
    2471. 

  2471. 

  2472.             const ::rtl::OString sT = OSQLParser::TokenIDToStr(m_nNodeID, &rParam.m_rContext);
    2473. 

  2473.             rString.append(::rtl::OUString(sT,sT.getLength(),RTL_TEXTENCODING_UTF8));
    2474. 

  2474.         }   break;
    2475. 

  2475.         case SQL_NODE_STRING:
    2476. 

  2476.             if (rString.getLength())
    2477. 

  2477.                 rString.appendAscii(" ");
    2478. 

  2478.             rString.append(SetQuotation(m_aNodeValue,::rtl::OUString::createFromAscii("\'"),::rtl::OUString::createFromAscii("\'\'")));
    2479. 

  2479.             break;
    2480. 

  2480.         case SQL_NODE_NAME:
    2481. 

  2481.             if (rString.getLength())
    2482. 

  2482.             {
    2483. 

  2483.                 switch(rString.charAt(rString.getLength()-1) )
    2484. 

  2484.                 {
    2485. 

  2485.                     case ' ' :
    2486. 

  2486.                     case '.' : break;
    2487. 

  2487.                     default  :
    2488. 

  2488.                         if  (   !rParam.aMetaData.getCatalogSeparator().getLength()
    2489. 

  2489.                             ||  rString.charAt( rString.getLength()-1 ) != rParam.aMetaData.getCatalogSeparator().toChar()
    2490. 

  2490.                             )
    2491. 

  2491.                             rString.appendAscii(" "); break;
    2492. 

  2492.                 }
    2493. 

  2493.             }
    2494. 

  2494.             if (rParam.bQuote)
    2495. 

  2495.             {
    2496. 

  2496.                 if (rParam.bPredicate)
    2497. 

  2497.                 {
    2498. 

  2498.                     rString.appendAscii("[");
    2499. 

  2499.                     rString.append(m_aNodeValue);
    2500. 

  2500.                     rString.appendAscii("]");
    2501. 

  2501.                 }
    2502. 

  2502.                 else
    2503. 

  2503.                     rString.append(SetQuotation(m_aNodeValue,
    2504. 

  2504.                         rParam.aMetaData.getIdentifierQuoteString(), rParam.aMetaData.getIdentifierQuoteString() ));
    2505. 

  2505.             }
    2506. 

  2506.             else
    2507. 

  2507.                 rString.append(m_aNodeValue);
    2508. 

  2508.             break;
    2509. 

  2509.         case SQL_NODE_ACCESS_DATE:
    2510. 

  2510.             if (rString.getLength())
    2511. 

  2511.                 rString.appendAscii(" ");
    2512. 

  2512.             rString.appendAscii("#");
    2513. 

  2513.             rString.append(m_aNodeValue);
    2514. 

  2514.             rString.appendAscii("#");
    2515. 

  2515.             break;
    2516. 

  2516.         case SQL_NODE_INTNUM:
    2517. 

  2517.         case SQL_NODE_APPROXNUM:
    2518. 

  2518.             {
    2519. 

  2519.                 ::rtl::OUString aTmp = m_aNodeValue;
    2520. 

  2520.                 if (rParam.bInternational && rParam.bPredicate && rParam.cDecSep != '.')
    2521. 

  2521.                     aTmp = aTmp.replace('.', rParam.cDecSep);
    2522. 

  2522. 

  2523.                 if (rString.getLength())
    2524. 

  2524.                     rString.appendAscii(" ");
    2525. 

  2525.                 rString.append(aTmp);
    2526. 

  2526. 

  2527.             }   break;
    2528. 

  2528.             // fall through
    2529. 

  2529.         default:
    2530. 

  2530.             if (rString.getLength() && m_aNodeValue.toChar() != '.' && m_aNodeValue.toChar() != ':' )
    2531. 

  2531.             {
    2532. 

  2532.                 switch( rString.charAt(rString.getLength()-1) )
    2533. 

  2533.                 {
    2534. 

  2534.                     case ' ' :
    2535. 

  2535.                     case '.' : break;
    2536. 

  2536.                     default  :
    2537. 

  2537.                         if  (   !rParam.aMetaData.getCatalogSeparator().getLength()
    2538. 

  2538.                             ||  rString.charAt( rString.getLength()-1 ) != rParam.aMetaData.getCatalogSeparator().toChar()
    2539. 

  2539.                             )
    2540. 

  2540.                             rString.appendAscii(" "); break;
    2541. 

  2541.                 }
    2542. 

  2542.             }
    2543. 

  2543.             rString.append(m_aNodeValue);
    2544. 

  2544.     }
    2545. 

  2545. }
    2546. 

  2546. 

  2547. // -----------------------------------------------------------------------------
    2548. 

  2548. sal_Int32 OSQLParser::getFunctionReturnType(const ::rtl::OUString& _sFunctionName, const IParseContext* pContext)
    2549. 

  2549. {
    2550. 

  2550.     sal_Int32 nType = DataType::VARCHAR;
    2551. 

  2551.     ::rtl::OString sFunctionName(_sFunctionName,_sFunctionName.getLength(),RTL_TEXTENCODING_UTF8);
    2552. 

  2552. 

  2553.     if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ASCII,pContext)))                     nType = DataType::INTEGER;
    2554. 

  2554.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_BIT_LENGTH,pContext)))           nType = DataType::INTEGER;
    2555. 

  2555.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CHAR,pContext)))                 nType = DataType::VARCHAR;
    2556. 

  2556.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CHAR_LENGTH,pContext)))          nType = DataType::INTEGER;
    2557. 

  2557.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CHARACTER_LENGTH,pContext)))     nType = DataType::INTEGER;
    2558. 

  2558.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CONCAT,pContext)))               nType = DataType::VARCHAR;
    2559. 

  2559.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DIFFERENCE,pContext)))           nType = DataType::VARCHAR;
    2560. 

  2560.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_INSERT,pContext)))               nType = DataType::VARCHAR;
    2561. 

  2561.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LCASE,pContext)))                nType = DataType::VARCHAR;
    2562. 

  2562.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LEFT,pContext)))                 nType = DataType::VARCHAR;
    2563. 

  2563.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LENGTH,pContext)))               nType = DataType::INTEGER;
    2564. 

  2564.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOCATE,pContext)))               nType = DataType::VARCHAR;
    2565. 

  2565.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOCATE_2,pContext)))             nType = DataType::VARCHAR;
    2566. 

  2566.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LTRIM,pContext)))                nType = DataType::VARCHAR;
    2567. 

  2567.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_OCTET_LENGTH,pContext)))         nType = DataType::INTEGER;
    2568. 

  2568.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_POSITION,pContext)))             nType = DataType::INTEGER;
    2569. 

  2569.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_REPEAT,pContext)))               nType = DataType::VARCHAR;
    2570. 

  2570.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_REPLACE,pContext)))              nType = DataType::VARCHAR;
    2571. 

  2571.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_RIGHT,pContext)))                nType = DataType::VARCHAR;
    2572. 

  2572.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_RTRIM,pContext)))                nType = DataType::VARCHAR;
    2573. 

  2573.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SOUNDEX,pContext)))              nType = DataType::VARCHAR;
    2574. 

  2574.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SPACE,pContext)))                nType = DataType::VARCHAR;
    2575. 

  2575.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SUBSTRING,pContext)))            nType = DataType::VARCHAR;
    2576. 

  2576.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_UCASE,pContext)))                nType = DataType::VARCHAR;
    2577. 

  2577.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CURRENT_DATE,pContext)))         nType = DataType::DATE;
    2578. 

  2578.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CURRENT_TIME,pContext)))         nType = DataType::TIME;
    2579. 

  2579.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CURRENT_TIMESTAMP,pContext)))    nType = DataType::TIMESTAMP;
    2580. 

  2580.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CURDATE,pContext)))              nType = DataType::DATE;
    2581. 

  2581.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DATEDIFF,pContext)))             nType = DataType::INTEGER;
    2582. 

  2582.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DATEVALUE,pContext)))            nType = DataType::DATE;
    2583. 

  2583.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CURTIME,pContext)))              nType = DataType::TIME;
    2584. 

  2584.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DAYNAME,pContext)))              nType = DataType::VARCHAR;
    2585. 

  2585.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DAYOFMONTH,pContext)))           nType = DataType::INTEGER;
    2586. 

  2586.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DAYOFWEEK,pContext)))            nType = DataType::INTEGER;
    2587. 

  2587.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DAYOFYEAR,pContext)))            nType = DataType::INTEGER;
    2588. 

  2588.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_EXTRACT,pContext)))              nType = DataType::VARCHAR;
    2589. 

  2589.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_HOUR,pContext)))                 nType = DataType::INTEGER;
    2590. 

  2590.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MINUTE,pContext)))               nType = DataType::INTEGER;
    2591. 

  2591.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MONTH,pContext)))                nType = DataType::INTEGER;
    2592. 

  2592.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MONTHNAME,pContext)))            nType = DataType::VARCHAR;
    2593. 

  2593.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_NOW,pContext)))                  nType = DataType::TIMESTAMP;
    2594. 

  2594.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_QUARTER,pContext)))              nType = DataType::INTEGER;
    2595. 

  2595.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SECOND,pContext)))               nType = DataType::INTEGER;
    2596. 

  2596.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_TIMESTAMPADD,pContext)))         nType = DataType::TIMESTAMP;
    2597. 

  2597.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_TIMESTAMPDIFF,pContext)))        nType = DataType::TIMESTAMP;
    2598. 

  2598.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_TIMEVALUE,pContext)))            nType = DataType::TIMESTAMP;
    2599. 

  2599.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_WEEK,pContext)))                 nType = DataType::INTEGER;
    2600. 

  2600.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_YEAR,pContext)))                 nType = DataType::INTEGER;
    2601. 

  2601.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ABS,pContext)))                  nType = DataType::DOUBLE;
    2602. 

  2602.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ACOS,pContext)))                 nType = DataType::DOUBLE;
    2603. 

  2603.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ASIN,pContext)))                 nType = DataType::DOUBLE;
    2604. 

  2604.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ATAN,pContext)))                 nType = DataType::DOUBLE;
    2605. 

  2605.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ATAN2,pContext)))                nType = DataType::DOUBLE;
    2606. 

  2606.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_CEILING,pContext)))              nType = DataType::DOUBLE;
    2607. 

  2607.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_COS,pContext)))                  nType = DataType::DOUBLE;
    2608. 

  2608.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_COT,pContext)))                  nType = DataType::DOUBLE;
    2609. 

  2609.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_DEGREES,pContext)))              nType = DataType::DOUBLE;
    2610. 

  2610.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_EXP,pContext)))                  nType = DataType::DOUBLE;
    2611. 

  2611.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_FLOOR,pContext)))                nType = DataType::DOUBLE;
    2612. 

  2612.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOGF,pContext)))                 nType = DataType::DOUBLE;
    2613. 

  2613.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOG,pContext)))                  nType = DataType::DOUBLE;
    2614. 

  2614.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOG10,pContext)))                nType = DataType::DOUBLE;
    2615. 

  2615.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LN,pContext)))                   nType = DataType::DOUBLE;
    2616. 

  2616.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MOD,pContext)))                  nType = DataType::DOUBLE;
    2617. 

  2617.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_PI,pContext)))                   nType = DataType::DOUBLE;
    2618. 

  2618.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_POWER,pContext)))                nType = DataType::DOUBLE;
    2619. 

  2619.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_RADIANS,pContext)))              nType = DataType::DOUBLE;
    2620. 

  2620.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_RAND,pContext)))                 nType = DataType::DOUBLE;
    2621. 

  2621.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ROUND,pContext)))                nType = DataType::DOUBLE;
    2622. 

  2622.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_ROUNDMAGIC,pContext)))           nType = DataType::DOUBLE;
    2623. 

  2623.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SIGN,pContext)))                 nType = DataType::DOUBLE;
    2624. 

  2624.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SIN,pContext)))                  nType = DataType::DOUBLE;
    2625. 

  2625.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SQRT,pContext)))                 nType = DataType::DOUBLE;
    2626. 

  2626.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_TAN,pContext)))                  nType = DataType::DOUBLE;
    2627. 

  2627.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_TRUNCATE,pContext)))             nType = DataType::DOUBLE;
    2628. 

  2628.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_COUNT,pContext)))                nType = DataType::INTEGER;
    2629. 

  2629.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MAX,pContext)))                  nType = DataType::DOUBLE;
    2630. 

  2630.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_MIN,pContext)))                  nType = DataType::DOUBLE;
    2631. 

  2631.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_AVG,pContext)))                  nType = DataType::DOUBLE;
    2632. 

  2632.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_SUM,pContext)))                  nType = DataType::DOUBLE;
    2633. 

  2633.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_LOWER,pContext)))                nType = DataType::VARCHAR;
    2634. 

  2634.     else if(sFunctionName.equalsIgnoreAsciiCase(TokenIDToStr(SQL_TOKEN_UPPER,pContext)))                nType = DataType::VARCHAR;
    2635. 

  2635. 

  2636.     return nType;
    2637. 

  2637. }
    2638. 

  2638. // -----------------------------------------------------------------------------
    2639. 

  2639. sal_Int32 OSQLParser::getFunctionParameterType(sal_uInt32 _nTokenId, sal_uInt32 _nPos)
    2640. 

  2640. {
    2641. 

  2641.     sal_Int32 nType = DataType::VARCHAR;
    2642. 

  2642. 

  2643.     if(_nTokenId == SQL_TOKEN_CHAR)                 nType = DataType::INTEGER;
    2644. 

  2644.     else if(_nTokenId == SQL_TOKEN_INSERT)
    2645. 

  2645.     {
    2646. 

  2646.         if ( _nPos == 2 || _nPos == 3 )
    2647. 

  2647.             nType = DataType::INTEGER;
    2648. 

  2648.     }
    2649. 

  2649.     else if(_nTokenId == SQL_TOKEN_LEFT)
    2650. 

  2650.     {
    2651. 

  2651.         if ( _nPos == 2 )
    2652. 

  2652.             nType = DataType::INTEGER;
    2653. 

  2653.     }
    2654. 

  2654.     else if(_nTokenId == SQL_TOKEN_LOCATE)
    2655. 

  2655.     {
    2656. 

  2656.         if ( _nPos == 3 )
    2657. 

  2657.             nType = DataType::INTEGER;
    2658. 

  2658.     }
    2659. 

  2659.     else if(_nTokenId == SQL_TOKEN_LOCATE_2)
    2660. 

  2660.     {
    2661. 

  2661.         if ( _nPos == 3 )
    2662. 

  2662.             nType = DataType::INTEGER;
    2663. 

  2663.     }
    2664. 

  2664.     else if( _nTokenId == SQL_TOKEN_REPEAT || _nTokenId == SQL_TOKEN_RIGHT )
    2665. 

  2665.     {
    2666. 

  2666.         if ( _nPos == 2 )
    2667. 

  2667.             nType = DataType::INTEGER;
    2668. 

  2668.     }
    2669. 

  2669.     else if(_nTokenId == SQL_TOKEN_SPACE )
    2670. 

  2670.     {
    2671. 

  2671.         nType = DataType::INTEGER;
    2672. 

  2672.     }
    2673. 

  2673.     else if(_nTokenId == SQL_TOKEN_SUBSTRING)
    2674. 

  2674.     {
    2675. 

  2675.         if ( _nPos != 1 )
    2676. 

  2676.             nType = DataType::INTEGER;
    2677. 

  2677.     }
    2678. 

  2678.     else if(_nTokenId == SQL_TOKEN_DATEDIFF)
    2679. 

  2679.     {
    2680. 

  2680.         if ( _nPos != 1 )
    2681. 

  2681.             nType = DataType::TIMESTAMP;
    2682. 

  2682.     }
    2683. 

  2683.     else if(_nTokenId == SQL_TOKEN_DATEVALUE)
    2684. 

  2684.         nType = DataType::DATE;
    2685. 

  2685.     else if(_nTokenId == SQL_TOKEN_DAYNAME)
    2686. 

  2686.         nType = DataType::DATE;
    2687. 

  2687.     else if(_nTokenId == SQL_TOKEN_DAYOFMONTH)
    2688. 

  2688.         nType = DataType::DATE;
    2689. 

  2689.     else if(_nTokenId == SQL_TOKEN_DAYOFWEEK)
    2690. 

  2690.         nType = DataType::DATE;
    2691. 

  2691.     else if(_nTokenId == SQL_TOKEN_DAYOFYEAR)
    2692. 

  2692.         nType = DataType::DATE;
    2693. 

  2693.     else if(_nTokenId == SQL_TOKEN_EXTRACT)              nType = DataType::VARCHAR;
    2694. 

  2694.     else if(_nTokenId == SQL_TOKEN_HOUR)                 nType = DataType::TIME;
    2695. 

  2695.     else if(_nTokenId == SQL_TOKEN_MINUTE)               nType = DataType::TIME;
    2696. 

  2696.     else if(_nTokenId == SQL_TOKEN_MONTH)                nType = DataType::DATE;
    2697. 

  2697.     else if(_nTokenId == SQL_TOKEN_MONTHNAME)            nType = DataType::DATE;
    2698. 

  2698.     else if(_nTokenId == SQL_TOKEN_NOW)                  nType = DataType::TIMESTAMP;
    2699. 

  2699.     else if(_nTokenId == SQL_TOKEN_QUARTER)              nType = DataType::DATE;
    2700. 

  2700.     else if(_nTokenId == SQL_TOKEN_SECOND)               nType = DataType::TIME;
    2701. 

  2701.     else if(_nTokenId == SQL_TOKEN_TIMESTAMPADD)         nType = DataType::TIMESTAMP;
    2702. 

  2702.     else if(_nTokenId == SQL_TOKEN_TIMESTAMPDIFF)        nType = DataType::TIMESTAMP;
    2703. 

  2703.     else if(_nTokenId == SQL_TOKEN_TIMEVALUE)            nType = DataType::TIMESTAMP;
    2704. 

  2704.     else if(_nTokenId == SQL_TOKEN_WEEK)                 nType = DataType::DATE;
    2705. 

  2705.     else if(_nTokenId == SQL_TOKEN_YEAR)                 nType = DataType::DATE;
    2706. 

  2706. 

  2707.     else if(_nTokenId == SQL_TOKEN_ABS)                  nType = DataType::DOUBLE;
    2708. 

  2708.     else if(_nTokenId == SQL_TOKEN_ACOS)                 nType = DataType::DOUBLE;
    2709. 

  2709.     else if(_nTokenId == SQL_TOKEN_ASIN)                 nType = DataType::DOUBLE;
    2710. 

  2710.     else if(_nTokenId == SQL_TOKEN_ATAN)                 nType = DataType::DOUBLE;
    2711. 

  2711.     else if(_nTokenId == SQL_TOKEN_ATAN2)                nType = DataType::DOUBLE;
    2712. 

  2712.     else if(_nTokenId == SQL_TOKEN_CEILING)              nType = DataType::DOUBLE;
    2713. 

  2713.     else if(_nTokenId == SQL_TOKEN_COS)                  nType = DataType::DOUBLE;
    2714. 

  2714.     else if(_nTokenId == SQL_TOKEN_COT)                  nType = DataType::DOUBLE;
    2715. 

  2715.     else if(_nTokenId == SQL_TOKEN_DEGREES)              nType = DataType::DOUBLE;
    2716. 

  2716.     else if(_nTokenId == SQL_TOKEN_EXP)                  nType = DataType::DOUBLE;
    2717. 

  2717.     else if(_nTokenId == SQL_TOKEN_FLOOR)                nType = DataType::DOUBLE;
    2718. 

  2718.     else if(_nTokenId == SQL_TOKEN_LOGF)                 nType = DataType::DOUBLE;
    2719. 

  2719.     else if(_nTokenId == SQL_TOKEN_LOG)                  nType = DataType::DOUBLE;
    2720. 

  2720.     else if(_nTokenId == SQL_TOKEN_LOG10)                nType = DataType::DOUBLE;
    2721. 

  2721.     else if(_nTokenId == SQL_TOKEN_LN)                   nType = DataType::DOUBLE;
    2722. 

  2722.     else if(_nTokenId == SQL_TOKEN_MOD)                  nType = DataType::DOUBLE;
    2723. 

  2723.     else if(_nTokenId == SQL_TOKEN_PI)                   nType = DataType::DOUBLE;
    2724. 

  2724.     else if(_nTokenId == SQL_TOKEN_POWER)                nType = DataType::DOUBLE;
    2725. 

  2725.     else if(_nTokenId == SQL_TOKEN_RADIANS)              nType = DataType::DOUBLE;
    2726. 

  2726.     else if(_nTokenId == SQL_TOKEN_RAND)                 nType = DataType::DOUBLE;
    2727. 

  2727.     else if(_nTokenId == SQL_TOKEN_ROUND)                nType = DataType::DOUBLE;
    2728. 

  2728.     else if(_nTokenId == SQL_TOKEN_ROUNDMAGIC)           nType = DataType::DOUBLE;
    2729. 

  2729.     else if(_nTokenId == SQL_TOKEN_SIGN)                 nType = DataType::DOUBLE;
    2730. 

  2730.     else if(_nTokenId == SQL_TOKEN_SIN)                  nType = DataType::DOUBLE;
    2731. 

  2731.     else if(_nTokenId == SQL_TOKEN_SQRT)                 nType = DataType::DOUBLE;
    2732. 

  2732.     else if(_nTokenId == SQL_TOKEN_TAN)                  nType = DataType::DOUBLE;
    2733. 

  2733.     else if(_nTokenId == SQL_TOKEN_TRUNCATE)             nType = DataType::DOUBLE;
    2734. 

  2734.     else if(_nTokenId == SQL_TOKEN_COUNT)                nType = DataType::INTEGER;
    2735. 

  2735.     else if(_nTokenId == SQL_TOKEN_MAX)                  nType = DataType::DOUBLE;
    2736. 

  2736.     else if(_nTokenId == SQL_TOKEN_MIN)                  nType = DataType::DOUBLE;
    2737. 

  2737.     else if(_nTokenId == SQL_TOKEN_AVG)                  nType = DataType::DOUBLE;
    2738. 

  2738.     else if(_nTokenId == SQL_TOKEN_SUM)                  nType = DataType::DOUBLE;
    2739. 

  2739. 

  2740.     else if(_nTokenId == SQL_TOKEN_LOWER)                nType = DataType::VARCHAR;
    2741. 

  2741.     else if(_nTokenId == SQL_TOKEN_UPPER)                nType = DataType::VARCHAR;
    2742. 

  2742. 

  2743.     return nType;
    2744. 

  2744. }
    2745. 

  2745. 

  2746. // -----------------------------------------------------------------------------
    2747. 

  2747. const SQLError& OSQLParser::getErrorHelper() const
    2748. 

  2748. {
    2749. 

  2749.     return m_pData->aErrors;
    2750. 

  2750. }
    2751. 

  2751. 

  2752. // -----------------------------------------------------------------------------
    2753. 

  2753. OSQLParseNode::Rule OSQLParseNode::getKnownRuleID() const
    2754. 

  2754. {
    2755. 

  2755.     if ( !isRule() )
    2756. 

  2756.         return UNKNOWN_RULE;
    2757. 

  2757.     return OSQLParser::RuleIDToRule( getRuleID() );
    2758. 

  2758. }
    2759. 

  2759. // -----------------------------------------------------------------------------
    2760. 

  2760. ::rtl::OUString OSQLParseNode::getTableRange(const OSQLParseNode* _pTableRef)
    2761. 

  2761. {
    2762. 

  2762.     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "parse", "Ocke.Janssen@sun.com", "OSQLParseNode::getTableRange" );
    2763. 

  2763.     OSL_ENSURE(_pTableRef && _pTableRef->count() > 1 && _pTableRef->getKnownRuleID() == OSQLParseNode::table_ref,"Invalid node give, only table ref is allowed!");
    2764. 

  2764.     const sal_uInt32 nCount = _pTableRef->count();
    2765. 

  2765.     ::rtl::OUString sTableRange;
    2766. 

  2766.     if ( nCount == 2 || (nCount == 3 && !_pTableRef->getChild(0)->isToken()) || nCount == 5 )
    2767. 

  2767.     {
    2768. 

  2768.         const OSQLParseNode* pNode = _pTableRef->getChild(nCount - (nCount == 2 ? 1 : 2));
    2769. 

  2769.         OSL_ENSURE(pNode && (pNode->getKnownRuleID() == OSQLParseNode::table_primary_as_range_column
    2770. 

  2770.                           || pNode->getKnownRuleID() == OSQLParseNode::range_variable) 
    2771. 

  2771.                          ,"SQL grammar changed!");
    2772. 

  2772.         if ( !pNode->isLeaf() )
    2773. 

  2773.             sTableRange = pNode->getChild(1)->getTokenValue();
    2774. 

  2774.     } // if ( nCount == 2 || nCount == 3 || nCount == 5)
    2775. 

  2775. 

  2776.     return sTableRange;
    2777. 

  2777. }
    2778. 

  2778. // -----------------------------------------------------------------------------
    2779. 

  2779. OSQLParseNodesContainer::OSQLParseNodesContainer()
    2780. 

  2780. {
    2781. 

  2781. }
    2782. 

  2782. // -----------------------------------------------------------------------------
    2783. 

  2783. OSQLParseNodesContainer::~OSQLParseNodesContainer()
    2784. 

  2784. {
    2785. 

  2785. }
    2786. 

  2786. // -----------------------------------------------------------------------------
    2787. 

  2787. void OSQLParseNodesContainer::push_back(OSQLParseNode* _pNode) 
    2788. 

  2788. { 
    2789. 

  2789.     ::osl::MutexGuard aGuard(m_aMutex);
    2790. 

  2790.     m_aNodes.push_back(_pNode); 
    2791. 

  2791. }
    2792. 

  2792. // -----------------------------------------------------------------------------
    2793. 

  2793. void OSQLParseNodesContainer::erase(OSQLParseNode* _pNode) 
    2794. 

  2794. { 
    2795. 

  2795.     ::osl::MutexGuard aGuard(m_aMutex);
    2796. 

  2796.     if ( !m_aNodes.empty() )
    2797. 

  2797.     {
    2798. 

  2798.         ::std::vector< OSQLParseNode* >::iterator aFind = ::std::find(m_aNodes.begin(), m_aNodes.end(),_pNode);
    2799. 

  2799.         if ( aFind != m_aNodes.end() )
    2800. 

  2800.             m_aNodes.erase(aFind);
    2801. 

  2801.     }
    2802. 

  2802. }
    2803. 

  2803. // -----------------------------------------------------------------------------
    2804. 

  2804. bool OSQLParseNodesContainer::empty() const 
    2805. 

  2805. { 
    2806. 

  2806.     return m_aNodes.empty(); 
    2807. 

  2807. }
    2808. 

  2808. // -----------------------------------------------------------------------------
    2809. 

  2809. void OSQLParseNodesContainer::clear() 
    2810. 

  2810. { 
    2811. 

  2811.     ::osl::MutexGuard aGuard(m_aMutex); 
    2812. 

  2812.     m_aNodes.clear(); 
    2813. 

  2813. }
    2814. 

  2814. // -----------------------------------------------------------------------------
    2815. 

  2815. void OSQLParseNodesContainer::clearAndDelete()
    2816. 

  2816. {
    2817. 

  2817.     ::osl::MutexGuard aGuard(m_aMutex);
    2818. 

  2818.     // clear the garbage collector
    2819. 

  2819.     while ( !m_aNodes.empty() )
    2820. 

  2820.     {
    2821. 

  2821. 	    OSQLParseNode* pNode = m_aNodes[0];
    2822. 

  2822.         while ( pNode->getParent() )
    2823. 

  2823.         {
    2824. 

  2824.             pNode = pNode->getParent();
    2825. 

  2825.         }
    2826. 

  2826.         delete pNode;
    2827. 

  2827.     }
    2828. 

  2828. }
    2829. 

  2829. }   // namespace connectivity
    2830. 

  2830.