← Back to team overview

maria-discuss team mailing list archive

Re: SQL_MODE=ORACLE documentation

 

Glad to hear that the plan is writing a detailed documentation. I'll probably contribute as I did in the past, but I definitely don't have the time to find out the correct syntaxes myself.
Yes, separate pages with links (where applicable) should be clear. IMHO, putting everything in the same pages would be confusing and not useful: if I need to check a PL/SQL syntax, I don't need to see the corresponding native MariaDB syntax.
Federico



      Da: Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>
 A: Alexander Barkov <bar@xxxxxxxxxxx> 
Cc: Federico Razzoli <federico_raz@xxxxxxxx>; Maria Discuss <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Inviato: Lunedì 5 Marzo 2018 9:58
 Oggetto: Re: [Maria-discuss] SQL_MODE=ORACLE documentation
   
IMHO, putting pointers each others will help instead of putting Oracle Syntax in the mainline pages. This may cause confusion for the people who never used oracle in firsthand. 
On Mon, Mar 5, 2018 at 2:11 PM, Alexander Barkov <bar@xxxxxxxxxxx> wrote:

Hello Federico,

On 03/02/2018 07:12 PM, Federico Razzoli wrote:

With SQL_MODE='ORACLE' a completely new syntax has been introduced. Basic syntax constructs of MariaDB become unavailable, but not all Oracle syntax seems to be supported. Is there any plan to document the supported syntax? Current documentation looks like an unfinished draft and doesn't save much time for the poor user.


The difference between the native MariaDB (SQL/PSM based) syntax
and the Oracle PL/SQL syntax is described as a summary here:

https://mariadb.com/kb/en/libr ary/sql_modeoracle-from-mariad b-103/

Yes, the documentation will be improving.

We need to decide if we want two separate SQL/PSM and PL/SQL pages
on every topic.

For example, for the WHILE loop syntax,
do we need an new PL/SQL article similar to
https://mariadb.com/kb/en/libr ary/while/ ,
or should we put the PL/SQL WHILE syntax directly
on this page.

What do you think would be more readable?

I'm slightly inclined towards having separate pages
for SQL/PSM and PL/SQL, with links to each other
in the "See Also" section.






Regards,
Federico



______________________________ _________________
Mailing list: https://launchpad.net/~maria-d iscuss
Post to     : maria-discuss@lists.launchpad. net
Unsubscribe : https://launchpad.net/~maria-d iscuss
More help   : https://help.launchpad.net/Lis tHelp



______________________________ _________________
Mailing list: https://launchpad.net/~maria-d iscuss
Post to     : maria-discuss@lists.launchpad. net
Unsubscribe : https://launchpad.net/~maria-d iscuss
More help   : https://help.launchpad.net/Lis tHelp




   

References