Possibly related : example of non-ASCII Unicode mishandling [Re: A curious bug...]

[Emmanuel Charpentier]

Possibly related : while exploring ⎕SQL, I noticed some misha dling of non-ASCC nin-APL Unicode.

After running :

⍝ Exploration of a sqlite database throug APL
⍝ Nota Bene : The database name *MUST* be an UNENCAPSULATED vector :
MaDBName←'/home/charpent/Documents/Perso/SuiviMédical/Circulation.sqlite'
⍝ Connection
MaDB←'sqlite' ⎕SQL[1] MaDBName
⍝ Dictionary Tables
TableNames←⎕SQL[8] MaDB ⍝ Returns a *VECTOR* !
⍝ Dictionary : Views. This could be a new ⎕SQL function 
⍝ Nota Bene : SQL queries ALSO must be UNENCAPSULATED...
ViewNames← ,'select name from sqlite_schema where type = ''view'';' ⎕SQL[3, MaDB]  '' ⍝ Returns a MATRIX* !
⍝ Dictionary Table/view columns (sqlite colum types are of questionable value)
ColumNames←(TableNames,ViewNames),[1.5]MaDB {⊃(⍺ ⎕SQL[9] ⊃⍵)[;1]}¨ TableNames,ViewNames

I noticed :

      ⍝ Compare
      ColumNames
 Circulation  Date               
              Poids              
              TA Systolique      
              TA Diastolique     
              Pouls              

 CircData     Date               
              nDate              
              Poids              
              TA Systolique      
              TA Diastolique     
              Pouls              

 CD2          Date               
              nDate              
              Poids              
              Pouls              
              TA Systolique      
              TA Diastolique     
              TA Moyenne         
              TA Différentielle 
      ⍝ with
      7 ⎕CR ColumNames
┌→──────────┐ ┌→─────────────┐
│Circulation│ ↓Date          │
└───────────┘ │Poids         │
              │TA Systolique │
              │TA Diastolique│
              │Pouls         │
              └──────────────┘

┌→───────┐    ┌→─────────────┐
│CircData│    ↓Date          │
└────────┘    │nDate         │
              │Poids         │
              │TA Systolique │
              │TA Diastolique│
              │Pouls         │
              └──────────────┘

┌→──┐         ┌→─────────────────┐
│CD2│         ↓Date              │
└───┘         │nDate             │
              │Poids             │
              │Pouls             │
              │TA Systolique     │
              │TA Diastolique    │
              │TA Moyenne        │
              │TA Diff⏃⎩rentielle│
              └──────────────────┘

7 ⎕CR mishandles the non-ASCII column names of CD2. Could this be related to the mishandling of functuon definition that appeared after the releaase of the current Debian package of Gnu APL ?

HTH,

--
Emmanuel Charpentier

[ Snip... ]