Sheeri K. Cabral wrote:
On 10/1/08, *Roy Lyseng* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
This is in accordance with the SQL standard. I think the reasoning
is that you should be able to split long text strings onto multiple
lines, so any sequence of quoted strings is concatenated into a
single string literal. Notice that there must be a <separator> (ie a
space or a newline) between the strings.
Makes sense, but it should be documented *somewhere* as an implicit concat.
The latter query (SELECT without a FROM) is a MySQL extension.
That wasn't the point of Brian using "select 'foo' 'bar';" as an example
-- the point I believe Brian was trying to make was that "select 'foo'
'bar';" acts like "select CONCAT('foo','bar');"
Sheeri,
I read from his mail about the "latter query" that there was an error
using sqlite and pqsql, and I assumed that was because a FROM-less query
is a MySQL extension. Obviously I may have made the wrong assumption :)
Roy
Which is explained by the SQL standard.....
-Sheeri
Roy
Another reason for not
Brian Moon wrote:
This example says it all. The folks in #mysql-dev (ok, one guy)
seemed to think this was expected. This apparently stems from
another interesting query at the end of the example. I can't
find this to be a standard of any kind and frankly find it to be
wrong. Due to an error in my application while building the
query (no , was inserted) I was getting bad data. I tried
sqlite and pgsql. They either gave a different, non-error
message (sqlite) or gave an error (pgsql). Wanna fix this in
Drizzle?
mysql> use information_schema;
Database changed
mysql> select table_name from tables where
table_schema in ('mysql' 'test');
Empty set (0.10 sec)
mysql> select table_name from tables where
table_schema in ('mysql', 'test');
+---------------------------+
| table_name |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
| user_info |
| comments |
| deal_queue |
| users |
+---------------------------+
21 rows in set (0.17 sec)
mysql> select 'foo' 'bar';
+--------+
| foo |
+--------+
| foobar |
+--------+
1 row in set (0.00 sec)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
Post to : [email protected]
<mailto:[email protected]>
Unsubscribe : https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
More help : https://help.launchpad.net/ListHelp
--
- Sheeri K. Cabral
Note: Currently I work for The Pythian Group (http://www.pythian.com/
), a remote DBA firm, and consulting would constitute a conflict of
interest. However, I do recommend our work, and if you're looking for
DBA work (I do MySQL work, but they have great Oracle and SQL Server
DBAs too) right now, whether you need a few hours a week, or someone
fulltime while you continue a job search.
I have a webpage with tips on how to find a
DBA: http://sheeri.net/how-to-find-a-dba/
I can recommend http://www.toomanyconnections.com as a good site to find
MySQL (and Oracle) DBAs.
If you're looking for web design, I recommend the small business my
husband works for, http://www.digital-loom.com
I regret that I have no other information for any other type of
position, including developer, programmer and systems administrator.
------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
