Mailing List Archive


Back to the month index Back to the list index
Christopher Seawood (cseawood@seawood.org)
Sun, 12 Jan 1997 19:25:04 -0500 (EST) 

Date: Sun, 12 Jan 1997 19:25:04 -0500 (EST)
From: Christopher Seawood <cseawood@seawood.org>
Subject: [mSQL] _timestamp comparisons
Message-Id: <Pine.LNX.3.95.970112184940.10508A-100000@shell.wisp.net>

Has anyone tried any complex queries that compare the _timestamp fields?
I'm having problems comparing the _timestamps of different tables and I
get an error (ERROR : Bad type for comparison of '_timestamp') if I
enclose the conditional portion of the select command in parens.

mSQL > update msql_dns_control set label = 99 where one_row = 'A'\g
Query OK. 1 row(s) modified or retrieved.

mSQL > update msql_dns_labels set label = 101 where label = 100\g
Query OK. 1 row(s) modified or retrieved.

mSQL > select msql_dns_labels.name from msql_dns_labels, msql_dns_control
where msql_dns_labels._timestamp > msql_dns_control._timestamp\g
Query OK. 0 row(s) modified or retrieved.

mSQL > select msql_dns_labels.name from msql_dns_labels, msql_dns_control
where (msql_dns_control.one_row = 'A') and msql_dns_labels._timestamp >
msql_dns_control._timestamp\g
Query OK. 0 row(s) modified or retrieved.

mSQL > select msql_dns_labels.name from msql_dns_labels, msql_dns_control
where (msql_dns_control.one_row = 'A') and (msql_dns_labels._timestamp >
msql_dns_control._timestamp )\g
ERROR : Bad type for comparison of '_timestamp'

mSQL > select _timestamp from msql_dns_control where one_row = 'A'\g
Query OK. 1 row(s) modified or retrieved.
 +------------+
 | _timestamp |
 +------------+
 | 853114149 |
 +------------+

mSQL > select _timestamp from msql_dns_labels where label = 101\g
Query OK. 1 row(s) modified or retrieved.
 +------------+
 | _timestamp |
 +------------+
 | 853114169 |
 +------------+

Setup:
msql-2.0B2, gcc-2.7.2.1+objc+pthread, linux-2.0.27 SMP

Version Details :-

        msqladmin version 2.0 Beta 2
        mSQL server version 2.0 Beta 2
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Linux-2.0.27-i586

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid
 
Regards,
Christopher 

---
Christopher Seawood		* Software Engineer/System Admin
CEO/HGIC of Seawood Consulting	* Specialized Linux Consulting
cseawood@seawood.org		* http://www.seawood.org

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!