sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "M. Le Bihan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SIS-184) DBase 3 - JDBC : Simple WHERE CLAUSE and Integer, Double field support
Date Thu, 13 Nov 2014 06:05:33 GMT

    [ https://issues.apache.org/jira/browse/SIS-184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14209334#comment-14209334
] 

M. Le Bihan commented on SIS-184:
---------------------------------

I am ready to commit to SVN, and I'll try tomorrow morning to send what I have done.
A Crude WHERE statement is handled, with one condition only, and they are some limitations.
But =, <, >, >=, <= are handled for FIELD operand FIELD and FIELD operand Litteral,
provided the litteral involved in the SQL query condition is of Integer, Double, or String
kind.

!SIS184_where_statement.png!


For checkin, I am currently doing a 
git svn clone  (a bit long to clone, however)
!git_svn.png!

expecting to transfert my current git content (except .git root directory) to that git svn
and attempt the commit


Then, I would checkin through a git svn checkin.
Do you think it's a good idea ?

> DBase 3 - JDBC : Simple WHERE CLAUSE and Integer, Double field support
> ----------------------------------------------------------------------
>
>                 Key: SIS-184
>                 URL: https://issues.apache.org/jira/browse/SIS-184
>             Project: Spatial Information Systems
>          Issue Type: Improvement
>          Components: Features, Storage
>    Affects Versions: 0.5
>            Reporter: M. Le Bihan
>            Priority: Minor
>         Attachments: SIS184_attach_DBase3_driver_to_Squirrel.png, SIS184_connect_to_database.png,
SIS184_create_alias_to_a_dbase3_file.png, SIS184_query_the_table.png, SIS184_table_metadata.png,
SIS184_where_statement.png, git_svn.png
>
>
> Following the SIS-180 (select * from DBF) this improvment will add the ability to :
> * Obtain field values from Integer and Double fields.
> * Add a simple WHERE clause with = , >, <, >=, <=, <> operators.
> Relational operators (AND, OR) _might be_ implemented too, depending on the ability of
parsing the query easily or not. Else, this feature will come in another JIRA.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message