when i create a join view like this
create view JV104FZ.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
JV104FZ.APPTINM .APAM32, JV104FZ.APPTINM .APNO20,
JV104FZ.APPTINM .APQY05, JV104FZ.APPTINM .PONO01,
JV104FZ.APPTINM .PONO05, JV104FZ.APPTINM .PONO19,
COALESCE(JV104F Z.POPTOL.POCD01 , ' '), COALESCE(JV104F Z.POPTOL.POCD13 ,
' '), JV104FZ.POPTOL. systimestamp, JV104FZ.POPTOL. loginname,
COALESCE(JV104F Z.APPTINM.id, JV104FZ.POPTOL. id ) from JV104FZ.APPTINM
left join JV104FZ.POPTOL on JV104FZ.APPTINM .PONO01 =
JV104FZ.POPTOL. PONO01 and JV104FZ.APPTINM .PONO05 =
JV104FZ.POPTOL. PONO05
i also want to have the where clause so the view will exclude the data
i don't want, so i have the view created like this
create view GN104DX.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
GN104DX.APPTINM .APAM32, GN104DX.APPTINM .APNO20,
GN104DX.APPTINM .APQY05, GN104DX.APPTINM .PONO01,
GN104DX.APPTINM .PONO05, GN104DX.APPTINM .PONO19, GN104DX.POPTOL. POCD01,
GN104DX.POPTOL. POCD13, GN104DX.POPTOL. systimestamp,
GN104DX.POPTOL. loginname, COALESCE(GN104D X.APPTINM.id,
GN104DX.POPTOL. id ) from GN104DX.APPTINM left join GN104DX.POPTOL on
GN104DX.APPTINM .PONO01 = GN104DX.POPTOL. PONO01 and
GN104DX.APPTINM .PONO05 = GN104DX.POPTOL. PONO05 where ((POCD01<>'D')
and ( POCD01<>'F') and ( POCD01<>'O')) , but looks like it exclude the
data from poptol first then do the join, so how to let db2 do the join
first then where clause later?
8  4164  da****@yahoo.co m (xixi) wrote in message create view GN104DX.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
GN104DX.APPTINM .APAM32, GN104DX.APPTINM .APNO20,
GN104DX.APPTINM .APQY05, GN104DX.APPTINM .PONO01,
GN104DX.APPTINM .PONO05, GN104DX.APPTINM .PONO19, GN104DX.POPTOL. POCD01,
GN104DX.POPTOL. POCD13, GN104DX.POPTOL. systimestamp,
GN104DX.POPTOL. loginname, COALESCE(GN104D X.APPTINM.id,
GN104DX.POPTOL. id ) from GN104DX.APPTINM left join GN104DX.POPTOL on
GN104DX.APPTINM .PONO01 = GN104DX.POPTOL. PONO01 and
GN104DX.APPTINM .PONO05 = GN104DX.POPTOL. PONO05 where ((POCD01<>'D')
and ( POCD01<>'F') and ( POCD01<>'O')) , but looks like it exclude the
data from poptol first then do the join, so how to let db2 do the join
first then where clause later?
Why do you think so?
DB2 do join first then apply where clause. So, all rows in APPTINM
that have no matched row of POPTOL will be excluded from final result.
The reason is:
POCD01 of those rows are NULL, then conditions in where are unknown,
not true. In consequence, those rows will be excluded from final
result.
If you want to include those rows in final result, you should put the
conditions in ON clause.
Here is how OUTER JOINs work in SQL-92. Assume you are given:
Table1 Table2
a b a c
====== ======
1 w 1 r
2 x 2 s
3 y 3 t
4 z
and the outer join expression:
Table1
LEFT OUTER JOIN
Table2
ON Table1.a = Table2.a <== join condition
AND Table2.c = 't'; <== single table condition
We call Table1 the "preserved table" and Table2 the "unpreserve d
table" in the query. What I am going to give you is a little
different, but equivalent to the ANSI/ISO standards.
1) We build the CROSS JOIN of the two tables. Scan each row in the
result set.
2) If the predicate tests TRUE for that row, then you keep it. You
also remove all rows derived from it from the CROSS JOIN
3) If the predicate tests FALSE or UNKNOWN for that row, then keep the
columns from the preserved table, convert all the columns from the
unpreserved table to NULLs and remove the duplicates.
So let us execute this by hand:
Let @ = passed the first predicate
Let * = passed the second predicate
Table1 CROSS JOIN Table2
a b a c
=============== ==========
1 w 1 r @
1 w 2 s
1 w 3 t *
2 x 1 r
2 x 2 s @
2 x 3 t *
3 y 1 r
3 y 2 s
3 y 3 t @* <== the TRUE set
4 z 1 r
4 z 2 s
4 z 3 t *
Table1 LEFT OUTER JOIN Table2
a b a c
=============== ==========
3 y 3 t <= only TRUE row
-----------------------
1 w NULL NULL Sets of duplicates
1 w NULL NULL
1 w NULL NULL
-----------------------
2 x NULL NULL
2 x NULL NULL
2 x NULL NULL
3 y NULL NULL <== derived from the TRUE set - Remove
3 y NULL NULL
-----------------------
4 z NULL NULL
4 z NULL NULL
4 z NULL NULL
the final results:
Table1 LEFT OUTER JOIN Table2
a b a c
=============== ==========
1 w NULL NULL
2 x NULL NULL
3 y 3 t
4 z NULL NULL
The basic rule is that every row in the preserved table is represented
in the results in at least one result row.
There are limitations and very serious problems with the extended
equality version of an outer join used in some diseased mutant
products. Consider the two Chris Date tables
Suppliers SupParts
supno supno partno qty
========= ==============
S1 S1 P1 100
S2 S1 P2 250
S3 S2 P1 100
S2 P2 250
and let's do an extended equality outer join like this:
SELECT *
FROM Supplier, SupParts
WHERE Supplier.supno *= SupParts.supno
AND qty < 200;
If I do the outer first, I get:
Suppliers LOJ SupParts
supno supno partno qty
=============== ========
S1 S1 P1 100
S1 S1 P2 250
S2 S2 P1 100
S2 S2 P2 250
S3 NULL NULL NULL
Then I apply the (qty < 200) predicate and get
Suppliers LOJ SupParts
supno supno partno qty
=============== ====
S1 S1 P1 100
S2 S2 P1 100
Doing it in the opposite order
Suppliers LOJ SupParts
supno supno partno qty
=============== ====
S1 S1 P1 100
S2 S2 P1 100
S3 NULL NULL NULL
Sybase does it one way, Oracle does it the other and Centura (nee
Gupta) lets you pick which one -- the worst of both non-standard
worlds! In SQL-92, you have a choice and can force the order of
execution. Either do the predicates after the join ...
SELECT *
FROM Supplier
LEFT OUTER JOIN
SupParts
ON Supplier.supno = SupParts.supno
WHERE qty < 200;
... or do it in the joining:
SELECT *
FROM Supplier
LEFT OUTER JOIN
SupParts
ON Supplier.supno = SupParts.supno
AND qty < 200;
Another problem is that you cannot show the same table as preserved
and unpreserved in the extended equality version, but it is easy in
SQL-92. For example to find the students who have taken Math 101 and
might have taken Math 102:
SELECT C1.student, C1.math, C2.math
FROM (SELECT * FROM Courses WHERE math = 101) AS C1
LEFT OUTER JOIN
(SELECT * FROM Courses WHERE math = 102) AS C2
ON C1.student = C2.student;
looks like the post here is incorrect for coalesce, the actual one is
create view NJIPD.APJTINM1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
NJIPD.APPTINM.A PAM32, NJIPD.APPTINM.A PNO20, NJIPD.APPTINM.A PQY05,
NJIPD.APPTINM.P ONO01, NJIPD.APPTINM.P ONO05, NJIPD.APPTINM.P ONO19,
COALESCE(NJIPD. POPTOL.POCD01, ' '), COALESCE(NJIPD. POPTOL.POCD13, '
'), NJIPD.POPTOL.sy stimestamp, NJIPD.POPTOL.lo ginname,
COALESCE(NJIPD. APPTINM.id, NJIPD.POPTOL.id ) from NJIPD.APPTINM left
join NJIPD.POPTOL on NJIPD.APPTINM.P ONO01 = NJIPD.POPTOL.PO NO01 and
NJIPD.APPTINM.P ONO05 = NJIPD.POPTOL.PO NO05 where ((POCD01<>'D') and (
POCD01<>'F') and ( POCD01<>'O'))
i specify that if the final result pocd01 and pocd13 is null, then use
space replace.
i can't get the right data if i have the where clause when i create
the view, i have to create a temp view first, then create a another
view on the temp view with where clause, then i get it right, can you
tell me whether you have any direct way? thanks to*****@jp.ibm. com (Tokunaga T.) wrote in message news:<81******* *************** ****@posting.go ogle.com>... da****@yahoo.co m (xixi) wrote in message create view GN104DX.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
GN104DX.APPTINM .APAM32, GN104DX.APPTINM .APNO20,
GN104DX.APPTINM .APQY05, GN104DX.APPTINM .PONO01,
GN104DX.APPTINM .PONO05, GN104DX.APPTINM .PONO19, GN104DX.POPTOL. POCD01,
GN104DX.POPTOL. POCD13, GN104DX.POPTOL. systimestamp,
GN104DX.POPTOL. loginname, COALESCE(GN104D X.APPTINM.id,
GN104DX.POPTOL. id ) from GN104DX.APPTINM left join GN104DX.POPTOL on
GN104DX.APPTINM .PONO01 = GN104DX.POPTOL. PONO01 and
GN104DX.APPTINM .PONO05 = GN104DX.POPTOL. PONO05 where ((POCD01<>'D')
and ( POCD01<>'F') and ( POCD01<>'O')) , but looks like it exclude the
data from poptol first then do the join, so how to let db2 do the join
first then where clause later?
Why do you think so?
DB2 do join first then apply where clause. So, all rows in APPTINM
that have no matched row of POPTOL will be excluded from final result.
The reason is:
POCD01 of those rows are NULL, then conditions in where are unknown,
not true. In consequence, those rows will be excluded from final
result.
If you want to include those rows in final result, you should put the
conditions in ON clause. da****@yahoo.co m (xixi) wrote in message news:<c0******* *************** ****@posting.go ogle.com>... looks like the post here is incorrect for coalesce, the actual one is
create view NJIPD.APJTINM1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
NJIPD.APPTINM.A PAM32, NJIPD.APPTINM.A PNO20, NJIPD.APPTINM.A PQY05,
NJIPD.APPTINM.P ONO01, NJIPD.APPTINM.P ONO05, NJIPD.APPTINM.P ONO19,
COALESCE(NJIPD. POPTOL.POCD01, ' '), COALESCE(NJIPD. POPTOL.POCD13, '
'), NJIPD.POPTOL.sy stimestamp, NJIPD.POPTOL.lo ginname,
COALESCE(NJIPD. APPTINM.id, NJIPD.POPTOL.id ) from NJIPD.APPTINM left
join NJIPD.POPTOL on NJIPD.APPTINM.P ONO01 = NJIPD.POPTOL.PO NO01 and
NJIPD.APPTINM.P ONO05 = NJIPD.POPTOL.PO NO05 where ((POCD01<>'D') and (
POCD01<>'F') and ( POCD01<>'O'))
i specify that if the final result pocd01 and pocd13 is null, then use
space replace.
i can't get the right data if i have the where clause when i create
the view,
I feel that you didn't understand my explanation.
If you specify "where ((POCD01<>'D') and (POCD01<>'F') and
(POCD01<>'O'))" ,
all rows that pocd01 is null will be excluded from results before you
apply COALESCE function.
If you want get rows that pocd01 is null, you shoud specify the
conditions in ON caluse and remove WHERE clause.
Like this:
on NJIPD.APPTINM.P ONO01 = NJIPD.POPTOL.PO NO01 and NJIPD.APPTINM.P ONO05
= NJIPD.POPTOL.PO NO05 AND POCD01<>'D' and POCD01<>'F' and POCD01<>'O'
i have to create a temp view first, then create a another
view on the temp view with where clause, then i get it right,
I guess that you replaced null POCD01 with space in a temp view.
Then "((POCD01<> 'D') and (POCD01<>'F') and (POCD01<>'O'))" get 'ture',
NOT 'unknown'.
can you tell me whether you have any direct way? thanks
I have mentioned at top of this post and at bottom of my previous
post.
ON ..... AND POCD01<>'D' and POCD01<>'F' and POCD01<>'O'
I'm sorry, if I miss the point.
to*****@jp.ibm. com (Tokunaga T.) wrote in message news:<81******* *************** ****@posting.go ogle.com>... da****@yahoo.co m (xixi) wrote in message create view GN104DX.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
GN104DX.APPTINM .APAM32, GN104DX.APPTINM .APNO20,
GN104DX.APPTINM .APQY05, GN104DX.APPTINM .PONO01,
GN104DX.APPTINM .PONO05, GN104DX.APPTINM .PONO19, GN104DX.POPTOL. POCD01,
GN104DX.POPTOL. POCD13, GN104DX.POPTOL. systimestamp,
GN104DX.POPTOL. loginname, COALESCE(GN104D X.APPTINM.id,
GN104DX.POPTOL. id ) from GN104DX.APPTINM left join GN104DX.POPTOL on
GN104DX.APPTINM .PONO01 = GN104DX.POPTOL. PONO01 and
GN104DX.APPTINM .PONO05 = GN104DX.POPTOL. PONO05 where ((POCD01<>'D')
and ( POCD01<>'F') and ( POCD01<>'O')) , but looks like it exclude the
data from poptol first then do the join, so how to let db2 do the join
first then where clause later?
Why do you think so?
DB2 do join first then apply where clause. So, all rows in APPTINM
that have no matched row of POPTOL will be excluded from final result.
The reason is:
POCD01 of those rows are NULL, then conditions in where are unknown,
not true. In consequence, those rows will be excluded from final
result.
If you want to include those rows in final result, you should put the
conditions in ON clause.
hi, i already try your way and still doesn't work, it returns all the
row from apptinm.
still can't get it right to*****@jp.ibm. com (Tokunaga T.) wrote in message news:<81******* *************** ****@posting.go ogle.com>... da****@yahoo.co m (xixi) wrote in message news:<c0******* *************** ****@posting.go ogle.com>... looks like the post here is incorrect for coalesce, the actual one is
create view NJIPD.APJTINM1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
NJIPD.APPTINM.A PAM32, NJIPD.APPTINM.A PNO20, NJIPD.APPTINM.A PQY05,
NJIPD.APPTINM.P ONO01, NJIPD.APPTINM.P ONO05, NJIPD.APPTINM.P ONO19,
COALESCE(NJIPD. POPTOL.POCD01, ' '), COALESCE(NJIPD. POPTOL.POCD13, '
'), NJIPD.POPTOL.sy stimestamp, NJIPD.POPTOL.lo ginname,
COALESCE(NJIPD. APPTINM.id, NJIPD.POPTOL.id ) from NJIPD.APPTINM left
join NJIPD.POPTOL on NJIPD.APPTINM.P ONO01 = NJIPD.POPTOL.PO NO01 and
NJIPD.APPTINM.P ONO05 = NJIPD.POPTOL.PO NO05 where ((POCD01<>'D') and (
POCD01<>'F') and ( POCD01<>'O'))
i specify that if the final result pocd01 and pocd13 is null, then use
space replace.
i can't get the right data if i have the where clause when i create
the view,
I feel that you didn't understand my explanation.
If you specify "where ((POCD01<>'D') and (POCD01<>'F') and
(POCD01<>'O'))" ,
all rows that pocd01 is null will be excluded from results before you
apply COALESCE function.
If you want get rows that pocd01 is null, you shoud specify the
conditions in ON caluse and remove WHERE clause.
Like this:
on NJIPD.APPTINM.P ONO01 = NJIPD.POPTOL.PO NO01 and NJIPD.APPTINM.P ONO05
= NJIPD.POPTOL.PO NO05 AND POCD01<>'D' and POCD01<>'F' and POCD01<>'O'
i have to create a temp view first, then create a another
view on the temp view with where clause, then i get it right,
I guess that you replaced null POCD01 with space in a temp view.
Then "((POCD01<> 'D') and (POCD01<>'F') and (POCD01<>'O'))" get 'ture',
NOT 'unknown'.
can you tell me whether you have any direct way? thanks
I have mentioned at top of this post and at bottom of my previous
post.
ON ..... AND POCD01<>'D' and POCD01<>'F' and POCD01<>'O'
I'm sorry, if I miss the point.
to*****@jp.ibm. com (Tokunaga T.) wrote in message news:<81******* *************** ****@posting.go ogle.com>... da****@yahoo.co m (xixi) wrote in message
> create view GN104DX.APJTINM 1 (APAM32, APNO20, APQY05, PONO01, PONO05,
> PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
> GN104DX.APPTINM .APAM32, GN104DX.APPTINM .APNO20,
> GN104DX.APPTINM .APQY05, GN104DX.APPTINM .PONO01,
> GN104DX.APPTINM .PONO05, GN104DX.APPTINM .PONO19, GN104DX.POPTOL. POCD01,
> GN104DX.POPTOL. POCD13, GN104DX.POPTOL. systimestamp,
> GN104DX.POPTOL. loginname, COALESCE(GN104D X.APPTINM.id,
> GN104DX.POPTOL. id ) from GN104DX.APPTINM left join GN104DX.POPTOL on
> GN104DX.APPTINM .PONO01 = GN104DX.POPTOL. PONO01 and
> GN104DX.APPTINM .PONO05 = GN104DX.POPTOL. PONO05 where ((POCD01<>'D')
> and ( POCD01<>'F') and ( POCD01<>'O')) , but looks like it exclude the
> data from poptol first then do the join, so how to let db2 do the join
> first then where clause later?
Why do you think so?
DB2 do join first then apply where clause. So, all rows in APPTINM
that have no matched row of POPTOL will be excluded from final result.
The reason is:
POCD01 of those rows are NULL, then conditions in where are unknown,
not true. In consequence, those rows will be excluded from final
result.
If you want to include those rows in final result, you should put the
conditions in ON clause.
da****@yahoo.co m (xixi) wrote in message news:<c0******* *************** ****@posting.go ogle.com>... hi, i already try your way and still doesn't work, it returns all the
row from apptinm.
still can't get it right
What result do you want to get?
You specified "NJIPD.APPT INM left join NJIPD.POPTOL" and no condition
for APPTINM(I thought POCD01 is a column of POPTOL).
So, all rows of APPTINM will be included in result. da****@yahoo.co m (xixi) wrote in message news:<c0******* *************** ****@posting.go ogle.com>... hi, i already try your way and still doesn't work, it returns all the
row from apptinm.
still can't get it right
How about this?
where (POCD01<>'D') and POCD01<>'F' and POCD01<>'O' OR POCD01 is null
This returns all the rows of APPTINM which have no corresponding row
of POPTOL and, if there is a corresponding row of POPTOL, POCD01 is
not in ('D', 'F', 'O') or POCD01 is null.
as i said, when i create the temp join view without where clause
specify, when i create a final view with where clause specify , i get
the right data, which is less than when i do the way as you specify. to*****@jp.ibm. com (Tokunaga T.) wrote in message news:<81******* *************** ***@posting.goo gle.com>... da****@yahoo.co m (xixi) wrote in message news:<c0******* *************** ****@posting.go ogle.com>... hi, i already try your way and still doesn't work, it returns all the
row from apptinm.
still can't get it right
What result do you want to get?
You specified "NJIPD.APPT INM left join NJIPD.POPTOL" and no condition
for APPTINM(I thought POCD01 is a column of POPTOL).
So, all rows of APPTINM will be included in result. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Preston Landers |
last post by:
Hello all.
I am trying to write a query that "just" switches some data around so
it is shown in a slightly different format. I am already able to do
what I want in Oracle 8i, but I am having trouble making it work in
SQL Server 2000. I am not a database newbie, but I can't seem to
figure this one out so I am turning to the newsgroup. I am thinking
that some of the SQL Gurus out there have done this very thing a
thousand times before...
|
by: Jack Smith |
last post by:
Hello,
I want to be able to view data from 3 tables using the JOIN statement, but
I'm not sure of how to do it. I think i don't know the syntax of the joins.I
imagine this is easy for the experienced - but Im not.
Allow me to explain:
I have 2 Tables: PERSON and SIGN
PERSON
|
by: Karsten Hilbert |
last post by:
Dear all,
for some reason I just cannot get my brain wrapped around the
required syntax for the following. I think I need to either
use a join or subselect(s):
Situation:
----------
I have two tables (simplified here) for an international
medical office application (www.gnumed.org):
|
by: Ian Boyd |
last post by:
i know nothing about DB2, but i'm sure this must be possible.
i'm trying to get a client to create a view (which it turns out is called a
"Logical" in DB2). The query needs a LEFT OUTER JOIN, but he doesn't know
how to do that, or even if he can, and i don't have to time to learn DB2
from scratch right now.
The following SQL Query is a trimmed sample of the full View (i.e. Logical)
definition - and i would create it on an SQL based...
|
by: Chris |
last post by:
I'm using ASP.NET and SQL Server and this might be an obviuos question for
most, but if I have a table that contains several fields that I need to
relate to just one field in another table, how do I do that?
I.e. Table 1 has Integer values for enteredbyID, CoordID, CustContactID
Table 2 is the contacts table with Contact_ID (integer) key. Table 1 uses
that field to bring back First and Last Name's.
So:
Table1 Table 2
| | |
by: stefaan.lhermitte |
last post by:
Dear mysql-ians,
I am performing a query that takes ages before showing a result. I
suppose it is very time consuming because of the JOIN I perform. My
question therefore is if you have any suggestions to optimize my query?
What I want to do is divide a value of a cell (NDVI) by the median of
its neighbours based on geographical coordinates (refgeo).
The selection script is as follows:
|
by: germanshorthairpointer |
last post by:
Hello,
I'm trying to do a join based on the following tables:
Person(person_id,person_name)
Grade(grade_id,grade_person_id,grade_score)
The data looks like this:
Person:
|
by: jason.langdale |
last post by:
I have 3 tables I want to use in a view. Table A has field 1,2,3,4,5
and table B has field 1,2,3,4,5. I want to do a union on these. (I have
done so successfully if I stop here) I also want to join table C which
has field 1,6,7,8,9. I would like to join on field 1 and bring in the
other fields. I can join table C to A or B. I can union table A and B
but I do not know how to both union A and B then join C. Can someone
please help me? Thanks...
|
by: cjakeman |
last post by:
Hi,
Solved a little mystery yesterday when I built a form that combined 2
tables with a 1:M relationship and relational integrity. All the
correct data was visible on the form but, if I tried to edit any of
the fields, the PC bleeped.
Seems it was due to the query the form was based on. Again, editing
any of the fields of the query caused the PC to bleep.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
