[MDEV-4922] Stored Procedure - Geometry parameter not working - Jira

Elena Stepanova added a comment - 2013-08-20 11:39 - edited

Hi Jonas,

Could you please be a little more specific in regard to what you mean by "works on MySQL" or by "does not work on MariaDB"?

I am running your attached scenario on MySQL 5.5 and MariaDB 5.5, and receiving seemingly identical results:

MySQL [test]> SELECT id,data,AsText(g) FROM testg;
----------------------------------------------------------------------------------------------------------------

id

data

AsText(g)

----------------------------------------------------------------------------------------------------------------

1

11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838

NULL

----------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

MariaDB [test]> SELECT id,data,AsText(g) FROM testg;
----------------------------------------------------------------------------------------------------------------

id

data

AsText(g)

----------------------------------------------------------------------------------------------------------------

1

11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838

NULL

----------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

At the same time, MariaDB 10.0.4 returns a not-null value in AsText(g):

MariaDB [test]> SELECT id,data,AsText(g) FROM testg;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

id

data

AsText(g)

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1

11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838

POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838))

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

MariaDB [test]> select @@version;
----------------------

@@version

----------------------

10.0.4-MariaDB-debug

----------------------
1 row in set (0.00 sec)

Elena Stepanova added a comment - 2013-08-20 11:39 - edited Hi Jonas, Could you please be a little more specific in regard to what you mean by "works on MySQL" or by "does not work on MariaDB"? I am running your attached scenario on MySQL 5.5 and MariaDB 5.5, and receiving seemingly identical results: MySQL [test] > SELECT id,data,AsText(g) FROM testg; --- --------------------------------------------------------------------------------------------------- ---------- id data AsText(g) --- --------------------------------------------------------------------------------------------------- ---------- 1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 NULL --- --------------------------------------------------------------------------------------------------- ---------- 1 row in set (0.00 sec) MariaDB [test] > SELECT id,data,AsText(g) FROM testg; --- --------------------------------------------------------------------------------------------------- ---------- id data AsText(g) --- --------------------------------------------------------------------------------------------------- ---------- 1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 NULL --- --------------------------------------------------------------------------------------------------- ---------- 1 row in set (0.00 sec) At the same time, MariaDB 10.0.4 returns a not-null value in AsText(g): MariaDB [test] > SELECT id,data,AsText(g) FROM testg; --- --------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- id data AsText(g) --- --------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- 1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838)) --- --------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- 1 row in set (0.00 sec) MariaDB [test] > select @@version; ---------------------- @@version ---------------------- 10.0.4-MariaDB-debug ---------------------- 1 row in set (0.00 sec)

Jonas Reinhardt added a comment - 2013-08-20 14:23

Hi Elena,

Before filing the Issue I did run the test several times on different servers.
The mysql server did answer as your MariaDB 10.0.4 "AsText(g)=POLYGON((..." , the expected answer.
The MariaDB servers I tested answered "AsText(g)=NULL" thus I thought it must be a MariaDB specific problem.
If you have a look on the screenshot (from HeidiSQL) you can identify the AsText(g)=NULL with the g column starting with 0X7.. or 0XA..
I believe this content is not valid geometry!

More interesting and strange is that today I tested again with different servers, (the same as yesterday)
all answered "AsText(g)=POLYGON((..." ????
Note the first result which on your server (and mine yesterday) resulted in AsText(g)=NULL are both MariaDB ver 5.5 ?

Se below:

5.5.32-MariaDB-log
id data AsText(g)
1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838))

mysql 5.1.59-community
id data AsText(g)
1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838))

Jonas Reinhardt added a comment - 2013-08-20 14:23 Hi Elena, Before filing the Issue I did run the test several times on different servers. The mysql server did answer as your MariaDB 10.0.4 "AsText(g)=POLYGON((..." , the expected answer. The MariaDB servers I tested answered "AsText(g)=NULL" thus I thought it must be a MariaDB specific problem. If you have a look on the screenshot (from HeidiSQL) you can identify the AsText(g)=NULL with the g column starting with 0X7.. or 0XA.. I believe this content is not valid geometry! More interesting and strange is that today I tested again with different servers, (the same as yesterday) all answered "AsText(g)=POLYGON((..." ???? Note the first result which on your server (and mine yesterday) resulted in AsText(g)=NULL are both MariaDB ver 5.5 ? Se below: 5.5.32-MariaDB-log id data AsText(g) 1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838)) mysql 5.1.59-community id data AsText(g) 1 11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838 POLYGON((11.960453 57.565838,11.925262 57.567955,11.921486 57.555248,11.960882 57.554189,11.960453 57.565838))

