#8973: universally truth/false logics should be supported in the where calause of aggregate functions | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Umair Anwar

Umairpk reported 2013-05-15T22:42:08Z · JennyNishimura last modified 2013-05-15T23:00:45Z

universally truth/false logics should be supported in the where calause of aggregate functions

Duplicates #8864

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	MongoSQL
Version	14.0

Sometimes there are certain situations where we need to put the universally truth/false options and it is support in all major DBMS..

create collection aggregate_test

GO

insert aggregate_test

(name,total) values('jack',100)

GO

select sum(total) from aggregate_test

where 1 = 1

---Error

All Comments (0) Change History

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017