Questions tagged [mariadb-10.11]
5 questions
2
votes
1 answer
JSON_CONTAINS in HAVING clause adds extra closing brace to JSON_OBJECTAGG
I have a table with data we've collected from various sources. It's got the item name, the source and the source's value.
The table looks like the…
gen_Eric
- 121
- 4
1
vote
1 answer
Replication - replica falling behind while mysqldump is taken
I am pretty inexperienced with MariaDB, especially replication. However, being 'on call duty' I have an issue with this today.
it looks like my replica is falling behind while I am taking a mysqldump of the replica.
Is this to be expected behavior…
vrms
- 269
- 1
- 4
- 12
1
vote
1 answer
Duplicating tables from database1 to database2 LIKE on same server fails, error 1064
I've been reading the MariaDB manual and tutorials and apparently this should work:
EXPLAIN CREATE TABLE `prefix_database2`.`table1` LIKE `prefix_database1`.`table1`;`
The LIKE operator is supposed to duplicate the table columns and keys. I'm at a…
John
- 757
- 1
- 10
- 23
0
votes
3 answers
Upgrading from mariadb 10.11.8 to 11.4.5 gives warning about ERROR 1267 Illegal mix of collations
As title says I upgraded my mariadb, all fine and no issues, ran mariadb-upgrade and all fine but now every time i start mariadb I see this errors
Mar 27 03:38:42 db3 debian-start[2408864]: SELECT count(*) FROM mysql.user WHERE user='root' and…
Freedo
- 206
- 2
- 10
0
votes
2 answers
How to optimize multiple WHEN that are using differents static string?
I have a table like that:
Id
Note
Client
1
Long note that havemultiple linesClient: Name
null
2
Anoter note that have multiple linesCustomer: Name
null
3
Third note that have multiple linesClient : Nameline
null
4
Line: AClient :…
Elikill58
- 181
- 3
- 11