Hi, Sorry for the delay. Could you send me the database, or a reproducible test case? So far I couldn't reproduce the problem. I tried:
drop table test; create table test(id int primary key, value int, CHECK ((value = 0) OR ((value >= 1.00) AND (value <= 25.00)))); <close / open database> alter table test alter column value rename to value2; <close / open database> Regards, Thomas On Tuesday, March 20, 2012, patrice henrio wrote: > 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]<javascript:_e({}, 'cvml', > '[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]<javascript:_e({}, 'cvml', >> '[email protected]');> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:_e({}, 'cvml', >> 'h2-database%[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]<javascript:_e({}, 'cvml', > '[email protected]');> > . > To unsubscribe from this group, send email to > [email protected] <javascript:_e({}, 'cvml', > 'h2-database%[email protected]');>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- 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.
