[MonetDB-users] 'on delete cascade' constraint over mapi fails

Sander Kruseman kruseman at xs4all.nl
Tue Oct 30 23:22:03 CET 2007


Concurrency is not an issue here, since I am using autocommit all the 
time, and synchronizing my client usage, or even restarting the server 
doesn't change the reported behavior.

Martin Kersten wrote:
> Simple check. Are you running both JDBC and mclient in parallel?
> And what are your commit option settings?
> 
> Beware that running both in parallel are different users from a
> database point off view. At least during the transaction.
> 
> Sander Kruseman wrote:
>> Nothing fancy: I use the default user monetdb in both clients, working 
>> in the sys schema. I start the JDBC client using:
>>
>> java -jar "C:\Program 
>> Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb
>> (java version "1.6.0_02")
>>
>> Happy hunting!
>> Sander
>>
>> Romulo Goncalves wrote:
>>   
>>> Sander Kruseman wrote:
>>>     
>>>> Romulo,
>>>>
>>>> I can confirm your results when setting up the tables from mclient. But 
>>>> I still get the failure when setting up the tables over JDBC and then 
>>>> delete the parent record from mclient.
>>>>       
>>> Ok I will debug that problem tomorrow morning. I just need to know how 
>>> do you connect with your JDBC. Which user do you use? The same as 
>>> mclient? Give me the commands and then I will debug the problem.
>>>
>>> Regards,
>>> Romulo
>>>     
>>>> (Not that this is my intended way of working. I just stubled upon this, 
>>>> developing my mapi client code and using the JDBC terminal for import of 
>>>> SQL scripts.)
>>>>
>>>> Sander
>>>>
>>>> Romulo Goncalves wrote:
>>>>       
>>>>> Sander Kruseman wrote:
>>>>>         
>>>>>> Hi Romulo,
>>>>>>
>>>>>> Thanks for your response. I downloaded the latest Windows installer 
>>>>>> today, and installed on XP.
>>>>>>           
>>>>> Me too and everything works fine. I used the SQL client (which is the 
>>>>> mclient -lsql) from the start menu to execute the queries on the 
>>>>> Mserver5 with SQL module loaded (also from the start menu).
>>>>>
>>>>> I did a select after the delete and both tables are empty.
>>>>>
>>>>> You need to find a solution to simulate this in my machine if not I am 
>>>>> not able to help you.
>>>>>
>>>>> Regards,
>>>>> Romulo
>>>>>         
>>>>>> # MonetDB server v5.2.0, based on kernel v1.20.0
>>>>>> ...
>>>>>> # MonetDB/SQL module v2.20.0 loaded
>>>>>>
>>>>>> Good to hear that apparently this has been fixed in the CVS trunk.
>>>>>>
>>>>>> Regards,
>>>>>> Sander
>>>>>>
>>>>>> Romulo Goncalves wrote:
>>>>>>           
>>>>>>> Sander Kruseman wrote:
>>>>>>>             
>>>>>>>> Consider the following setup:
>>>>>>>>
>>>>>>>> CREATE TABLE parent (key int PRIMARY KEY);
>>>>>>>> CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE 
>>>>>>>> CASCADE);
>>>>>>>>
>>>>>>>> INSERT INTO parent VALUES (1);
>>>>>>>> INSERT INTO child VALUES (1);
>>>>>>>>
>>>>>>>> Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1;
>>>>>>>> properly results in deletion of both records.
>>>>>>>>
>>>>>>>> However, when issued over mapi, either from my custom C++ code or from 
>>>>>>>> the provided Monet SQL client console, the same statement only deletes 
>>>>>>>> the row from 'parent', ignoring the cascading constraint.
>>>>>>>>               
>>>>>>> I just used my mclient to execute the queries on my MonetDB5 (5.21 
>>>>>>> current cvs branch) with the SQL module loaded and it works.
>>>>>>>
>>>>>>> Which version are you using and platform?
>>>>>>>
>>>>>>> Regards,
>>>>>>> Romulo
>>>>>>>             
>>>>>>>> Kind regards,
>>>>>>>> Sander Kruseman
>>>>>>>>
>>>>>>>> -------------------------------------------------------------------------
>>>>>>>> This SF.net email is sponsored by: Splunk Inc.
>>>>>>>> Still grepping through log files to find problems?  Stop.
>>>>>>>> Now Search log events and configuration files using AJAX and a browser.
>>>>>>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>>>>>>> _______________________________________________
>>>>>>>> MonetDB-users mailing list
>>>>>>>> MonetDB-users at lists.sourceforge.net
>>>>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>>>>>>               
>>>>>>> -------------------------------------------------------------------------
>>>>>>> This SF.net email is sponsored by: Splunk Inc.
>>>>>>> Still grepping through log files to find problems?  Stop.
>>>>>>> Now Search log events and configuration files using AJAX and a browser.
>>>>>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>>>>>> _______________________________________________
>>>>>>> MonetDB-users mailing list
>>>>>>> MonetDB-users at lists.sourceforge.net
>>>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>>>>>             
>>>>>> -------------------------------------------------------------------------
>>>>>> This SF.net email is sponsored by: Splunk Inc.
>>>>>> Still grepping through log files to find problems?  Stop.
>>>>>> Now Search log events and configuration files using AJAX and a browser.
>>>>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>>>>> _______________________________________________
>>>>>> MonetDB-users mailing list
>>>>>> MonetDB-users at lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>>>>           
>>>>> -------------------------------------------------------------------------
>>>>> This SF.net email is sponsored by: Splunk Inc.
>>>>> Still grepping through log files to find problems?  Stop.
>>>>> Now Search log events and configuration files using AJAX and a browser.
>>>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>>>> _______________________________________________
>>>>> MonetDB-users mailing list
>>>>> MonetDB-users at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>>>         
>>>> -------------------------------------------------------------------------
>>>> This SF.net email is sponsored by: Splunk Inc.
>>>> Still grepping through log files to find problems?  Stop.
>>>> Now Search log events and configuration files using AJAX and a browser.
>>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>>> _______________________________________________
>>>> MonetDB-users mailing list
>>>> MonetDB-users at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>>       
>>> -------------------------------------------------------------------------
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a browser.
>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>> _______________________________________________
>>> MonetDB-users mailing list
>>> MonetDB-users at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>>     
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>> _______________________________________________
>> MonetDB-users mailing list
>> MonetDB-users at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>>   
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users




More information about the users-list mailing list