| Bug #44982 | Don't recognize a view | ||
|---|---|---|---|
| Submitted: | 20 May 2009 12:32 | Modified: | 26 Jun 2009 9:36 |
| Reporter: | alexandre dursel | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.34 | OS: | Windows (XP pro V2) |
| Assigned to: | CPU Architecture: | Any | |
[20 May 2009 12:32]
alexandre dursel
[20 May 2009 12:38]
alexandre dursel
this select is ok SELECT ALL vue_personnes_pre_nom.`V_PERS_ID`, vue_personnes_pre_nom.`V_PERS_PRE_NOM`, vue_personnes_pre_nom.`V_PERS_NOM`, vue_personnes_pre_nom.`V_PERS_PRENOM`, utilisateur_groupe.`GROUPE_ID`, utilisateur_groupe.`PERS_ID` FROM vue_personnes_pre_nom, utilisateur_groupe WHERE utilisateur_groupe.`GROUPE_ID` = ? AND vue_personnes_pre_nom.`V_PERS_ID` = utilisateur_groupe.`PERS_ID` ORDER BY vue_personnes_pre_nom.`V_PERS_NOM` ASC, vue_personnes_pre_nom.`V_PERS_PRENOM` ASC" this select is not recognise SELECT ALL vue_personnes_pre_nom.`V_PERS_ID`, vue_personnes_pre_nom.`V_PERS_PRE_NOM`, vue_personnes_pre_nom.`V_PERS_NOM`, vue_personnes_pre_nom.`V_PERS_PRENOM` FROM vue_personnes_pre_nom ORDER BY vue_personnes_pre_nom.`V_PERS_NOM` ASC, vue_personnes_pre_nom.`V_PERS_PRENOM` ASC
[20 May 2009 13:20]
Valeriy Kravchuk
You write about 5.0.67 vs. 5.0.81, but why version is noted as 5.1.34 then? Please, send the results of: EXPLAIN SELECT ALL vue_personnes_pre_nom.`V_PERS_ID`, vue_personnes_pre_nom.`V_PERS_PRE_NOM`, vue_personnes_pre_nom.`V_PERS_NOM`, vue_personnes_pre_nom.`V_PERS_PRENOM` FROM vue_personnes_pre_nom ORDER BY vue_personnes_pre_nom.`V_PERS_NOM` ASC, vue_personnes_pre_nom.`V_PERS_PRENOM` ASC\G from the problematic version (5.0.81?) and the results of SHOW CREATE VIEW for that vue_personnes_pre_nom view. Please, check also if will get any error message running this query from the command line client.
[25 May 2009 8:30]
alexandre dursel
Why version is noted as 5.1.34? It is because we have new server and we have download the MySQL GA version and it was the 5.1.34. After I have downloaded the 5.0.81. Few month ago for my test we had the 5.0.67. This version work. The result of the select is for the 5.0.81, but if you want it is possible for me to install the 5.1.34. I make it with the MySQL query browser. When i take the problematic select it work !(with the query browser) Here are the results: EXPLAIN SELECT ALL vue_personnes_pre_nom.`V_PERS_ID`, vue_personnes_pre_nom.`V_PERS_PRE_NOM`, vue_personnes_pre_nom.`V_PERS_NOM`, vue_personnes_pre_nom.`V_PERS_PRENOM` FROM vue_personnes_pre_nom ORDER BY vue_personnes_pre_nom.`V_PERS_NOM` ASC, vue_personnes_pre_nom.`V_PERS_PRENOM` ASC "id","select_type","table","type","possible_keys","key","key_len","ref","rows","Extra" 1,"SIMPLE","personnes","ALL","PRIMARY","","","",43,"Using where; Using filesort" SHOW CREATE VIEW vue_personnes_pre_nom "View","Create View" "vue_personnes_pre_nom","CREATE ALGORITHM=UNDEFINED DEFINER=`autic`@`%` SQL SECURITY DEFINER VIEW `vue_personnes_pre_nom` AS select `personnes`.`PERS_ID` AS `V_PERS_ID`,concat(`personnes`.`PERS_NOM`,_utf8' ',`personnes`.`PERS_PRENOM`) AS `V_PERS_PRE_NOM`,`personnes`.`PERS_NOM` AS `V_PERS_NOM`,`personnes`.`PERS_PRENOM` AS `V_PERS_PRENOM` from `personnes` where (`personnes`.`PERS_ID` >= _utf8'0')"
[25 May 2009 12:22]
Sveta Smirnova
Thank you for the feedback. Please also provide output of SHOW CREATE TABLE personnes
[25 May 2009 12:35]
alexandre dursel
Thanks for the attention SHOW CREATE TABLE personnes "Table","Create Table" "personnes","CREATE TABLE `personnes` ( `PERS_ID` int(4) NOT NULL default '0', `PERS_NOM` varchar(50) default NULL, `PERS_PRENOM` varchar(50) default NULL, `PERS_EMAIL` varchar(100) default NULL, `PERS_TEL` varchar(15) default NULL, PRIMARY KEY (`PERS_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"
[25 May 2009 13:02]
Sveta Smirnova
Thank you for the feedback. Problem is not repeatable without Glassfish. Please try to create repeatable test case we can use. Also, please, indicate version of Connector/J which you are using.
[25 May 2009 13:29]
alexandre dursel
Ok it is not repeatable without use glassfish, when i make a simple query on a view with the glassfish and a complex view work! If a take an other view it is the same probleme. I explain it so : the view that i compose is not recognise as you seen in the error messages. Normaly the query server is "view.column" but here it was "table_name.column" so when the appserver excecute the query, we found an error. I am use the "mysql-connector-java-5.1.6-bin.jar". I have just tested with mysql-connector-java-5.1.7-bin.jar and the error is still there. Which kind of test can i make to help the community because with the 5.0.67 version it work fine. For me it is possible to download other MySQL version, drivers, ... It is possible to have a problem in the java (JRE, JDK, SDK)
[25 May 2009 13:36]
Sveta Smirnova
Thank you for the feedback. We need any code which we can compile, then repeat the problem. Please see comment "[12 Mar 11:28] Tonci Grgin" to bug #43556 for the example of test which we use in connector/J testsuite. Also please check if your case is duplicate of bug #43556 or bug #33744.
[26 May 2009 9:10]
alexandre dursel
Hello, It is exactly the same problem that the 43556. What would you say any code? Because i work with netbeans, (it is not a problem i can made a small application), I think it is not possible to make an attachement. The sql script it is a simple file. The configuration of my glassfish server: I have no idea to give the configuration file. But if you say me how it will be with pleasure.
[26 May 2009 9:36]
Sveta Smirnova
Thank you for the feedback. > What would you say any code? Because i work with netbeans, (it is not a problem i can made > a small application), I think it is not possible to make an attachement. You can make archive from netbeans project and attach using "Files" tab of the bug report web page. > The configuration of my glassfish server: I have no idea to give the configuration file. > But if you say me how it will be with pleasure. Most likely this is domain.xml file
[26 Jun 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
