https://bugs.freedesktop.org/show_bug.cgi?id=57994
--- Comment #3 from [email protected] --- (In reply to comment #2) > As I know the '*' it is only in the gui mode. Changing to edit in SQL view > '%' is the wildcard. > > In SQL the basic wildcard are '%'(*) as any and '_'(?) as one. This is the problem described in this bug: You could use wildcards in queries, which aren't wildcards when using the direct SQL input. So somebody would use the wildcard '*' in a query and says: "OK, that are the rows I will delete." Then he takes the same code in direct SQL input - and all data were lost. The difference you could see, when you change the query-editor and press the sql-button in this editor. Don't know, if we should change the importance to "critical". Loosing the whole data of a table due to a misleading SQL-code, which works in GUI-mode and doesen't work in direct-SQL-mode, is worst case for a database-user. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
