Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"The most important thing in a man is not what he knows, but what he is." -- Narciso Yepes


computers / comp.sys.tandem / Re: SQL/MP - ERROR from SQL [-3074]

SubjectAuthor
* SQL/MP - ERROR from SQL [-3074]Gustavo Bertazzoli
`* Re: SQL/MP - ERROR from SQL [-3074]Henrik Paludan-Moerk
 `* Re: SQL/MP - ERROR from SQL [-3074]Randall
  `* Re: SQL/MP - ERROR from SQL [-3074]Gustavo Bertazzoli
   `* Re: SQL/MP - ERROR from SQL [-3074]JShepherd
    `- Re: SQL/MP - ERROR from SQL [-3074]Randall

1
SQL/MP - ERROR from SQL [-3074]

<17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=497&group=comp.sys.tandem#497

 copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a37:a656:0:b0:6b4:8116:de71 with SMTP id p83-20020a37a656000000b006b48116de71mr1850780qke.691.1657004071778;
Mon, 04 Jul 2022 23:54:31 -0700 (PDT)
X-Received: by 2002:a25:1f44:0:b0:66c:8185:7c2e with SMTP id
f65-20020a251f44000000b0066c81857c2emr34780057ybf.629.1657004071553; Mon, 04
Jul 2022 23:54:31 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Mon, 4 Jul 2022 23:54:31 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=141.113.3.34; posting-account=y6cHAAoAAAC6eCczfLV2Rx_5bZz07tIn
NNTP-Posting-Host: 141.113.3.34
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
Subject: SQL/MP - ERROR from SQL [-3074]
From: gube...@gmail.com (Gustavo Bertazzoli)
Injection-Date: Tue, 05 Jul 2022 06:54:31 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1701
 by: Gustavo Bertazzoli - Tue, 5 Jul 2022 06:54 UTC

Hi guys,

It's my first message here but I hope that someone can help me.

I'm doing a simple SQL with count, but I'm always getting an error and I don't know why.

Here is the query:
select
count(ID)
from table1
where
IDstate not in ("release", "finished")
and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6), DEFAULT)
group by sequenceGroup
browse access;

here is the error:
...select count(ID) from table1...
^
*** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is specified.

I didn't specified as ALL but maybe I don't. Can someone please help me?

Re: SQL/MP - ERROR from SQL [-3074]

<ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=498&group=comp.sys.tandem#498

 copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:187:b0:319:b2d:4aff with SMTP id s7-20020a05622a018700b003190b2d4affmr28182920qtw.386.1657022034671;
Tue, 05 Jul 2022 04:53:54 -0700 (PDT)
X-Received: by 2002:a81:1c4b:0:b0:31c:5f22:6bd3 with SMTP id
c72-20020a811c4b000000b0031c5f226bd3mr24882615ywc.47.1657022034499; Tue, 05
Jul 2022 04:53:54 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Tue, 5 Jul 2022 04:53:54 -0700 (PDT)
In-Reply-To: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=147.161.165.21; posting-account=8FAxrQoAAADMwG-6BKqit1hRT6E9lSTA
NNTP-Posting-Host: 147.161.165.21
References: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com>
Subject: Re: SQL/MP - ERROR from SQL [-3074]
From: hpm....@gmail.com (Henrik Paludan-Moerk)
Injection-Date: Tue, 05 Jul 2022 11:53:54 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 30
 by: Henrik Paludan-Moerk - Tue, 5 Jul 2022 11:53 UTC

please try to puy Select Count (*)
instead of count(id)? your sql looks fine to me.

//Henrik P

tirsdag den 5. juli 2022 kl. 08.54.32 UTC+2 skrev gub...@gmail.com:
> Hi guys,
>
> It's my first message here but I hope that someone can help me.
>
> I'm doing a simple SQL with count, but I'm always getting an error and I don't know why.
>
> Here is the query:
> select
> count(ID)
> from table1
> where
> IDstate not in ("release", "finished")
> and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
> dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6), DEFAULT)
> group by sequenceGroup
> browse access;
>
> here is the error:
> ...select count(ID) from table1...
> ^
> *** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is specified.
>
> I didn't specified as ALL but maybe I don't. Can someone please help me?

Re: SQL/MP - ERROR from SQL [-3074]

<a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=501&group=comp.sys.tandem#501

 copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:3cc:b0:317:cdb0:e with SMTP id k12-20020a05622a03cc00b00317cdb0000emr27997422qtx.190.1657033265271;
Tue, 05 Jul 2022 08:01:05 -0700 (PDT)
X-Received: by 2002:a81:23c4:0:b0:31c:8bf8:af81 with SMTP id
j187-20020a8123c4000000b0031c8bf8af81mr15134906ywj.340.1657033264961; Tue, 05
Jul 2022 08:01:04 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Tue, 5 Jul 2022 08:01:04 -0700 (PDT)
In-Reply-To: <ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2607:fea8:3fa0:4b9:c1c0:b54:18f5:a901;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3fa0:4b9:c1c0:b54:18f5:a901
References: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com> <ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com>
Subject: Re: SQL/MP - ERROR from SQL [-3074]
From: rsbec...@nexbridge.com (Randall)
Injection-Date: Tue, 05 Jul 2022 15:01:05 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 30
 by: Randall - Tue, 5 Jul 2022 15:01 UTC

On Tuesday, July 5, 2022 at 7:53:55 a.m. UTC-4, hpm...@gmail.com wrote:
> please try to puy Select Count (*)
> instead of count(id)? your sql looks fine to me.
>
> //Henrik P
> tirsdag den 5. juli 2022 kl. 08.54.32 UTC+2 skrev gub...@gmail.com:
> > Hi guys,
> >
> > It's my first message here but I hope that someone can help me.
> >
> > I'm doing a simple SQL with count, but I'm always getting an error and I don't know why.
> >
> > Here is the query:
> > select
> > count(ID)
> > from table1
> > where
> > IDstate not in ("release", "finished")
> > and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
> > dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6), DEFAULT)
> > group by sequenceGroup
> > browse access;
> >
> > here is the error:
> > ...select count(ID) from table1...
> > ^
> > *** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is specified.
> >
> > I didn't specified as ALL but maybe I don't. Can someone please help me?

What are you trying to do? Count the number of unique IDs? Count the instances of each unique ID? Count the number of matching records?

Re: SQL/MP - ERROR from SQL [-3074]

<7cf20fd5-d35a-4282-a536-efbec3b84b7an@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=512&group=comp.sys.tandem#512

 copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:138f:b0:31e:9d0f:623f with SMTP id o15-20020a05622a138f00b0031e9d0f623fmr1921316qtk.463.1657269435973;
Fri, 08 Jul 2022 01:37:15 -0700 (PDT)
X-Received: by 2002:a0d:ff81:0:b0:317:bfca:bb33 with SMTP id
p123-20020a0dff81000000b00317bfcabb33mr2611283ywf.516.1657269435689; Fri, 08
Jul 2022 01:37:15 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Fri, 8 Jul 2022 01:37:15 -0700 (PDT)
In-Reply-To: <a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=141.113.3.14; posting-account=y6cHAAoAAAC6eCczfLV2Rx_5bZz07tIn
NNTP-Posting-Host: 141.113.3.14
References: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
<ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com> <a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7cf20fd5-d35a-4282-a536-efbec3b84b7an@googlegroups.com>
Subject: Re: SQL/MP - ERROR from SQL [-3074]
From: gube...@gmail.com (Gustavo Bertazzoli)
Injection-Date: Fri, 08 Jul 2022 08:37:15 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 37
 by: Gustavo Bertazzoli - Fri, 8 Jul 2022 08:37 UTC

On Tuesday, 5 July 2022 at 23:01:06 UTC+8, Randall wrote:
> On Tuesday, July 5, 2022 at 7:53:55 a.m. UTC-4, hpm...@gmail.com wrote:
> > please try to puy Select Count (*)
> > instead of count(id)? your sql looks fine to me.
> >
> > //Henrik P
> > tirsdag den 5. juli 2022 kl. 08.54.32 UTC+2 skrev gub...@gmail.com:
> > > Hi guys,
> > >
> > > It's my first message here but I hope that someone can help me.
> > >
> > > I'm doing a simple SQL with count, but I'm always getting an error and I don't know why.
> > >
> > > Here is the query:
> > > select
> > > count(ID)
> > > from table1
> > > where
> > > IDstate not in ("release", "finished")
> > > and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
> > > dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6), DEFAULT)
> > > group by sequenceGroup
> > > browse access;
> > >
> > > here is the error:
> > > ...select count(ID) from table1...
> > > ^
> > > *** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is specified.
> > >
> > > I didn't specified as ALL but maybe I don't. Can someone please help me?
> What are you trying to do? Count the number of unique IDs? Count the instances of each unique ID? Count the number of matching records?

Hi guys,

yes, I'm trying to count the amount of IDs per sequenceGroup. But I already saw that I forgot the sequenceGroup in the select part.
Thanks for the fast answer colleagues. I actually in the end, extracted to excel and did my countings directly on excel.

Have a nice weekend!

Re: SQL/MP - ERROR from SQL [-3074]

<taer92$1djoi$1@dont-email.me>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=513&group=comp.sys.tandem#513

 copy link   Newsgroups: comp.sys.tandem
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: inva...@nowhere.com (JShepherd)
Newsgroups: comp.sys.tandem
Subject: Re: SQL/MP - ERROR from SQL [-3074]
Date: Sun, 10 Jul 2022 15:29:39 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 62
Message-ID: <taer92$1djoi$1@dont-email.me>
References: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
<ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com> <a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com> <7cf20fd5-d35a-4282-a536-efbec3b84b7an@googlegroups.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Injection-Date: Sun, 10 Jul 2022 15:29:39 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="40dd95b4c3a819c2c52783b7321719b6";
logging-data="1494802"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+A1Yv9ONPI4BMIW+gPOjxfB3LqgExKzBQ="
Cancel-Lock: sha1:/m3wKx1EVfXrGLtLdejFTg3WvFc=
 by: JShepherd - Sun, 10 Jul 2022 15:29 UTC

In article <7cf20fd5-d35a-4282-a536-efbec3b84b7an@googlegroups.com>,
guberta@gmail.com says...
>
>On Tuesday, 5 July 2022 at 23:01:06 UTC+8, Randall wrote:
>> On Tuesday, July 5, 2022 at 7:53:55 a.m. UTC-4, hpm...@gmail.com wrote:
>> > please try to puy Select Count (*)
>> > instead of count(id)? your sql looks fine to me.
>> >
>> > //Henrik P
>> > tirsdag den 5. juli 2022 kl. 08.54.32 UTC+2 skrev gub...@gmail.com:
>> > > Hi guys,
>> > >
>> > > It's my first message here but I hope that someone can help me.
>> > >
>> > > I'm doing a simple SQL with count, but I'm always getting an error and
I d
>on't know why.
>> > >
>> > > Here is the query:
>> > > select
>> > > count(ID)
>> > > from table1
>> > > where
>> > > IDstate not in ("release", "finished")
>> > > and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
>> > > dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6),
DEFA
>ULT)
>> > > group by sequenceGroup
>> > > browse access;
>> > >
>> > > here is the error:
>> > > ...select count(ID) from table1...
>> > > ^
>> > > *** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is
specified
>.
>> > >
>> > > I didn't specified as ALL but maybe I don't. Can someone please help
me?
>> What are you trying to do? Count the number of unique IDs? Count the
instances
> of each unique ID? Count the number of matching records?
>
>Hi guys,
>
>yes, I'm trying to count the amount of IDs per sequenceGroup. But I already
saw
>that I forgot the sequenceGroup in the select part.
>Thanks for the fast answer colleagues. I actually in the end, extracted to
excel
> and did my countings directly on excel.
>
>Have a nice weekend!

maybe try

select count(distinct id) from table1
where <predicate>;

Re: SQL/MP - ERROR from SQL [-3074]

<d237aff0-a815-4148-91f7-9e526e16d549n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=514&group=comp.sys.tandem#514

 copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:243:b0:31a:1a19:7b2d with SMTP id c3-20020a05622a024300b0031a1a197b2dmr11723682qtx.564.1657484794754;
Sun, 10 Jul 2022 13:26:34 -0700 (PDT)
X-Received: by 2002:a25:d6d1:0:b0:66e:e116:c736 with SMTP id
n200-20020a25d6d1000000b0066ee116c736mr11168315ybg.645.1657484794492; Sun, 10
Jul 2022 13:26:34 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Sun, 10 Jul 2022 13:26:34 -0700 (PDT)
In-Reply-To: <taer92$1djoi$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=2607:fea8:3fa0:4b9:55fe:4e74:f3a4:c042;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3fa0:4b9:55fe:4e74:f3a4:c042
References: <17cc0a0b-ac0e-4c37-be63-8e6f69b279aen@googlegroups.com>
<ec9cd43a-93d1-4ecc-88a8-4a0bed7a83c8n@googlegroups.com> <a06b86d8-9292-4925-a6c7-8234a6734f87n@googlegroups.com>
<7cf20fd5-d35a-4282-a536-efbec3b84b7an@googlegroups.com> <taer92$1djoi$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d237aff0-a815-4148-91f7-9e526e16d549n@googlegroups.com>
Subject: Re: SQL/MP - ERROR from SQL [-3074]
From: rsbec...@nexbridge.com (Randall)
Injection-Date: Sun, 10 Jul 2022 20:26:34 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 62
 by: Randall - Sun, 10 Jul 2022 20:26 UTC

On Sunday, July 10, 2022 at 11:29:41 a.m. UTC-4, JShepherd wrote:
> In article <7cf20fd5-d35a-4282...@googlegroups.com>,
> gub...@gmail.com says...
> >
> >On Tuesday, 5 July 2022 at 23:01:06 UTC+8, Randall wrote:
> >> On Tuesday, July 5, 2022 at 7:53:55 a.m. UTC-4, hpm...@gmail.com wrote:
> >> > please try to puy Select Count (*)
> >> > instead of count(id)? your sql looks fine to me.
> >> >
> >> > //Henrik P
> >> > tirsdag den 5. juli 2022 kl. 08.54.32 UTC+2 skrev gub...@gmail.com:
> >> > > Hi guys,
> >> > >
> >> > > It's my first message here but I hope that someone can help me.
> >> > >
> >> > > I'm doing a simple SQL with count, but I'm always getting an error and
> I d
> >on't know why.
> >> > >
> >> > > Here is the query:
> >> > > select
> >> > > count(ID)
> >> > > from table1
> >> > > where
> >> > > IDstate not in ("release", "finished")
> >> > > and dateformat(TIMESTAMP year to FRACTION(6), DEFAULT) >
> >> > > dateformat(DATETIME "2022-07-05:00:00:00.000000" year to FRACTION(6),
> DEFA
> >ULT)
> >> > > group by sequenceGroup
> >> > > browse access;
> >> > >
> >> > > here is the error:
> >> > > ...select count(ID) from table1...
> >> > > ^
> >> > > *** ERROR from SQL [-3074]: You cannot specify COUNT when ALL is
> specified
> >.
> >> > >
> >> > > I didn't specified as ALL but maybe I don't. Can someone please help
> me?
> >> What are you trying to do? Count the number of unique IDs? Count the
> instances
> > of each unique ID? Count the number of matching records?
> >
> >Hi guys,
> >
> >yes, I'm trying to count the amount of IDs per sequenceGroup. But I already
> saw
> >that I forgot the sequenceGroup in the select part.
> >Thanks for the fast answer colleagues. I actually in the end, extracted to
> excel
> > and did my countings directly on excel.
> >
> >Have a nice weekend!
> maybe try
>
> select count(distinct id) from table1
> where <predicate>;

select id, count(1) from table1
where <predicate>
group by id;

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor