14,635 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
37
views
MariaDB: json is persisted as longtext and does not work anymore for json_value
I have following SQL (for MariaDB)
select
t.id AS id,
r.i AS i,
json_value(r.res, '$[0]') AS lat
from
tasks t
join JSON_TABLE(json_query(t.expected_answer, '$.accepted_polygons[0]'), '$...
2
votes
3
answers
109
views
How to extract the correct server version from a MySQLDump?
We are creating docker images from MySQLdump from all kind of systems and try to extract the DB version via Regex from files like this:
-- Server version 10.11.8-MariaDB-0ubuntu0.24.04.1
$ echo &...
Alex's user avatar
- 35.8k
2
votes
1
answer
108
views
How to avoid SSL being enforced with the MySQL/mariadb connector
Consider this minimal example program:
#include <mysql/mysql.h>
#include <stdio.h>
int main() {
MYSQL *conn = mysql_init(NULL);
unsigned int mode = SSL_MODE_DISABLED;
...
1
vote
2
answers
125
views
Using LIMIT clause in partition by
For each minute there is some data stored in a MariaDB 12.1.2.
For each minute I want to find the rows with
percent_change_1h > 4 and percent_change_24h > 2;
But only for the top 30 rows sort ...
1
vote
3
answers
189
views
How to count the number of matching characters in two strings of the same length?
Is there a way to count the number of matching characters between two strings (of the same length) in MariaDB?
Like if we have "keyboard" and "ekyboard" then the answer should be 6 ...
0
votes
2
answers
72
views
MariaDB / QMySqlDriver connection without SSL got 2026 error
My problem:
A MariaDB-Server is running in a LAMPP-Installation
It runs by default without SSL.
A Qt-Application (both 5.15.2 and 6.10.1) with loaded QMARIADB-Driver tried to open a connection to the ...
0
votes
3
answers
122
views
Example .gitlab-ci.yml for Laravel 12 with MariaDB that seeds database before running php artisan test
I'm setting up a GitLab Runner for a Laravel 12 project and I want my CI pipeline to do the following:
Spin up a MariaDB service for the tests
Run php artisan migrate:fresh --seed to seed the ...
0
votes
2
answers
138
views
How to turn off SSL from the Windows client library mariadb connector-c 3.4.8 win64 [closed]
After installing the SDK mariadb-connector-c-3.4.8-win64.msi, when I try to connect to a server using MariaDB, I get "TLS/SSL error: SSL is required, but the server does not support it".
...
0
votes
0
answers
69
views
AWS RDS MariaDB query surprisingly slow on single value result
I have the following tables:
create table account_transactions
(
id int auto_increment primary key,
account_id int not null,
amount ...
0
votes
1
answer
49
views
MariaDB / XAMPP: "Table '.\mysql\proxies_priv' is marked as crashed and last repair failed" — fixed by manually repairing Aria tables
I ran into an issue where MariaDB in XAMPP refused to start and showed this error:
Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
Fatal error: Can't open and ...
1
vote
1
answer
90
views
Function definition in mariadb 10.11.13 syntax error - typical message for a missing semicolon, but the semicolon is there [closed]
DELIMITER //
CREATE FUNCTION total_cost_for_customer (
custNumber INT
)
RETURNS INT
DETERMINISTIC
READS SQL DATA
BEGIN
DECLARE total INT;
SELECT SUM(unitPrice)
INTO total
FROM ...
2
votes
1
answer
122
views
QSqlQuery in Qt6: in-place vs prepared
First of all, Qt version is 6.10.0, testing on Arch Linux rolling. I think I've found a bug in Qt but maybe it's just my fault.
My program asks MariaDB database for some data and displays it in ...
Advice
0
votes
2
replies
44
views
Remote access to Xampp (mariadb)
I would like to store data remotely in a MariaDB (Xampp) running on Ubuntu. It is running on a totally isolated LAN - no external connection.
I have been looking at various places, but seem to be more ...
1
vote
2
answers
110
views
How do I use a json array to search and extract matched values from a different json array in mariaDB?
Situation
I have two tables. ing_master is a master list of ingredients; pdet is a product table, with an ingredients field formatted as json array.
For each product's ingredient list in pdet, I want ...
3
votes
1
answer
114
views
Cause of and means to avoid "flat BNL join" in mariadb 10.11
I'm trying to help a user in another stackoverflow question and have bumped by head into a strange behaviour.
As I rarely use MariaDB, I'm opening another question to investigate the behaviour,
...