Elena Stepanova added a comment - 2013-08-20 14:35

Hi Jonas,

I wasn't quite sure how to apply the screenshot to the problem, it has a 5-row result set while your test case only returns one.

Regarding the rest, I'll take another look, thanks for the info.

Elena Stepanova added a comment - 2013-08-20 14:35 Hi Jonas, I wasn't quite sure how to apply the screenshot to the problem, it has a 5-row result set while your test case only returns one. Regarding the rest, I'll take another look, thanks for the info.

Jonas Reinhardt added a comment - 2013-08-20 14:45

Hi again,
If you run the test-case multiple times the rows add up, no reset is done...
/J

Jonas Reinhardt added a comment - 2013-08-20 14:45 Hi again, If you run the test-case multiple times the rows add up, no reset is done... /J

Elena Stepanova added a comment - 2013-08-21 02:57

There turns out to be a valgrind issue (Invalid read), which probably causes the problem. The valgrind warning is reproducible on MariaDB 5.3, 5.5 and on MySQL 5.5, 5.6; but not on MariaDB 10.0.4.
The rest is apparently the matter of luck, depending on what the invalid read has read.

Are you willing to file a bug report at bugs.mysql.com? We usually report upstream bugs to MySQL as well.

Stack trace from MariaDB 5.3:

