SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG: SQL Reference and CREATE DATABASE (MariaDB)

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
BUG: SQL Reference and CREATE DATABASE (MariaDB)
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post BUG: SQL Reference and CREATE DATABASE (MariaDB) Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Thank you very much!
Mon Apr 27, 2020 8:24 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 668
Country: United States

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.