Union All not working

[Daniel Paquin]

Hello, I am currently having a problem when using the Union All function.

I am performing this command
select * from tblEVENEMENT union ALL select * from _dupEVENEMENT

Before executing the command tblEVENEMENT contain 419 records and the _dupEVENEMENT contains 253 records.

Once executed I do get a message where 672 records are being showned within the tblEVENEMENT table. I do browse though the table and I see the added records.

Unfortunately for a reason I cannot explained,once I click on the database name. All contained table are showned with the corresponding number of records. Unfortunately, the tblEVENEMENT tbale only contains 419 records.

It's like if the function created a temporary table view where all records are showned but in the back-end nothing is being store physically.

Both table have the sme structure. As a matter fact the _dupEVENEMENT table is a duplicate of tblEVENEMENT. Through a bunch of queries I remove some records. This is how I'Ve created the duplicate table.

CREATE TABLE `DFichiersC`.`_dupEVENEMENT` like tblEVENEMENT
insert into _dupEVENEMENT select * from tblEVENEMENT

I've multiples attempts.
I've turned of my computer and restarted the database.


Would anyone have an idea why I am getting this result? I am running out of answers.

Thanks in advance!