Encountered an error while creating view.
Semantic error 226. Referenced column - - not found.
Semantic error 485. Near: CREATE VIEW "_SYSTEM"."Vue_4" AS SELECT "id", "Article", "PrixArticle", "Attribut", "ValeurEntier", "ValeurTexte" FROM ((SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", COALESCE("ValeurEntier"."valeur",0) AS "ValeurEntier", " " AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributEntier" AS "ValeurEntier","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurEntier"."id"="va"."id") AND ("ValeurEntier"."id_Article"="va"."id_Article") AND ("ValeurEntier"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))UNION(SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", 0 AS "ValeurEntier", COALESCE("ValeurTexte"."valeur",0) AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributTexte" AS "ValeurTexte","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurTexte"."id"="va"."id") AND ("ValeurTexte"."id_Article"="va"."id_Article") AND ("ValeurTexte"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))) AS "tmp" WHERE "tmp"."id"=1;.
Semantic error 485. Near: 0.
Semantic error 217. Datatypes are not comparable or don't match.
Semantic error 485. Near: CREATE VIEW "_SYSTEM"."Vue_4" AS SELECT "id", "Article", "PrixArticle", "Attribut", "ValeurEntier", "ValeurTexte" FROM ((SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", COALESCE("ValeurEntier"."valeur",0) AS "ValeurEntier", " " AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributEntier" AS "ValeurEntier","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurEntier"."id"="va"."id") AND ("ValeurEntier"."id_Article"="va"."id_Article") AND ("ValeurEntier"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))UNION(SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", 0 AS "ValeurEntier", COALESCE("ValeurTexte"."valeur",0) AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributTexte" AS "ValeurTexte","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurTexte"."id"="va"."id") AND ("ValeurTexte"."id_Article"="va"."id_Article") AND ("ValeurTexte"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))) AS "tmp" WHERE "tmp"."id"=1;.
Semantic error 485. Near: 0.
Semantic error 226. Referenced column - id - not found.
Semantic error 485. Near: CREATE VIEW "_SYSTEM"."Vue_4" AS SELECT "id", "Article", "PrixArticle", "Attribut", "ValeurEntier", "ValeurTexte" FROM ((SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", COALESCE("ValeurEntier"."valeur",0) AS "ValeurEntier", " " AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributEntier" AS "ValeurEntier","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurEntier"."id"="va"."id") AND ("ValeurEntier"."id_Article"="va"."id_Article") AND ("ValeurEntier"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))UNION(SELECT "ta"."id", "a"."libelle", "a"."prix", "att"."nom", 0 AS "ValeurEntier", COALESCE("ValeurTexte"."valeur",0) AS "ValeurTexte" FROM "ValeurAttribut" AS "va3","ValeurAttribut" AS "va2","ValeurAttributTexte" AS "ValeurTexte","ValeurAttribut" AS "va","Attribut" AS "att","Article" AS "a","TypeArticle" AS "ta" WHERE ("va3"."id_Article"="a"."id") AND ("va2"."id_TypeArticle"="ta"."id") AND ("ValeurTexte"."id"="va"."id") AND ("ValeurTexte"."id_Article"="va"."id_Article") AND ("ValeurTexte"."id_TypeArticle"="va"."id_TypeArticle") AND ("va"."id_Attribut"="att"."id") AND ("att"."id_TypeArticle"="ta"."id") AND ("a"."id_TypeArticle"="ta"."id"))) AS "tmp" WHERE "tmp"."id"=1;.
Semantic error 485. Near: "TypeArticle".
Semantic error 226. Referenced column - Article - not found.
Semantic error 226. Referenced column - PrixArticle - not found.
Semantic error 226. Referenced column - Attribut - not found.
Semantic error 226. Referenced column - ValeurEntier - not found.
Semantic error 226. Referenced column - ValeurTexte - not found.
Semantic error 116. Referenced TABLE - tmp - does not exist.
Semantic error 485. Near: "tmp"."id".
Semantic error 226. Referenced column - id - not found.
Semantic error 217. Datatypes are not comparable or don't match.
Semantic error 485. Near: 1.
Exception 363 (40:000). Transaction rollback.
Partager