Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.6.9
-
None
-
ubuntu jammy
Description
Hi,
I have created a test for mariadb 10.6.9 on Jammy in a qemu instance but .. on a fresh install I get
Database changed
|
MariaDB [mysql]> show databases;
|
ERROR:
|
MariaDB [mysql]> show tables;
|
+---------------------+
|
| Database |
|
+---------------------+
|
| _mysql_housekeeping |
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
| sys |
|
+---------------------+
|
5 rows in set (0.000 sec)
|
|
|
MariaDB [mysql]> show functions;
|
+---------------------------+
|
| Tables_in_mysql |
|
+---------------------------+
|
| column_stats |
|
| columns_priv |
|
| db |
|
| event |
|
| func |
|
| general_log |
|
| global_priv |
|
| gtid_slave_pos |
|
| help_category |
|
| help_keyword |
|
| help_relation |
|
| help_topic |
|
| index_stats |
|
| innodb_index_stats |
|
| innodb_table_stats |
|
| plugin |
|
| proc |
|
| procs_priv |
|
| proxies_priv |
|
| roles_mapping |
|
| servers |
|
| slow_log |
|
| table_stats |
|
| tables_priv |
|
| time_zone |
|
| time_zone_leap_second |
|
| time_zone_name |
|
| time_zone_transition |
|
| time_zone_transition_type |
|
| transaction_registry |
|
| user |
|
+---------------------------+
|
31 rows in set (0.000 sec)
|
|
|
MariaDB [mysql]>
|
MariaDB [mysql]> show functions;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'functions' at line 1
|
or
mysql mysql
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 19
|
Server version: 10.6.9-MariaDB-1:10.6.9+maria~ubu2204
|
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [mysql]> repair table proc;
|
+---------------------------------+
|
| @@version_comment |
|
+---------------------------------+
|
| mariadb.org binary distribution |
|
+---------------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [mysql]>
|
packages installed
ii libmariadb3:amd64 1:10.6.9+maria~ubu2204 amd64 MariaDB database client library
|
ii mariadb-client 1:10.6.9+maria~ubu2204 all MariaDB database client (metapackage depending on the latest version)
|
ii mariadb-client-10.6 1:10.6.9+maria~ubu2204 amd64 MariaDB database client binaries
|
ii mariadb-client-core-10.6 1:10.6.9+maria~ubu2204 amd64 MariaDB database core client binaries
|
ii mariadb-common 1:10.6.9+maria~ubu2204 all MariaDB common configuration files
|
ii mariadb-server-10.6 1:10.6.9+maria~ubu2204 amd64 MariaDB database server binaries
|
ii mariadb-server-core-10.6 1:10.6.9+maria~ubu2204 amd64 MariaDB database core server files
|
i libmysqlclient21:amd64 8.0.30-0ubuntu0.22.04.1 amd64 MySQL database client library
|
ii mysql-common 1:10.6.9+maria~ubu2204 all MariaDB database common files (e.g. /etc/mysql/my.cnf)
|
I also see this when connection from the python library mysql connector. First select always gives a out of index error .. second select works.
all of it installed from mariadb downloads.
I also did a test of 10.6.9 on Focal and that works as expected.