tag:blogger.com,1999:blog-16959946.post113319469690210697..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: MySQL 5 general purpose routine library - II: Using arraysGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-16959946.post-69862575621338094092013-01-29T14:50:12.736+01:002013-01-29T14:50:12.736+01:00This library was made for MySQl 5.0, and probably ...This library was made for MySQl 5.0, and probably it is not even fully compatible with MySQL 5.5.<br />Besides, stored routines in MySQL are not performing very well.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-29329847453689723612013-01-29T14:16:39.630+01:002013-01-29T14:16:39.630+01:00Right now I am working on converting a massive Ora...Right now I am working on converting a massive Oracle database to MySQL 5.6 and I'm having major trouble porting the Varrays to anything MySQL understands without hurting the performance too much.<br /><br />Can you tell me if this library is actually still compatible with MySQL 5.6.9rc?<br /><br />Thanks in advance,<br /><br />Erwin<br />Solohttps://www.blogger.com/profile/00729840459693655909noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-46439873093304025332007-11-29T20:34:00.000+01:002007-11-29T20:34:00.000+01:00Hi again,I just thought I should mention another s...Hi again,<BR/><BR/>I just thought I should mention another small detail. There is an inconsistency between stacks and queues when attempting to retreve a value from an empty list, one giving an error and the other one returning a "null" value.<BR/><BR/>Regards,<BR/><BR/>DavidDavidhttps://www.blogger.com/profile/04758774274952539008noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-21765177504440134082007-11-29T20:30:00.000+01:002007-11-29T20:30:00.000+01:00Hi,I really love your libraries and they have real...Hi,<BR/><BR/>I really love your libraries and they have really saved me a lot of time. Especially the for_each_table.<BR/><BR/>I think that I have found a bug in your implementation of queue. Look at the order of the data-output in the following example. Notice that the order is the same whether i use stack or queue.<BR/><BR/>mysql> call array_create('ids_since_find_case', 0);<BR/>Query OK, 0 rows affected (0.05 sec)<BR/><BR/>mysql> call array_unshift('ids_since_find_case', 1);<BR/>Query OK, 0 rows affected (0.00 sec)<BR/><BR/>mysql> call array_unshift('ids_since_find_case', 2);<BR/>Query OK, 0 rows affected (0.00 sec)<BR/><BR/>mysql> select array_shift('ids_since_find_case');<BR/>+------------------------------------+<BR/>| array_shift('ids_since_find_case') |<BR/>+------------------------------------+<BR/>| 2 |<BR/>+------------------------------------+<BR/>1 row in set (0.00 sec)<BR/><BR/>mysql> select array_shift('ids_since_find_case');<BR/>+------------------------------------+<BR/>| array_shift('ids_since_find_case') |<BR/>+------------------------------------+<BR/>| 1 |<BR/>+------------------------------------+<BR/>1 row in set (0.00 sec)<BR/><BR/>mysql> call array_create('ids_since_find_case', 0);<BR/>Query OK, 0 rows affected (0.00 sec)<BR/><BR/>mysql> call array_push('ids_since_find_case', 1);<BR/>Query OK, 0 rows affected (0.00 sec)<BR/><BR/>mysql> call array_push('ids_since_find_case', 2);<BR/>Query OK, 0 rows affected (0.00 sec)<BR/><BR/>mysql> select array_pop('ids_since_find_case');<BR/>+----------------------------------+<BR/>| array_pop('ids_since_find_case') |<BR/>+----------------------------------+<BR/>| 2 |<BR/>+----------------------------------+<BR/>1 row in set (0.00 sec)<BR/><BR/>mysql> select array_pop('ids_since_find_case');<BR/>+----------------------------------+<BR/>| array_pop('ids_since_find_case') |<BR/>+----------------------------------+<BR/>| 1 |<BR/>+----------------------------------+<BR/>1 row in set (0.00 sec)<BR/><BR/>mysql>Davidhttps://www.blogger.com/profile/04758774274952539008noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-1146009628214645932006-04-26T02:00:00.000+02:002006-04-26T02:00:00.000+02:00array_from_list has problems dealing with empty va...array_from_list has problems dealing with empty values in the CSV parameter<BR/><BR/>eg: array_from_list('"","",""', "array_name" ) seems to give errors.<BR/><BR/>Plus a hard-found problem: all values in the CSV input MUST be quoted (even for integers)Jason Suwalahttps://www.blogger.com/profile/04290049393284258203noreply@blogger.com