[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] bad sql??


http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
"In MySQL, databases correspond to directories within the data
directory. Each table within a database corresponds to at least one
file within the database directory (and possibly more, depending on
the storage engine). Consequently, the case sensitivity of the
underlying operating system plays a part in the case sensitivity of
database and table names. This means database and table names are not
case sensitive in Windows, and case sensitive in most varieties of
Unix. One notable exception is Mac OS X, which is Unix-based but uses
a default filesystem type (HFS+) that is not case sensitive. However,
Mac OS X also supports UFS volumes, which are case sensitive just as
on any Unix."

All of the above applies to MySQL MyISAM engine (default engine for
MySQL of many cases).

In MySQL, example:

OK:
select JobId from Job limit 1;
select jobid from Job limit 1;

Error:
select jobid from job limit 1;
Table 'bacula.job' doesn't exist


2008/9/18 John Huttley <John@xxxxxxxxxxxxxxxxxx>:
> https://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula,-Sqlite,-Postgres...-when-good-tools-go-horribly-horribly-wrong.html
>
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Bacula-devel mailing list
> Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/bacula-devel
>



-- 
with best regards

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.