varying results of sql-send-buffer

varying results of sql-send-buffer

[Andreas Zielke]

Hello,

I'm using Emacs 20.7.1 to build a MySQL database. I wrote a series of 
queries which creates a db, tables and puts in some data (db is dropped 
in the beginning to provide a clean start for each run). This file works 
fine if used directly with mysql: mysql < file.sql

But if I send this buffer via the sql-send-buffer command to mysql in the 
interactive-buffer, the final state of the database is different almost 
each time. 

It seems as if some of the queries get lost along the way. This is 
curious, since I did some previous tasks where everything went smoothly.

The Emacs environment is set as follows: 
sql-mysql
sql-set-sqli-buffer


I could not find any clues on the web for this problem. 

Andreas

Re: varying results of sql-send-buffer

[Andreas Zielke]

I installed XEmacs and this works fine.

Re: varying results of sql-send-buffer

[Martin Mueller]

Andreas Zielke <Zielke.ng@oktapos.de> writes:

> I'm using Emacs 20.7.1 to build a MySQL database. I wrote a series of 
> queries which creates a db, tables and puts in some data (db is dropped 
> in the beginning to provide a clean start for each run). This file works 
> fine if used directly with mysql: mysql < file.sql
> 
> But if I send this buffer via the sql-send-buffer command to mysql in the 
> interactive-buffer, the final state of the database is different almost 
> each time. 
> 
> It seems as if some of the queries get lost along the way. This is 
> curious, since I did some previous tasks where everything went smoothly.
> 
> The Emacs environment is set as follows: 
> sql-mysql
> sql-set-sqli-buffer

It is the same here.
I can avoid the problems when I remove the comments from my
sql-script. Do you have comments in your file?

Martin