SQL commands convert schema name ton lowercase
Database management in a single PHP file
Brought to you by:
jakubvrana
When i try to write SQL commands, schema name are systematically lowercased, but meaning the feedback inconsistant.
Having a schema already created, named "TEST" (capitalized)
I try « CREATE TABLE TEST.test_schema ( id integer ); »
I got :
«
CREATE TABLE TEST.test_schema ( id integer )
Error in query: ERROR: schema "test" does not exist
»
but writing « create schema TEST; »
leads to :
«
create schema TEST
Query executed OK, 0 rows affected. (0.015 s) Edit
»
in fact, the credated schema is named "test" in lowercase.
This doesn't look like Adminer bug. Adminer just passes the SQL command to the server.