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

[bugtracker at gambaswiki.org]

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

Comment #6 by Gianluigi GRADASCHI:

POSTGRESQL
==========

If I save in two separate times I always get "Type mismatch", this is the output relating to the date:
==
2023-08-25 09:22:37.398 gb.db.postgresql: 0x5563e1130c80: SELECT * FROM "t_flowers" WHERE "id_flower" = 7
2023-08-25 09:22:37.399 gb.db.postgresql: 0x5563e1130c80: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute LEFT JOIN pg_catalog.pg_attrdef  ON (pg_attrdef.adnum = pg_attribute.attnum AND pg_attrdef.adrelid = pg_attribute.attrelid) LEFT JOIN pg_collation ON (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:22:37.400 gb.db.postgresql: 0x5563e1130c80: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum

Instead, if I save both data: both the name and the date, it works correctly and this is the output:
==
2023-08-25 09:26:46.128 gb.db.postgresql: 0x5631d46e7220: select relname from pg_class where (relkind in ('r', 'v', 'm', 'p')) and (relname = 't_flowers') and (relnamespace in (select oid from pg_namespace where nspname = 'public'))
2023-08-25 09:26:46.128 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.130 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:26:46.130 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:26:46.131 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:26:46.131 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:26:46.132 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:26:46.132 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:26:46.134 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:26:46.135 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.137 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.143 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.148 gb.db.postgresql: 0x5631d46e7220: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-25 09:26:46.150 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.151 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:26:46.160 gb.db.postgresql: 0x5631d46e7220: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-25 09:26:46.167 gb.db.postgresql: 0x5631d46e7220: SELECT "name","id_flower" FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-25 09:26:46.170 gb.db.postgresql: 0x5631d46e7220: SELECT * FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-25 09:27:13.635 gb.db.postgresql: 0x5631d46e7220: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute LEFT JOIN pg_catalog.pg_attrdef  ON (pg_attrdef.adnum = pg_attribute.attnum AND pg_attrdef.adrelid = pg_attribute.attrelid) LEFT JOIN pg_collation ON (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:27:13.637 gb.db.postgresql: 0x5631d46e7220: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:27:13.640 gb.db.postgresql: 0x5631d46e7220: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2023-08-25 00:00:00', E'Pippo' ) RETURNING "id_flower"
2023-08-25 09:27:13.649 gb.db.postgresql: 0x5631d46e7220: SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY "name","id_flower") AS __index FROM "t_flowers") AS __pg_sucks WHERE "id_flower" = 7 LIMIT 1
2023-08-25 09:27:13.651 gb.db.postgresql: 0x5631d46e7220: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-25 09:27:13.652 gb.db.postgresql: 0x5631d46e7220: SELECT "name","id_flower" FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-25 09:27:13.652 gb.db.postgresql: 0x5631d46e7220: SELECT * FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256

Seach by name and by date works well: here the output:
==
2023-08-25 09:31:51.212 gb.db.postgresql: 0x558690ad5130: select relname from pg_class where (relkind in ('r', 'v', 'm', 'p')) and (relname = 't_flowers') and (relnamespace in (select oid from pg_namespace where nspname = 'public'))
2023-08-25 09:31:51.212 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.214 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:31:51.214 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:31:51.214 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:31:51.215 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:31:51.215 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:31:51.216 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid 
2023-08-25 09:31:51.216 gb.db.postgresql: 0x558690ad5130: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-25 09:31:51.218 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.219 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.223 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.228 gb.db.postgresql: 0x558690ad5130: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-25 09:31:51.229 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.236 gb.db.postgresql: 0x558690ad5130: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-25 09:31:51.246 gb.db.postgresql: 0x558690ad5130: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-25 09:31:51.254 gb.db.postgresql: 0x558690ad5130: SELECT "name","id_flower" FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-25 09:31:51.255 gb.db.postgresql: 0x558690ad5130: SELECT * FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-25 09:32:09.241 gb.db.postgresql: 0x558690ad5130: SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY "name","id_flower") AS __index FROM "t_flowers") AS __pg_sucks WHERE name = E'Ranunkel' LIMIT 1
2023-08-25 09:32:49.329 gb.db.postgresql: 0x558690ad5130: 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
==

I pass to the test on MySQL which I send separately.

Thank you

Gianluigi

Gianluigi GRADASCHI changed the state of the bug to: Accepted.