 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
BUG: SQL Reference and CREATE DATABASE (MariaDB) |
|
I've run into a minor error using the SQL Reference. It shows the following for CREATE SCHEMA (Mariadb). Both character set and collate can be used in a single CREATE SCHEMA statement, but to use SQL Reference to add them both, I have to click that comma highlighted in red. That will actually add a comma to the statement, but adding it there makes this a syntax error.

|
|
Fri Apr 24, 2020 5:19 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you. According to https://mariadb.com/kb/en/create-database/ there is no comma in the syntax. I submitted a defect for this issue #SA0038501
I also verified the the graphical method for creating new schema generates valid SQL syntax.
Right-click any schema in Database Explorer -> Click the "New..." menu

|
|
Sat Apr 25, 2020 11:26 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
Thank you very much!
|
|
Mon Apr 27, 2020 8:24 am |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 846 Country: United States |
|
|
|
Am I losing my mind? This is the second or third time I've seen SQL Assistant screenshots that look like it's running in MacOS.
|
|
Tue Apr 28, 2020 11:40 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
Yeah, I always think, I can depart Windows but then suddenly I wake up and remember, that just a theme :)

|
|
Tue Apr 28, 2020 12:14 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Right. That's what it is. It's a Mac theme, not a screenshot from an iOS system.
But the actual theme selection is in a different place, it's target specific. The place you are pointing to is where you customize theme features if you don't like the predefined colors and fonts.
Please see below

|
|
Tue Apr 28, 2020 1:44 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|