Thread: Re: Howto analyse sql statement.

Re: Howto analyse sql statement.

From

Tatsuo Ishii

Date:

18 February 2010, 06:08:55

From: Muhammad Isnaini <moch_isnaini@yahoo.com>
Subject: Re: Howto analyse sql statement.
Date: Wed, 17 Feb 2010 21:02:26 +0800 (SGT)
Message-ID: <525621.291.qm@web76202.mail.sg1.yahoo.com>

> >     parse_tree_list = raw_parser(string);
>
> I have got it. I will send later.
> Next chalange is how writing query statement ( include rewriting ) from a node ?. Is that posible ?.

You could recursively search the parse tree and rewrite the query. See
pool_timestamp.c for a great example.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp