Author: fdesbois Date: 2010-06-11 16:20:21 +0000 (Fri, 11 Jun 2010) New Revision: 509 Log: Bug on migration Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-06-11 15:45:32 UTC (rev 508) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-06-11 16:20:21 UTC (rev 509) @@ -129,11 +129,11 @@ queries.add("ALTER TABLE SampleRowLog ADD fromAdmin BOOLEAN;"); // EXISTS will return TRUE for admin author and false for others queries.add("UPDATE SampleRowLog A SET fromAdmin = EXISTS (" + - "SELECT B FROM SampleRowLog B, WaoUser U " + - "WHERE B.topiaId = A.topiaId " + - "AND B.author = U.topiaId" + + "SELECT U FROM SampleRowLog B, WaoUser U" + + " WHERE B.topiaId = A.topiaId" + + " AND B.author = U.topiaId" + // Admin role = 1 - "AND U.role = 1);" + " AND U.role = 1);" ); }