Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.3]

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL.

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL. Since version 10.0 MariaDB has veered off MySQL and now implements a different set of features.

MariaDB 10.3 implements system-versioning tables, PERCENTILE_CONT(), PERCENTILE_DISC(), and MEDIAN() window functions, INTERSECT and EXCEPT clauses, cursors with parameters, LIMIT in multi-table updates, LIMIT in GROUP_CONCAT(), and many other new features.

171 questions
0
votes
0 answers

SELECT in MariaDB 10.3 which finds all records with and without spaces

I have a query for SELECT in MariaDB 10.3, which finds all records with and without spaces (accepting accents at the same time). Spaces can be anywhere (after each character, for example). If I have in the database in the column 'code' value: ŘCT…
user2095758
  • 21
  • 2
0
votes
1 answer

Unique keys > 3072 bytes allowed in MariaDB versions > 10.5

I discovered the normal 3072 byte key limitation in MariaDB 10.3 while running this statement: ALTER TABLE table1 ADD UNIQUE INDEX idx_my_composite_uniqueai_usr_email_uniq (table2_uuid ASC, table3_uuid ASC, text_column ASC) Which gave the expected…
Geyser14
  • 1,385
  • 3
  • 14
  • 32
0
votes
0 answers

How to use subprocess.run to run sql from a file

I'm trying to get a Python script to work that downloads a file and then loads the data into a mariadb. My best option seems to be using subprocess.run, as I cannot update the Python version to a version that includes the new mariadb connector. I've…
Joost
  • 82
  • 1
  • 9
0
votes
2 answers

Create index on timestamp delivered by JSON - incorrect datetime value

I constantly retrieve JSON data from some API and put that data into a MariaDB table. The JSON ships with a timestamp which I'd like to place an index on, because this attribute is used for querying the table. The JSON looks something like this…
dovregubben
  • 364
  • 2
  • 16
0
votes
1 answer

How to insert all parents id in pivot table (MariaDB 10.3)

I have the following tables: Announcements: id | title | body ----------------------- 1 | test1 | test body1 2 | test2 | test body2 3 | test3 | test body3 Tags: id | title | parent_id ------------------------- 1 | tag1 | (NULL) 2 | tag2 |…
George Stinis
  • 1
  • 1
0
votes
0 answers

Failed to open file, Error 2 - MySQL Import

I'm trying to import a MySQL Database via command line (Terminal). The file's path seems to be correct, but I keep getting an error message that is most likely showing that, the path of the SQL file I'm importing is not correct. Below is the sample…
P. Paul
  • 111
  • 1
  • 6
0
votes
0 answers

Unable to resolve name [org.hibernate.dialect.MariaDBDialect] as strategy [org.hibernate.dialect.Dialect]

I am trying to read the database configurations from yml file but getting the exception while trying to read it . org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path…
nee nee
  • 79
  • 4
0
votes
0 answers

phpmyAdmin not working after using MySQL/MariaDB upgrade on WHM

My Moodle site required I upgrade its database from MySQL 5.7.3 to MariaDB 10.2. I upgraded it to 10.3 through the MySQL/MariaDB Upgrade package on WHM, but after the upgrade, it gave this error: "The MySQL/MariaDB server is not currently running.…
Dominion Ikpeawujor
  • 1
0
votes
0 answers

ER_UNKNOWN_STMT_HANDLER when executing a batch insert

Trying to do a batch insert, but I keep hitting a ER_UNKNOWN_STMT_HANDLER error. I managed to rewrite it useing query, but I would like to figure out how to do it using batch Here is the code I have: result = await conn.batch("INSERT INTO…
PrivatMamtora
  • 2,072
  • 2
  • 19
  • 29
0
votes
0 answers

WHERE IN changed from ALL to RANGE type query based on number of arguments

I couldn't find a similar question on SO so my apologies if this is a duplicate, but I have 2 seemingly equivalent queries, however they're not executed in the same way which is detrimental for query times. The first query executes in a matter of a…
jlos
  • 1,010
  • 1
  • 8
  • 12
0
votes
2 answers

Mysql event not working in the server. Same code worked in local

DROP EVENT `game_insert`; CREATE DEFINER=`numberBetting_user`@`%` EVENT `game_insert` ON SCHEDULE EVERY 5 MINUTE STARTS '2021-08-18 17:25:29' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN UPDATE `game` set `status` =0 where `status`=1; INSERT INTO…
Selsons Software
  • 23
  • 6
0
votes
1 answer

how to remove null values after union join in maria db?

After the union the result is given above I want to remove the empty field in test_values column the query used for union is > SELECT tt.test_name,tt.test_category,report.test_values,tt.unit FROM > report LEFT JOIN tt ON report.test_id = tt.id…
damanpreet singh
  • 109
  • 2
  • 5
0
votes
0 answers

Insert on duplicate key fails if nonaffected values not provided?

I encountered a strange behavior with MariaDB 10.3.29 today. Here is the table in question: CREATE TABLE `quick` ( `userid` int(11) NOT NULL, `room1` varchar(32) NOT NULL, `room2` varchar(32) NOT NULL, `room3` varchar(32) NOT NULL, `room4`…
InterLinked
  • 1,247
  • 2
  • 18
  • 50
0
votes
1 answer

EF Core and Pomelo 5.0 - how to query the json column

I'm using last version of json implementation in Pomelo 5.0 and configure my maria server to use microsoft json serialisation. var serverVersion = new MariaDbServerVersion(new Version(10, 3, 0)); …
C. Rozan
  • 1
  • 2
0
votes
2 answers

SQL distinct Worked Dates across Projects excluding Break Dates

Consider the following schema; CREATE TABLE `Project Assignment` (`Employee` varchar(1), `Project Id` int, `Project Assignment Date` date, `Project Relieving Date` date) ; INSERT INTO `Project Assignment` (`Employee`, `Project Id`, `Project…
vamyip
  • 1,161
  • 1
  • 10
  • 35
1 2 3
…
11 12