Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.apache.org
Date: Fri, 23 Oct 2015 08:54:27 +0000 (UTC)
From: =?utf-8?Q?Kasper_S=C3=B8rensen_=28JIRA=29?= <jira@apache.org>
To: dev@metamodel.apache.org
Message-ID: <JIRA.12907333.1445590431000.37812.1445590467720@Atlassian.JIRA>
In-Reply-To: <JIRA.12907333.1445590431000@Atlassian.JIRA>
References: <JIRA.12907333.1445590431000@Atlassian.JIRA>
 <JIRA.12907333.1445590431276@arcas>
Subject: [jira] [Created] (METAMODEL-200) No syntax available in SQL
 representation of Query for "functiona approximation"
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Kasper S=C3=B8rensen created METAMODEL-200:
-----------------------------------------

             Summary: No syntax available in SQL representation of Query fo=
r "functiona approximation"
                 Key: METAMODEL-200
                 URL: https://issues.apache.org/jira/browse/METAMODEL-200
             Project: Apache MetaModel
          Issue Type: Bug
            Reporter: Kasper S=C3=B8rensen


In MetaModel we have a flag that can be set on e.g. "COUNT(*)" which indica=
tes if the database may approximate the number instead of doing a consisten=
t calculation. This is good for optimization scenarios where you don't need=
 an actual count, just an estimate (for progress bars and similar stuff in =
UIs).

But unfortunately we don't have any syntax support for this when dealing wi=
th String queries. Shouldn't we add that?

I could imagine a prefix or something like that, e.g. the "tilde / ~" symbo=
l, like this:

{code}
SELECT ~COUNT(*) FROM table
{code}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)