[Gambas-bugtracker] Bug #2777: DataSource Save method malfunction

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2777&from=L21haW4-

Comment #7 by Gianluigi GRADASCHI:

MySQL
====

'Save' separate works fine

2023-08-25 10:37:49.627 gb.db.mysql: 0x55f33277b310: show tables
2023-08-25 10:37:49.628 gb.db.mysql: 0x55f33277b310: show index from `t_flowers`
2023-08-25 10:37:49.637 gb.db.mysql: 0x55f33277b310: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:37:49.673 gb.db.mysql: 0x55f33277b310: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:37:49.710 gb.db.mysql: 0x55f33277b310: SELECT `name`,`id_flower` FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:37:49.711 gb.db.mysql: 0x55f33277b310: SELECT * FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:38:19.544 gb.db.mysql: 0x55f33277b310: show full columns from `t_flowers`
2023-08-25 10:38:19.545 gb.db: 'RETURNING' keyword is not supported by this 'mysql' connection
2023-08-25 10:38:19.545 gb.db.mysql: 0x55f33277b310: show index from `t_flowers`
2023-08-25 10:38:19.547 gb.db.mysql: 0x55f33277b310: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Pippo', NULL )
2023-08-25 10:38:19.574 gb.db.mysql: 0x55f33277b310: SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY `name`,`id_flower`) AS __index FROM `t_flowers`) AS __pg_sucks WHERE `id_flower` = NULL LIMIT 1
2023-08-25 10:38:19.575 gb.db.mysql: 0x55f33277b310: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:38:19.595 gb.db.mysql: 0x55f33277b310: SELECT `name`,`id_flower` FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:38:19.596 gb.db.mysql: 0x55f33277b310: SELECT * FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:38:49.543 gb.db.mysql: 0x55f33277b310: SELECT * FROM `t_flowers` WHERE `id_flower` = 7
2023-08-25 10:38:49.544 gb.db.mysql: 0x55f33277b310: show full columns from `t_flowers`
2023-08-25 10:38:49.546 gb.db.mysql: 0x55f33277b310: show index from `t_flowers`
2023-08-25 10:38:49.547 gb.db.mysql: 0x55f33277b310: UPDATE `t_flowers` SET `name` = 'Pippo', `date` = '2023-08-25 00:00:00' WHERE `id_flower` = 7
2023-08-25 10:38:49.575 gb.db.mysql: 0x55f33277b310: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:38:49.594 gb.db.mysql: 0x55f33277b310: SELECT `name`,`id_flower` FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:38:49.594 gb.db.mysql: 0x55f33277b310: SELECT * FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256

Search works fine too:

2023-08-25 10:41:26.125 gb.db.mysql: 0x563e514c93f0: show tables
2023-08-25 10:41:26.126 gb.db.mysql: 0x563e514c93f0: show index from `t_flowers`
2023-08-25 10:41:26.136 gb.db.mysql: 0x563e514c93f0: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:41:26.171 gb.db.mysql: 0x563e514c93f0: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-25 10:41:26.191 gb.db.mysql: 0x563e514c93f0: SELECT `name`,`id_flower` FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:41:26.191 gb.db.mysql: 0x563e514c93f0: SELECT * FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-25 10:41:38.966 gb.db.mysql: 0x563e514c93f0: SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY `name`,`id_flower`) AS __index FROM `t_flowers`) AS __pg_sucks WHERE name = 'Ranunkel' LIMIT 1
2023-08-25 10:42:25.301 gb.db.mysql: 0x563e514c93f0: SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY `name`,`id_flower`) AS __index FROM `t_flowers`) AS __pg_sucks WHERE date = '2019-06-04 00:00:00' LIMIT 1

Thank you

Gianluigi