Description:
Hi,
I have try this query:
SELECT pianifica.datapian, Serano, Richard, Tosati
FROM (
SELECT pianifica.datapian AS d1, pianifica.IDric Serano
FROM pianifica
WHERE tecnico
RLIKE 'serano' ) AS t1
RIGHT JOIN ( (
SELECT pianifica.datapian AS d1, pianifica.IDric AS Richard
FROM pianifica
WHERE tecnico
RLIKE 'richard' ) AS t2
RIGHT JOIN ( (
SELECT pianifica.datapian AS d1, pianifica.IDric AS Tosati
FROM pianifica
WHERE tecnico
RLIKE 'tosati' ) AS t3
RIGHT JOIN pianifica ON t3.d1 = pianifica.datapian ) ON t2.d1 = pianifica.datapian ) ON t1.d1 = pianifica.datapian
GROUP BY Serano, Richard, Tosati, pianifica.datapian
ORDER BY pianifica.datapian
where in datapian table exist 1 field that is a primary Key. Only if I remove the primary key definition, this query work fine; just the definition of primary key.
This primary Key is not user in the query listed on this reporting, but the effect is in evidence.
Let me know if you need more info.
Regards
How to repeat:
Define a table as listed below, and try a query as defined in description, and look it working just delete the primary key.
Campo Tipo Set di caratteri Attributi Null Predefinito Extra Azione
IDpian int(11) --- No auto_increment Modifica Elimina Primaria Indice Unica Testo completo
datapian date --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo
IDric int(11) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo
durata set('Mattino', 'Pomeriggio', 'Giorno') --- Si Giorno Modifica Elimina Primaria Indice Unica Testo completo
luogo varchar(50) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo
tecnico varchar(50) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo
Seleziona tutti / Deseleziona tutti Se selezionati: Oppure
Indici : [Documentazione]
Nome chiave Tipo Cardinalità Azione Campo
PRIMARY PRIMARY 426 Elimina Modifica IDpian
Suggested fix:
?
Description: Hi, I have try this query: SELECT pianifica.datapian, Serano, Richard, Tosati FROM ( SELECT pianifica.datapian AS d1, pianifica.IDric Serano FROM pianifica WHERE tecnico RLIKE 'serano' ) AS t1 RIGHT JOIN ( ( SELECT pianifica.datapian AS d1, pianifica.IDric AS Richard FROM pianifica WHERE tecnico RLIKE 'richard' ) AS t2 RIGHT JOIN ( ( SELECT pianifica.datapian AS d1, pianifica.IDric AS Tosati FROM pianifica WHERE tecnico RLIKE 'tosati' ) AS t3 RIGHT JOIN pianifica ON t3.d1 = pianifica.datapian ) ON t2.d1 = pianifica.datapian ) ON t1.d1 = pianifica.datapian GROUP BY Serano, Richard, Tosati, pianifica.datapian ORDER BY pianifica.datapian where in datapian table exist 1 field that is a primary Key. Only if I remove the primary key definition, this query work fine; just the definition of primary key. This primary Key is not user in the query listed on this reporting, but the effect is in evidence. Let me know if you need more info. Regards How to repeat: Define a table as listed below, and try a query as defined in description, and look it working just delete the primary key. Campo Tipo Set di caratteri Attributi Null Predefinito Extra Azione IDpian int(11) --- No auto_increment Modifica Elimina Primaria Indice Unica Testo completo datapian date --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo IDric int(11) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo durata set('Mattino', 'Pomeriggio', 'Giorno') --- Si Giorno Modifica Elimina Primaria Indice Unica Testo completo luogo varchar(50) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo tecnico varchar(50) --- Si NULL Modifica Elimina Primaria Indice Unica Testo completo Seleziona tutti / Deseleziona tutti Se selezionati: Oppure Indici : [Documentazione] Nome chiave Tipo Cardinalità Azione Campo PRIMARY PRIMARY 426 Elimina Modifica IDpian Suggested fix: ?