Shard Query Unsupported Features

Jump to bottom Edit New page

Justin Swanhart edited this page Oct 12, 2013 · 1 revision

List of unsupported features

CREATE/DROP/ALTER/USE database

All access is via one abstracted virtual schema/database
Schemas are created using the shards.ini file
Access is denied to the mysql database

Temporary Tables

Temporary tables are not supported

Auxilliary functions

found_rows()
last_insert_id()
sql_calc_found_rows()
row_count()
connection_id()
current_user()
session_user()
user()
system_user()
database() / schema()

Replication functions

master_pos_wait()
name_const()

Locking

get_lock()
free_lock()
is_free_lock()
is_used_lock()
release_lock()
lock table
lock tables
unlock tables
SELECT ... FOR UPDATE
SELECT ... LOCK IN SHARE MODE

User variable assignment

:=
INTO clause

Bulk loading

LOAD DATA INFILE (use provided external loader)
LOAD_FILE

SHOW commands

show master status
show slave status
show binlogs
show binary logs
show create database
show databases
show logs
show mutex
show engine
show innodb
show open
show privileges
show status
show variables

Maintainance operations

check table
checksum table
backup table
repair table
restore table

Stored Routine invocation

call
do

NoSQL

handler

Transactions

begin
start transaction
commit
rollback
set transaction
savepoint

XA

xa start
xa begin
xa end
xa prepare
xa commit
xa rollback
xa recover