I think the following should be enough as a Test Case : *drop all objects;*
*create schema if not exists table_view;* *set schema table_view;* *create table if not exists test1 (* * id int,* * name varchar(20));* *create view if not exists test_view_1 as (select * from test1);* *set schema public;* *create schema if not exists test_run;* *set schema test_run;* *create table if not exists test2 (* * vid int, * * address varchar(20),* * constraint a_cons check (vid in (select id from table_view.test1)));* *set schema public;* Akshay On Sun, Dec 15, 2013 at 3:18 PM, Thomas Mueller < [email protected]> wrote: > Hi, > > That's not good... Do you have a test case? > > Regards, Thomas > Am 15.12.2013 09:13 schrieb "Akshay Mehta" <[email protected]>: > > Hi, >> >> I tried the latest version (downloaded from the Latest Automated Build) , >> but now the database seems to be stuck in a Loop and the Program is >> unresponsive after I issue the 'Drop All Objects' Command. >> >> regards >> Akshay >> >> >> On Fri, Nov 29, 2013 at 2:01 PM, Akshay Mehta <[email protected]>wrote: >> >>> Hi, >>> >>> It was my mistake that I forgot to mention the View was in a different >>> schema. Will this make a difference ? >>> >>> regards >>> Akshay >>> >>> >>> On Thu, Nov 21, 2013 at 7:14 PM, Akshay Mehta <[email protected]>wrote: >>> >>>> Thanks will check it out >>>> >>>> Akshay >>>> On 21 Nov 2013 18:44, "Thomas Mueller" <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> This should be fixed now (in the trunk). >>>>> >>>>> Regards, >>>>> Thomas >>>>> >>>>> >>>>> >>>>> On Sat, Nov 16, 2013 at 2:37 PM, Thomas Mueller < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> Thanks for reporting! This is a bug. The database is supposed to drop >>>>>> the objects in the right order; it looks like it doesn't do that >>>>>> currently >>>>>> in this case. I will try to fix it. Test case: >>>>>> >>>>>> create table a(x int); >>>>>> create view b as select * from a; >>>>>> create table c(y int check (select count(*) from b) = 0); >>>>>> drop all objects delete files; >>>>>> >>>>>> Regards, >>>>>> Thomas >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Nov 15, 2013 at 4:11 PM, Akshay Mehta <[email protected] >>>>>> > wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Is the Statement "Drop All Objects" still checking for dependencies? >>>>>>> >>>>>>> I have a constraint on a Table A, which Checks the value of a column >>>>>>> in a Particular View B. However using "Drop All Objects" reports an >>>>>>> error : >>>>>>> "Table A depends on B". >>>>>>> >>>>>>> Any Ideas? >>>>>>> >>>>>>> regards >>>>>>> Akshay >>>>>>> >>>>>>> I am Using: H2 1.3.174 >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "H2 Database" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to [email protected]. >>>>>>> To post to this group, send email to [email protected]. >>>>>>> Visit this group at http://groups.google.com/group/h2-database. >>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>> >>>>>> >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "H2 Database" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at http://groups.google.com/group/h2-database. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>> >>> >>> -- >>> Akshay Mehta >>> Ph. - 09302104522 >>> >> >> >> >> -- >> Akshay Mehta >> Ph. - 09302104522 >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- Akshay Mehta Ph. - 09302104522 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
