asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Jacobs <sjaco...@ucr.edu>
Subject CASE capabilities in SQL++
Date Mon, 15 May 2017 21:09:47 GMT
Hi all,
I'm trying to understand the capabilities of the "case" that we have in
SQL++. I tried the following queries and the two results don't seem to make
sense. Am I missing something?

SQL++:
use experiments
select count (country) from Tweets1;
select case when (select value count (country) from Tweets1) > 50  THEN
"true" ELSE "false" END;

RESULTS:

{ "$1": 36297735 }

{ "$1": "false" }

Thanks,
Steven

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message