==10277== Thread 4:
==10277== Invalid read of size 1
==10277== at 0x4C2D1A0: memcpy@@GLIBC_2.14 (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
==10277== by 0x9341B1: _mi_rec_pack (mi_dynrec.c:1015)
==10277== by 0x931674: _mi_write_blob_record (mi_dynrec.c:300)
==10277== by 0x954E5E: mi_write (mi_write.c:149)
==10277== by 0x90FA6A: ha_myisam::write_row(unsigned char*) (ha_myisam.cc:851)
==10277== by 0x810272: handler::ha_write_row(unsigned char*) (handler.cc:4978)
==10277== by 0x748E05: write_record(THD*, st_table*, st_copy_info*) (sql_insert.cc:1692)
==10277== by 0x746C0A: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:887)
==10277== by 0x68B560: mysql_execute_command(THD*) (sql_parse.cc:3253)
==10277== by 0x6946B3: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
==10277== by 0x68610E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
==10277== by 0x68537F: do_command(THD*) (sql_parse.cc:923)
==10277== by 0x682219: handle_one_connection (sql_connect.cc:1231)
==10277== by 0x548DE99: start_thread (pthread_create.c:308)
==10277== by 0x5F9ACBC: clone (clone.S:112)
==10277== Address 0xf873978 is 136 bytes inside a block of size 148 free'd
==10277== at 0x4C2A82E: free (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
==10277== by 0xB7477E: _myfree (safemalloc.c:337)
==10277== by 0x56B571: String::free() (sql_string.h:240)
==10277== by 0x65165D: Field_blob::free() (field.h:1896)
==10277== by 0x6FB69C: free_blobs(st_table*) (table.cc:2531)
==10277== by 0x8C1684: sp_rcontext::~sp_rcontext() (sp_rcontext.cc:58)
==10277== by 0x8BA4E7: sp_head::execute_procedure(THD*, List<Item>*) (sp_head.cc:2069)
==10277== by 0x68F73B: mysql_execute_command(THD*) (sql_parse.cc:4500)
==10277== by 0x8BC917: sp_instr_stmt::exec_core(THD*, unsigned int*) (sp_head.cc:2976)
==10277== by 0x8BC22C: sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) (sp_head.cc:2794)
==10277== by 0x8BC6D9: sp_instr_stmt::execute(THD*, unsigned int*) (sp_head.cc:2919)
==10277== by 0x8B8590: sp_head::execute(THD*) (sp_head.cc:1283)
==10277== by 0x8B911A: sp_head::execute_trigger(THD*, st_mysql_lex_string const*, st_mysql_lex_string const*, st_grant_info*) (sp_head.cc:1586)
==10277== by 0x8CF381: Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool) (sql_trigger.cc:2130)
==10277== by 0x6F00E7: fill_record_n_invoke_before_triggers(THD*, List<Item>&, List<Item>&, bool, Table_triggers_list*, trg_event_type) (sql_base.cc:8747)
==10277== by 0x746914: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:808)
==10277== Invalid read of size 1
==10277== at 0x4C2D1AD: memcpy@@GLIBC_2.14 (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
==10277== by 0x9341B1: _mi_rec_pack (mi_dynrec.c:1015)
==10277== by 0x931674: _mi_write_blob_record (mi_dynrec.c:300)
==10277== by 0x954E5E: mi_write (mi_write.c:149)
==10277== by 0x90FA6A: ha_myisam::write_row(unsigned char*) (ha_myisam.cc:851)
==10277== by 0x810272: handler::ha_write_row(unsigned char*) (handler.cc:4978)
==10277== by 0x748E05: write_record(THD*, st_table*, st_copy_info*) (sql_insert.cc:1692)
==10277== by 0x746C0A: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:887)
==10277== by 0x68B560: mysql_execute_command(THD*) (sql_parse.cc:3253)
==10277== by 0x6946B3: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
==10277== by 0x68610E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
==10277== by 0x68537F: do_command(THD*) (sql_parse.cc:923)
==10277== by 0x682219: handle_one_connection (sql_connect.cc:1231)
==10277== by 0x548DE99: start_thread (pthread_create.c:308)
==10277== by 0x5F9ACBC: clone (clone.S:112)
==10277== Address 0xf873976 is 134 bytes inside a block of size 148 free'd
==10277== at 0x4C2A82E: free (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
==10277== by 0xB7477E: _myfree (safemalloc.c:337)
==10277== by 0x56B571: String::free() (sql_string.h:240)
==10277== by 0x65165D: Field_blob::free() (field.h:1896)
==10277== by 0x6FB69C: free_blobs(st_table*) (table.cc:2531)
==10277== by 0x8C1684: sp_rcontext::~sp_rcontext() (sp_rcontext.cc:58)
==10277== by 0x8BA4E7: sp_head::execute_procedure(THD*, List<Item>*) (sp_head.cc:2069)
==10277== by 0x68F73B: mysql_execute_command(THD*) (sql_parse.cc:4500)
==10277== by 0x8BC917: sp_instr_stmt::exec_core(THD*, unsigned int*) (sp_head.cc:2976)
==10277== by 0x8BC22C: sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) (sp_head.cc:2794)
==10277== by 0x8BC6D9: sp_instr_stmt::execute(THD*, unsigned int*) (sp_head.cc:2919)
==10277== by 0x8B8590: sp_head::execute(THD*) (sp_head.cc:1283)
==10277== by 0x8B911A: sp_head::execute_trigger(THD*, st_mysql_lex_string const*, st_mysql_lex_string const*, st_grant_info*) (sp_head.cc:1586)
==10277== by 0x8CF381: Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool) (sql_trigger.cc:2130)
==10277== by 0x6F00E7: fill_record_n_invoke_before_triggers(THD*, List<Item>&, List<Item>&, bool, Table_triggers_list*, trg_event_type) (sql_base.cc:8747)
==10277== by 0x746914: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:808)

