Valentina Database Mantis

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005649ADK-V4REVSQLpublic2011-12-15 10:092012-10-15 06:52
Reporterbjdevlin 
Assigned ToKirill Pekarov 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOSOS Version
Product Version4.8 
Target Version5.0Fixed in Version 
Summary0005649: SELECT Function() generally return nonsense
DescriptionI chose some of the possible functions, and included the returned values (on the right of the = sign below).

SELECT DATABASEVERSION(); = ??6
SELECT CONCAT('Va', 'len', 'tina'); = ??V
SELECT HEAD('aesop', 'ea'); = ??a
SELECT HEX( 327680 ) ; = ??0
SELECT FORMAT(now(), '', 'kDateFormatFull'); = ??W
SELECT INITCAP ( 'valentina' ); = ??V
SELECT LEFT('database', 5); = ??d
SELECT IF('Hello!' LIKE 'Hello_', 1, 0); = 1
SELECT LOCATE('len', 'Valentina'); = 3
SELECT MD5('1234567890'); = ??E
SELECT REGEX_REPLACE('abcd', '(ab)(cd)', '$2--$1:' ); = ??c
SELECT REVERSE('data'); = ??a
SELECT RPAD('hello',7,'?'); = ??h
SELECT SCHEMAVERSION(); = ??1
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (0006144)
bjdevlin (reporter)
2011-12-16 22:54

Because of the issues around bug 5645 (bind/array action crashing LiveCode with V 4.8) I reverted to the last version for which I have a license (V 4.7). With V 4.7 this current bug does not occur. Here is the output from running my tests running SELECT with some of the provided Valentina calls:
SELECT DATABASEVERSION();= 608
SELECT CONCAT('Va', 'len', 'tina');= Valentina
SELECT HEAD('aesop', 'ea');= ae
SELECT HEX( 327680 ) ;= 0x50000
SELECT FORMAT(now(), '', 'kDateFormatFull');= Friday, December 16, 2011 10:50:31 PM United Kingdom Time
SELECT INITCAP ( 'valentina' );= Valentina
SELECT LEFT('database', 5);= datab
SELECT IF('Hello!' LIKE 'Hello_', 1, 0);= 1
SELECT LOCATE('len', 'Valentina');= 3
SELECT MD5('1234567890');= E807F1FCF82D132F9BB018CA6738A19F
SELECT REGEX_REPLACE('abcd', '(ab)(cd)', '$2--$1:' );= cd--ab:
SELECT REVERSE('data');= atad
SELECT RPAD('hello',7,'?');= hello??
SELECT SCHEMA
VERSION();= 1

When I ran this test on V. 4.9.1, the SELECT function() still returns nonsense. So, this bug is still OPEN.
User avatar (0006180)
Kirill Pekarov (developer)
2012-02-17 15:42

Just check it. All work fine here.

Please, try my way:
1. Open example SQL_way/TextCompressed.
2. Click edit card script
3. Modify function SelectButtonClick to this:
----------------------------------------------------------
function SelectButtonClick
  set the cursor to watch

  put VDatabase_SqlSelect( mDBRef, "SELECT DATABASEVERSION();" ) into mCursor
  
  put VCursor_Field( mCursor, 1 ) into fld_text
  put VField_Value( fld_text ) into field efText
  set the cursor to arrow

end SelectButtonClick

4. Run example, and press SELECT button.

Do you see right values? Or broken? I've correct return values, for example for "SELECT DATABASEVERSION();" in the "fld_text" text box value "608"

- Issue History
Date Modified Username Field Change
2011-12-15 10:09 bjdevlin New Issue
2011-12-16 22:54 bjdevlin Note Added: 0006144
2012-02-17 09:58 Ruslan Zasukhin Assigned To => Kirill Pekarov
2012-02-17 09:58 Ruslan Zasukhin Priority normal => immediate
2012-02-17 09:58 Ruslan Zasukhin Status new => assigned
2012-02-17 09:58 Ruslan Zasukhin Target Version => 5.0
2012-02-17 15:42 Kirill Pekarov Note Added: 0006180
2012-10-15 06:52 Ruslan Zasukhin Status assigned => closed
2012-10-15 06:52 Ruslan Zasukhin Resolution open => unable to reproduce


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker