Hi, I do the same procedure (but before I do a backup). I rename a column with a constraint. All seem good. When I deconnect and reconnect I have an error. I give you the message entirely.
*Column "VAL_LOUPE_LIMITE_AFFICHAGE" not found; SQL statement:* CREATE CACHED TABLE PUBLIC.TERRITOIRES<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('Cette table remplace le fichiers pays.dat. Elle permet de trouver et de dessiner les territoires concern\u00e9s par la date courante.')<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> ( ID INTEGER NOT NULL SELECTIVITY 100 CHECK (ID > 0), ID_NOM INTEGER NOT NULL SELECTIVITY 26 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT 'L''identifiant du nom du territoire.' CHECK (ID_NOM > 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> RANG INTEGER NOT NULL SELECTIVITY 100 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT 'Le rang dans l''ordre de dessin pour les territoires.' CHECK (RANG > 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> ID_POURTOUR INTEGER NOT NULL SELECTIVITY 68 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('L''identifiant du pourtour permettant de dessiner les fronti\u00e8res du territoire.') CHECK (ID_POURTOUR > 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COULEUR_INTERIEUR INTEGER SELECTIVITY 2 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('La couleur du territoire. La valeur 0 n''indique pas le noir (comme d''habitude) mais le caract\u00e8re transparent de ce territoire (on voit le territoire dessin\u00e9 en dessous).') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK (COULEUR_INTERIEUR >= 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> HACHURE TINYINT SELECTIVITY 1 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT 'Le style de hachure du territoire. Voir les constantes de la classe TraceurCarte du programme.' <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((HACHURE >= 0)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (HACHURE <= 6)),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COULEUR_FRONTIERE INTEGER SELECTIVITY 2 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT 'La couleur de la frontiere et des hachures. La valeur 0 indique le noir .' <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK (COULEUR_FRONTIERE >= 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> STYLE TINYINT SELECTIVITY 1 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('Le style de la fronti\u00e8re (\u00e9paisseur du trait, type de trait). Voir les constantes de la classe TraceurCarte du programme.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((STYLE >= 0)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (STYLE <= 6)),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> DEBUT INT SELECTIVITY 43 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('Le d\u00e9but de la p\u00e9riode concernant le territoire.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((DEBUT <> 0)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND ((DEBUT >= -3100)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (YEAR(CURRENT_DATE()) >= DEBUT))),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> FIN INT SELECTIVITY 43 COMMENT STRINGDECODE('La fin de la p\u00e9riode concernant le territoire.')<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((FIN <> 0)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND ((FIN >= -3100)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (YEAR(CURRENT_DATE()) >= FIN))),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> LONGITUDE_CENTRE DECIMAL(5, 2) NOT NULL SELECTIVITY 52 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('La valeur par d\u00e9faut de la longitude du centre d''afichage des infos sur la carte.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((LONGITUDE_CENTRE >= -179.99)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (LONGITUDE_CENTRE <= 180.00)),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> LATITUDE_CENTRE DECIMAL(4, 2) NOT NULL SELECTIVITY 46 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('La valeur par d\u00e9faut de la latitude du centre d''afichage des infos sur la carte.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK ((LATITUDE_CENTRE >= -90.00)<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AND (LATITUDE_CENTRE <= 90.00)),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> ID_CIV INTEGER SELECTIVITY 2 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('L''identifiant de la civilisation dont d\u00e9pend le territoire.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> CHECK (ID_CIV > 0),<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> AFFICHAGE FLOAT SELECTIVITY 1 <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> COMMENT STRINGDECODE('La valeur par d\u00e9faut de la limite du zoom en de\u00e7a duquel les infos du territoire ne sont pas affich\u00e9es.') <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> *CHECK ((VAL_LOUPE_LIMITE_AFFICHAGE = 0)*<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> * OR ((VAL_LOUPE_LIMITE_AFFICHAGE >= 1.00)*<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> * AND (VAL_LOUPE_LIMITE_AFFICHAGE <= 25.00)))*<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> ) <http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> *[42122-163]*<http://192.168.1.64:8082/login.do?jsessionid=2a93017a860d5b2e30b007103bda8185#> * 42S22/42122* (Aide)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c42122> We can see than in the table the constraint in the column Affichage is not updated with the new name. I don't know the version of my H2 but it's recent (less than a month). I use the embedded mode (I don't know if this remark is necessary). With the latest version of H2, the bug is the same. Le 20 mars 2012 07:46, Thomas Mueller <[email protected]> a écrit : > Hi, > > It sounds like a bug. Which version of H2 do you use, and does it > happen if you use the newest version? Could you post the complete > exception message including error codes? > > Do you have a simple reproducible test case? > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site : http://histoiremondiale.free.fr -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