Elena Stepanova added a comment - 2013-08-21 02:57 There turns out to be a valgrind issue (Invalid read), which probably causes the problem. The valgrind warning is reproducible on MariaDB 5.3, 5.5 and on MySQL 5.5, 5.6; but not on MariaDB 10.0.4. The rest is apparently the matter of luck, depending on what the invalid read has read. Are you willing to file a bug report at bugs.mysql.com? We usually report upstream bugs to MySQL as well. Stack trace from MariaDB 5.3: ==10277== Thread 4: ==10277== Invalid read of size 1 ==10277== at 0x4C2D1A0: memcpy@@GLIBC_2.14 (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so) ==10277== by 0x9341B1: _mi_rec_pack (mi_dynrec.c:1015) ==10277== by 0x931674: _mi_write_blob_record (mi_dynrec.c:300) ==10277== by 0x954E5E: mi_write (mi_write.c:149) ==10277== by 0x90FA6A: ha_myisam::write_row(unsigned char*) (ha_myisam.cc:851) ==10277== by 0x810272: handler::ha_write_row(unsigned char*) (handler.cc:4978) ==10277== by 0x748E05: write_record(THD*, st_table*, st_copy_info*) (sql_insert.cc:1692) ==10277== by 0x746C0A: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:887) ==10277== by 0x68B560: mysql_execute_command(THD*) (sql_parse.cc:3253) ==10277== by 0x6946B3: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173) ==10277== by 0x68610E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243) ==10277== by 0x68537F: do_command(THD*) (sql_parse.cc:923) ==10277== by 0x682219: handle_one_connection (sql_connect.cc:1231) ==10277== by 0x548DE99: start_thread (pthread_create.c:308) ==10277== by 0x5F9ACBC: clone (clone.S:112) ==10277== Address 0xf873978 is 136 bytes inside a block of size 148 free'd ==10277== at 0x4C2A82E: free (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so) ==10277== by 0xB7477E: _myfree (safemalloc.c:337) ==10277== by 0x56B571: String::free() (sql_string.h:240) ==10277== by 0x65165D: Field_blob::free() (field.h:1896) ==10277== by 0x6FB69C: free_blobs(st_table*) (table.cc:2531) ==10277== by 0x8C1684: sp_rcontext::~sp_rcontext() (sp_rcontext.cc:58) ==10277== by 0x8BA4E7: sp_head::execute_procedure(THD*, List<Item>*) (sp_head.cc:2069) ==10277== by 0x68F73B: mysql_execute_command(THD*) (sql_parse.cc:4500) ==10277== by 0x8BC917: sp_instr_stmt::exec_core(THD*, unsigned int*) (sp_head.cc:2976) ==10277== by 0x8BC22C: sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) (sp_head.cc:2794) ==10277== by 0x8BC6D9: sp_instr_stmt::execute(THD*, unsigned int*) (sp_head.cc:2919) ==10277== by 0x8B8590: sp_head::execute(THD*) (sp_head.cc:1283) ==10277== by 0x8B911A: sp_head::execute_trigger(THD*, st_mysql_lex_string const*, st_mysql_lex_string const*, st_grant_info*) (sp_head.cc:1586) ==10277== by 0x8CF381: Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool) (sql_trigger.cc:2130) ==10277== by 0x6F00E7: fill_record_n_invoke_before_triggers(THD*, List<Item>&, List<Item>&, bool, Table_triggers_list*, trg_event_type) (sql_base.cc:8747) ==10277== by 0x746914: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:808) ==10277== Invalid read of size 1 ==10277== at 0x4C2D1AD: memcpy@@GLIBC_2.14 (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so) ==10277== by 0x9341B1: _mi_rec_pack (mi_dynrec.c:1015) ==10277== by 0x931674: _mi_write_blob_record (mi_dynrec.c:300) ==10277== by 0x954E5E: mi_write (mi_write.c:149) ==10277== by 0x90FA6A: ha_myisam::write_row(unsigned char*) (ha_myisam.cc:851) ==10277== by 0x810272: handler::ha_write_row(unsigned char*) (handler.cc:4978) ==10277== by 0x748E05: write_record(THD*, st_table*, st_copy_info*) (sql_insert.cc:1692) ==10277== by 0x746C0A: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:887) ==10277== by 0x68B560: mysql_execute_command(THD*) (sql_parse.cc:3253) ==10277== by 0x6946B3: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173) ==10277== by 0x68610E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243) ==10277== by 0x68537F: do_command(THD*) (sql_parse.cc:923) ==10277== by 0x682219: handle_one_connection (sql_connect.cc:1231) ==10277== by 0x548DE99: start_thread (pthread_create.c:308) ==10277== by 0x5F9ACBC: clone (clone.S:112) ==10277== Address 0xf873976 is 134 bytes inside a block of size 148 free'd ==10277== at 0x4C2A82E: free (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so) ==10277== by 0xB7477E: _myfree (safemalloc.c:337) ==10277== by 0x56B571: String::free() (sql_string.h:240) ==10277== by 0x65165D: Field_blob::free() (field.h:1896) ==10277== by 0x6FB69C: free_blobs(st_table*) (table.cc:2531) ==10277== by 0x8C1684: sp_rcontext::~sp_rcontext() (sp_rcontext.cc:58) ==10277== by 0x8BA4E7: sp_head::execute_procedure(THD*, List<Item>*) (sp_head.cc:2069) ==10277== by 0x68F73B: mysql_execute_command(THD*) (sql_parse.cc:4500) ==10277== by 0x8BC917: sp_instr_stmt::exec_core(THD*, unsigned int*) (sp_head.cc:2976) ==10277== by 0x8BC22C: sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) (sp_head.cc:2794) ==10277== by 0x8BC6D9: sp_instr_stmt::execute(THD*, unsigned int*) (sp_head.cc:2919) ==10277== by 0x8B8590: sp_head::execute(THD*) (sp_head.cc:1283) ==10277== by 0x8B911A: sp_head::execute_trigger(THD*, st_mysql_lex_string const*, st_mysql_lex_string const*, st_grant_info*) (sp_head.cc:1586) ==10277== by 0x8CF381: Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool) (sql_trigger.cc:2130) ==10277== by 0x6F00E7: fill_record_n_invoke_before_triggers(THD*, List<Item>&, List<Item>&, bool, Table_triggers_list*, trg_event_type) (sql_base.cc:8747) ==10277== by 0x746914: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:808)

