Special SQL mode?

Special SQL mode?

[Doug Lewan]

I work with a non-standard variant of SQL. (Don't ask.) I have, accordingly, a non-standard variant of SQL mode, defined via `(define-derived-mode pp-sql-mode sql-mode "PP sql" ...)'.

The stock SQL mode entry has been replaced in auto-mode-alist by `("\\.sql\\'" . pp-sql-mode)'. There is no other even remotely SQL-ish entry in auto-mode-alist. The variable  magic-mode-alist  is NIL, and there are no local file variables. Finally, there is no '#!'.

Nonetheless, my *.sql files automatically get SQL[ANSI] mode.

If the info about Choosing Major Modes is right, then I should not (if I'm smart enough to understand it). Apparently I'm not. Does anyone have a hint about what I might have missed?

Thanks.

,Douglas
Douglas Lewan
Shubert Ticketing
(201) 489-8600 ext 224

There is no national science just as there is no national multiplication table; what is national is no longer science. - Anton Chekov

Re: Special SQL mode?

[Stefan Monnier]

> Nonetheless, my *.sql files automatically get SQL[ANSI] mode.

When pp-sql-mode calls sql-mode, sql-mode registers
`sql-highlight-product' on `hack-local-variables-hook' (which is run
later, even after running the mode hooks) to select which SQL variant
should be used.

A quick hack would be for you to (remove-hook 'hack-local-variables-hook
'sql-highlight-product t).  But maybe another approach (instead of
or additionally to creating a derived-mode) would be to add an entry in
sql-product-alist for your "pp sql".


        Stefan

RE: Special SQL mode?

[Doug Lewan]

Stefan,

Thank you. These are details that I had known nothing about. I'll give your suggestions a try.

,Doug

> -----Original Message-----
> From: help-gnu-emacs-bounces+dougl=shubertticketing.com@gnu.org
> [mailto:help-gnu-emacs-bounces+dougl=shubertticketing.com@gnu.org] On
> Behalf Of Stefan Monnier
> Sent: Thursday, 2012 November 22 11:47
> To: help-gnu-emacs@gnu.org
> Subject: Re: Special SQL mode?
> 
> > Nonetheless, my *.sql files automatically get SQL[ANSI] mode.
> 
> When pp-sql-mode calls sql-mode, sql-mode registers
> `sql-highlight-product' on `hack-local-variables-hook' (which is run
> later, even after running the mode hooks) to select which SQL variant
> should be used.
> 
> A quick hack would be for you to (remove-hook 'hack-local-variables-
> hook
> 'sql-highlight-product t).  But maybe another approach (instead of
> or additionally to creating a derived-mode) would be to add an entry in
> sql-product-alist for your "pp sql".
> 
> 
>         Stefan
>