You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by Oliver Zeigermann <oz...@c1-fse.de> on 2004/06/07 16:53:47 UTC
[POSTGRES, ORACLE] Re: cvs commit: jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms
MySqlRDBMSAdapter.java StandardRDBMSAdapter.java
Has anyone any idea how this might look like for Postgres? Or Oracle?
For MySQL it is:
> convert(SUBSTRING_INDEX("+revisioNumber+", '.', 1), unsigned),
> convert(SUBSTRING_INDEX("+revisioNumber+", '.', -1), unsigned)
and for SQL Server and Sybase
> convert(numeric,
> SUBSTRING("+revisioNumber+",1,charindex('.',"+revisioNumber+"))),
> convert(numeric,
> SUBSTRING("+revisioNumber+",charindex('.',"+revisioNumber+")+1,100))
Oliver
ozeigermann@apache.org wrote:
> ozeigermann 2004/06/07 07:25:20
>
> Modified: src/stores/org/apache/slide/store/impl/rdbms
> MySqlRDBMSAdapter.java StandardRDBMSAdapter.java
> Log:
> Fixed fix for bug #29359 SQLServer, Sybase and MySQL
>
> Revision Changes Path
> 1.5 +6 -5 jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/MySqlRDBMSAdapter.java
>
> Index: MySqlRDBMSAdapter.java
> ===================================================================
> RCS file: /home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/MySqlRDBMSAdapter.java,v
> retrieving revision 1.4
> retrieving revision 1.5
> diff -u -r1.4 -r1.5
> --- MySqlRDBMSAdapter.java 7 Jun 2004 13:04:58 -0000 1.4
> +++ MySqlRDBMSAdapter.java 7 Jun 2004 14:25:20 -0000 1.5
> @@ -62,7 +62,8 @@
> }
>
> protected String convertRevisionNumberToComparable(String revisioNumber) {
> - return "convert("+revisioNumber+", unsigned)";
> +
> + return "convert(SUBSTRING_INDEX("+revisioNumber+", '.', 1), unsigned), convert(SUBSTRING_INDEX("+revisioNumber+", '.', -1), unsigned)";
> }
>
>
>
>
>
> 1.27 +5 -5 jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java
>
> Index: StandardRDBMSAdapter.java
> ===================================================================
> RCS file: /home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/StandardRDBMSAdapter.java,v
> retrieving revision 1.26
> retrieving revision 1.27
> diff -u -r1.26 -r1.27
> --- StandardRDBMSAdapter.java 7 Jun 2004 13:04:58 -0000 1.26
> +++ StandardRDBMSAdapter.java 7 Jun 2004 14:25:20 -0000 1.27
> @@ -1365,7 +1365,7 @@
> }
>
> protected String convertRevisionNumberToComparable(String revisioNumber) {
> - return "convert(numeric, "+revisioNumber+")";
> + return "convert(numeric, SUBSTRING("+revisioNumber+",1,charindex('.',"+revisioNumber+"))), convert(numeric, SUBSTRING("+revisioNumber+",charindex('.',"+revisioNumber+")+1,100))";
> }
>
> protected void close(PreparedStatement statement) {
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-dev-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org