Jonas Reinhardt added a comment - 2013-08-21 12:11

OK, Filed mysql bug report:
http://bugs.mysql.com/bug.php?id=70104

Jonas Reinhardt added a comment - 2013-08-21 12:11 OK, Filed mysql bug report: http://bugs.mysql.com/bug.php?id=70104

Jonas Reinhardt added a comment - 2014-02-03 19:41 - edited

While waiting for a version that is fixed I use the following workaround inside a few triggers.
(Perhaps its always working with user variables, or we are just lucky below, but so far it has been working, no POINT(0 0) detected)

  IF (NEW.data is not null) THEN

    CALL DataToGeometry(NEW.data, NEW.g);

    IF (NEW.g is null) or (AsText(NEW.g) is null) THEN

      SET @data=NEW.data,@g=null;

      CALL DataToGeometry(@data, @g);

      IF (@g is null) or (AsText(@g) is null) THEN

        SET NEW.g=GeomFromText(concat('POINT(0 0)'));

      ELSE

        NEW.g=@g;

      END IF;

    END IF;

  END IF;

(DataToGeometry procedure converts a formated string into a geometry)

Jonas Reinhardt added a comment - 2014-02-03 19:41 - edited While waiting for a version that is fixed I use the following workaround inside a few triggers. (Perhaps its always working with user variables, or we are just lucky below, but so far it has been working, no POINT(0 0) detected) IF (NEW.data is not null ) THEN CALL DataToGeometry(NEW.data, NEW.g); IF (NEW.g is null ) or (AsText(NEW.g) is null ) THEN SET @data=NEW.data,@g= null ; CALL DataToGeometry(@data, @g); IF (@g is null ) or (AsText(@g) is null ) THEN SET NEW.g=GeomFromText(concat( 'POINT(0 0)' )); ELSE NEW.g=@g; END IF ; END IF ; END IF ; (DataToGeometry procedure converts a formated string into a geometry)

Elena Stepanova added a comment - 2014-11-16 00:04

The upstream bug is said to have been fixed in 5.7.3.
I still can't reproduce the problem on 10.0, only on 5.x ( (5.5 produces NULLs if not the valgrind warning).
So I leave it to holyfoot to decide whether to fix it in 5.5.
Raising the priority to get it moved somewhere – either fix or close as "won't fix".

Elena Stepanova added a comment - 2014-11-16 00:04 The upstream bug is said to have been fixed in 5.7.3. I still can't reproduce the problem on 10.0, only on 5.x ( (5.5 produces NULLs if not the valgrind warning). So I leave it to holyfoot to decide whether to fix it in 5.5. Raising the priority to get it moved somewhere – either fix or close as "won't fix".

Alexey Botchkov added a comment - 2015-06-08 14:13

Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-June/008013.html

Alexey Botchkov added a comment - 2015-06-08 14:13 Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-June/008013.html

MariaDB Server

Stored Procedure - Geometry parameter not working

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration