Kasper Sørensen created METAMODEL-200:
-----------------------------------------
Summary: No syntax available in SQL representation of Query for
"functiona approximation"
Key: METAMODEL-200
URL: https://issues.apache.org/jira/browse/METAMODEL-200
Project: Apache MetaModel
Issue Type: Bug
Reporter: Kasper Sørensen
In MetaModel we have a flag that can be set on e.g. "COUNT(*)" which indicates
if the database may approximate the number instead of doing a consistent
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 with
String queries. Shouldn't we add that?
I could imagine a prefix or something like that, e.g. the "tilde / ~" symbol,
like this:
{code}
SELECT ~COUNT(*) FROM table
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
