From Alex.Shestakov@gsacapital.com Thu Jan 2 12:26:30 2014 From: "Shestakov, Alex" To: developers-list@monetdb.org Subject: Segmentation faultin sql_optimizer Date: Thu, 02 Jan 2014 11:26:27 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2994032508710230493==" --===============2994032508710230493== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, I have a segmentation fault when running an SQL query against a specific tabl= e. I can execute queries like "select count(*) from " but the server crashes when I do "select * from

" but the server crashes when I do "select * from

where businessdate =3D '2013-12-18' limit 100". MonetDB version: MonetDB Database Server Toolkit v1.1 (Feb2013-SP5) Stack trace: #0 0x00007f7cf2987eb1 in GDKfilepath (path=3D0x7f6e44f0db5d "", dir=3D0x7f7c= eb4c51d4 "bat", name=3D0x0, ext=3D0x0) at gdk_storage.c:51 #1 0x00007f7ceb3fbbd3 in BATlocation (fnme=3D0x7f6e44f0fbe0, bid=3D) at sql_optimizer.c:77 #2 0x00007f7ceb3fc59a in SQLgetStatistics (c=3D0x7f7cebed6308) at sql_optimi= zer.c:160 #3 addQueryToCache (c=3D0x7f7cebed6308) at sql_optimizer.c:295 #4 0x00007f7ceb3fb7ed in backend_dumpproc (be=3D0x7f6e3809d5f0, c=3D0x7f7ceb= ed6308, cq=3D0x7f6e383d4090, s=3D0x7f6e3837bd20) at sql_gencode.c:2431 #5 0x00007f7ceb3e2067 in SQLparser (c=3D0x7f7cebed6308) at sql_scenario.c:17= 55 #6 0x00007f7cf2f35b63 in runPhase (c=3D0x7f7cebed6308) at mal_scenario.c:522 #7 runScenarioBody (c=3D0x7f7cebed6308) at mal_scenario.c:558 #8 0x00007f7cf2f35caf in runScenario (c=3D0x7f7cebed6308) at mal_scenario.c:= 586 #9 0x00007f7cf2f36508 in MSserveClient (dummy=3D0x7f7cebed6308) at mal_sessi= on.c:446 #10 0x0000003ee9a07851 in start_thread () from /lib64/libpthread.so.0 #11 0x0000003ee92e890d in clone () from /lib64/libc.so.6 The problem is that it tries to de-reference null pointer 'name'. The pointer is calculated in BATLocation as (b->T->heap.filename ? b->T->hea= p.filename: b->H->heap.filename). The column in question has type real so as far as I understand there is no he= ap file for it. I don't know if heap.filename should contain NULL or something else. Regards, Alex Shestakov. ________________________________ This email and any files transmitted with it contain confidential and proprie= tary information and is solely for the use of the intended recipient. If you = are not the intended recipient please return the email to the sender and dele= te it from your computer and you must not use, disclose, distribute, copy, pr= int or rely on this email or its contents. This communication is for informat= ional purposes only. It is not intended as an offer or solicitation for the p= urchase or sale of any financial instrument or as an official confirmation of= any transaction. Any comments or statements made herein do not necessarily r= eflect those of GSA Capital. GSA Capital Partners LLP is authorised and regul= ated by the Financial Conduct Authority and is registered in England and Wale= s at Stratton House, 5 Stratton Street, London W1J 8LA, number OC309261. GSA = Capital Services Limited is registered in England and Wales at the same addre= ss, number 5320529. ________________________________ This email and any files transmitted with it contain confidential and proprie= tary information and is solely for the use of the intended recipient. If you = are not the intended recipient please return the email to the sender and dele= te it from your computer and you must not use, disclose, distribute, copy, pr= int or rely on this email or its contents. This communication is for informat= ional purposes only. It is not intended as an offer or solicitation for the p= urchase or sale of any financial instrument or as an official confirmation of= any transaction. Any comments or statements made herein do not necessarily r= eflect those of GSA Capital. GSA Capital Partners LLP is authorised and regul= ated by the Financial Conduct Authority and is registered in England and Wale= s at Stratton House, 5 Stratton Street, London W1J 8LA, number OC309261. GSA = Capital Services Limited is registered in England and Wales at the same addre= ss, number 5320529. --===============1155207267048462705== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9z b2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zOm09Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5j b20vb2ZmaWNlLzIwMDQvMTIvb21tbCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnL1RSL1JFQy1o dG1sNDAiPgo8aGVhZD4KPG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0 ZXh0L2h0bWw7IGNoYXJzZXQ9dXMtYXNjaWkiPgo8bWV0YSBuYW1lPSJHZW5lcmF0b3IiIGNvbnRl bnQ9Ik1pY3Jvc29mdCBXb3JkIDEyIChmaWx0ZXJlZCBtZWRpdW0pIj4KPCEtLVtpZiAhbXNvXT48 c3R5bGU+dlw6KiB7YmVoYXZpb3I6dXJsKCNkZWZhdWx0I1ZNTCk7fQpvXDoqIHtiZWhhdmlvcjp1 cmwoI2RlZmF1bHQjVk1MKTt9CndcOioge2JlaGF2aW9yOnVybCgjZGVmYXVsdCNWTUwpO30KLnNo YXBlIHtiZWhhdmlvcjp1cmwoI2RlZmF1bHQjVk1MKTt9Cjwvc3R5bGU+PCFbZW5kaWZdLS0+PHN0 eWxlPjwhLS0KLyogRm9udCBEZWZpbml0aW9ucyAqLwpAZm9udC1mYWNlCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7CglwYW5vc2UtMToyIDQgNSAzIDUgNCA2IDMgMiA0O30KQGZvbnQtZmFj ZQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7CglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9 CkBmb250LWZhY2UKCXtmb250LWZhbWlseTpUYWhvbWE7CglwYW5vc2UtMToyIDExIDYgNCAzIDUg NCA0IDIgNDt9Ci8qIFN0eWxlIERlZmluaXRpb25zICovCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3Jt YWwsIGRpdi5Nc29Ob3JtYWwKCXttYXJnaW46MGNtOwoJbWFyZ2luLWJvdHRvbTouMDAwMXB0OwoJ Zm9udC1zaXplOjExLjBwdDsKCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7fQph OmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJY29sb3I6 Ymx1ZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlw ZXJsaW5rRm9sbG93ZWQKCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7Cgljb2xvcjpwdXJwbGU7Cgl0 ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30Kc3Bhbi5FbWFpbFN0eWxlMTcKCXttc28tc3R5bGUt dHlwZTpwZXJzb25hbDsKCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7Cgljb2xv cjp3aW5kb3d0ZXh0O30Kc3Bhbi5FbWFpbFN0eWxlMTgKCXttc28tc3R5bGUtdHlwZTpwZXJzb25h bC1yZXBseTsKCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7Cgljb2xvcjojMUY0 OTdEO30KLk1zb0NocERlZmF1bHQKCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsKCWZvbnQt c2l6ZToxMC4wcHQ7fQpAcGFnZSBXb3JkU2VjdGlvbjEKCXtzaXplOjYxMi4wcHQgNzkyLjBwdDsK CW1hcmdpbjo3Mi4wcHQgNzIuMHB0IDcyLjBwdCA3Mi4wcHQ7fQpkaXYuV29yZFNlY3Rpb24xCgl7 cGFnZTpXb3JkU2VjdGlvbjE7fQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPgo8 bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIxMDI2IiAvPgo8L3htbD48IVtl bmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVk aXQiPgo8bzppZG1hcCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4KPC9vOnNoYXBlbGF5b3V0Pjwv eG1sPjwhW2VuZGlmXS0tPgo8L2hlYWQ+Cjxib2R5IGxhbmc9IkVOLUdCIiBsaW5rPSJibHVlIiB2 bGluaz0icHVycGxlIj4KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPkkgbmFycm93ZWQgaXQgZG93bi48bzpw PjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xv cjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj5UaGUgdGFibGUgY2F1c2luZyB0aGUgcHJv YmxlbSB3YXMgY3JlYXRlZCBhcyAmIzgyMjA7Y3JlYXRlIHRhYmxlIGFzIHNlbGVjdCBmcm9tICZs dDtTT01FX1ZJRVcmZ3Q7JiM4MjIxOy48bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj5UaGUgdmlldyBoYWQgb25lIGNv bHVtbiB0aGF0IHdhcyBhbHdheXMgbnVsbCBhbmQgdW5rbm93biB0eXBlLjxvOnA+PC9vOnA+PC9z cGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0Qi PkFzIGEgcmVzdWx0IGluIHRoZSB0YWJsZSB0aGUgY29sdW1uIGhhZCB0eXBlIEFOWS4gVGhhdCBz ZWVtcyB0byBoYXZlIGNhdXNlZCB0aGUgcHJvYmxlbS48bzpwPjwvbzpwPjwvc3Bhbj48L3A+Cjxw IGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNw OzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xv cjojMUY0OTdEIj5BZnRlciBJJiM4MjE3O3ZlIGNyZWF0ZWQgdGhlIHRhYmxlIGV4cGxpY2l0bHkg c3BlY2lmeWluZyBhbGwgdGhlIHR5cGVzIHRoZSBwcm9ibGVtIGhhcyBnb25lLjxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5 N0QiPlRoZSBzZWdmYXVsdCBzdGlsbCBuZWVkcyBmaXhpbmcgYXQgc29tZSBsZXZlbC48bzpwPjwv bzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjoj MUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwi PjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj5SZWdhcmRzLDxvOnA+PC9vOnA+PC9zcGFuPjwv cD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPkFsZXgg U2hlc3Rha292LjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPGRpdj4KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwv cD4KPC9kaXY+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdE Ij48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CjxkaXY+CjxkaXYgc3R5bGU9ImJvcmRlcjpu b25lO2JvcmRlci10b3A6c29saWQgI0I1QzRERiAxLjBwdDtwYWRkaW5nOjMuMHB0IDBjbSAwY20g MGNtIj4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNwYW4gbGFuZz0iRU4tVVMiIHN0eWxlPSJm b250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RhaG9tYSZxdW90OywmcXVvdDtzYW5z LXNlcmlmJnF1b3Q7Ij5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gbGFuZz0iRU4tVVMiIHN0eWxlPSJm b250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RhaG9tYSZxdW90OywmcXVvdDtzYW5z LXNlcmlmJnF1b3Q7Ij4gZGV2ZWxvcGVycy1saXN0IFttYWlsdG86ZGV2ZWxvcGVycy1saXN0LWJv dW5jZXMmIzQzO2FsZXguc2hlc3Rha292PWdzYWNhcGl0YWwuY29tQG1vbmV0ZGIub3JnXQo8Yj5P biBCZWhhbGYgT2YgPC9iPlNoZXN0YWtvdiwgQWxleDxicj4KPGI+U2VudDo8L2I+IDAyIEphbnVh cnkgMjAxNCAxMToyNjxicj4KPGI+VG86PC9iPiBkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmc8 YnI+CjxiPlN1YmplY3Q6PC9iPiBTZWdtZW50YXRpb24gZmF1bHRpbiBzcWxfb3B0aW1pemVyPG86 cD48L286cD48L3NwYW4+PC9wPgo8L2Rpdj4KPC9kaXY+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxv OnA+Jm5ic3A7PC9vOnA+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj5IaSw8bzpwPjwvbzpwPjwv cD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+CjxwIGNsYXNzPSJN c29Ob3JtYWwiPkkgaGF2ZSBhIHNlZ21lbnRhdGlvbiBmYXVsdCB3aGVuIHJ1bm5pbmcgYW4gU1FM IHF1ZXJ5IGFnYWluc3QgYSBzcGVjaWZpYyB0YWJsZS48bzpwPjwvbzpwPjwvcD4KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+SSBjYW4gZXhlY3V0ZSBxdWVyaWVzIGxpa2UgPG86cD48L286cD48L3A+Cjxw IGNsYXNzPSJNc29Ob3JtYWwiPiYjODIyMDtzZWxlY3QgY291bnQoKikgZnJvbSAmbHQ7VEFCTEUm Z3Q7JiM4MjIxOyA8bzpwPjwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+YnV0IHRoZSBz ZXJ2ZXIgY3Jhc2hlcyB3aGVuIEkgZG8gPG86cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3Jt YWwiPiYjODIyMDtzZWxlY3QgKiBmcm9tICZsdDtUQUJMRSZndDsgd2hlcmUgYnVzaW5lc3NkYXRl ID0gJiM4MjE2OzIwMTMtMTItMTgmIzgyMTc7IGxpbWl0IDEwMCYjODIyMTsuPG86cD48L286cD48 L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPgo8cCBjbGFzcz0i TXNvTm9ybWFsIj5Nb25ldERCIHZlcnNpb246PG86cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29O b3JtYWwiPk1vbmV0REIgRGF0YWJhc2UgU2VydmVyIFRvb2xraXQgdjEuMSAoRmViMjAxMy1TUDUp PG86cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9w Pgo8cCBjbGFzcz0iTXNvTm9ybWFsIj5TdGFjayB0cmFjZTo8bzpwPjwvbzpwPjwvcD4KPHAgY2xh c3M9Ik1zb05vcm1hbCI+IzAmbmJzcDsgMHgwMDAwN2Y3Y2YyOTg3ZWIxIGluIEdES2ZpbGVwYXRo IChwYXRoPTB4N2Y2ZTQ0ZjBkYjVkICZxdW90OyZxdW90OywgZGlyPTB4N2Y3Y2ViNGM1MWQ0ICZx dW90O2JhdCZxdW90OywgbmFtZT0weDAsIGV4dD0weDApIGF0IGdka19zdG9yYWdlLmM6NTE8bzpw PjwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+IzEmbmJzcDsgMHgwMDAwN2Y3Y2ViM2Zi YmQzIGluIEJBVGxvY2F0aW9uIChmbm1lPTB4N2Y2ZTQ0ZjBmYmUwLCBiaWQ9Jmx0O3ZhbHVlIG9w dGltaXplZCBvdXQmZ3Q7KSBhdCBzcWxfb3B0aW1pemVyLmM6Nzc8bzpwPjwvbzpwPjwvcD4KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+IzImbmJzcDsgMHgwMDAwN2Y3Y2ViM2ZjNTlhIGluIFNRTGdldFN0 YXRpc3RpY3MgKGM9MHg3ZjdjZWJlZDYzMDgpIGF0IHNxbF9vcHRpbWl6ZXIuYzoxNjA8bzpwPjwv bzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+IzMmbmJzcDsgYWRkUXVlcnlUb0NhY2hlIChj PTB4N2Y3Y2ViZWQ2MzA4KSBhdCBzcWxfb3B0aW1pemVyLmM6Mjk1PG86cD48L286cD48L3A+Cjxw IGNsYXNzPSJNc29Ob3JtYWwiPiM0Jm5ic3A7IDB4MDAwMDdmN2NlYjNmYjdlZCBpbiBiYWNrZW5k X2R1bXBwcm9jIChiZT0weDdmNmUzODA5ZDVmMCwgYz0weDdmN2NlYmVkNjMwOCwgY3E9MHg3ZjZl MzgzZDQwOTAsIHM9MHg3ZjZlMzgzN2JkMjApIGF0IHNxbF9nZW5jb2RlLmM6MjQzMTxvOnA+PC9v OnA+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj4jNSZuYnNwOyAweDAwMDA3ZjdjZWIzZTIwNjcg aW4gU1FMcGFyc2VyIChjPTB4N2Y3Y2ViZWQ2MzA4KSBhdCBzcWxfc2NlbmFyaW8uYzoxNzU1PG86 cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPiM2Jm5ic3A7IDB4MDAwMDdmN2NmMmYz NWI2MyBpbiBydW5QaGFzZSAoYz0weDdmN2NlYmVkNjMwOCkgYXQgbWFsX3NjZW5hcmlvLmM6NTIy PG86cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPiM3Jm5ic3A7IHJ1blNjZW5hcmlv Qm9keSAoYz0weDdmN2NlYmVkNjMwOCkgYXQgbWFsX3NjZW5hcmlvLmM6NTU4PG86cD48L286cD48 L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPiM4Jm5ic3A7IDB4MDAwMDdmN2NmMmYzNWNhZiBpbiBy dW5TY2VuYXJpbyAoYz0weDdmN2NlYmVkNjMwOCkgYXQgbWFsX3NjZW5hcmlvLmM6NTg2PG86cD48 L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPiM5Jm5ic3A7IDB4MDAwMDdmN2NmMmYzNjUw OCBpbiBNU3NlcnZlQ2xpZW50IChkdW1teT0weDdmN2NlYmVkNjMwOCkgYXQgbWFsX3Nlc3Npb24u Yzo0NDY8bzpwPjwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+IzEwIDB4MDAwMDAwM2Vl OWEwNzg1MSBpbiBzdGFydF90aHJlYWQgKCkgZnJvbSAvbGliNjQvbGlicHRocmVhZC5zby4wPG86 cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPiMxMSAweDAwMDAwMDNlZTkyZTg5MGQg aW4gY2xvbmUgKCkgZnJvbSAvbGliNjQvbGliYy5zby42PG86cD48L286cD48L3A+CjxwIGNsYXNz PSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj5U aGUgcHJvYmxlbSBpcyB0aGF0IGl0IHRyaWVzIHRvIGRlLXJlZmVyZW5jZSBudWxsIHBvaW50ZXIg JiM4MjE2O25hbWUmIzgyMTc7Lgo8bzpwPjwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ VGhlIHBvaW50ZXIgaXMgY2FsY3VsYXRlZCBpbiBCQVRMb2NhdGlvbiBhcyAmbmJzcDsoYi0mZ3Q7 VC0mZ3Q7aGVhcC5maWxlbmFtZSA/IGItJmd0O1QtJmd0O2hlYXAuZmlsZW5hbWU6IGItJmd0O0gt Jmd0O2hlYXAuZmlsZW5hbWUpLjxvOnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj5U aGUgY29sdW1uIGluIHF1ZXN0aW9uIGhhcyB0eXBlIHJlYWwgc28gYXMgZmFyIGFzIEkgdW5kZXJz dGFuZCB0aGVyZSBpcyBubyBoZWFwIGZpbGUgZm9yIGl0LjxvOnA+PC9vOnA+PC9wPgo8cCBjbGFz cz0iTXNvTm9ybWFsIj5JIGRvbiYjODIxNzt0IGtub3cgaWYgaGVhcC5maWxlbmFtZSBzaG91bGQg Y29udGFpbiBOVUxMIG9yIHNvbWV0aGluZyBlbHNlLjxvOnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0i TXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+UmVn YXJkcyw8bzpwPjwvbzpwPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+QWxleCBTaGVzdGFrb3Yu PG86cD48L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9w Pgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEyLjBwdDtmb250 LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxv OnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPGRpdiBjbGFzcz0iTXNvTm9ybWFsIiBhbGlnbj0i Y2VudGVyIiBzdHlsZT0idGV4dC1hbGlnbjpjZW50ZXIiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6 MTIuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJp ZiZxdW90OyI+CjxociBzaXplPSIyIiB3aWR0aD0iMTAwJSIgYWxpZ249ImNlbnRlciI+Cjwvc3Bh bj48L2Rpdj4KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1ib3R0b206MTIuMHB0 Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjcuNXB0O2ZvbnQtZmFtaWx5OiZxdW90O0FyaWFsJnF1 b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6Z3JheSI+VGhpcyBlbWFpbCBhbmQgYW55 IGZpbGVzIHRyYW5zbWl0dGVkIHdpdGggaXQgY29udGFpbiBjb25maWRlbnRpYWwgYW5kIHByb3By aWV0YXJ5IGluZm9ybWF0aW9uIGFuZCBpcyBzb2xlbHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGludGVu ZGVkCiByZWNpcGllbnQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgcGxl YXNlIHJldHVybiB0aGUgZW1haWwgdG8gdGhlIHNlbmRlciBhbmQgZGVsZXRlIGl0IGZyb20geW91 ciBjb21wdXRlciBhbmQgeW91IG11c3Qgbm90IHVzZSwgZGlzY2xvc2UsIGRpc3RyaWJ1dGUsIGNv cHksIHByaW50IG9yIHJlbHkgb24gdGhpcyBlbWFpbCBvciBpdHMgY29udGVudHMuIFRoaXMgY29t bXVuaWNhdGlvbiBpcyBmb3IgaW5mb3JtYXRpb25hbCBwdXJwb3Nlcwogb25seS4gSXQgaXMgbm90 IGludGVuZGVkIGFzIGFuIG9mZmVyIG9yIHNvbGljaXRhdGlvbiBmb3IgdGhlIHB1cmNoYXNlIG9y IHNhbGUgb2YgYW55IGZpbmFuY2lhbCBpbnN0cnVtZW50IG9yIGFzIGFuIG9mZmljaWFsIGNvbmZp cm1hdGlvbiBvZiBhbnkgdHJhbnNhY3Rpb24uIEFueSBjb21tZW50cyBvciBzdGF0ZW1lbnRzIG1h ZGUgaGVyZWluIGRvIG5vdCBuZWNlc3NhcmlseSByZWZsZWN0IHRob3NlIG9mIEdTQSBDYXBpdGFs LiBHU0EgQ2FwaXRhbAogUGFydG5lcnMgTExQIGlzIGF1dGhvcmlzZWQgYW5kIHJlZ3VsYXRlZCBi eSB0aGUgRmluYW5jaWFsIENvbmR1Y3QgQXV0aG9yaXR5IGFuZCBpcyByZWdpc3RlcmVkIGluIEVu Z2xhbmQgYW5kIFdhbGVzIGF0IFN0cmF0dG9uIEhvdXNlLCA1IFN0cmF0dG9uIFN0cmVldCwgTG9u ZG9uIFcxSiA4TEEsIG51bWJlciBPQzMwOTI2MS4gR1NBIENhcGl0YWwgU2VydmljZXMgTGltaXRl ZCBpcyByZWdpc3RlcmVkIGluIEVuZ2xhbmQgYW5kIFdhbGVzIGF0IHRoZQogc2FtZSBhZGRyZXNz LCBudW1iZXIgNTMyMDUyOS48L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQ7Zm9u dC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48 bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjwvZGl2Pgo8YnI+Cjxocj4KPGZvbnQgZmFjZT0iQXJpYWwi IGNvbG9yPSJHcmF5IiBzaXplPSIxIj5UaGlzIGVtYWlsIGFuZCBhbnkgZmlsZXMgdHJhbnNtaXR0 ZWQgd2l0aCBpdCBjb250YWluIGNvbmZpZGVudGlhbCBhbmQgcHJvcHJpZXRhcnkgaW5mb3JtYXRp b24gYW5kIGlzIHNvbGVseSBmb3IgdGhlIHVzZSBvZiB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LiBJ ZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IHBsZWFzZSByZXR1cm4gdGhlIGVt YWlsIHRvIHRoZQogc2VuZGVyIGFuZCBkZWxldGUgaXQgZnJvbSB5b3VyIGNvbXB1dGVyIGFuZCB5 b3UgbXVzdCBub3QgdXNlLCBkaXNjbG9zZSwgZGlzdHJpYnV0ZSwgY29weSwgcHJpbnQgb3IgcmVs eSBvbiB0aGlzIGVtYWlsIG9yIGl0cyBjb250ZW50cy4gVGhpcyBjb21tdW5pY2F0aW9uIGlzIGZv ciBpbmZvcm1hdGlvbmFsIHB1cnBvc2VzIG9ubHkuIEl0IGlzIG5vdCBpbnRlbmRlZCBhcyBhbiBv ZmZlciBvciBzb2xpY2l0YXRpb24gZm9yIHRoZSBwdXJjaGFzZSBvcgogc2FsZSBvZiBhbnkgZmlu YW5jaWFsIGluc3RydW1lbnQgb3IgYXMgYW4gb2ZmaWNpYWwgY29uZmlybWF0aW9uIG9mIGFueSB0 cmFuc2FjdGlvbi4gQW55IGNvbW1lbnRzIG9yIHN0YXRlbWVudHMgbWFkZSBoZXJlaW4gZG8gbm90 IG5lY2Vzc2FyaWx5IHJlZmxlY3QgdGhvc2Ugb2YgR1NBIENhcGl0YWwuIEdTQSBDYXBpdGFsIFBh cnRuZXJzIExMUCBpcyBhdXRob3Jpc2VkIGFuZCByZWd1bGF0ZWQgYnkgdGhlIEZpbmFuY2lhbCBD b25kdWN0IEF1dGhvcml0eQogYW5kIGlzIHJlZ2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQgV2FsZXMg YXQgU3RyYXR0b24gSG91c2UsIDUgU3RyYXR0b24gU3RyZWV0LCBMb25kb24gVzFKIDhMQSwgbnVt YmVyIE9DMzA5MjYxLiBHU0EgQ2FwaXRhbCBTZXJ2aWNlcyBMaW1pdGVkIGlzIHJlZ2lzdGVyZWQg aW4gRW5nbGFuZCBhbmQgV2FsZXMgYXQgdGhlIHNhbWUgYWRkcmVzcywgbnVtYmVyIDUzMjA1Mjku PGJyPgo8YnI+CjwvZm9udD4KPC9ib2R5Pgo8L2h0bWw+Cg== --===============1155207267048462705==-- From adnan.agbaria@yahoo.com Sun Jan 5 16:00:35 2014 From: Adnan Agbaria To: developers-list@monetdb.org Subject: Create a table with FLOAT type Date: Sun, 05 Jan 2014 07:00:33 -0800 Message-ID: <1388934033.64387.YahooMailNeo@web162803.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1382811067147317977==" --===============1382811067147317977== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello, I use MonetDB in Ubuntu. When I create a table with FLOAT type, MonetDB creat= ed it as DOUBLE type. Why does MonetDB decide to change FLOAT to DOUBLE? How can I fix this? --===============1382811067147317977== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWw+PGJvZHk+PGRpdiBzdHlsZT0iY29sb3I6IzAwMDsgYmFja2dyb3VuZC1jb2xvcjojZmZm OyBmb250LWZhbWlseTpIZWx2ZXRpY2FOZXVlLCBIZWx2ZXRpY2EgTmV1ZSwgSGVsdmV0aWNhLCBB cmlhbCwgTHVjaWRhIEdyYW5kZSwgc2Fucy1zZXJpZjtmb250LXNpemU6MTJwdCI+SGVsbG8sPGJy PkkgdXNlIE1vbmV0REIgaW4gVWJ1bnR1LiBXaGVuIEkgY3JlYXRlIGEgdGFibGUgd2l0aCBGTE9B VCB0eXBlLCBNb25ldERCIGNyZWF0ZWQgaXQgYXMgRE9VQkxFIHR5cGUuPGJyPldoeSBkb2VzIE1v bmV0REIgZGVjaWRlIHRvIGNoYW5nZSBGTE9BVCB0byBET1VCTEU/PGJyPkhvdyBjYW4gSSBmaXgg dGhpcz88ZGl2PjwvZGl2PjwvZGl2PjwvYm9keT48L2h0bWw+ --===============1382811067147317977==-- From Stefan.Manegold@cwi.nl Sun Jan 5 16:39:33 2014 From: Stefan Manegold To: developers-list@monetdb.org Subject: Re: Create a table with FLOAT type Date: Sun, 05 Jan 2014 16:39:24 +0100 Message-ID: <782292700.1033789.1388936364808.JavaMail.zimbra@cwi.nl> In-Reply-To: <1388934033.64387.YahooMailNeo@web162803.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6583080706819616817==" --===============6583080706819616817== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Hi, in the SQL standard, REAL is a single-precision (32-bit/4-byte) floating point data type, DOUBLE is a double-precision (64-bit/8-byte) floating point data type, and FLOAT is a data type that might allow to specify the precision; cf., e.g., http://www.techonthenet.com/sql/datatypes.php In MonetDB, we do not support FLOAT with variable precision. Thus, we choose the highes available precision by mapping FLOAT to DOUBLE. If you prefer single-precision (32-bit/4-byte), please consider using REAL instead. See also http://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes Best, Stefan ----- Original Message ----- > Hello, > I use MonetDB in Ubuntu. When I create a table with FLOAT type, MonetDB > created it as DOUBLE type. > Why does MonetDB decide to change FLOAT to DOUBLE? > How can I fix this? > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list > -- | Stefan.Manegold(a)CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | --===============6583080706819616817==-- From N.Rooney@sophiasearch.com Mon Jan 6 17:32:09 2014 From: Niall Rooney To: developers-list@monetdb.org Subject: user defnined function problem Date: Mon, 06 Jan 2014 16:32:06 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6008955450237392227==" --===============6008955450237392227== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello, I am making the following adjustment to the user defined function template fi= les . I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. I have added to the following files in the ./sql/backends/monet5/UDF director= y as shown: 80_udf.sql create function sumProb(prob1 double, prob2 double) returns double external name udf.sumProb; udf.mal module udf; command sumProb(prob1:dbl,prob2:dbl):dbl address UDFSumProb comment "sum two probabilities"; udf.c str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) { *res =3D *prob1 + *prob2; return MAL_SUCCEED; } udf.h udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); I did a configure/make/make install and tried the following call in mclient: declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select c=3Djsdistance(a,b); and get the error: TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D udf.sumpr= ob(_8:dbl, _11:dbl) program contains errors --===============6008955450237392227== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+CjxoZWFkPgo8bWV0YSBodHRwLWVxdWl2PSJDb250ZW50LVR5cGUiIGNv bnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD11cy1hc2NpaSI+CjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTQgKGZpbHRlcmVkIG1lZGl1bSkiPgo8c3R5bGU+ PCEtLQovKiBGb250IERlZmluaXRpb25zICovCkBmb250LWZhY2UKCXtmb250LWZhbWlseToiQ2Ft YnJpYSBNYXRoIjsKCXBhbm9zZS0xOjIgNCA1IDMgNSA0IDYgMyAyIDQ7fQpAZm9udC1mYWNlCgl7 Zm9udC1mYW1pbHk6Q2FsaWJyaTsKCXBhbm9zZS0xOjIgMTUgNSAyIDIgMiA0IDMgMiA0O30KLyog U3R5bGUgRGVmaW5pdGlvbnMgKi8KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05v cm1hbAoJe21hcmdpbjowY207CgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7Cglmb250LXNpemU6MTEu MHB0OwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsKCW1zby1mYXJlYXN0LWxh bmd1YWdlOkVOLVVTO30KYTpsaW5rLCBzcGFuLk1zb0h5cGVybGluawoJe21zby1zdHlsZS1wcmlv cml0eTo5OTsKCWNvbG9yOmJsdWU7Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30KYTp2aXNp dGVkLCBzcGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJ Y29sb3I6cHVycGxlOwoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9CnAKCXttc28tc3R5bGUt cHJpb3JpdHk6OTk7Cgltc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzsKCW1hcmdpbi1yaWdodDowY207 Cgltc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bzsKCW1hcmdpbi1sZWZ0OjBjbTsKCWZvbnQtc2l6 ZToxMi4wcHQ7Cglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2VyaWYiO30KY29kZQoJ e21zby1zdHlsZS1wcmlvcml0eTo5OTsKCWZvbnQtZmFtaWx5OiJDb3VyaWVyIE5ldyI7fQpwcmUK CXttc28tc3R5bGUtcHJpb3JpdHk6OTk7Cgltc28tc3R5bGUtbGluazoiSFRNTCBQcmVmb3JtYXR0 ZWQgQ2hhciI7CgltYXJnaW46MGNtOwoJbWFyZ2luLWJvdHRvbTouMDAwMXB0OwoJZm9udC1zaXpl OjEwLjBwdDsKCWZvbnQtZmFtaWx5OiJDb3VyaWVyIE5ldyI7fQpzcGFuLkVtYWlsU3R5bGUxNwoJ e21zby1zdHlsZS10eXBlOnBlcnNvbmFsLWNvbXBvc2U7Cglmb250LWZhbWlseToiQ2FsaWJyaSIs InNhbnMtc2VyaWYiOwoJY29sb3I6d2luZG93dGV4dDt9CnNwYW4uSFRNTFByZWZvcm1hdHRlZENo YXIKCXttc28tc3R5bGUtbmFtZToiSFRNTCBQcmVmb3JtYXR0ZWQgQ2hhciI7Cgltc28tc3R5bGUt cHJpb3JpdHk6OTk7Cgltc28tc3R5bGUtbGluazoiSFRNTCBQcmVmb3JtYXR0ZWQiOwoJZm9udC1m YW1pbHk6IkNvdXJpZXIgTmV3IjsKCW1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLUdCO30KLk1zb0No cERlZmF1bHQKCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsKCWZvbnQtZmFtaWx5OiJDYWxp YnJpIiwic2Fucy1zZXJpZiI7Cgltc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1VUzt9CkBwYWdlIFdv cmRTZWN0aW9uMQoJe3NpemU6NjEyLjBwdCA3OTIuMHB0OwoJbWFyZ2luOjcyLjBwdCA3Mi4wcHQg NzIuMHB0IDcyLjBwdDt9CmRpdi5Xb3JkU2VjdGlvbjEKCXtwYWdlOldvcmRTZWN0aW9uMTt9Ci0t Pjwvc3R5bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+CjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9 ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+CjwveG1sPjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1z byA5XT48eG1sPgo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+CjxvOmlkbWFwIHY6ZXh0PSJl ZGl0IiBkYXRhPSIxIiAvPgo8L286c2hhcGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+CjwvaGVh ZD4KPGJvZHkgbGFuZz0iRU4tR0IiIGxpbms9ImJsdWUiIHZsaW5rPSJwdXJwbGUiPgo8ZGl2IGNs YXNzPSJXb3JkU2VjdGlvbjEiPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9u dC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij5I ZWxsbyw8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0 eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYm cXVvdDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVv dDtzZXJpZiZxdW90OyI+SSBhbSBtYWtpbmcgdGhlIGZvbGxvd2luZyBhZGp1c3RtZW50IHRvIHRo ZSB1c2VyIGRlZmluZWQgZnVuY3Rpb24gdGVtcGxhdGUgZmlsZXMgLjxvOnA+PC9vOnA+PC9zcGFu PjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90 O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+PG86cD4mbmJzcDs8L286 cD48L3NwYW4+PC9wPgo8dGFibGUgY2xhc3M9Ik1zb05vcm1hbFRhYmxlIiBib3JkZXI9IjAiIGNl bGxzcGFjaW5nPSIzIiBjZWxscGFkZGluZz0iMCI+Cjx0Ym9keT4KPHRyPgo8dGQgc3R5bGU9InBh ZGRpbmc6Ljc1cHQgLjc1cHQgLjc1cHQgLjc1cHQiPjwvdGQ+Cjx0ZCBzdHlsZT0icGFkZGluZzou NzVwdCAuNzVwdCAuNzVwdCAuNzVwdCI+CjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtc28t bWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byI+PHNwYW4gc3R5 bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZx dW90Ozttc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1HQiI+SSBhbSB1c2luZyBNb25ldERCLTExLjE1 LjE1IGJ1aWx0IGZyb20gc291cmNlIG9uIFVidW50dSAxMi4wNC48bzpwPjwvbzpwPjwvc3Bhbj48 L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bztt c28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90 O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90Ozttc28tZmFyZWFzdC1sYW5n dWFnZTpFTi1HQiI+SSBoYXZlIGFkZGVkIHRvIHRoZSBmb2xsb3dpbmcgZmlsZXMgaW4gdGhlIC4v c3FsL2JhY2tlbmRzL21vbmV0NS9VREYgZGlyZWN0b3J5IGFzIHNob3duOjxvOnA+PC9vOnA+PC9z cGFuPjwvcD4KPC90ZD4KPC90cj4KPC90Ym9keT4KPC90YWJsZT4KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90Oywm cXVvdDtzZXJpZiZxdW90OyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPgo8cCBjbGFzcz0i TXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFu JnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+Cjxw IGNsYXNzPSJNc29Ob3JtYWwiPjxiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1l cyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjgwX3VkZi5zcWw8bzpwPjwvbzpw Pjwvc3Bhbj48L2I+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1m YW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48bzpw PiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxl PSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVv dDsiPmNyZWF0ZSBmdW5jdGlvbiBzdW1Qcm9iKHByb2IxIGRvdWJsZSwgcHJvYjIgZG91YmxlKTxv OnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZv bnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+ cmV0dXJucyBkb3VibGUgZXh0ZXJuYWwgbmFtZSB1ZGYuc3VtUHJvYjs8bzpwPjwvbzpwPjwvc3Bh bj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVv dDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+PC9vOnA+PC9z cGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5 OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+dWRmLm1hbDxv OnA+PC9vOnA+PC9zcGFuPjwvYj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxl PSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVv dDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtz ZXJpZiZxdW90OyI+bW9kdWxlIHVkZjs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4m cXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5l dyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+Y29tbWFuZCBzdW1Qcm9iKHByb2IxOmRi bCxwcm9iMjpkYmwpOmRibDxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90Oywm cXVvdDtzZXJpZiZxdW90OyI+YWRkcmVzcyBVREZTdW1Qcm9iPG86cD48L286cD48L3NwYW4+PC9w Pgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7VGlt ZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij5jb21tZW50ICZxdW90O3N1bSB0 d28gcHJvYmFiaWxpdGllcyZxdW90Ozs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4m cXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVz IE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+dWRmLmM8bzpwPjwvbzpwPjwvc3Bh bj48L2I+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6 JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48bzpwPiZuYnNw OzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250 LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPnN0 ciBVREZTdW1Qcm9iKGRibCAqIHJlcywgZGJsICogcHJvYjEsIGRibCZuYnNwOyAqIHByb2IyKTxv OnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZv bnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+ ezxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90 OyI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7ICpyZXMgPSZuYnNwOyAqcHJvYjEgJiM0MzsgKnByb2IyOzxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5 OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 IHJldHVybiBNQUxfU1VDQ0VFRDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29O b3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVv dDssJnF1b3Q7c2VyaWYmcXVvdDsiPn08bzpwPjwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4m cXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVz IE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+dWRmLmg8bzpwPjwvbzpwPjwvc3Bh bj48L2I+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6 JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48bzpwPiZuYnNw OzwvbzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250 LWZhbWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPnVk Zl9leHBvcnQgc3RyIFVERlN1bVByb2IoZGJsICogcmVzLCBkYmwgKiBwcm9iMSwgZGJsJm5ic3A7 ICogcHJvYjIpOzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtz ZXJpZiZxdW90OyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPgo8cCBjbGFzcz0iTXNvTm9y bWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7 LCZxdW90O3NlcmlmJnF1b3Q7Ij5JIGRpZCBhIGNvbmZpZ3VyZS9tYWtlL21ha2UgaW5zdGFsbCBh bmQgdHJpZWQgdGhlIGZvbGxvd2luZyBjYWxsIGluIG1jbGllbnQ6PG86cD48L286cD48L3NwYW4+ PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7 VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZxdW90O3NlcmlmJnF1b3Q7Ij48bzpwPiZuYnNwOzwvbzpw Pjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWls eTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPmRlY2xhcmUg YSwgYixjIGRvdWJsZTsgc2V0IGE9IDAuMTsgc2V0IGI9IDAuMjsgc2VsZWN0IGM9anNkaXN0YW5j ZShhLGIpOzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4g c3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJp ZiZxdW90OyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPgo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7LCZx dW90O3NlcmlmJnF1b3Q7Ij5hbmQgZ2V0IHRoZSBlcnJvcjo8bzpwPjwvbzpwPjwvc3Bhbj48L3A+ CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtUaW1l cyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+Jm5ic3A7PC9vOnA+PC9z cGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZx dW90O1RpbWVzIE5ldyBSb21hbiZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+VHlwZUV4Y2VwdGlv bjp1c2VyLnMyXzFbOF06J3VkZi5zdW1wcm9iJyB1bmRlZmluZWQgaW46IF8xMjphbnkgOj0gdWRm LnN1bXByb2IoXzg6ZGJsLCBfMTE6ZGJsKTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21h biZxdW90OywmcXVvdDtzZXJpZiZxdW90OyI+cHJvZ3JhbSBjb250YWlucyBlcnJvcnM8bzpwPjwv bzpwPjwvc3Bhbj48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZh bWlseTomcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDssJnF1b3Q7c2VyaWYmcXVvdDsiPjxvOnA+ Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8 L286cD48L3A+CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPgo8L2Rp dj4KPC9ib2R5Pgo8L2h0bWw+Cg== --===============6008955450237392227==-- From Stefan.Manegold@cwi.nl Mon Jan 6 18:32:05 2014 From: Stefan Manegold To: developers-list@monetdb.org Subject: Re: user defnined function problem Date: Mon, 06 Jan 2014 18:31:58 +0100 Message-ID: <124985355.1141181.1389029518945.JavaMail.zimbra@cwi.nl> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8775491009059173793==" --===============8775491009059173793== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, as all XY_*.sql files that are installed into /monetdb5/createdb/ also 80_udf.sql get only loaded and executed the first time mserver5 is started on a virgin empty (i.e., newly created) DB (then the content is persistently kept in the DB's catalog. Thus, to get your newly added funtion working (i.e., added to the SQL catalog= ), you either need to create a new database, or execute the SQL commands you add= ed to 80_udf.sql by hand (once) in mclient. Best, Stefan ----- Original Message ----- >=20 >=20 > Hello, >=20 >=20 >=20 > I am making the following adjustment to the user defined function template > files . >=20 >=20 > =09 >=20 > I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >=20 > I have added to the following files in the ./sql/backends/monet5/UDF > directory as shown: >=20 >=20 >=20 >=20 >=20 > 80_udf.sql >=20 >=20 >=20 > create function sumProb(prob1 double, prob2 double) >=20 > returns double external name udf.sumProb; >=20 >=20 >=20 > udf.mal >=20 >=20 >=20 > module udf; >=20 >=20 >=20 > command sumProb(prob1:dbl,prob2:dbl):dbl >=20 > address UDFSumProb >=20 > comment "sum two probabilities"; >=20 >=20 >=20 > udf.c >=20 >=20 >=20 > str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >=20 > { >=20 > *res =3D *prob1 + *prob2; >=20 > return MAL_SUCCEED; >=20 > } >=20 >=20 >=20 > udf.h >=20 >=20 >=20 > udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >=20 >=20 >=20 > I did a configure/make/make install and tried the following call in mclient: >=20 >=20 >=20 > declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select c=3Djsdistance(a,= b); >=20 >=20 >=20 > and get the error: >=20 >=20 >=20 > TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D > udf.sumprob(_8:dbl, _11:dbl) >=20 > program contains errors >=20 >=20 >=20 >=20 >=20 >=20 >=20 > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list >=20 --=20 | Stefan.Manegold(a)CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | --===============8775491009059173793==-- From N.Rooney@sophiasearch.com Mon Jan 6 18:46:14 2014 From: Niall Rooney To: developers-list@monetdb.org Subject: FW: user defnined function problem Date: Mon, 06 Jan 2014 17:46:12 +0000 Message-ID: <0cc5de20fc3c4c0b9ddecc86f22b61c9@AMSPR03MB097.eurprd03.prod.outlook.com> In-Reply-To: <124985355.1141181.1389029518945.JavaMail.zimbra@cwi.nl> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7229922021891368999==" --===============7229922021891368999== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello Stefan, I tried doing so on a newly created database but I had the same error message. -----Original Message----- From: developers-list [mailto:developers-list-bounces+n.rooney=3Dsophiasearch= .com(a)monetdb.org] On Behalf Of Stefan Manegold Sent: 06 January 2014 17:32 To: Communication channel for developers of the MonetDB suite. Subject: Re: user defnined function problem Hi, as all XY_*.sql files that are installed into /monetdb5/createdb/ als= o 80_udf.sql get only loaded and executed the first time mserver5 is started = on a virgin empty (i.e., newly created) DB (then the content is persistently = kept in the DB's catalog. Thus, to get your newly added funtion working (i.e., added to the SQL catalog= ), you either need to create a new database, or execute the SQL commands you = added to 80_udf.sql by hand (once) in mclient. Best, Stefan ----- Original Message ----- >=20 >=20 > Hello, >=20 >=20 >=20 > I am making the following adjustment to the user defined function=20 > template files . >=20 >=20 > =09 >=20 > I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >=20 > I have added to the following files in the ./sql/backends/monet5/UDF=20 > directory as shown: >=20 >=20 >=20 >=20 >=20 > 80_udf.sql >=20 >=20 >=20 > create function sumProb(prob1 double, prob2 double) >=20 > returns double external name udf.sumProb; >=20 >=20 >=20 > udf.mal >=20 >=20 >=20 > module udf; >=20 >=20 >=20 > command sumProb(prob1:dbl,prob2:dbl):dbl >=20 > address UDFSumProb >=20 > comment "sum two probabilities"; >=20 >=20 >=20 > udf.c >=20 >=20 >=20 > str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >=20 > { >=20 > *res =3D *prob1 + *prob2; >=20 > return MAL_SUCCEED; >=20 > } >=20 >=20 >=20 > udf.h >=20 >=20 >=20 > udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >=20 >=20 >=20 > I did a configure/make/make install and tried the following call in mclient: >=20 >=20 >=20 > declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select=20 > c=3Djsdistance(a,b); >=20 >=20 >=20 > and get the error: >=20 >=20 >=20 > TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D=20 > udf.sumprob(_8:dbl, _11:dbl) >=20 > program contains errors >=20 >=20 >=20 >=20 >=20 >=20 >=20 > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list >=20 --=20 | Stefan.Manegold(a)CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ developers-list mailing list developers-list(a)monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list --===============7229922021891368999==-- From sjoerd@monetdb.org Mon Jan 6 23:04:18 2014 From: Sjoerd Mullender To: developers-list@monetdb.org Subject: Re: FW: user defnined function problem Date: Mon, 06 Jan 2014 23:04:14 +0100 Message-ID: <52CB285E.4080807@monetdb.org> In-Reply-To: <0cc5de20fc3c4c0b9ddecc86f22b61c9@AMSPR03MB097.eurprd03.prod.outlook.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4495725180011403267==" --===============4495725180011403267== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable You also need something like 80_udf.mal in .../lib/monetdb5/autoload with the line include udf; in it. On 2014-01-06 18:46, Niall Rooney wrote: > Hello Stefan, >=20 > I tried doing so on a newly created database but I had the same error messa= ge. >=20 >=20 > -----Original Message----- > From: developers-list [mailto:developers-list-bounces+n.rooney=3Dsophiasear= ch.com(a)monetdb.org] On Behalf Of Stefan Manegold > Sent: 06 January 2014 17:32 > To: Communication channel for developers of the MonetDB suite. > Subject: Re: user defnined function problem >=20 > Hi, >=20 > as all XY_*.sql files that are installed into /monetdb5/createdb/ a= lso 80_udf.sql get only loaded and executed the first time mserver5 is starte= d on a virgin empty (i.e., newly created) DB (then the content is persistentl= y kept in the DB's catalog. >=20 > Thus, to get your newly added funtion working (i.e., added to the SQL catal= og), you either need to create a new database, or execute the SQL commands yo= u added to 80_udf.sql by hand (once) in mclient. >=20 > Best, > Stefan >=20 > ----- Original Message ----- >> >> >> Hello, >> >> >> >> I am making the following adjustment to the user defined function=20 >> template files . >> >> >> =09 >> >> I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >> >> I have added to the following files in the ./sql/backends/monet5/UDF=20 >> directory as shown: >> >> >> >> >> >> 80_udf.sql >> >> >> >> create function sumProb(prob1 double, prob2 double) >> >> returns double external name udf.sumProb; >> >> >> >> udf.mal >> >> >> >> module udf; >> >> >> >> command sumProb(prob1:dbl,prob2:dbl):dbl >> >> address UDFSumProb >> >> comment "sum two probabilities"; >> >> >> >> udf.c >> >> >> >> str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >> >> { >> >> *res =3D *prob1 + *prob2; >> >> return MAL_SUCCEED; >> >> } >> >> >> >> udf.h >> >> >> >> udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >> >> >> >> I did a configure/make/make install and tried the following call in mclien= t: >> >> >> >> declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select=20 >> c=3Djsdistance(a,b); >> >> >> >> and get the error: >> >> >> >> TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D=20 >> udf.sumprob(_8:dbl, _11:dbl) >> >> program contains errors >> >> >> >> >> >> >> >> _______________________________________________ >> developers-list mailing list >> developers-list(a)monetdb.org >> https://www.monetdb.org/mailman/listinfo/developers-list >> >=20 --=20 Sjoerd Mullender --===============4495725180011403267== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEKQ29tbWVudDog VXNpbmcgR251UEcgd2l0aCBUaHVuZGVyYmlyZCAtIGh0dHA6Ly93d3cuZW5pZ21haWwubmV0LwoK aVFDVkF3VUJVc3NvWWo3ZzA0QWp2SVFwQVFMTGNBUUFnS0tQdmx3a2RaaFdSd1JCMmt6emJrOHBD MnlQa3NJegowbHZPcy9OSnZhN3ZDNjBtWXNjRkpUZ0FpR3J3dmFVSGNlajhOUGJZOFFnY0NZcDNG SndnbEJFYlQveFVHMHNICmJrcTIzMWpCZlUrNmJtOE9HRDE0cjk0cVY0c2orbjhXVUR6bEh1d1B4 MGJVWS9tK1NUSys1M0lueTk0TWlhemMKYnkzaXpZNENoQjg9Cj15T2FXCi0tLS0tRU5EIFBHUCBT SUdOQVRVUkUtLS0tLQo= --===============4495725180011403267==-- From N.Rooney@sophiasearch.com Tue Jan 7 13:50:03 2014 From: Niall Rooney To: developers-list@monetdb.org Subject: RE: FW: user defnined function problem Date: Tue, 07 Jan 2014 10:39:03 +0000 Message-ID: <5917c368abb94228b14b3289c5f2e1b4@AMXPR03MB101.eurprd03.prod.outlook.com> In-Reply-To: <52CB285E.4080807@monetdb.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1113300559034568403==" --===============1113300559034568403== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello Stefan, I have 80_udf.mal in .../lib/monetdb5/autoload with the line include udf; but I seem to still have a problem creating a udf function. I tried this simp= le definition: 80_udf.sql create function identInt(val integer) returns double external name udf.identInt; udf.c str UDFidentInt(int * res, int * val) { *res =3D *val ; return MAL_SUCCEED; } udf.h udf_export str UDFidentInt(int * res, int * val); udf.mal command identInt(val:int):int address UDFidentInt comment "return val"; I get the error message: TypeException:user.s2_1[3]:'udf.identint' undefined in: _5:any :=3D udf.ident= int(_4:int) Best Niall -----Original Message----- From: developers-list [mailto:developers-list-bounces+n.rooney=3Dsophiasearch= .com(a)monetdb.org] On Behalf Of Sjoerd Mullender Sent: 06 January 2014 22:04 To: developers-list(a)monetdb.org Subject: Re: FW: user defnined function problem You also need something like 80_udf.mal in .../lib/monetdb5/autoload with the= line include udf; in it. On 2014-01-06 18:46, Niall Rooney wrote: > Hello Stefan, > > I tried doing so on a newly created database but I had the same error messa= ge. > > > -----Original Message----- > From: developers-list > [mailto:developers-list-bounces+n.rooney=3Dsophiasearch.com(a)monetdb.org] > On Behalf Of Stefan Manegold > Sent: 06 January 2014 17:32 > To: Communication channel for developers of the MonetDB suite. > Subject: Re: user defnined function problem > > Hi, > > as all XY_*.sql files that are installed into /monetdb5/createdb/ a= lso 80_udf.sql get only loaded and executed the first time mserver5 is starte= d on a virgin empty (i.e., newly created) DB (then the content is persistentl= y kept in the DB's catalog. > > Thus, to get your newly added funtion working (i.e., added to the SQL catal= og), you either need to create a new database, or execute the SQL commands yo= u added to 80_udf.sql by hand (once) in mclient. > > Best, > Stefan > > ----- Original Message ----- >> >> >> Hello, >> >> >> >> I am making the following adjustment to the user defined function >> template files . >> >> >> >> >> I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >> >> I have added to the following files in the ./sql/backends/monet5/UDF >> directory as shown: >> >> >> >> >> >> 80_udf.sql >> >> >> >> create function sumProb(prob1 double, prob2 double) >> >> returns double external name udf.sumProb; >> >> >> >> udf.mal >> >> >> >> module udf; >> >> >> >> command sumProb(prob1:dbl,prob2:dbl):dbl >> >> address UDFSumProb >> >> comment "sum two probabilities"; >> >> >> >> udf.c >> >> >> >> str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >> >> { >> >> *res =3D *prob1 + *prob2; >> >> return MAL_SUCCEED; >> >> } >> >> >> >> udf.h >> >> >> >> udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >> >> >> >> I did a configure/make/make install and tried the following call in mclien= t: >> >> >> >> declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select >> c=3Djsdistance(a,b); >> >> >> >> and get the error: >> >> >> >> TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D >> udf.sumprob(_8:dbl, _11:dbl) >> >> program contains errors >> >> >> >> >> >> >> >> _______________________________________________ >> developers-list mailing list >> developers-list(a)monetdb.org >> https://www.monetdb.org/mailman/listinfo/developers-list >> > -- Sjoerd Mullender --===============1113300559034568403== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRvciIgY29udGVu dD0iTWljcm9zb2Z0IEV4Y2hhbmdlIFNlcnZlciI+DQo8IS0tIGNvbnZlcnRlZCBmcm9tIHJ0ZiAt LT4NCjxzdHlsZT48IS0tIC5FbWFpbFF1b3RlIHsgbWFyZ2luLWxlZnQ6IDFwdDsgcGFkZGluZy1s ZWZ0OiA0cHQ7IGJvcmRlci1sZWZ0OiAjODAwMDAwIDJweCBzb2xpZDsgfSAtLT48L3N0eWxlPg0K PC9oZWFkPg0KPGJvZHk+DQo8Zm9udCBmYWNlPSJDYWxpYnJpIiBzaXplPSIyIj48c3BhbiBzdHls ZT0iZm9udC1zaXplOjExcHQ7Ij4NCjxkaXY+SGVsbG8gU3RlZmFuLDwvZGl2Pg0KPGRpdj4mbmJz cDs8L2Rpdj4NCjxkaXY+SSBoYXZlIDgwX3VkZi5tYWwgaW4gLi4uL2xpYi9tb25ldGRiNS9hdXRv bG9hZCB3aXRoIHRoZSBsaW5lPC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5pbmNsdWRl IHVkZjs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PmJ1dCBJIHNlZW0gdG8gc3RpbGwg aGF2ZSBhIHByb2JsZW0gY3JlYXRpbmcgYSB1ZGYgZnVuY3Rpb24uIEkgdHJpZWQgdGhpcyBzaW1w bGUgZGVmaW5pdGlvbjo8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PjxiPjgwX3VkZi5z cWw8L2I+PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5jcmVhdGUgZnVuY3Rpb24gaWRl bnRJbnQodmFsIGludGVnZXIpPC9kaXY+DQo8ZGl2PnJldHVybnMgZG91YmxlIGV4dGVybmFsIG5h bWUgdWRmLmlkZW50SW50OzwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+PGI+dWRmLmM8 L2I+PC9kaXY+DQo8ZGl2PnN0ciBVREZpZGVudEludChpbnQgKiByZXMsIGludCAqIHZhbCk8L2Rp dj4NCjxkaXY+ezwvZGl2Pg0KPGRpdj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsgKnJlcyA9Jm5ic3A7ICp2YWwgOzwvZGl2Pg0KPGRpdj4mbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgcmV0dXJuIE1BTF9TVUNDRUVEOzwvZGl2Pg0KPGRp dj59PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj48Yj51ZGYuaDwvYj48L2Rpdj4NCjxk aXY+dWRmX2V4cG9ydCBzdHIgVURGaWRlbnRJbnQoaW50ICogcmVzLCBpbnQgKiB2YWwpOzwvZGl2 Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PjxiPnVkZi48L2I+ PGI+bWFsPC9iPjwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+Y29tbWFuZCBpZGVudElu dCh2YWw6aW50KTppbnQ8L2Rpdj4NCjxkaXY+YWRkcmVzcyBVREZpZGVudEludDwvZGl2Pg0KPGRp dj5jb21tZW50ICZxdW90O3JldHVybiB2YWwmcXVvdDs7PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2 Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+SSBnZXQgdGhlIGVycm9yIG1lc3NhZ2U6PC9kaXY+ DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5UeXBlRXhjZXB0aW9uOnVzZXIuczJfMVszXTondWRm LmlkZW50aW50JyB1bmRlZmluZWQgaW46IF81OmFueSA6PSB1ZGYuaWRlbnRpbnQoXzQ6aW50KTwv ZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+QmVzdDwvZGl2Pg0KPGRpdj5OaWFsbDwvZGl2 Pg0KPGRpdj4tLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLTxicj4NCg0KRnJvbTogZGV2ZWxvcGVy cy1saXN0IFs8YSBocmVmPSJtYWlsdG86ZGV2ZWxvcGVycy1saXN0LWJvdW5jZXMmIzQzO24ucm9v bmV5PXNvcGhpYXNlYXJjaC5jb21AbW9uZXRkYi5vcmciPm1haWx0bzpkZXZlbG9wZXJzLWxpc3Qt Ym91bmNlcyYjNDM7bi5yb29uZXk9c29waGlhc2VhcmNoLmNvbUBtb25ldGRiLm9yZzwvYT5dIE9u IEJlaGFsZiBPZiBTam9lcmQgTXVsbGVuZGVyPGJyPg0KDQpTZW50OiAwNiBKYW51YXJ5IDIwMTQg MjI6MDQ8YnI+DQoNClRvOiBkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmc8YnI+DQoNClN1Ympl Y3Q6IFJlOiBGVzogdXNlciBkZWZuaW5lZCBmdW5jdGlvbiBwcm9ibGVtPC9kaXY+DQo8ZGl2PiZu YnNwOzwvZGl2Pg0KPGRpdj5Zb3UgYWxzbyBuZWVkIHNvbWV0aGluZyBsaWtlIDgwX3VkZi5tYWwg aW4gLi4uL2xpYi9tb25ldGRiNS9hdXRvbG9hZCB3aXRoIHRoZSBsaW5lPC9kaXY+DQo8ZGl2PiZu YnNwOzwvZGl2Pg0KPGRpdj5pbmNsdWRlIHVkZjs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8 ZGl2PmluIGl0LjwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+T24gMjAxNC0wMS0wNiAx ODo0NiwgTmlhbGwgUm9vbmV5IHdyb3RlOjwvZGl2Pg0KPGRpdj4mZ3Q7IEhlbGxvIFN0ZWZhbiw8 L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyBJIHRyaWVkIGRvaW5nIHNvIG9uIGEg bmV3bHkgY3JlYXRlZCBkYXRhYmFzZSBidXQgSSBoYWQgdGhlIHNhbWUgZXJyb3IgbWVzc2FnZS48 L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyAtLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLTwvZGl2Pg0KPGRpdj4mZ3Q7IEZyb206IGRldmVsb3BlcnMt bGlzdCA8L2Rpdj4NCjxkaXY+Jmd0OyBbPGEgaHJlZj0ibWFpbHRvOmRldmVsb3BlcnMtbGlzdC1i b3VuY2VzJiM0MztuLnJvb25leT1zb3BoaWFzZWFyY2guY29tQG1vbmV0ZGIub3JnIj5tYWlsdG86 ZGV2ZWxvcGVycy1saXN0LWJvdW5jZXMmIzQzO24ucm9vbmV5PXNvcGhpYXNlYXJjaC5jb21AbW9u ZXRkYi5vcmc8L2E+XSA8L2Rpdj4NCjxkaXY+Jmd0OyBPbiBCZWhhbGYgT2YgU3RlZmFuIE1hbmVn b2xkPC9kaXY+DQo8ZGl2PiZndDsgU2VudDogMDYgSmFudWFyeSAyMDE0IDE3OjMyPC9kaXY+DQo8 ZGl2PiZndDsgVG86IENvbW11bmljYXRpb24gY2hhbm5lbCBmb3IgZGV2ZWxvcGVycyBvZiB0aGUg TW9uZXREQiBzdWl0ZS48L2Rpdj4NCjxkaXY+Jmd0OyBTdWJqZWN0OiBSZTogdXNlciBkZWZuaW5l ZCBmdW5jdGlvbiBwcm9ibGVtPC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsgSGks PC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsgYXMgYWxsIFhZXyouc3FsIGZpbGVz IHRoYXQgYXJlIGluc3RhbGxlZCBpbnRvICZsdDtMSUJESVImZ3Q7L21vbmV0ZGI1L2NyZWF0ZWRi LyBhbHNvIDgwX3VkZi5zcWwgZ2V0IG9ubHkgbG9hZGVkIGFuZCBleGVjdXRlZCB0aGUgZmlyc3Qg dGltZSBtc2VydmVyNSBpcyBzdGFydGVkIG9uIGEgdmlyZ2luIGVtcHR5IChpLmUuLCBuZXdseSBj cmVhdGVkKSBEQiAodGhlbiB0aGUgY29udGVudCBpcyBwZXJzaXN0ZW50bHkga2VwdCBpbiB0aGUg REIncyBjYXRhbG9nLjwvZGl2Pg0KPGRpdj4mZ3Q7IDwvZGl2Pg0KPGRpdj4mZ3Q7IFRodXMsIHRv IGdldCB5b3VyIG5ld2x5IGFkZGVkIGZ1bnRpb24gd29ya2luZyAoaS5lLiwgYWRkZWQgdG8gdGhl IFNRTCBjYXRhbG9nKSwgeW91IGVpdGhlciBuZWVkIHRvIGNyZWF0ZSBhIG5ldyBkYXRhYmFzZSwg b3IgZXhlY3V0ZSB0aGUgU1FMIGNvbW1hbmRzIHlvdSBhZGRlZCB0byA4MF91ZGYuc3FsIGJ5IGhh bmQgKG9uY2UpIGluIG1jbGllbnQuPC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsg QmVzdCw8L2Rpdj4NCjxkaXY+Jmd0OyBTdGVmYW48L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxk aXY+Jmd0OyAtLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7 PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IEhlbGxvLDwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0Ozwv ZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBJIGFtIG1ha2luZyB0aGUgZm9sbG93aW5nIGFkanVzdG1lbnQg dG8gdGhlIHVzZXIgZGVmaW5lZCBmdW5jdGlvbiA8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgdGVtcGxh dGUgZmlsZXMgLjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyA8L2Rpdj4NCjxkaXY+ Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgSSBhbSB1c2luZyBNb25ldERCLTExLjE1LjE1 IGJ1aWx0IGZyb20gc291cmNlIG9uIFVidW50dSAxMi4wNC48L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDsgSSBoYXZlIGFkZGVkIHRvIHRoZSBmb2xsb3dpbmcgZmlsZXMg aW4gdGhlIC4vc3FsL2JhY2tlbmRzL21vbmV0NS9VREYgPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IGRp cmVjdG9yeSBhcyBzaG93bjo8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+ Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgODBfdWRmLnNxbDwvZGl2Pg0KPGRpdj4mZ3Q7 Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OyBjcmVhdGUgZnVuY3Rpb24gc3VtUHJvYihwcm9iMSBkb3VibGUsIHByb2IyIGRv dWJsZSk8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgcmV0dXJucyBk b3VibGUgZXh0ZXJuYWwgbmFtZSB1ZGYuc3VtUHJvYjs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rp dj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDsgdWRmLm1hbDwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBtb2R1bGUgdWRmOzwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0Ozwv ZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBjb21tYW5kIHN1bVByb2IocHJvYjE6ZGJsLHByb2IyOmRibCk6 ZGJsPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IGFkZHJlc3MgVURG U3VtUHJvYjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBjb21tZW50 ICZxdW90O3N1bSB0d28gcHJvYmFiaWxpdGllcyZxdW90Ozs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgdWRmLmM8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rp dj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgc3RyIFVERlN1bVByb2IoZGJs ICogcmVzLCBkYmwgKiBwcm9iMSwgZGJsICogcHJvYjIpPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7IHs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgKnJlcyA9ICpwcm9iMSAmIzQzOyAqcHJvYjI7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7IHJldHVybiBNQUxfU1VDQ0VFRDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgfTwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyB1ZGYu aDwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4m Z3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyB1ZGZfZXhwb3J0IHN0ciBVREZTdW1Qcm9iKGRi bCAqIHJlcywgZGJsICogcHJvYjEsIGRibCAqIHByb2IyKTs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgSSBkaWQgYSBjb25maWd1cmUvbWFrZS9tYWtlIGluc3RhbGwgYW5kIHRyaWVkIHRoZSBm b2xsb3dpbmcgY2FsbCBpbiBtY2xpZW50OjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBkZWNs YXJlIGEsIGIsYyBkb3VibGU7IHNldCBhPSAwLjE7IHNldCBiPSAwLjI7IHNlbGVjdCA8L2Rpdj4N CjxkaXY+Jmd0OyZndDsgYz1qc2Rpc3RhbmNlKGEsYik7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsm Z3Q7IGFuZCBnZXQgdGhlIGVycm9yOjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4m Z3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBUeXBlRXhj ZXB0aW9uOnVzZXIuczJfMVs4XTondWRmLnN1bXByb2InIHVuZGVmaW5lZCBpbjogXzEyOmFueSA6 PSA8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgdWRmLnN1bXByb2IoXzg6ZGJsLCBfMTE6ZGJsKTwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBwcm9ncmFtIGNvbnRhaW5zIGVy cm9yczwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0 OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OyBkZXZlbG9wZXJzLWxpc3QgbWFpbGluZyBsaXN0PC9kaXY+DQo8ZGl2PiZn dDsmZ3Q7IDxhIGhyZWY9Im1haWx0bzpkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmciPmRldmVs b3BlcnMtbGlzdEBtb25ldGRiLm9yZzwvYT48L2Rpdj4NCjxkaXY+Jmd0OyZndDsgPGEgaHJlZj0i aHR0cHM6Ly93d3cubW9uZXRkYi5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXZlbG9wZXJzLWxpc3Qi Pmh0dHBzOi8vd3d3Lm1vbmV0ZGIub3JnL21haWxtYW4vbGlzdGluZm8vZGV2ZWxvcGVycy1saXN0 PC9hPjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7IDwvZGl2Pg0KPGRpdj4m bmJzcDs8L2Rpdj4NCjxkaXY+LS08L2Rpdj4NCjxkaXY+U2pvZXJkIE11bGxlbmRlcjwvZGl2Pg0K PGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8L3NwYW4+PC9mb250Pg0KPC9i b2R5Pg0KPC9odG1sPg0K --===============1113300559034568403==-- From N.Rooney@sophiasearch.com Tue Jan 7 13:55:57 2014 From: Niall Rooney To: developers-list@monetdb.org Subject: FW: FW: user defnined function problem Date: Tue, 07 Jan 2014 11:05:51 +0000 Message-ID: In-Reply-To: <52CB285E.4080807@monetdb.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7838619454835689990==" --===============7838619454835689990== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable _____________________________________________ From: Niall Rooney Sent: 07 January 2014 10:39 To: 'Communication channel for developers of the MonetDB suite.' Subject: RE: FW: user defnined function problem Hello Sjoerd I have 80_udf.mal in .../lib/monetdb5/autoload with the line include udf; but I seem to still have a problem creating a udf function. I tried this simp= le definition: 80_udf.sql create function identInt(val integer) returns double external name udf.identInt; udf.c str UDFidentInt(int * res, int * val) { *res =3D *val ; return MAL_SUCCEED; } udf.h udf_export str UDFidentInt(int * res, int * val); udf.mal command identInt(val:int):int address UDFidentInt comment "return val"; I get the error message: TypeException:user.s2_1[3]:'udf.identint' undefined in: _5:any :=3D udf.ident= int(_4:int) Best Niall -----Original Message----- From: developers-list [mailto:developers-list-bounces+n.rooney=3Dsophiasearch= .com(a)monetdb.org] On Behalf Of Sjoerd Mullender Sent: 06 January 2014 22:04 To: developers-list(a)monetdb.org Subject: Re: FW: user defnined function problem You also need something like 80_udf.mal in .../lib/monetdb5/autoload with the= line include udf; in it. On 2014-01-06 18:46, Niall Rooney wrote: > Hello Stefan, > > I tried doing so on a newly created database but I had the same error messa= ge. > > > -----Original Message----- > From: developers-list > [mailto:developers-list-bounces+n.rooney=3Dsophiasearch.com(a)monetdb.org] > On Behalf Of Stefan Manegold > Sent: 06 January 2014 17:32 > To: Communication channel for developers of the MonetDB suite. > Subject: Re: user defnined function problem > > Hi, > > as all XY_*.sql files that are installed into /monetdb5/createdb/ a= lso 80_udf.sql get only loaded and executed the first time mserver5 is starte= d on a virgin empty (i.e., newly created) DB (then the content is persistentl= y kept in the DB's catalog. > > Thus, to get your newly added funtion working (i.e., added to the SQL catal= og), you either need to create a new database, or execute the SQL commands yo= u added to 80_udf.sql by hand (once) in mclient. > > Best, > Stefan > > ----- Original Message ----- >> >> >> Hello, >> >> >> >> I am making the following adjustment to the user defined function >> template files . >> >> >> >> >> I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >> >> I have added to the following files in the ./sql/backends/monet5/UDF >> directory as shown: >> >> >> >> >> >> 80_udf.sql >> >> >> >> create function sumProb(prob1 double, prob2 double) >> >> returns double external name udf.sumProb; >> >> >> >> udf.mal >> >> >> >> module udf; >> >> >> >> command sumProb(prob1:dbl,prob2:dbl):dbl >> >> address UDFSumProb >> >> comment "sum two probabilities"; >> >> >> >> udf.c >> >> >> >> str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >> >> { >> >> *res =3D *prob1 + *prob2; >> >> return MAL_SUCCEED; >> >> } >> >> >> >> udf.h >> >> >> >> udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >> >> >> >> I did a configure/make/make install and tried the following call in mclien= t: >> >> >> >> declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select >> c=3Djsdistance(a,b); >> >> >> >> and get the error: >> >> >> >> TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D >> udf.sumprob(_8:dbl, _11:dbl) >> >> program contains errors >> >> >> >> >> >> >> >> _______________________________________________ >> developers-list mailing list >> developers-list(a)monetdb.org >> https://www.monetdb.org/mailman/listinfo/developers-list >> > -- Sjoerd Mullender --===============7838619454835689990== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRvciIgY29udGVu dD0iTWljcm9zb2Z0IEV4Y2hhbmdlIFNlcnZlciI+DQo8IS0tIGNvbnZlcnRlZCBmcm9tIHJ0ZiAt LT4NCjxzdHlsZT48IS0tIC5FbWFpbFF1b3RlIHsgbWFyZ2luLWxlZnQ6IDFwdDsgcGFkZGluZy1s ZWZ0OiA0cHQ7IGJvcmRlci1sZWZ0OiAjODAwMDAwIDJweCBzb2xpZDsgfSAtLT48L3N0eWxlPg0K PC9oZWFkPg0KPGJvZHk+DQo8Zm9udCBmYWNlPSJDYWxpYnJpIiBzaXplPSIyIj48c3BhbiBzdHls ZT0iZm9udC1zaXplOjExcHQ7Ij4NCjxkaXY+PGZvbnQgY29sb3I9IiMxRjQ5N0QiPiZuYnNwOzwv Zm9udD48L2Rpdj4NCjxkaXY+PGZvbnQgY29sb3I9IiMxRjQ5N0QiPiZuYnNwOzwvZm9udD48L2Rp dj4NCjxkaXY+PGZvbnQgZmFjZT0iVGFob21hIiBzaXplPSIyIj48c3BhbiBzdHlsZT0iZm9udC1z aXplOjEwcHQ7Ij5fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX188 YnI+DQoNCjxiPkZyb206PC9iPiBOaWFsbCBSb29uZXkgPGJyPg0KDQo8Yj5TZW50OjwvYj4gMDcg SmFudWFyeSAyMDE0IDEwOjM5PGJyPg0KDQo8Yj5Ubzo8L2I+ICdDb21tdW5pY2F0aW9uIGNoYW5u ZWwgZm9yIGRldmVsb3BlcnMgb2YgdGhlIE1vbmV0REIgc3VpdGUuJzxicj4NCg0KPGI+U3ViamVj dDo8L2I+IFJFOiBGVzogdXNlciBkZWZuaW5lZCBmdW5jdGlvbiBwcm9ibGVtPC9zcGFuPjwvZm9u dD48L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2Pjxmb250IGNvbG9yPSIjMUY0OTdEIj5I ZWxsbyA8Zm9udCBjb2xvcj0iYmxhY2siPlNqb2VyZCA8L2ZvbnQ+PC9mb250PjwvZGl2Pg0KPGRp dj4mbmJzcDs8L2Rpdj4NCjxkaXY+SSBoYXZlIDgwX3VkZi5tYWwgaW4gLi4uL2xpYi9tb25ldGRi NS9hdXRvbG9hZCB3aXRoIHRoZSBsaW5lPC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5p bmNsdWRlIHVkZjs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PmJ1dCBJIHNlZW0gdG8g c3RpbGwgaGF2ZSBhIHByb2JsZW0gY3JlYXRpbmcgYSB1ZGYgZnVuY3Rpb24uIEkgdHJpZWQgdGhp cyBzaW1wbGUgZGVmaW5pdGlvbjo8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PjxiPjgw X3VkZi5zcWw8L2I+PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5jcmVhdGUgZnVuY3Rp b24gaWRlbnRJbnQodmFsIGludGVnZXIpPC9kaXY+DQo8ZGl2PnJldHVybnMgZG91YmxlIGV4dGVy bmFsIG5hbWUgdWRmLmlkZW50SW50OzwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+PGI+ dWRmLmM8L2I+PC9kaXY+DQo8ZGl2PnN0ciBVREZpZGVudEludChpbnQgKiByZXMsIGludCAqIHZh bCk8L2Rpdj4NCjxkaXY+ezwvZGl2Pg0KPGRpdj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsgKnJlcyA9Jm5ic3A7ICp2YWwgOzwvZGl2Pg0KPGRpdj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgcmV0dXJuIE1BTF9TVUNDRUVEOzwvZGl2 Pg0KPGRpdj59PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj48Yj51ZGYuaDwvYj48L2Rp dj4NCjxkaXY+dWRmX2V4cG9ydCBzdHIgVURGaWRlbnRJbnQoaW50ICogcmVzLCBpbnQgKiB2YWwp OzwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PjxiPnVk Zi5tYWw8L2I+PC9kaXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5jb21tYW5kIGlkZW50SW50 KHZhbDppbnQpOmludDwvZGl2Pg0KPGRpdj5hZGRyZXNzIFVERmlkZW50SW50PC9kaXY+DQo8ZGl2 PmNvbW1lbnQgJnF1b3Q7cmV0dXJuIHZhbCZxdW90Ozs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+ DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5JIGdldCB0aGUgZXJyb3IgbWVzc2FnZTo8L2Rpdj4N CjxkaXY+Jm5ic3A7PC9kaXY+DQo8ZGl2PlR5cGVFeGNlcHRpb246dXNlci5zMl8xWzNdOid1ZGYu aWRlbnRpbnQnIHVuZGVmaW5lZCBpbjogXzU6YW55IDo9IHVkZi5pZGVudGludChfNDppbnQpPC9k aXY+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPGRpdj5CZXN0PC9kaXY+DQo8ZGl2Pk5pYWxsPC9kaXY+ DQo8ZGl2Pi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tPGJyPg0KDQpGcm9tOiBkZXZlbG9wZXJz LWxpc3QgWzxhIGhyZWY9Im1haWx0bzpkZXZlbG9wZXJzLWxpc3QtYm91bmNlcyYjNDM7bi5yb29u ZXk9c29waGlhc2VhcmNoLmNvbUBtb25ldGRiLm9yZyI+PGZvbnQgY29sb3I9ImJsdWUiPjx1Pm1h aWx0bzpkZXZlbG9wZXJzLWxpc3QtYm91bmNlcyYjNDM7bi5yb29uZXk9c29waGlhc2VhcmNoLmNv bUBtb25ldGRiLm9yZzwvdT48L2ZvbnQ+PC9hPl0gT24gQmVoYWxmIE9mIFNqb2VyZCBNdWxsZW5k ZXI8YnI+DQoNClNlbnQ6IDA2IEphbnVhcnkgMjAxNCAyMjowNDxicj4NCg0KVG86IDxhIGhyZWY9 Im1haWx0bzpkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmciPjxmb250IGNvbG9yPSJibHVlIj48 dT5kZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmc8L3U+PC9mb250PjwvYT48YnI+DQoNClN1Ympl Y3Q6IFJlOiBGVzogdXNlciBkZWZuaW5lZCBmdW5jdGlvbiBwcm9ibGVtPC9kaXY+DQo8ZGl2PiZu YnNwOzwvZGl2Pg0KPGRpdj5Zb3UgYWxzbyBuZWVkIHNvbWV0aGluZyBsaWtlIDgwX3VkZi5tYWwg aW4gLi4uL2xpYi9tb25ldGRiNS9hdXRvbG9hZCB3aXRoIHRoZSBsaW5lPC9kaXY+DQo8ZGl2PiZu YnNwOzwvZGl2Pg0KPGRpdj5pbmNsdWRlIHVkZjs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8 ZGl2PmluIGl0LjwvZGl2Pg0KPGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+T24gMjAxNC0wMS0wNiAx ODo0NiwgTmlhbGwgUm9vbmV5IHdyb3RlOjwvZGl2Pg0KPGRpdj4mZ3Q7IEhlbGxvIFN0ZWZhbiw8 L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyBJIHRyaWVkIGRvaW5nIHNvIG9uIGEg bmV3bHkgY3JlYXRlZCBkYXRhYmFzZSBidXQgSSBoYWQgdGhlIHNhbWUgZXJyb3IgbWVzc2FnZS48 L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxkaXY+Jmd0OyAtLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLTwvZGl2Pg0KPGRpdj4mZ3Q7IEZyb206IGRldmVsb3BlcnMt bGlzdCA8L2Rpdj4NCjxkaXY+Jmd0OyBbPGEgaHJlZj0ibWFpbHRvOmRldmVsb3BlcnMtbGlzdC1i b3VuY2VzJiM0MztuLnJvb25leT1zb3BoaWFzZWFyY2guY29tQG1vbmV0ZGIub3JnIj5tYWlsdG86 ZGV2ZWxvcGVycy1saXN0LWJvdW5jZXMmIzQzO24ucm9vbmV5PXNvcGhpYXNlYXJjaC5jb21AbW9u ZXRkYi5vcmc8L2E+XSA8L2Rpdj4NCjxkaXY+Jmd0OyBPbiBCZWhhbGYgT2YgU3RlZmFuIE1hbmVn b2xkPC9kaXY+DQo8ZGl2PiZndDsgU2VudDogMDYgSmFudWFyeSAyMDE0IDE3OjMyPC9kaXY+DQo8 ZGl2PiZndDsgVG86IENvbW11bmljYXRpb24gY2hhbm5lbCBmb3IgZGV2ZWxvcGVycyBvZiB0aGUg TW9uZXREQiBzdWl0ZS48L2Rpdj4NCjxkaXY+Jmd0OyBTdWJqZWN0OiBSZTogdXNlciBkZWZuaW5l ZCBmdW5jdGlvbiBwcm9ibGVtPC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsgSGks PC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsgYXMgYWxsIFhZXyouc3FsIGZpbGVz IHRoYXQgYXJlIGluc3RhbGxlZCBpbnRvICZsdDtMSUJESVImZ3Q7L21vbmV0ZGI1L2NyZWF0ZWRi LyBhbHNvIDgwX3VkZi5zcWwgZ2V0IG9ubHkgbG9hZGVkIGFuZCBleGVjdXRlZCB0aGUgZmlyc3Qg dGltZSBtc2VydmVyNSBpcyBzdGFydGVkIG9uIGEgdmlyZ2luIGVtcHR5IChpLmUuLCBuZXdseSBj cmVhdGVkKSBEQiAodGhlbiB0aGUgY29udGVudCBpcyBwZXJzaXN0ZW50bHkga2VwdCBpbiB0aGUg REIncyBjYXRhbG9nLjwvZGl2Pg0KPGRpdj4mZ3Q7IDwvZGl2Pg0KPGRpdj4mZ3Q7IFRodXMsIHRv IGdldCB5b3VyIG5ld2x5IGFkZGVkIGZ1bnRpb24gd29ya2luZyAoaS5lLiwgYWRkZWQgdG8gdGhl IFNRTCBjYXRhbG9nKSwgeW91IGVpdGhlciBuZWVkIHRvIGNyZWF0ZSBhIG5ldyBkYXRhYmFzZSwg b3IgZXhlY3V0ZSB0aGUgU1FMIGNvbW1hbmRzIHlvdSBhZGRlZCB0byA4MF91ZGYuc3FsIGJ5IGhh bmQgKG9uY2UpIGluIG1jbGllbnQuPC9kaXY+DQo8ZGl2PiZndDsgPC9kaXY+DQo8ZGl2PiZndDsg QmVzdCw8L2Rpdj4NCjxkaXY+Jmd0OyBTdGVmYW48L2Rpdj4NCjxkaXY+Jmd0OyA8L2Rpdj4NCjxk aXY+Jmd0OyAtLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7 PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IEhlbGxvLDwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0Ozwv ZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBJIGFtIG1ha2luZyB0aGUgZm9sbG93aW5nIGFkanVzdG1lbnQg dG8gdGhlIHVzZXIgZGVmaW5lZCBmdW5jdGlvbiA8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgdGVtcGxh dGUgZmlsZXMgLjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyA8L2Rpdj4NCjxkaXY+ Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgSSBhbSB1c2luZyBNb25ldERCLTExLjE1LjE1 IGJ1aWx0IGZyb20gc291cmNlIG9uIFVidW50dSAxMi4wNC48L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDsgSSBoYXZlIGFkZGVkIHRvIHRoZSBmb2xsb3dpbmcgZmlsZXMg aW4gdGhlIC4vc3FsL2JhY2tlbmRzL21vbmV0NS9VREYgPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IGRp cmVjdG9yeSBhcyBzaG93bjo8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+ Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgODBfdWRmLnNxbDwvZGl2Pg0KPGRpdj4mZ3Q7 Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OyBjcmVhdGUgZnVuY3Rpb24gc3VtUHJvYihwcm9iMSBkb3VibGUsIHByb2IyIGRv dWJsZSk8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgcmV0dXJucyBk b3VibGUgZXh0ZXJuYWwgbmFtZSB1ZGYuc3VtUHJvYjs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rp dj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDsgdWRmLm1hbDwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBtb2R1bGUgdWRmOzwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0Ozwv ZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBjb21tYW5kIHN1bVByb2IocHJvYjE6ZGJsLHByb2IyOmRibCk6 ZGJsPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7IGFkZHJlc3MgVURG U3VtUHJvYjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBjb21tZW50 ICZxdW90O3N1bSB0d28gcHJvYmFiaWxpdGllcyZxdW90Ozs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgdWRmLmM8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rp dj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgc3RyIFVERlN1bVByb2IoZGJs ICogcmVzLCBkYmwgKiBwcm9iMSwgZGJsICogcHJvYjIpPC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7IHs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgKnJlcyA9ICpwcm9iMSAmIzQzOyAqcHJvYjI7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7IHJldHVybiBNQUxfU1VDQ0VFRDs8L2Rpdj4NCjxkaXY+Jmd0OyZn dDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgfTwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyB1ZGYu aDwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4m Z3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyB1ZGZfZXhwb3J0IHN0ciBVREZTdW1Qcm9iKGRi bCAqIHJlcywgZGJsICogcHJvYjEsIGRibCAqIHByb2IyKTs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8 L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0OyZndDs8L2Rpdj4NCjxkaXY+Jmd0 OyZndDsgSSBkaWQgYSBjb25maWd1cmUvbWFrZS9tYWtlIGluc3RhbGwgYW5kIHRyaWVkIHRoZSBm b2xsb3dpbmcgY2FsbCBpbiBtY2xpZW50OjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBkZWNs YXJlIGEsIGIsYyBkb3VibGU7IHNldCBhPSAwLjE7IHNldCBiPSAwLjI7IHNlbGVjdCA8L2Rpdj4N CjxkaXY+Jmd0OyZndDsgYz1qc2Rpc3RhbmNlKGEsYik7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9k aXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsmZ3Q7PC9kaXY+DQo8ZGl2PiZndDsm Z3Q7IGFuZCBnZXQgdGhlIGVycm9yOjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4m Z3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBUeXBlRXhj ZXB0aW9uOnVzZXIuczJfMVs4XTondWRmLnN1bXByb2InIHVuZGVmaW5lZCBpbjogXzEyOmFueSA6 PSA8L2Rpdj4NCjxkaXY+Jmd0OyZndDsgdWRmLnN1bXByb2IoXzg6ZGJsLCBfMTE6ZGJsKTwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OyBwcm9ncmFtIGNvbnRhaW5zIGVy cm9yczwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRp dj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2 Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0 OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzwvZGl2Pg0K PGRpdj4mZ3Q7Jmd0OyBkZXZlbG9wZXJzLWxpc3QgbWFpbGluZyBsaXN0PC9kaXY+DQo8ZGl2PiZn dDsmZ3Q7IDxhIGhyZWY9Im1haWx0bzpkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmciPmRldmVs b3BlcnMtbGlzdEBtb25ldGRiLm9yZzwvYT48L2Rpdj4NCjxkaXY+Jmd0OyZndDsgPGEgaHJlZj0i aHR0cHM6Ly93d3cubW9uZXRkYi5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXZlbG9wZXJzLWxpc3Qi Pmh0dHBzOi8vd3d3Lm1vbmV0ZGIub3JnL21haWxtYW4vbGlzdGluZm8vZGV2ZWxvcGVycy1saXN0 PC9hPjwvZGl2Pg0KPGRpdj4mZ3Q7Jmd0OzwvZGl2Pg0KPGRpdj4mZ3Q7IDwvZGl2Pg0KPGRpdj4m bmJzcDs8L2Rpdj4NCjxkaXY+LS08L2Rpdj4NCjxkaXY+U2pvZXJkIE11bGxlbmRlcjwvZGl2Pg0K PGRpdj4mbmJzcDs8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8L3NwYW4+PC9mb250Pg0KPC9i b2R5Pg0KPC9odG1sPg0K --===============7838619454835689990==-- From sjoerd@monetdb.org Tue Jan 7 14:03:16 2014 From: Sjoerd Mullender To: developers-list@monetdb.org Subject: Re: FW: FW: user defnined function problem Date: Tue, 07 Jan 2014 14:03:11 +0100 Message-ID: <52CBFB0F.7050400@monetdb.org> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2738760686719796499==" --===============2738760686719796499== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On 2014-01-07 12:05, Niall Rooney wrote: > =20 > =20 > _____________________________________________ > *From:* Niall Rooney > *Sent:* 07 January 2014 10:39 > *To:* 'Communication channel for developers of the MonetDB suite.' > *Subject:* RE: FW: user defnined function problem > =20 > Hello Sjoerd > =20 > I have 80_udf.mal in .../lib/monetdb5/autoload with the line > =20 > include udf; > =20 > but I seem to still have a problem creating a udf function. I tried this > simple definition: > =20 > *80_udf.sql* > =20 > create function identInt(val integer) > returns double external name udf.identInt; You need to quote identInt, otherwise the case gets folded to all lowercase: ... name udf."identInt"; > =20 > *udf.c* > str UDFidentInt(int * res, int * val) > { > *res =3D *val ; > return MAL_SUCCEED; > } > =20 > *udf.h* > udf_export str UDFidentInt(int * res, int * val); > =20 > =20 > *udf.mal* > =20 > command identInt(val:int):int > address UDFidentInt > comment "return val"; > =20 > =20 > I get the error message: > =20 > TypeException:user.s2_1[3]:'udf.identint' undefined in: _5:any :=3D > udf.identint(_4:int) > =20 > Best > Niall > -----Original Message----- > From: developers-list > [_mailto:developers-list-bounces+n.rooney=3Dsophiasearch.com(a)monetdb.org_] > On Behalf Of Sjoerd Mullender > Sent: 06 January 2014 22:04 > To: _developers-list(a)monetdb.org_ > Subject: Re: FW: user defnined function problem > =20 > You also need something like 80_udf.mal in .../lib/monetdb5/autoload > with the line > =20 > include udf; > =20 > in it. > =20 > On 2014-01-06 18:46, Niall Rooney wrote: >> Hello Stefan, >>=20 >> I tried doing so on a newly created database but I had the same error mess= age. >>=20 >>=20 >> -----Original Message----- >> From: developers-list=20 >> [mailto:developers-list-bounces+n.rooney=3Dsophiasearch.com(a)monetdb.org] >> On Behalf Of Stefan Manegold >> Sent: 06 January 2014 17:32 >> To: Communication channel for developers of the MonetDB suite. >> Subject: Re: user defnined function problem >>=20 >> Hi, >>=20 >> as all XY_*.sql files that are installed into /monetdb5/createdb/ = also 80_udf.sql get only loaded and executed the first time mserver5 is start= ed on a virgin empty (i.e., newly created) DB (then the content is persistent= ly kept in the DB's catalog. >>=20 >> Thus, to get your newly added funtion working (i.e., added to the SQL cata= log), you either need to create a new database, or execute the SQL commands y= ou added to 80_udf.sql by hand (once) in mclient. >>=20 >> Best, >> Stefan >>=20 >> ----- Original Message ----- >>> >>> >>> Hello, >>> >>> >>> >>> I am making the following adjustment to the user defined function=20 >>> template files . >>> >>> >>> =20 >>> >>> I am using MonetDB-11.15.15 built from source on Ubuntu 12.04. >>> >>> I have added to the following files in the ./sql/backends/monet5/UDF=20 >>> directory as shown: >>> >>> >>> >>> >>> >>> 80_udf.sql >>> >>> >>> >>> create function sumProb(prob1 double, prob2 double) >>> >>> returns double external name udf.sumProb; >>> >>> >>> >>> udf.mal >>> >>> >>> >>> module udf; >>> >>> >>> >>> command sumProb(prob1:dbl,prob2:dbl):dbl >>> >>> address UDFSumProb >>> >>> comment "sum two probabilities"; >>> >>> >>> >>> udf.c >>> >>> >>> >>> str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2) >>> >>> { >>> >>> *res =3D *prob1 + *prob2; >>> >>> return MAL_SUCCEED; >>> >>> } >>> >>> >>> >>> udf.h >>> >>> >>> >>> udf_export str UDFSumProb(dbl * res, dbl * prob1, dbl * prob2); >>> >>> >>> >>> I did a configure/make/make install and tried the following call in mclie= nt: >>> >>> >>> >>> declare a, b,c double; set a=3D 0.1; set b=3D 0.2; select=20 >>> c=3Djsdistance(a,b); >>> >>> >>> >>> and get the error: >>> >>> >>> >>> TypeException:user.s2_1[8]:'udf.sumprob' undefined in: _12:any :=3D=20 >>> udf.sumprob(_8:dbl, _11:dbl) >>> >>> program contains errors >>> >>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> developers-list mailing list >>> developers-list(a)monetdb.org >>> https://www.monetdb.org/mailman/listinfo/developers-list >>> >>=20 > =20 > -- > Sjoerd Mullender > =20 > =20 >=20 >=20 > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list >=20 --=20 Sjoerd Mullender --===============2738760686719796499== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEuNC4xNSAoR05V L0xpbnV4KQpDb21tZW50OiBVc2luZyBHbnVQRyB3aXRoIFRodW5kZXJiaXJkIC0gaHR0cDovL3d3 dy5lbmlnbWFpbC5uZXQvCgppUUNWQXdVQlVzdjdFejdnMDRBanZJUXBBUUtUbEFQK0wreVUrOWJr MDVpK3R1YzZPeEZQUGhtcnlNbm1Gekt5Ck1hc0VNMm4xalZBUmtxci9HR0lmMkhMbVhRWXFRN0J1 V3d4K3ZKNWJMZ0lGSzZ0Q21OY21aN1pxQW9TUk1LZHcKVTBoaS9jK0tIRHdkMTMrbEhxdkJFcXdw Y2pEMkVGekZYWllCcnA0ZDNZemZ3bGFEY2RZc0RlQXkzQkFGVCtzYgpTV3VqamkvMDhldz0KPVl6 WGkKLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0tCg== --===============2738760686719796499==-- From shura.shestakov@gmail.com Tue Jan 14 12:12:42 2014 From: Alexander Shestakov To: developers-list@monetdb.org Subject: Segmentation fault on a query from table expression Date: Tue, 14 Jan 2014 11:12:40 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7851777061371323624==" --===============7851777061371323624== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Hi, I am running MonetDB Database Server Toolkit v1.1 (Feb2013-SP6) , I have a table DailyData defined as follows. create table DailyData ( sym varchar(32), businessdate date, closePrice float, adjustedClosePrice float, openingPrice float, accVol float, unique(businessdate, sym) ); I make the following query. with dd as (select * from DailyData where businessdate > '2013-06-01'), r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / y.adjustedcloseprice as ret from dd t left outer join dd y on t.businessdate = y.businessdate + (interval '1' day) and t.sym = y.sym), v as (select sym, stddev_samp(ret) as volatility from r group by sym) select * from v where v.sym like '%.L' limit 100; It results in a segmentation fault: Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7f5f17023700 (LWP 25178)] 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 (gdb) where #0 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 #1 0x00007f6f2d4ef6f8 in rel_use_index (changes=, sql=0x7f5f08005470, rel=0x7f5f0850aa70) at rel_optimizer.c:4829 #2 0x00007f6f2d4ea225 in rewrite (sql=0x7f5f08005470, rel=0x7f5f0850aa70, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6106 #3 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f0850cb40, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #4 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f0850ec30, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #5 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f0850ef50, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #6 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f08512a90, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #7 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f0850feb0, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #8 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, rel=0x7f5f085101c0, rewriter=0x7f6f2d4ef610 , has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 #9 0x00007f6f2d4ecf58 in _rel_optimizer (sql=0x7f5f08005470, rel=, level=0) at rel_optimizer.c:6278 #10 0x00007f6f2d484369 in sql_symbol2relation (c=0x7f5f08005470, sym=) at sql.mx:1755 #11 0x00007f6f2d454b2f in SQLparser (c=0x7f6f2df49308) at sql_scenario.c:1708 #12 0x00007f6f352ecdd3 in runPhase (c=0x7f6f2df49308) at mal_scenario.c:522 #13 runScenarioBody (c=0x7f6f2df49308) at mal_scenario.c:558 #14 0x00007f6f352ecf1f in runScenario (c=0x7f6f2df49308) at mal_scenario.c:586 #15 0x00007f6f352ed778 in MSserveClient (dummy=0x7f6f2df49308) at mal_session.c:446 #16 0x0000003ee9a07851 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003ee92e890d in clone () from /lib64/libc.so.6 Apparently at rel_optimizer.c:4829 strcmp(exp_relname(nre) returns NULL which is not checked. If I rewrite the query in the following way it works if not very fast. with r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / y.adjustedcloseprice as ret from DailyData t left outer join DailyData y on t.businessdate = y.businessdate + (interval '1' day) and t.sym = y.sym where t.businessdate > '2013-06-01'), v as (select sym, stddev_samp(ret) as volatility from r group by sym) select * from v where v.sym like '%.L' limit 100; Regards, Alex Shestakov. --===============7851777061371323624== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWwsc2Fucy1zZXJpZjtm b250LXNpemU6MTNweCI+PGRpdj5IaSw8L2Rpdj48ZGl2PkkgYW0gcnVubmluZ6BNb25ldERCIERh dGFiYXNlIFNlcnZlciBUb29sa2l0IHYxLjEgKEZlYjIwMTMtU1A2KSAsPC9kaXY+PGRpdj48YnI+ PC9kaXY+PGRpdj5JIGhhdmUgYSB0YWJsZSBEYWlseURhdGEgZGVmaW5lZCBhcyBmb2xsb3dzLjwv ZGl2Pgo8ZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Y3JlYXRlIHRhYmxlIERhaWx5RGF0YSAoPC9k aXY+PGRpdj5zeW0gdmFyY2hhcigzMiksPC9kaXY+PGRpdj5idXNpbmVzc2RhdGUgZGF0ZSw8L2Rp dj48ZGl2PmNsb3NlUHJpY2UgZmxvYXQsPC9kaXY+PGRpdj5hZGp1c3RlZENsb3NlUHJpY2UgZmxv YXQsPC9kaXY+PGRpdj5vcGVuaW5nUHJpY2UgZmxvYXQsPC9kaXY+PGRpdj5hY2NWb2wgZmxvYXQs PC9kaXY+CjxkaXY+dW5pcXVlKGJ1c2luZXNzZGF0ZSwgc3ltKTwvZGl2PjxkaXY+KTs8L2Rpdj48 L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkkgbWFrZSB0aGUgZm9sbG93 aW5nIHF1ZXJ5LjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdj53aXRoIGRkIGFzIChzZWxl Y3QgKiBmcm9tIERhaWx5RGF0YSB3aGVyZSBidXNpbmVzc2RhdGUgJmd0OyAmIzM5OzIwMTMtMDYt MDEmIzM5OyksPC9kaXY+CjxkaXY+ciBhcyAoc2VsZWN0IHQuYnVzaW5lc3NkYXRlLCB0LnN5bSwg MSAtIHQuYWRqdXN0ZWRjbG9zZXByaWNlIC8geS5hZGp1c3RlZGNsb3NlcHJpY2UgYXMgcmV0IGZy b20gZGQgdDwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZS13cmFwIj4JPC9z cGFuPmxlZnQgb3V0ZXIgam9pbiBkZCB5IG9uIHQuYnVzaW5lc3NkYXRlID0geS5idXNpbmVzc2Rh dGUgKyAoaW50ZXJ2YWwgJiMzOTsxJiMzOTsgZGF5KSBhbmQgdC5zeW0gPSB5LnN5bSksPC9kaXY+ CjxkaXY+diBhcyAoc2VsZWN0IHN5bSwgc3RkZGV2X3NhbXAocmV0KSBhcyB2b2xhdGlsaXR5IGZy b20gciBncm91cCBieSBzeW0pPC9kaXY+PGRpdj5zZWxlY3QgKiBmcm9tIHYgd2hlcmUgdi5zeW0g bGlrZSAmIzM5OyUuTCYjMzk7IGxpbWl0IDEwMDs8L2Rpdj48L2Rpdj48L2Rpdj48ZGl2IHN0eWxl PSJmb250LWZhbWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxM3B4Ij48YnI+CjwvZGl2 PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLHNhbnMtc2VyaWY7Zm9udC1zaXplOjEzcHgi Pjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQt c2l6ZToxM3B4Ij5JdCByZXN1bHRzIGluIGEgc2VnbWVudGF0aW9uIGZhdWx0OjwvZGl2PjxkaXYg c3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLHNhbnMtc2VyaWY7Zm9udC1zaXplOjEzcHgiPgo8ZGl2 Pjxicj48L2Rpdj48ZGl2PlByb2dyYW0gcmVjZWl2ZWQgc2lnbmFsIFNJR1NFR1YsIFNlZ21lbnRh dGlvbiBmYXVsdC48L2Rpdj48ZGl2PltTd2l0Y2hpbmcgdG8gVGhyZWFkIDB4N2Y1ZjE3MDIzNzAw IChMV1AgMjUxNzgpXTwvZGl2PjxkaXY+MHgwMDAwMDAzZWU5MzI3YTlhIGluIF9fc3RyY21wX3Nz ZTQyICgpIGZyb20gL2xpYjY0L2xpYmMuc28uNjwvZGl2PjxkaXY+KGdkYikgd2hlcmU8L2Rpdj4K PGRpdj4jMCCgMHgwMDAwMDAzZWU5MzI3YTlhIGluIF9fc3RyY21wX3NzZTQyICgpIGZyb20gL2xp YjY0L2xpYmMuc28uNjwvZGl2PjxkaXY+IzEgoDB4MDAwMDdmNmYyZDRlZjZmOCBpbiByZWxfdXNl X2luZGV4IChjaGFuZ2VzPSZsdDt2YWx1ZSBvcHRpbWl6ZWQgb3V0Jmd0Oywgc3FsPTB4N2Y1ZjA4 MDA1NDcwLCByZWw9MHg3ZjVmMDg1MGFhNzApIGF0IHJlbF9vcHRpbWl6ZXIuYzo0ODI5PC9kaXY+ CjxkaXY+IzIgoDB4MDAwMDdmNmYyZDRlYTIyNSBpbiByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0 NzAsIHJlbD0weDdmNWYwODUwYWE3MCwgcmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91 c2VfaW5kZXgmZ3Q7LCBoYXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXpl ci5jOjYxMDY8L2Rpdj48ZGl2PiMzIKAweDAwMDA3ZjZmMmQ0ZWEyYmMgaW4gcmV3cml0ZSAoc3Fs PTB4N2Y1ZjA4MDA1NDcwLCByZWw9MHg3ZjVmMDg1MGNiNDAsIHJld3JpdGVyPTB4N2Y2ZjJkNGVm NjEwICZsdDtyZWxfdXNlX2luZGV4Jmd0OywgaGFzX2NoYW5nZXM9MHg3ZjVmMTcwMjJjYWMpIGF0 IHJlbF9vcHRpbWl6ZXIuYzo2MDkzPC9kaXY+CjxkaXY+IzQgoDB4MDAwMDdmNmYyZDRlYTJiYyBp biByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsIHJlbD0weDdmNWYwODUwZWMzMCwgcmV3cml0 ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LCBoYXNfY2hhbmdlcz0weDdm NWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYwOTM8L2Rpdj48ZGl2PiM1IKAweDAwMDA3 ZjZmMmQ0ZWEyYmMgaW4gcmV3cml0ZSAoc3FsPTB4N2Y1ZjA4MDA1NDcwLCByZWw9MHg3ZjVmMDg1 MGVmNTAsIHJld3JpdGVyPTB4N2Y2ZjJkNGVmNjEwICZsdDtyZWxfdXNlX2luZGV4Jmd0OywgaGFz X2NoYW5nZXM9MHg3ZjVmMTcwMjJjYWMpIGF0IHJlbF9vcHRpbWl6ZXIuYzo2MDkzPC9kaXY+Cjxk aXY+IzYgoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAs IHJlbD0weDdmNWYwODUxMmE5MCwgcmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2Vf aW5kZXgmZ3Q7LCBoYXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5j OjYwOTM8L2Rpdj48ZGl2PiM3IKAweDAwMDA3ZjZmMmQ0ZWEyYmMgaW4gcmV3cml0ZSAoc3FsPTB4 N2Y1ZjA4MDA1NDcwLCByZWw9MHg3ZjVmMDg1MGZlYjAsIHJld3JpdGVyPTB4N2Y2ZjJkNGVmNjEw ICZsdDtyZWxfdXNlX2luZGV4Jmd0OywgaGFzX2NoYW5nZXM9MHg3ZjVmMTcwMjJjYWMpIGF0IHJl bF9vcHRpbWl6ZXIuYzo2MDkzPC9kaXY+CjxkaXY+IzggoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiBy ZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsIHJlbD0weDdmNWYwODUxMDFjMCwgcmV3cml0ZXI9 MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LCBoYXNfY2hhbmdlcz0weDdmNWYx NzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYwOTM8L2Rpdj48ZGl2PiM5IKAweDAwMDA3ZjZm MmQ0ZWNmNTggaW4gX3JlbF9vcHRpbWl6ZXIgKHNxbD0weDdmNWYwODAwNTQ3MCwgcmVsPSZsdDt2 YWx1ZSBvcHRpbWl6ZWQgb3V0Jmd0OywgbGV2ZWw9MCkgYXQgcmVsX29wdGltaXplci5jOjYyNzg8 L2Rpdj4KPGRpdj4jMTAgMHgwMDAwN2Y2ZjJkNDg0MzY5IGluIHNxbF9zeW1ib2wycmVsYXRpb24g KGM9MHg3ZjVmMDgwMDU0NzAsIHN5bT0mbHQ7dmFsdWUgb3B0aW1pemVkIG91dCZndDspIGF0oDxh IGhyZWY9Imh0dHA6Ly9zcWwubXg6MTc1NS8iIHRhcmdldD0iX2JsYW5rIj5zcWwubXg6MTc1NTwv YT48L2Rpdj48ZGl2PiMxMSAweDAwMDA3ZjZmMmQ0NTRiMmYgaW4gU1FMcGFyc2VyIChjPTB4N2Y2 ZjJkZjQ5MzA4KSBhdCBzcWxfc2NlbmFyaW8uYzoxNzA4PC9kaXY+CjxkaXY+IzEyIDB4MDAwMDdm NmYzNTJlY2RkMyBpbiBydW5QaGFzZSAoYz0weDdmNmYyZGY0OTMwOCkgYXQgbWFsX3NjZW5hcmlv LmM6NTIyPC9kaXY+PGRpdj4jMTMgcnVuU2NlbmFyaW9Cb2R5IChjPTB4N2Y2ZjJkZjQ5MzA4KSBh dCBtYWxfc2NlbmFyaW8uYzo1NTg8L2Rpdj48ZGl2PiMxNCAweDAwMDA3ZjZmMzUyZWNmMWYgaW4g cnVuU2NlbmFyaW8gKGM9MHg3ZjZmMmRmNDkzMDgpIGF0IG1hbF9zY2VuYXJpby5jOjU4NjwvZGl2 Pgo8ZGl2PiMxNSAweDAwMDA3ZjZmMzUyZWQ3NzggaW4gTVNzZXJ2ZUNsaWVudCAoZHVtbXk9MHg3 ZjZmMmRmNDkzMDgpIGF0IG1hbF9zZXNzaW9uLmM6NDQ2PC9kaXY+PGRpdj4jMTYgMHgwMDAwMDAz ZWU5YTA3ODUxIGluIHN0YXJ0X3RocmVhZCAoKSBmcm9tIC9saWI2NC9saWJwdGhyZWFkLnNvLjA8 L2Rpdj48ZGl2PiMxNyAweDAwMDAwMDNlZTkyZTg5MGQgaW4gY2xvbmUgKCkgZnJvbSAvbGliNjQv bGliYy5zby42PC9kaXY+CjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLHNhbnMt c2VyaWY7Zm9udC1zaXplOjEzcHgiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTph cmlhbCxzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxM3B4Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9u dC1mYW1pbHk6YXJpYWwsc2Fucy1zZXJpZjtmb250LXNpemU6MTNweCI+QXBwYXJlbnRseSBhdCBy ZWxfb3B0aW1pemVyLmM6NDgyOSBzdHJjbXAoZXhwX3JlbG5hbWUobnJlKSByZXR1cm5zIE5VTEwg d2hpY2ggaXMgbm90IGNoZWNrZWQuPC9kaXY+CjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFs LHNhbnMtc2VyaWY7Zm9udC1zaXplOjEzcHgiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZh bWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxM3B4Ij5JZiBJIHJld3JpdGUgdGhlIHF1 ZXJ5IGluIHRoZSBmb2xsb3dpbmcgd2F5IGl0IHdvcmtzIGlmIG5vdCB2ZXJ5IGZhc3QuPC9kaXY+ PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWwsc2Fucy1zZXJpZjtmb250LXNpemU6MTNweCI+ Cjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQt c2l6ZToxM3B4Ij48ZGl2PndpdGggciBhcyAoc2VsZWN0IHQuYnVzaW5lc3NkYXRlLCB0LnN5bSwg MSAtIHQuYWRqdXN0ZWRjbG9zZXByaWNlIC8geS5hZGp1c3RlZGNsb3NlcHJpY2UgYXMgcmV0IGZy b20gRGFpbHlEYXRhIHQ8L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3Jh cCI+CTwvc3Bhbj6gbGVmdCBvdXRlciBqb2luIERhaWx5RGF0YSB5IG9uIHQuYnVzaW5lc3NkYXRl ID0geS5idXNpbmVzc2RhdGUgKyAoaW50ZXJ2YWwgJiMzOTsxJiMzOTsgZGF5KSBhbmQgdC5zeW0g PSB5LnN5bTwvZGl2Pgo8ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcCI+CTwv c3Bhbj6gd2hlcmUgdC5idXNpbmVzc2RhdGUgJmd0OyAmIzM5OzIwMTMtMDYtMDEmIzM5OyksPC9k aXY+PGRpdj52IGFzIChzZWxlY3Qgc3ltLCBzdGRkZXZfc2FtcChyZXQpIGFzIHZvbGF0aWxpdHkg ZnJvbSByIGdyb3VwIGJ5IHN5bSk8L2Rpdj48ZGl2PnNlbGVjdCAqIGZyb20gdiB3aGVyZSB2LnN5 bSBsaWtlICYjMzk7JS5MJiMzOTsgbGltaXQgMTAwOzwvZGl2Pgo8L2Rpdj48ZGl2IHN0eWxlPSJm b250LWZhbWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxM3B4Ij48YnI+PC9kaXY+PGRp diBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWwsc2Fucy1zZXJpZjtmb250LXNpemU6MTNweCI+UmVn YXJkcyw8L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxzYW5zLXNlcmlmO2ZvbnQt c2l6ZToxM3B4Ij5BbGV4IFNoZXN0YWtvdi48L2Rpdj4KPC9kaXY+Cg== --===============7851777061371323624==-- From sjoerd@monetdb.org Tue Jan 14 14:15:46 2014 From: Sjoerd Mullender To: developers-list@monetdb.org Subject: Re: Segmentation fault on a query from table expression Date: Tue, 14 Jan 2014 14:15:44 +0100 Message-ID: <52D53880.80404@monetdb.org> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3991809461585210768==" --===============3991809461585210768== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Can you create a bug report on bugs.monetdb.org please? On 2014-01-14 12:12, Alexander Shestakov wrote: > Hi, > I am running MonetDB Database Server Toolkit v1.1 (Feb2013-SP6) , > > I have a table DailyData defined as follows. > > create table DailyData ( > sym varchar(32), > businessdate date, > closePrice float, > adjustedClosePrice float, > openingPrice float, > accVol float, > unique(businessdate, sym) > ); > > > I make the following query. > > with dd as (select * from DailyData where businessdate > '2013-06-01'), > r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / > y.adjustedcloseprice as ret from dd t > left outer join dd y on t.businessdate = y.businessdate + (interval '1' > day) and t.sym = y.sym), > v as (select sym, stddev_samp(ret) as volatility from r group by sym) > select * from v where v.sym like '%.L' limit 100; > > > It results in a segmentation fault: > > Program received signal SIGSEGV, Segmentation fault. > [Switching to Thread 0x7f5f17023700 (LWP 25178)] > 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 > (gdb) where > #0 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 > #1 0x00007f6f2d4ef6f8 in rel_use_index (changes=, > sql=0x7f5f08005470, rel=0x7f5f0850aa70) at rel_optimizer.c:4829 > #2 0x00007f6f2d4ea225 in rewrite (sql=0x7f5f08005470, > rel=0x7f5f0850aa70, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6106 > #3 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f0850cb40, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #4 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f0850ec30, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #5 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f0850ef50, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #6 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f08512a90, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #7 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f0850feb0, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #8 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > rel=0x7f5f085101c0, rewriter=0x7f6f2d4ef610 , > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > #9 0x00007f6f2d4ecf58 in _rel_optimizer (sql=0x7f5f08005470, rel= optimized out>, level=0) at rel_optimizer.c:6278 > #10 0x00007f6f2d484369 in sql_symbol2relation (c=0x7f5f08005470, > sym=) at sql.mx:1755 > #11 0x00007f6f2d454b2f in SQLparser (c=0x7f6f2df49308) at > sql_scenario.c:1708 > #12 0x00007f6f352ecdd3 in runPhase (c=0x7f6f2df49308) at mal_scenario.c:522 > #13 runScenarioBody (c=0x7f6f2df49308) at mal_scenario.c:558 > #14 0x00007f6f352ecf1f in runScenario (c=0x7f6f2df49308) at > mal_scenario.c:586 > #15 0x00007f6f352ed778 in MSserveClient (dummy=0x7f6f2df49308) at > mal_session.c:446 > #16 0x0000003ee9a07851 in start_thread () from /lib64/libpthread.so.0 > #17 0x0000003ee92e890d in clone () from /lib64/libc.so.6 > > > Apparently at rel_optimizer.c:4829 strcmp(exp_relname(nre) returns NULL > which is not checked. > > If I rewrite the query in the following way it works if not very fast. > > with r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / > y.adjustedcloseprice as ret from DailyData t > left outer join DailyData y on t.businessdate = y.businessdate + > (interval '1' day) and t.sym = y.sym > where t.businessdate > '2013-06-01'), > v as (select sym, stddev_samp(ret) as volatility from r group by sym) > select * from v where v.sym like '%.L' limit 100; > > Regards, > Alex Shestakov. > > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list > -- Sjoerd Mullender --===============3991809461585210768== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEKQ29tbWVudDog VXNpbmcgR251UEcgd2l0aCBUaHVuZGVyYmlyZCAtIGh0dHA6Ly93d3cuZW5pZ21haWwubmV0LwoK aVFDVkF3VUJVdFU0Z0Q3ZzA0QWp2SVFwQVFJSkJnUUFuQy9IMDhtZm5DdVFMbmtsSFhhNmtrcUZm UzByMUJVWQpSSzRITFAxa05mTlpNYVM3RjNJOENybVUrM3pnOGhjSVlqaVVBejNKS2ZRMjlaTEtn dng1TndRQklCa1lEenRNCmg2TWdvWkFMWHdZbHNEUmc0R2NYSVVPcGF1akZqNEhzTkMrekp4dVVy OC9WTkxBeEpZRDRyNk1FUWdBVTRRdk0KVFBTM1lLeXRGenc9Cj05b1l0Ci0tLS0tRU5EIFBHUCBT SUdOQVRVUkUtLS0tLQo= --===============3991809461585210768==-- From shura.shestakov@gmail.com Tue Jan 14 15:36:31 2014 From: Alexander Shestakov To: developers-list@monetdb.org Subject: Re: Segmentation fault on a query from table expression Date: Tue, 14 Jan 2014 14:36:27 +0000 Message-ID: In-Reply-To: <52D53880.80404@monetdb.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5417553245293760009==" --===============5417553245293760009== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit I did. On 14 January 2014 13:15, Sjoerd Mullender wrote: > Can you create a bug report on bugs.monetdb.org please? > > On 2014-01-14 12:12, Alexander Shestakov wrote: > > Hi, > > I am running MonetDB Database Server Toolkit v1.1 (Feb2013-SP6) , > > > > I have a table DailyData defined as follows. > > > > create table DailyData ( > > sym varchar(32), > > businessdate date, > > closePrice float, > > adjustedClosePrice float, > > openingPrice float, > > accVol float, > > unique(businessdate, sym) > > ); > > > > > > I make the following query. > > > > with dd as (select * from DailyData where businessdate > '2013-06-01'), > > r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / > > y.adjustedcloseprice as ret from dd t > > left outer join dd y on t.businessdate = y.businessdate + (interval '1' > > day) and t.sym = y.sym), > > v as (select sym, stddev_samp(ret) as volatility from r group by sym) > > select * from v where v.sym like '%.L' limit 100; > > > > > > It results in a segmentation fault: > > > > Program received signal SIGSEGV, Segmentation fault. > > [Switching to Thread 0x7f5f17023700 (LWP 25178)] > > 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 > > (gdb) where > > #0 0x0000003ee9327a9a in __strcmp_sse42 () from /lib64/libc.so.6 > > #1 0x00007f6f2d4ef6f8 in rel_use_index (changes=, > > sql=0x7f5f08005470, rel=0x7f5f0850aa70) at rel_optimizer.c:4829 > > #2 0x00007f6f2d4ea225 in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f0850aa70, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6106 > > #3 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f0850cb40, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #4 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f0850ec30, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #5 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f0850ef50, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #6 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f08512a90, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #7 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f0850feb0, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #8 0x00007f6f2d4ea2bc in rewrite (sql=0x7f5f08005470, > > rel=0x7f5f085101c0, rewriter=0x7f6f2d4ef610 , > > has_changes=0x7f5f17022cac) at rel_optimizer.c:6093 > > #9 0x00007f6f2d4ecf58 in _rel_optimizer (sql=0x7f5f08005470, rel= > optimized out>, level=0) at rel_optimizer.c:6278 > > #10 0x00007f6f2d484369 in sql_symbol2relation (c=0x7f5f08005470, > > sym=) at sql.mx:1755 > > #11 0x00007f6f2d454b2f in SQLparser (c=0x7f6f2df49308) at > > sql_scenario.c:1708 > > #12 0x00007f6f352ecdd3 in runPhase (c=0x7f6f2df49308) at > mal_scenario.c:522 > > #13 runScenarioBody (c=0x7f6f2df49308) at mal_scenario.c:558 > > #14 0x00007f6f352ecf1f in runScenario (c=0x7f6f2df49308) at > > mal_scenario.c:586 > > #15 0x00007f6f352ed778 in MSserveClient (dummy=0x7f6f2df49308) at > > mal_session.c:446 > > #16 0x0000003ee9a07851 in start_thread () from /lib64/libpthread.so.0 > > #17 0x0000003ee92e890d in clone () from /lib64/libc.so.6 > > > > > > Apparently at rel_optimizer.c:4829 strcmp(exp_relname(nre) returns NULL > > which is not checked. > > > > If I rewrite the query in the following way it works if not very fast. > > > > with r as (select t.businessdate, t.sym, 1 - t.adjustedcloseprice / > > y.adjustedcloseprice as ret from DailyData t > > left outer join DailyData y on t.businessdate = y.businessdate + > > (interval '1' day) and t.sym = y.sym > > where t.businessdate > '2013-06-01'), > > v as (select sym, stddev_samp(ret) as volatility from r group by sym) > > select * from v where v.sym like '%.L' limit 100; > > > > Regards, > > Alex Shestakov. > > > > > > _______________________________________________ > > developers-list mailing list > > developers-list(a)monetdb.org > > https://www.monetdb.org/mailman/listinfo/developers-list > > > > > -- > Sjoerd Mullender > > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list > > --===============5417553245293760009== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+SSBkaWQuPC9kaXY+PGRpdiBjbGFzcz0iZ21haWxfZXh0cmEiPjxicj48 YnI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIDE0IEphbnVhcnkgMjAxNCAxMzoxNSwgU2pv ZXJkIE11bGxlbmRlciA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpzam9lcmRA bW9uZXRkYi5vcmciIHRhcmdldD0iX2JsYW5rIj5zam9lcmRAbW9uZXRkYi5vcmc8L2E+Jmd0Ozwv c3Bhbj4gd3JvdGU6PGJyPgo8YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJt YXJnaW46MCAwIDAgLjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6 MWV4Ij5DYW4geW91IGNyZWF0ZSBhIGJ1ZyByZXBvcnQgb24gPGEgaHJlZj0iaHR0cDovL2J1Z3Mu bW9uZXRkYi5vcmciIHRhcmdldD0iX2JsYW5rIj5idWdzLm1vbmV0ZGIub3JnPC9hPiBwbGVhc2U/ PGJyPgo8ZGl2PjxkaXYgY2xhc3M9Img1Ij48YnI+Ck9uIDIwMTQtMDEtMTQgMTI6MTIsIEFsZXhh bmRlciBTaGVzdGFrb3Ygd3JvdGU6PGJyPgomZ3Q7IEhpLDxicj4KJmd0OyBJIGFtIHJ1bm5pbmcg TW9uZXREQiBEYXRhYmFzZSBTZXJ2ZXIgVG9vbGtpdCB2MS4xIChGZWIyMDEzLVNQNikgLDxicj4K Jmd0Ozxicj4KJmd0OyBJIGhhdmUgYSB0YWJsZSBEYWlseURhdGEgZGVmaW5lZCBhcyBmb2xsb3dz Ljxicj4KJmd0Ozxicj4KJmd0OyBjcmVhdGUgdGFibGUgRGFpbHlEYXRhICg8YnI+CiZndDsgc3lt IHZhcmNoYXIoMzIpLDxicj4KJmd0OyBidXNpbmVzc2RhdGUgZGF0ZSw8YnI+CiZndDsgY2xvc2VQ cmljZSBmbG9hdCw8YnI+CiZndDsgYWRqdXN0ZWRDbG9zZVByaWNlIGZsb2F0LDxicj4KJmd0OyBv cGVuaW5nUHJpY2UgZmxvYXQsPGJyPgomZ3Q7IGFjY1ZvbCBmbG9hdCw8YnI+CiZndDsgdW5pcXVl KGJ1c2luZXNzZGF0ZSwgc3ltKTxicj4KJmd0OyApOzxicj4KJmd0Ozxicj4KJmd0Ozxicj4KJmd0 OyBJIG1ha2UgdGhlIGZvbGxvd2luZyBxdWVyeS48YnI+CiZndDs8YnI+CiZndDsgd2l0aCBkZCBh cyAoc2VsZWN0ICogZnJvbSBEYWlseURhdGEgd2hlcmUgYnVzaW5lc3NkYXRlICZndDsgJiMzOTsy MDEzLTA2LTAxJiMzOTspLDxicj4KJmd0OyByIGFzIChzZWxlY3QgdC5idXNpbmVzc2RhdGUsIHQu c3ltLCAxIC0gdC5hZGp1c3RlZGNsb3NlcHJpY2UgLzxicj4KJmd0OyB5LmFkanVzdGVkY2xvc2Vw cmljZSBhcyByZXQgZnJvbSBkZCB0PGJyPgomZ3Q7IGxlZnQgb3V0ZXIgam9pbiBkZCB5IG9uIHQu YnVzaW5lc3NkYXRlID0geS5idXNpbmVzc2RhdGUgKyAoaW50ZXJ2YWwgJiMzOTsxJiMzOTs8YnI+ CiZndDsgZGF5KSBhbmQgdC5zeW0gPSB5LnN5bSksPGJyPgomZ3Q7IHYgYXMgKHNlbGVjdCBzeW0s IHN0ZGRldl9zYW1wKHJldCkgYXMgdm9sYXRpbGl0eSBmcm9tIHIgZ3JvdXAgYnkgc3ltKTxicj4K Jmd0OyBzZWxlY3QgKiBmcm9tIHYgd2hlcmUgdi5zeW0gbGlrZSAmIzM5OyUuTCYjMzk7IGxpbWl0 IDEwMDs8YnI+CiZndDs8YnI+CiZndDs8YnI+CiZndDsgSXQgcmVzdWx0cyBpbiBhIHNlZ21lbnRh dGlvbiBmYXVsdDo8YnI+CiZndDs8YnI+CiZndDsgUHJvZ3JhbSByZWNlaXZlZCBzaWduYWwgU0lH U0VHViwgU2VnbWVudGF0aW9uIGZhdWx0Ljxicj4KJmd0OyBbU3dpdGNoaW5nIHRvIFRocmVhZCAw eDdmNWYxNzAyMzcwMCAoTFdQIDI1MTc4KV08YnI+CiZndDsgMHgwMDAwMDAzZWU5MzI3YTlhIGlu IF9fc3RyY21wX3NzZTQyICgpIGZyb20gL2xpYjY0L2xpYmMuc28uNjxicj4KJmd0OyAoZ2RiKSB3 aGVyZTxicj4KJmd0OyAjMCCgMHgwMDAwMDAzZWU5MzI3YTlhIGluIF9fc3RyY21wX3NzZTQyICgp IGZyb20gL2xpYjY0L2xpYmMuc28uNjxicj4KJmd0OyAjMSCgMHgwMDAwN2Y2ZjJkNGVmNmY4IGlu IHJlbF91c2VfaW5kZXggKGNoYW5nZXM9Jmx0O3ZhbHVlIG9wdGltaXplZCBvdXQmZ3Q7LDxicj4K Jmd0OyBzcWw9MHg3ZjVmMDgwMDU0NzAsIHJlbD0weDdmNWYwODUwYWE3MCkgYXQgcmVsX29wdGlt aXplci5jOjQ4Mjk8YnI+CiZndDsgIzIgoDB4MDAwMDdmNmYyZDRlYTIyNSBpbiByZXdyaXRlIChz cWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgomZ3Q7IHJlbD0weDdmNWYwODUwYWE3MCwgcmV3cml0ZXI9 MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNfY2hhbmdl cz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYxMDY8YnI+CiZndDsgIzMgoDB4 MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgomZ3Q7 IHJlbD0weDdmNWYwODUwY2I0MCwgcmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2Vf aW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29w dGltaXplci5jOjYwOTM8YnI+CiZndDsgIzQgoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdyaXRl IChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgomZ3Q7IHJlbD0weDdmNWYwODUwZWMzMCwgcmV3cml0 ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNfY2hh bmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYwOTM8YnI+CiZndDsgIzUg oDB4MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgom Z3Q7IHJlbD0weDdmNWYwODUwZWY1MCwgcmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91 c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVs X29wdGltaXplci5jOjYwOTM8YnI+CiZndDsgIzYgoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdy aXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgomZ3Q7IHJlbD0weDdmNWYwODUxMmE5MCwgcmV3 cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNf Y2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYwOTM8YnI+CiZndDsg IzcgoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiByZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJy PgomZ3Q7IHJlbD0weDdmNWYwODUwZmViMCwgcmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3Jl bF91c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBoYXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQg cmVsX29wdGltaXplci5jOjYwOTM8YnI+CiZndDsgIzggoDB4MDAwMDdmNmYyZDRlYTJiYyBpbiBy ZXdyaXRlIChzcWw9MHg3ZjVmMDgwMDU0NzAsPGJyPgomZ3Q7IHJlbD0weDdmNWYwODUxMDFjMCwg cmV3cml0ZXI9MHg3ZjZmMmQ0ZWY2MTAgJmx0O3JlbF91c2VfaW5kZXgmZ3Q7LDxicj4KJmd0OyBo YXNfY2hhbmdlcz0weDdmNWYxNzAyMmNhYykgYXQgcmVsX29wdGltaXplci5jOjYwOTM8YnI+CiZn dDsgIzkgoDB4MDAwMDdmNmYyZDRlY2Y1OCBpbiBfcmVsX29wdGltaXplciAoc3FsPTB4N2Y1ZjA4 MDA1NDcwLCByZWw9Jmx0O3ZhbHVlPGJyPgomZ3Q7IG9wdGltaXplZCBvdXQmZ3Q7LCBsZXZlbD0w KSBhdCByZWxfb3B0aW1pemVyLmM6NjI3ODxicj4KJmd0OyAjMTAgMHgwMDAwN2Y2ZjJkNDg0MzY5 IGluIHNxbF9zeW1ib2wycmVsYXRpb24gKGM9MHg3ZjVmMDgwMDU0NzAsPGJyPgo8L2Rpdj48L2Rp dj4mZ3Q7IHN5bT0mbHQ7dmFsdWUgb3B0aW1pemVkIG91dCZndDspIGF0IDxhIGhyZWY9Imh0dHA6 Ly9zcWwubXg6MTc1NSIgdGFyZ2V0PSJfYmxhbmsiPnNxbC5teDoxNzU1PC9hPiAmbHQ7PGEgaHJl Zj0iaHR0cDovL3NxbC5teDoxNzU1LyIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9zcWwubXg6MTc1 NS88L2E+Jmd0Ozxicj4KPGRpdiBjbGFzcz0iaW0iPiZndDsgIzExIDB4MDAwMDdmNmYyZDQ1NGIy ZiBpbiBTUUxwYXJzZXIgKGM9MHg3ZjZmMmRmNDkzMDgpIGF0PGJyPgomZ3Q7IHNxbF9zY2VuYXJp by5jOjE3MDg8YnI+CiZndDsgIzEyIDB4MDAwMDdmNmYzNTJlY2RkMyBpbiBydW5QaGFzZSAoYz0w eDdmNmYyZGY0OTMwOCkgYXQgbWFsX3NjZW5hcmlvLmM6NTIyPGJyPgomZ3Q7ICMxMyBydW5TY2Vu YXJpb0JvZHkgKGM9MHg3ZjZmMmRmNDkzMDgpIGF0IG1hbF9zY2VuYXJpby5jOjU1ODxicj4KJmd0 OyAjMTQgMHgwMDAwN2Y2ZjM1MmVjZjFmIGluIHJ1blNjZW5hcmlvIChjPTB4N2Y2ZjJkZjQ5MzA4 KSBhdDxicj4KJmd0OyBtYWxfc2NlbmFyaW8uYzo1ODY8YnI+CiZndDsgIzE1IDB4MDAwMDdmNmYz NTJlZDc3OCBpbiBNU3NlcnZlQ2xpZW50IChkdW1teT0weDdmNmYyZGY0OTMwOCkgYXQ8YnI+CiZn dDsgbWFsX3Nlc3Npb24uYzo0NDY8YnI+CiZndDsgIzE2IDB4MDAwMDAwM2VlOWEwNzg1MSBpbiBz dGFydF90aHJlYWQgKCkgZnJvbSAvbGliNjQvbGlicHRocmVhZC5zby4wPGJyPgomZ3Q7ICMxNyAw eDAwMDAwMDNlZTkyZTg5MGQgaW4gY2xvbmUgKCkgZnJvbSAvbGliNjQvbGliYy5zby42PGJyPgom Z3Q7PGJyPgomZ3Q7PGJyPgomZ3Q7IEFwcGFyZW50bHkgYXQgcmVsX29wdGltaXplci5jOjQ4Mjkg c3RyY21wKGV4cF9yZWxuYW1lKG5yZSkgcmV0dXJucyBOVUxMPGJyPgomZ3Q7IHdoaWNoIGlzIG5v dCBjaGVja2VkLjxicj4KJmd0Ozxicj4KJmd0OyBJZiBJIHJld3JpdGUgdGhlIHF1ZXJ5IGluIHRo ZSBmb2xsb3dpbmcgd2F5IGl0IHdvcmtzIGlmIG5vdCB2ZXJ5IGZhc3QuPGJyPgomZ3Q7PGJyPgom Z3Q7IHdpdGggciBhcyAoc2VsZWN0IHQuYnVzaW5lc3NkYXRlLCB0LnN5bSwgMSAtIHQuYWRqdXN0 ZWRjbG9zZXByaWNlIC88YnI+CiZndDsgeS5hZGp1c3RlZGNsb3NlcHJpY2UgYXMgcmV0IGZyb20g RGFpbHlEYXRhIHQ8YnI+CiZndDsgoGxlZnQgb3V0ZXIgam9pbiBEYWlseURhdGEgeSBvbiB0LmJ1 c2luZXNzZGF0ZSA9IHkuYnVzaW5lc3NkYXRlICs8YnI+CiZndDsgKGludGVydmFsICYjMzk7MSYj Mzk7IGRheSkgYW5kIHQuc3ltID0geS5zeW08YnI+CiZndDsgoHdoZXJlIHQuYnVzaW5lc3NkYXRl ICZndDsgJiMzOTsyMDEzLTA2LTAxJiMzOTspLDxicj4KJmd0OyB2IGFzIChzZWxlY3Qgc3ltLCBz dGRkZXZfc2FtcChyZXQpIGFzIHZvbGF0aWxpdHkgZnJvbSByIGdyb3VwIGJ5IHN5bSk8YnI+CiZn dDsgc2VsZWN0ICogZnJvbSB2IHdoZXJlIHYuc3ltIGxpa2UgJiMzOTslLkwmIzM5OyBsaW1pdCAx MDA7PGJyPgomZ3Q7PGJyPgomZ3Q7IFJlZ2FyZHMsPGJyPgomZ3Q7IEFsZXggU2hlc3Rha292Ljxi cj4KJmd0Ozxicj4KJmd0Ozxicj4KPC9kaXY+Jmd0OyBfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXzxicj4KJmd0OyBkZXZlbG9wZXJzLWxpc3QgbWFpbGluZyBs aXN0PGJyPgomZ3Q7IDxhIGhyZWY9Im1haWx0bzpkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmci PmRldmVsb3BlcnMtbGlzdEBtb25ldGRiLm9yZzwvYT48YnI+CiZndDsgPGEgaHJlZj0iaHR0cHM6 Ly93d3cubW9uZXRkYi5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXZlbG9wZXJzLWxpc3QiIHRhcmdl dD0iX2JsYW5rIj5odHRwczovL3d3dy5tb25ldGRiLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2RldmVs b3BlcnMtbGlzdDwvYT48YnI+CiZndDs8YnI+CjxzcGFuIGNsYXNzPSJIT0VuWmIiPjxmb250IGNv bG9yPSIjODg4ODg4Ij48YnI+Cjxicj4KLS08YnI+ClNqb2VyZCBNdWxsZW5kZXI8YnI+Cjxicj4K PC9mb250Pjwvc3Bhbj48YnI+X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX188YnI+CmRldmVsb3BlcnMtbGlzdCBtYWlsaW5nIGxpc3Q8YnI+CjxhIGhyZWY9Im1h aWx0bzpkZXZlbG9wZXJzLWxpc3RAbW9uZXRkYi5vcmciPmRldmVsb3BlcnMtbGlzdEBtb25ldGRi Lm9yZzwvYT48YnI+CjxhIGhyZWY9Imh0dHBzOi8vd3d3Lm1vbmV0ZGIub3JnL21haWxtYW4vbGlz dGluZm8vZGV2ZWxvcGVycy1saXN0IiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly93d3cubW9uZXRk Yi5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXZlbG9wZXJzLWxpc3Q8L2E+PGJyPgo8YnI+PC9ibG9j a3F1b3RlPjwvZGl2Pjxicj48L2Rpdj4K --===============5417553245293760009==-- From sjoerd@acm.org Wed Jan 15 14:26:20 2014 From: Sjoerd Mullender To: developers-list@monetdb.org Subject: Announcement: Release Candidate for Jan2014 Release Date: Wed, 15 Jan 2014 14:26:18 +0100 Message-ID: <52D68C7A.1080901@acm.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1723864676926603944==" --===============1723864676926603944== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit The MonetDB team at CWI/MonetDB BV is pleased to announce a release candidate for the upcoming Jan2014 feature release. Many things have changed in this release compared to the previous (Feb2013) release (that's why it took so long). For a smooth upgrade I would urge you to try out this release candidate and to provide feedback on our bug tracker (http://bugs.monetdb.org). The release candidate can be found at http://dev.monetdb.org/downloads/testing. -- Sjoerd Mullender --===============1723864676926603944== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEKQ29tbWVudDog VXNpbmcgR251UEcgd2l0aCBUaHVuZGVyYmlyZCAtIGh0dHA6Ly93d3cuZW5pZ21haWwubmV0LwoK aVFDVkF3VUJVdGFNZWo3ZzA0QWp2SVFwQVFLVHdRUUFnV1ZFakQzUlVtZG9RZXd3QlpzN1IxSnZV enBaMEJXcwptSDlWbnJGbjJVb3FwM1hrNVpTQVl0OEVpTXEwZllKM1dnc3piWFRrWGdiUm5YYTRG SEw2TzNFbUlGSklkY2Q5CjBxMmVJWlloSjhWZzRhbW1iYm1GRFJqcHRZQU9nV3FrS090NlV3WTBp WTBvclBnMnEzaDFhOTd4QUxnUEtpOVUKYm53MHpNQUhMdjQ9Cj1uS0xZCi0tLS0tRU5EIFBHUCBT SUdOQVRVUkUtLS0tLQo= --===============1723864676926603944==-- From sjoerd@acm.org Sat Jan 25 18:56:02 2014 From: Sjoerd Mullender To: developers-list@monetdb.org Subject: Announcement: Second Release Candidate for Jan2014 Release Date: Sat, 25 Jan 2014 18:55:55 +0100 Message-ID: <52E3FAAB.3040108@acm.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1959370842855519952==" --===============1959370842855519952== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit The MonetDB team at CWI/MonetDB BV is pleased to announce a second release candidate for the upcoming Jan2014 feature release. Many things have changed in this release compared to the previous (Feb2013) release (that's why it took so long). For a smooth upgrade I would urge you to try out this release candidate and to provide feedback on our bug tracker (http://bugs.monetdb.org). A number of bugs in the previous release candidate have been fixed. Among others, packaging errors on Debian and Ubuntu have been fixed, and a problem with slow startup has been fixed. The release candidate can be found at http://dev.monetdb.org/downloads/testing. -- Sjoerd Mullender --===============1959370842855519952== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEKQ29tbWVudDog VXNpbmcgR251UEcgd2l0aCBUaHVuZGVyYmlyZCAtIGh0dHA6Ly93d3cuZW5pZ21haWwubmV0LwoK aVFDVkF3VUJVdVA2cXo3ZzA0QWp2SVFwQVFJRGVnUUFxT283N3ZCdjJOa0hvbTdMM2c4REw3Tjdi ZzlPd3dJUQpHSW9XaWYzSThJdnB4djU3M29KUElLSG1Cd0dkVGxTajVEWTdUR29jZVVpNHRYQXds dytVbnlld0JOZE1zNWtRCnQvOUVabk9OQkhWck1kbkpmb3ZLTy9sVDlYZDh4Z1N5T3cvOVl4UG0w RHoyL0YzaEZlZGt2YWNsTFFQckpnYkQKcDBhS1FFZkFDMUk9Cj00NkRvCi0tLS0tRU5EIFBHUCBT SUdOQVRVUkUtLS0tLQo= --===============1959370842855519952==--