QG /YeP-perl/mSQL 2.0 Status


Hi, Stipe,

Many thanks for this info, I think I'l insert the link to your site
somewhere
on Qub.com. Unfortunately, after playing with Cygwin for more than 1 year,
I now decided that it is not worth the efforts to continue with it.
Apparently,
I also found that mySQL is much better than mSQL.

Rgds.Paul.


>Hi Paul,
>
>just wanted to inform you about Joshua's mSQL 2.0.5 port to Cygwin b20.
>You may find it at
>
> http://shell.warped.com/~joshua/
>
>His latest build of mSQL 2.0.5 is bundeled into our CAMP 1.0 alpha
>release, the Cygwin Apache mSQL MySQL PHP3 embedded web authoring
>environment containing Cygwin b20 ports of:
>
> - Apache 1.3.3
> - PHP3 apache module and standalone executable
>   with MySQL 3.22.10, mSQL 2.0.5 and PostgreSQL 6.4 client support
>   with GD 1.3 support
> - MySQL Authentification apache module
> - mSQL 2.0.5 database engine
>
>Have a look at our project site at
>
> http://www-public.rz.uni-duesseldorf.de/~tolj/
>
>Regards,
>Stipe
>
>--
>Stipe Tolj 
>Cygwin Porting Project
>Department of Economical Computer Science
>University of Cologne, Germany
>http://www-public.rz.uni-duesseldorf.de/~tolj
>
>

I have build Yep-Perl extension that passes 90% of mSQL-2 tests, but when investigating failures in detail, I found that port of mSQL 2.0 daemon that I'm using has many trivial drawbacks. So I decide to wait when Hughes would ship promised 'official' mSQL 2.0 Win32 port. (Promised in 2 weeks)

If you don't want to wait with me - provide me with any url to mSQL 2* for Win32 that supports trivial script below - and I'l be glad to provide perl support for that mSQL 2* Win32 distribution. Unfortunately, at the moment I have no time to port mSQL 2* itself.

Paul

 

% msql test

Welcome to the miniSQL monitor.  Type \h for help.


mSQL > drop table ttt                          \g

Query OK.  1 row(s) modified or retrieved.




mSQL > create table ttt (id    char(10))       \g

Query OK.  1 row(s) modified or retrieved.




mSQL > insert into ttt VALUES ( NULL )         \g

Query OK.  1 row(s) modified or retrieved.




mSQL > insert into ttt VALUES ( 'aaa' )        \g

Query OK.  1 row(s) modified or retrieved.




mSQL > select * from ttt                       \g

Query OK.  2 row(s) modified or retrieved.

 +------------+
 | id         |
 +------------+
 | NULL       |
 | aaa        |
 +------------+



mSQL > select * from ttt WHERE id = 'aaa'      \g

Query OK.  1 row(s) modified or retrieved.

 +------------+
 | id         |
 +------------+
 | aaa        |
 +------------+



mSQL > select * from ttt WHERE id = NULL       \g

Query OK.  1 row(s) modified or retrieved.

 +------------+
 | id         |
 +------------+
 | NULL       |
 +------------+



mSQL >

 
QG /YeP-perl/mSQL 2.0 Status