close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 20 years ago

Closed 20 years ago

#321 closed defect (invalid)

Grammar in DBTable

Reported by: Chakib Faghloumi Owned by: Javier Portugal
Priority: normal Milestone:
Component: DataBase Version: head
Severity: normal Keywords: TOL
Cc:

Description

The Table01 have the different grammar in each component of each column but
Tol return the Text grammar in all of their component
Example:

Set Table01 = DBTable(
"select 1, 'a', str_to_date('20050103', '%Y%m%d')

union all
select 'a', str_to_date('20050103', '%Y%m%d'), 1
union all
select str_to_date('20050103', '%Y%m%d'), 1, 'a'");


Change History (3)

comment:1 Changed 20 years ago by Chakib Faghloumi

Component: Tables → ENGINE_Database
Keywords: TOL added; Tol-Base removed
product: Tol-Base → TOL
Summary: Gramer in DBTable → Grammar in DBTable
Version: cvs-snapshot → nightly built

comment:2 Changed 20 years ago by Chakib Faghloumi

So: the line code

Real r = Table01[1][1];

gives mistake

comment:3 Changed 20 years ago by Javier Portugal

Resolution: → invalid
Status: new → closed

I don't think this is a bug, when we have diferent types for the same column in
diferents rows, the database management system can give an error (Oracle,
SqlServer) or return all rows as text (MySQL). In this case, TOL (and TolBase)
manages this as Text columns.

Note: See TracTickets for help on using tickets.